Skip to main content

SQLAlchemy support for GBase 8s Servers

Project description

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

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distributions

No source distribution files available for this release.See tutorial on generating distribution archives.

Built Distributions

DbtAlchemy-1.0.1.1-py3.6.egg (44.9 kB view details)

Uploaded Source

DbtAlchemy-1.0.1.1-py3-none-any.whl (24.4 kB view details)

Uploaded Python 3

File details

Details for the file DbtAlchemy-1.0.1.1-py3.6.egg.

File metadata

  • Download URL: DbtAlchemy-1.0.1.1-py3.6.egg
  • Upload date:
  • Size: 44.9 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.8.0 pkginfo/1.9.6 readme-renderer/34.0 requests/2.27.1 requests-toolbelt/0.10.1 urllib3/1.26.15 tqdm/4.64.1 importlib-metadata/4.8.3 keyring/23.4.1 rfc3986/1.5.0 colorama/0.4.5 CPython/3.6.8

File hashes

Hashes for DbtAlchemy-1.0.1.1-py3.6.egg
Algorithm Hash digest
SHA256 61d9c10b8ecdf05463729ff79d45acbb14ea66682c835fa10aafb7b0df4a5d6c
MD5 7ba2566811631415bbb8d491506cf64c
BLAKE2b-256 da6a33248d3195570b41f7214f06ca886157050c7836b1904f0ccb26f61d8edf

See more details on using hashes here.

File details

Details for the file DbtAlchemy-1.0.1.1-py3-none-any.whl.

File metadata

  • Download URL: DbtAlchemy-1.0.1.1-py3-none-any.whl
  • Upload date:
  • Size: 24.4 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.8.0 pkginfo/1.9.6 readme-renderer/34.0 requests/2.27.1 requests-toolbelt/0.10.1 urllib3/1.26.15 tqdm/4.64.1 importlib-metadata/4.8.3 keyring/23.4.1 rfc3986/1.5.0 colorama/0.4.5 CPython/3.6.8

File hashes

Hashes for DbtAlchemy-1.0.1.1-py3-none-any.whl
Algorithm Hash digest
SHA256 45b2f7abc918c470bb064f9325bf4aba426924db7add965ada2579e3f99ac1ab
MD5 30d3319be3e2fed0de2967b36819b786
BLAKE2b-256 fd1c99e460eaf5f7f651c5d218da0a4cc279b79674dea1cbbbb53842a3d4edc7

See more details on using hashes here.

Supported by

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