sqlalchemy-iris
An InterSystems IRIS dialect for SQLAlchemy.
Pre-requisites
This dialect requires SQLAlchemy, InterSystems DB-API driver. They are specified as requirements so pip
will install them if they are not already in place. To install, just:
pip install sqlalchemy-iris
Usage
In your Python app, you can connect to the database via:
from sqlalchemy import create_engine
engine = create_engine("iris://_SYSTEM:SYS@localhost:1972/USER")
InterSystems IRIS
You can run your instance of InterSystems IRIS Community Edition with Docker
docker run -d --name iris \
-p 1972:1972 \
-p 52773:52773 \
intersystemsdc/iris-community:preview
Port 1972 is used for binary communication (this driver, xDBC and so on), and 52773 is for web (Management Portal, IRIS based web-applications and API's).
The System Management Portal is available by URL: http://localhost:52773/csp/sys/UtilHome.csp
The default password - SYS, has to be changed after the first login to the management portal. Or start the container with a command that resets the change password flag
docker run -d --name iris \
-p 1972:1972 \
-p 52773:52773 \
intersystemsdc/iris-community:preview \
-a "iris session iris -U%SYS '##class(Security.Users).UnExpireUserPasswords(\"*\")'"
1 maintainer
Release files for sqlalchemy-iris 0.5.0
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| sqlalchemy-iris-0.5.0.tar.gz | 108.5 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| sqlalchemy_iris-0.5.0-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 241.0 kB
Release files / sqlalchemy-iris-0.5.0.tar.gz
| Download URL | sqlalchemy-iris-0.5.0.tar.gz |
|---|---|
| Size | 108.5 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
bb5468bddb20c9db4636624ef4de5eaf41cb63ff9165399af9fc5327d623bb94
|
|
BLAKE2b-256 checksum How to use checksums |
edf2550d55ab71d03aa5c283d5a484a621d5f479ec8552b3f3804569dfacfb70
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.2 CPython/3.10.9
|
Release files / sqlalchemy_iris-0.5.0-py3-none-any.whl
| Download URL | sqlalchemy_iris-0.5.0-py3-none-any.whl |
|---|---|
| Size | 132.5 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
776ec64358a5d130ec59071e65f85a1c6c6b8f19d400bcad278b90750cbbe8d3
|
|
BLAKE2b-256 checksum How to use checksums |
f44a36801bfa40bdc6dae72882cf932a557855db3e6c90ba5c34e372427aac57
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.2 CPython/3.10.9
|
