sqlalchemy-iris

Downloads19
Subscribe
2
Bookmark
3
This application is not supported by InterSystems Corporation. Please be notified that you use it at your own responsibility.
Details
Releases
Reviews
Issues
Videos
Articles
Reports

What's new in this version

  • Many fixes and improvements
  • Updated to the updated version of DB-API Driver

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(\"*\")'"
Rating
5 (1)
Category
Frameworks
Works with
InterSystems IRISInterSystems IRIS for Health
Tags
Info
Version
0.4.0
Last updated
2022-11-16
Repository
Open
Documentation
Open
License
Link