GBasedbt Alchemy Adapter
========================
The GBasedbt Alchemy adapter provides the Python/SQLAlchemy interface to GBase 8s Servers.
Fork from https://github.com/OpenInformix/InformixAlchemy
Version
--------
x.x.x
Prerequisites
--------------
1. Python 3.5.x .
2. SQLAlchemy 0.7.3 or above.
3. DbtPy driver and DbtPyDbi
Install and Configuration
=========================
The GBasedbt Alchemy Python Egg component (.egg) can be installed using the standard setuptools provided by the Python Easy Install through Python Enterprise
Application Kit community portal:
http://peak.telecommunity.com/DevCenter/EasyInstall
Please follow the steps provided to Install "Easy Install" in the link above and follow up with these additional steps to install GBasedbt Alchemy:
1. To install GBasedbt Alchemy from source
Standard Python setup should be used::
python setup.py build
python setup.py install
Connecting
----------
A TCP/IP connection can be specified as the following::
from sqlalchemy import create_engine
e = create_engine("gbasedbt://user:pass@host[:port]/database")
For a local socket connection, exclude the "host" and "port" portions::
from sqlalchemy import create_engine
e = create_engine("gbasedbt://user:pass@/database")
Known Limitations in DbtAlchemy adapter for GBase 8s databases
---------------------------------------------------------------
1) Non-standard SQL queries are not supported. e.g. "SELECT ? FROM TAB1"
2) For updations involving primary/foreign key references, the entries should be made in correct order. Integrity check is always on and thus the primary keys referenced by the foreign keys in the referencing tables should always exist in the parent table.
3) Unique key which contains nullable column not supported
4) UPDATE CASCADE for foreign keys not supported
5) DEFERRABLE INITIALLY deferred not supported
6) Subquery in ON clause of LEFT OUTER JOIN not supported
Raw data
{
"_id": null,
"home_page": "https://gbasedbt.com",
"name": "DbtAlchemy",
"maintainer": "",
"docs_url": null,
"requires_python": "",
"maintainer_email": "",
"keywords": "sqlalchemy database interface for GBase 8s servers",
"author": "Development Team",
"author_email": "dbt@gbasebdt.com",
"download_url": "",
"platform": "All",
"description": "GBasedbt Alchemy Adapter\n========================\n\nThe GBasedbt Alchemy adapter provides the Python/SQLAlchemy interface to GBase 8s Servers.\nFork from https://github.com/OpenInformix/InformixAlchemy\n\nVersion\n--------\nx.x.x\n\nPrerequisites\n--------------\n1. Python 3.5.x .\n2. SQLAlchemy 0.7.3 or above.\n3. DbtPy driver and DbtPyDbi\n\nInstall and Configuration\n=========================\nThe GBasedbt Alchemy Python Egg component (.egg) can be installed using the standard setuptools provided by the Python Easy Install through Python Enterprise\nApplication Kit community portal:\n http://peak.telecommunity.com/DevCenter/EasyInstall\n\nPlease follow the steps provided to Install \"Easy Install\" in the link above and follow up with these additional steps to install GBasedbt Alchemy:\n\n 1. To install GBasedbt Alchemy from source\n Standard Python setup should be used::\n python setup.py build\n python setup.py install\n\nConnecting\n----------\nA TCP/IP connection can be specified as the following::\n\n\tfrom sqlalchemy import create_engine\n\n\te = create_engine(\"gbasedbt://user:pass@host[:port]/database\")\n\nFor a local socket connection, exclude the \"host\" and \"port\" portions::\n\n\tfrom sqlalchemy import create_engine\n\n\te = create_engine(\"gbasedbt://user:pass@/database\")\n\n\n\nKnown Limitations in DbtAlchemy adapter for GBase 8s databases\n---------------------------------------------------------------\n1) Non-standard SQL queries are not supported. e.g. \"SELECT ? FROM TAB1\"\n2) For updations involving primary/foreign key references, the entries should be made in correct order. Integrity check is always on and thus the primary keys referenced by the foreign keys in the referencing tables should always exist in the parent table.\n3) Unique key which contains nullable column not supported\n4) UPDATE CASCADE for foreign keys not supported\n5) DEFERRABLE INITIALLY deferred not supported\n6) Subquery in ON clause of LEFT OUTER JOIN not supported\n\n\n\n",
"bugtrack_url": null,
"license": "Apache License 2.0",
"summary": "SQLAlchemy support for GBase 8s Servers",
"version": "1.0.1.1",
"split_keywords": [
"sqlalchemy",
"database",
"interface",
"for",
"gbase",
"8s",
"servers"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "da6a33248d3195570b41f7214f06ca886157050c7836b1904f0ccb26f61d8edf",
"md5": "7ba2566811631415bbb8d491506cf64c",
"sha256": "61d9c10b8ecdf05463729ff79d45acbb14ea66682c835fa10aafb7b0df4a5d6c"
},
"downloads": -1,
"filename": "DbtAlchemy-1.0.1.1-py3.6.egg",
"has_sig": false,
"md5_digest": "7ba2566811631415bbb8d491506cf64c",
"packagetype": "bdist_egg",
"python_version": "1.0.1.1",
"requires_python": null,
"size": 44943,
"upload_time": "2023-03-11T14:39:02",
"upload_time_iso_8601": "2023-03-11T14:39:02.984697Z",
"url": "https://files.pythonhosted.org/packages/da/6a/33248d3195570b41f7214f06ca886157050c7836b1904f0ccb26f61d8edf/DbtAlchemy-1.0.1.1-py3.6.egg",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "fd1c99e460eaf5f7f651c5d218da0a4cc279b79674dea1cbbbb53842a3d4edc7",
"md5": "30d3319be3e2fed0de2967b36819b786",
"sha256": "45b2f7abc918c470bb064f9325bf4aba426924db7add965ada2579e3f99ac1ab"
},
"downloads": -1,
"filename": "DbtAlchemy-1.0.1.1-py3-none-any.whl",
"has_sig": false,
"md5_digest": "30d3319be3e2fed0de2967b36819b786",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": null,
"size": 24352,
"upload_time": "2023-03-11T14:39:00",
"upload_time_iso_8601": "2023-03-11T14:39:00.528404Z",
"url": "https://files.pythonhosted.org/packages/fd/1c/99e460eaf5f7f651c5d218da0a4cc279b79674dea1cbbbb53842a3d4edc7/DbtAlchemy-1.0.1.1-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2023-03-11 14:39:02",
"github": false,
"gitlab": false,
"bitbucket": false,
"lcname": "dbtalchemy"
}
JSON