InterSystems IRIS for SQLAlchemy
Project description
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
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for sqlalchemy_iris-0.13.4b2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9ef379ed97b5fa222e458485bc3dad834cb611fc8d05d4f93473f43fb0e6396e |
|
MD5 | 69a6ad22c0a27396e7b9cde9581d75d7 |
|
BLAKE2b-256 | fdcf9f9b9c54d3fc79f18cf97b6142509b8b0ac89f9a9c639fb8efaeb0f580bb |