This release is a pre-release and may not be stable for production use.
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")
IRIS Cloud SQL requires SSLContext
url = engine.URL.create(
drivername="iris",
host=host,
port=443,
username='SQLAdmin',
password=password,
database='USER',
)
sslcontext = ssl.create_default_context(cafile="certificateSQLaaS.pem")
engine = create_engine(url, connect_args={"sslcontext": sslcontext})
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 \
-e IRIS_USERNAME=_SYSTEM \
-e IRIS_PASSWORD=SYS \
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
1 maintainer
Release files for sqlalchemy-iris 0.14.1b2
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.14.1b2.tar.gz | 119.5 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| sqlalchemy_iris-0.14.1b2-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 261.5 kB
Release files / sqlalchemy_iris-0.14.1b2.tar.gz
| Download URL | sqlalchemy_iris-0.14.1b2.tar.gz |
|---|---|
| Size | 119.5 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
cf58bf61e6b60f581d4f5db73a6bf9c5c636e998bb40d4410036a986019141b8
|
|
BLAKE2b-256 checksum How to use checksums |
5bca4f10df947974f45280a1ce4026037aeb3954aa7fb3f3521845e452eb161c
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/5.1.0 CPython/3.12.4
|
Release files / sqlalchemy_iris-0.14.1b2-py3-none-any.whl
| Download URL | sqlalchemy_iris-0.14.1b2-py3-none-any.whl |
|---|---|
| Size | 142.0 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
5ad9c15685a163ea4492ba1bae4a2da2298b76817af762ad50e2dc869a2755a9
|
|
BLAKE2b-256 checksum How to use checksums |
26da45142982c7671f41f434372f6a80ad2a3417d3e78371ce5361b019155c7f
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/5.1.0 CPython/3.12.4
|
