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:
```shell
pip install sqlalchemy-iris
```
Usage
---
In your Python app, you can connect to the database via:
```python
from sqlalchemy import create_engine
engine = create_engine("iris://_SYSTEM:SYS@localhost:1972/USER")
```
IRIS Cloud SQL requires SSLContext
```python
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
```shell
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`
Raw data
{
"_id": null,
"home_page": "https://github.com/caretdev/sqlalchemy-iris",
"name": "sqlalchemy-iris",
"maintainer": "CaretDev",
"docs_url": null,
"requires_python": ">=3.8",
"maintainer_email": "dmitry@caretdev.com",
"keywords": "\"SQLAlchemy InterSystems IRIS\"",
"author": null,
"author_email": null,
"download_url": "https://files.pythonhosted.org/packages/0f/15/08b9ab954377b69d89f287014162c73dc2b1c2805973f096b6e920d2dbf5/sqlalchemy_iris-0.15.4.tar.gz",
"platform": null,
"description": "sqlalchemy-iris\n===\n\nAn InterSystems IRIS dialect for SQLAlchemy.\n\nPre-requisites\n---\n\nThis dialect requires SQLAlchemy, InterSystems DB-API driver. They are specified as requirements so ``pip``\nwill install them if they are not already in place. To install, just:\n\n```shell\npip install sqlalchemy-iris\n```\n\nUsage\n---\n\nIn your Python app, you can connect to the database via:\n\n```python\nfrom sqlalchemy import create_engine\nengine = create_engine(\"iris://_SYSTEM:SYS@localhost:1972/USER\")\n```\n\nIRIS Cloud SQL requires SSLContext\n\n```python\nurl = engine.URL.create(\n drivername=\"iris\",\n host=host,\n port=443,\n username='SQLAdmin',\n password=password,\n database='USER',\n)\n\nsslcontext = ssl.create_default_context(cafile=\"certificateSQLaaS.pem\")\n\nengine = create_engine(url, connect_args={\"sslcontext\": sslcontext})\n```\n\nInterSystems IRIS\n---\n\nYou can run your instance of InterSystems IRIS Community Edition with Docker\n\n```shell\ndocker run -d --name iris \\\n -p 1972:1972 \\\n -p 52773:52773 \\\n -e IRIS_USERNAME=_SYSTEM \\\n -e IRIS_PASSWORD=SYS \\\n intersystemsdc/iris-community:preview\n```\n\n_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)._\n\nThe System Management Portal is available by URL: `http://localhost:52773/csp/sys/UtilHome.csp`\n",
"bugtrack_url": null,
"license": "MIT",
"summary": "InterSystems IRIS for SQLAlchemy",
"version": "0.15.4",
"project_urls": {
"Homepage": "https://github.com/caretdev/sqlalchemy-iris",
"Source": "https://github.com/caretdev/sqlalchemy-iris",
"Tracker": "https://github.com/caretdev/sqlalchemy-iris/issues"
},
"split_keywords": [
"\"sqlalchemy",
"intersystems",
"iris\""
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "39f31f19742df8168e3228306da1317d55a0c57a1d322f5a577660d80aeaa264",
"md5": "51fc32f1d1f31cc546ed7d00178e1956",
"sha256": "f9a9148419bbbb09aae1a5b428a367dc749d9bd31f30cbd978cf74b0c7a1b1e0"
},
"downloads": -1,
"filename": "sqlalchemy_iris-0.15.4-py3-none-any.whl",
"has_sig": false,
"md5_digest": "51fc32f1d1f31cc546ed7d00178e1956",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.8",
"size": 146646,
"upload_time": "2024-11-28T21:37:50",
"upload_time_iso_8601": "2024-11-28T21:37:50.512129Z",
"url": "https://files.pythonhosted.org/packages/39/f3/1f19742df8168e3228306da1317d55a0c57a1d322f5a577660d80aeaa264/sqlalchemy_iris-0.15.4-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "0f1508b9ab954377b69d89f287014162c73dc2b1c2805973f096b6e920d2dbf5",
"md5": "e2a17eb22f796e5653b884cc328a7ce3",
"sha256": "ae361f9eece1928b495a03bb585fbb3b63b81d75e71eb83cfd398fe92c214d32"
},
"downloads": -1,
"filename": "sqlalchemy_iris-0.15.4.tar.gz",
"has_sig": false,
"md5_digest": "e2a17eb22f796e5653b884cc328a7ce3",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.8",
"size": 123773,
"upload_time": "2024-11-28T21:37:51",
"upload_time_iso_8601": "2024-11-28T21:37:51.981000Z",
"url": "https://files.pythonhosted.org/packages/0f/15/08b9ab954377b69d89f287014162c73dc2b1c2805973f096b6e920d2dbf5/sqlalchemy_iris-0.15.4.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-11-28 21:37:51",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "caretdev",
"github_project": "sqlalchemy-iris",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"requirements": [
{
"name": "SQLAlchemy",
"specs": [
[
">=",
"1.3"
]
]
}
],
"tox": true,
"lcname": "sqlalchemy-iris"
}
JSON
