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/cf/4a/fc27e5d913c157caf156921d3516127b013beeca1a26abc540e0551348d3/sqlalchemy_iris-0.15.3.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.3",
"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": "b5bf45fa4b70e5fe1d00412a22c32063c3a5ec94dbdd53fdc04164d47d77d683",
"md5": "8e70215a935e281aa0c118221836c60d",
"sha256": "0bb240ac5e876d461dac087af2c6bd483d6fa0c4b1fa0bf507b8f91b6ad0749f"
},
"downloads": -1,
"filename": "sqlalchemy_iris-0.15.3-py3-none-any.whl",
"has_sig": false,
"md5_digest": "8e70215a935e281aa0c118221836c60d",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.8",
"size": 142219,
"upload_time": "2024-07-06T13:36:21",
"upload_time_iso_8601": "2024-07-06T13:36:21.002255Z",
"url": "https://files.pythonhosted.org/packages/b5/bf/45fa4b70e5fe1d00412a22c32063c3a5ec94dbdd53fdc04164d47d77d683/sqlalchemy_iris-0.15.3-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "cf4afc27e5d913c157caf156921d3516127b013beeca1a26abc540e0551348d3",
"md5": "fe89042de1005f585a3921980ecb686d",
"sha256": "d7977beba47a373bddc9d03eace04270fddaa8eeb3d09f4bf64647cab2309e34"
},
"downloads": -1,
"filename": "sqlalchemy_iris-0.15.3.tar.gz",
"has_sig": false,
"md5_digest": "fe89042de1005f585a3921980ecb686d",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.8",
"size": 119800,
"upload_time": "2024-07-06T13:36:23",
"upload_time_iso_8601": "2024-07-06T13:36:23.051701Z",
"url": "https://files.pythonhosted.org/packages/cf/4a/fc27e5d913c157caf156921d3516127b013beeca1a26abc540e0551348d3/sqlalchemy_iris-0.15.3.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-07-06 13:36:23",
"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
