Skip to main content

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")

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(\"*\")'"

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

sqlalchemy-iris-0.5.0b3.tar.gz (18.0 kB view details)

Uploaded Source

Built Distribution

sqlalchemy_iris-0.5.0b3-py3-none-any.whl (17.7 kB view details)

Uploaded Python 3

File details

Details for the file sqlalchemy-iris-0.5.0b3.tar.gz.

File metadata

  • Download URL: sqlalchemy-iris-0.5.0b3.tar.gz
  • Upload date:
  • Size: 18.0 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.1 CPython/3.9.16

File hashes

Hashes for sqlalchemy-iris-0.5.0b3.tar.gz
Algorithm Hash digest
SHA256 16edd6149e9d206b6b57524db7275034ee7672efd105345ffbe8530392eecda6
MD5 2eb05c8ab2f5438d1b142a79218f1ca4
BLAKE2b-256 9bf5f55b89508662d120a4e3853c9fa8998ee5a5eaecd5640c7f64d6f7e57de9

See more details on using hashes here.

File details

Details for the file sqlalchemy_iris-0.5.0b3-py3-none-any.whl.

File metadata

File hashes

Hashes for sqlalchemy_iris-0.5.0b3-py3-none-any.whl
Algorithm Hash digest
SHA256 427ad5a4b0a86b035095da30df6aa8c4c23a74bd54a77a19d3984e04831c11e5
MD5 bed497afdfb189648566bad6ba4a9262
BLAKE2b-256 7346f1ce09ea748e89e3cb5a58aa5c84f90e8293fef6269a6003d732d80b9d4e

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page