{ "info": { "author": "IBM Application Development Team", "author_email": "opendev@us.ibm.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 4 - Beta", "Intended Audience :: Developers", "License :: OSI Approved :: Apache Software License", "Operating System :: OS Independent", "Topic :: Database :: Front-Ends" ], "description": "IBM_DB_SA\n=========\n\nThe IBM_DB_SA adapter provides the Python/SQLAlchemy interface to IBM Data Servers.\n\nVersion\n--------\n0.3.3 (2016/08/30)\n\nPrerequisites\n--------------\n1. Python 2.5.x or Jython 2.5.x .\n2. SQLAlchemy 0.7.3 or above.\n3. IBM_DB driver and IBM_DB_DBI wrapper 1.0.1 or higher\n\nInstall and Configuration\n=========================\nThe IBM_DB_SA Python Egg component (.egg) can be installed using the standard setuptools provided by the Python Easy Install through Python Entreprise \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 IBM_DB_SA:\n\n 1. To install IBM_DB_SA egg component available in the remote repositories\n (pypi.python.org):\n Windows:\n > easy_install ibm_db_sa\n Linux/Unix:\n $ sudo easy_install ibm_db_sa\n \n 2. To install IBM_DB_SA egg component from the downloaded .egg file\n Windows:\n > easy_install ibm_db_sa-x.x.x-pyx.x.egg\n Linux/Unix:\n $ sudo easy_install ibm_db_sa-x.x.x-pyx.x.egg\n \n 3. To install IBM_DB_SA from source\n Standard Python setup should be used::\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(\"db2+ibm_db://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(\"db2+ibm_db://user:pass@/database\")\n\nSupported Databases\n-------------------\n- IBM DB2 Universal Database for Linux/Unix/Windows versions 9.7 onwards\n\nKnown Limitations in ibm_db_sa adapter for DB2 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\n7) PyODBC and Jython/zxjdbc support is experimental\n\n\nCredits\n-------\nibm_db_sa for SQLAlchemy was first produced by IBM Inc., targeting version 0.4.\nThe library was ported for version 0.6 and 0.7 by Jaimy Azle.\nPort for version 0.8 and modernization of test suite by Mike Bayer.\n\nContributing to IBM_DB_SA python project\n----------------------------------------\nSee `CONTRIBUTING\n`_.\n\n```\nThe developer sign-off should include the reference to the DCO in remarks(example below):\nDCO 1.1 Signed-off-by: Random J Developer \n```", "description_content_type": "text/markdown", "docs_url": null, "download_url": "http://code.google.com/p/ibm-db/downloads/list", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "http://pypi.python.org/pypi/ibm_db_sa/", "keywords": "sqlalchemy database interface IBM Data Servers DB2 Informix IDS", "license": "Apache License 2.0", "maintainer": "", "maintainer_email": "", "name": "ibm-db-sa", "package_url": "https://pypi.org/project/ibm-db-sa/", "platform": "All", "project_url": "https://pypi.org/project/ibm-db-sa/", "project_urls": { "Download": "http://code.google.com/p/ibm-db/downloads/list", "Homepage": "http://pypi.python.org/pypi/ibm_db_sa/" }, "release_url": "https://pypi.org/project/ibm-db-sa/0.3.5/", "requires_dist": null, "requires_python": "", "summary": "SQLAlchemy support for IBM Data Servers", "version": "0.3.5" }, "last_serial": 5341797, "releases": { "0.1.1": [ { "comment_text": "SQLAlchemy adapter", "digests": { "md5": "dce5572831fe589645a16d5817b52cc2", "sha256": "a7def63f852772c8a3122bbb981ce607c5b4502c0036b5ef90a6f5522f38c6ed" }, "downloads": -1, "filename": "ibm_db_sa-0.1.1-py2.5.egg", "has_sig": false, "md5_digest": "dce5572831fe589645a16d5817b52cc2", "packagetype": "bdist_egg", "python_version": "2.5", "requires_python": null, "size": 27818, "upload_time": "2008-03-06T14:38:43", "url": "https://files.pythonhosted.org/packages/f0/13/a7e00988651a0ad09e535ef9869fc3c6806d39b36899f480e102e269991e/ibm_db_sa-0.1.1-py2.5.egg" }, { "comment_text": "SQLAlchemy adapter source", "digests": { "md5": "2ecd71812c9cc13df49f54d8b85c1925", "sha256": "13f0142b80728679a16d429d20e064af775958e7a833fdaebf1b51b31fd21b86" }, "downloads": -1, "filename": "ibm_db_sa-0.1.1.tar.gz", "has_sig": false, "md5_digest": "2ecd71812c9cc13df49f54d8b85c1925", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 16508, "upload_time": "2008-03-06T14:38:21", "url": "https://files.pythonhosted.org/packages/ff/43/1cadad450d8eaf86253d1b9a05e6f93952b64475e2299c205aa0c10c6ade/ibm_db_sa-0.1.1.tar.gz" } ], "0.1.5": [ { "comment_text": "SQLAlchemy adapter", "digests": { "md5": "5a0014dee7fe9e1a816bb408758e828e", "sha256": "eb6106566a8cb88f0520a0d3f255484dbef546e0c089035a159cd8e8f7020cc6" }, "downloads": -1, "filename": "ibm_db_sa-0.1.5-py2.5.egg", "has_sig": false, "md5_digest": "5a0014dee7fe9e1a816bb408758e828e", "packagetype": "bdist_egg", "python_version": "2.5", "requires_python": null, "size": 28124, "upload_time": "2008-03-28T22:05:15", "url": "https://files.pythonhosted.org/packages/28/7d/af0764a93e106bba1ce410b04dec9a21bb35d07022f9d90803b3e9ff3b34/ibm_db_sa-0.1.5-py2.5.egg" }, { "comment_text": "SQLAlchemy adapter source", "digests": { "md5": "ae1c59e7389a8bf242039938d8d6de32", "sha256": "4171057fe5345a0770bb34b11745daa24c6f95989ef379fa7059f619c4d719eb" }, "downloads": -1, "filename": "ibm_db_sa-0.1.5.tar.gz", "has_sig": false, "md5_digest": "ae1c59e7389a8bf242039938d8d6de32", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 16864, "upload_time": "2008-03-28T22:09:40", "url": "https://files.pythonhosted.org/packages/9b/95/4843f345b790a2e966bb1dba14fba193d82ee83b45f97e23c11e2e2d447d/ibm_db_sa-0.1.5.tar.gz" } ], "0.1.6": [ { "comment_text": "SQLAlchemy adapter egg", "digests": { "md5": "030144ea507bb87ff7f167393007b40c", "sha256": "fe471b6bb9436a78db7a059d90a52964d6a8b8f54bd87e6d26fddeecce221078" }, "downloads": -1, "filename": "ibm_db_sa-0.1.6-py2.5.egg", "has_sig": false, "md5_digest": "030144ea507bb87ff7f167393007b40c", "packagetype": "bdist_egg", "python_version": "2.5", "requires_python": null, "size": 28292, "upload_time": "2008-11-06T07:45:00", "url": "https://files.pythonhosted.org/packages/bd/28/dd4cb998cf36edd087486ad3729bb35b311026c1a55523c08fa50509f742/ibm_db_sa-0.1.6-py2.5.egg" }, { "comment_text": "SQLAlchemy adapter source", "digests": { "md5": "e22a9ed4cdfc0d21cc550d84d4d0ca99", "sha256": "da83f90e6c0e8863ef4e2ca7cd39a26b1fb1a4a2f61cdbafabc8a57e236576f7" }, "downloads": -1, "filename": "ibm_db_sa-0.1.6.tar.gz", "has_sig": false, "md5_digest": "e22a9ed4cdfc0d21cc550d84d4d0ca99", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 17079, "upload_time": "2008-11-06T07:44:34", "url": "https://files.pythonhosted.org/packages/2d/b7/56aafed52bd2d799fa560240edf7f9adc592936aa7d3293a187e436d66ac/ibm_db_sa-0.1.6.tar.gz" } ], "0.3.0": [ { "comment_text": "SQLAlchemy adapter egg ", "digests": { "md5": "dcddfb42d62881cc74aeea83c785f9a2", "sha256": "dcfe697fd61e40ed3c42a07c32a1bf8bd1f55b169e09f92119c9463f3bb0f9f1" }, "downloads": -1, "filename": "ibm_db_sa-0.3.0-py2.5.egg", "has_sig": false, "md5_digest": "dcddfb42d62881cc74aeea83c785f9a2", "packagetype": "bdist_egg", "python_version": "2.5", "requires_python": null, "size": 47670, "upload_time": "2013-03-01T13:13:15", "url": "https://files.pythonhosted.org/packages/f0/99/2adcddb201470a3ddfb4e14ca6d9a3a2bacd661c702ac152dcb04200a4bc/ibm_db_sa-0.3.0-py2.5.egg" }, { "comment_text": "SQLAlchemy adapter egg ", "digests": { "md5": "7376a29fb001a4383115abb4c7f170de", "sha256": "03694474ab28d78a4722847ce0d714a4fe5021c01451a3ee63afa872aa64a740" }, "downloads": -1, "filename": "ibm_db_sa-0.3.0-py2.6.egg", "has_sig": false, "md5_digest": "7376a29fb001a4383115abb4c7f170de", "packagetype": "bdist_egg", "python_version": "2.6", "requires_python": null, "size": 47610, "upload_time": "2013-03-04T08:44:41", "url": "https://files.pythonhosted.org/packages/31/89/ddf3023958e2d1c7ebf8d8d0542705aa35d03aa2cbcf78784e62187b49de/ibm_db_sa-0.3.0-py2.6.egg" }, { "comment_text": "SQLAlchemy adapter egg ", "digests": { "md5": "c286ab6fe2fbd0e355eb3c9cc955ec58", "sha256": "f638528aa73c8a1c6d5ecc7c296c9cc1a1b52f9ba9b1921aa2a3b0aa8aa72b47" }, "downloads": -1, "filename": "ibm_db_sa-0.3.0-py2.7.egg", "has_sig": false, "md5_digest": "c286ab6fe2fbd0e355eb3c9cc955ec58", "packagetype": "bdist_egg", "python_version": "2.7", "requires_python": null, "size": 47437, "upload_time": "2013-03-04T08:35:14", "url": "https://files.pythonhosted.org/packages/b9/8b/322d6f0affa3e1aa4ec7ddc6126be97539b637460cce27f7b2c6f921c878/ibm_db_sa-0.3.0-py2.7.egg" }, { "comment_text": "SQLAlchemy adapter source ", "digests": { "md5": "61ecb3cc98d20ef62d0097e95db80031", "sha256": "bef4d2964548734085de4077061d96f6612cc6da9f7a975fd602184598e4e8f9" }, "downloads": -1, "filename": "ibm_db_sa-0.3.0.tar.gz", "has_sig": false, "md5_digest": "61ecb3cc98d20ef62d0097e95db80031", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 21606, "upload_time": "2013-03-01T13:12:34", "url": "https://files.pythonhosted.org/packages/6d/b9/72417c3e4484a36f3ab447ddd12ca7c05af15ed9f1bf8dff1d4fb29c5920/ibm_db_sa-0.3.0.tar.gz" } ], "0.3.1": [ { "comment_text": "SQLAlchemy adapter egg ", "digests": { "md5": "298fe90c38a1834b7116bb4719f1817c", "sha256": "45ed0f5e23405698a933a2ec8a2c411b857f01c37c40153e7a6d1814dde258ac" }, "downloads": -1, "filename": "ibm_db_sa-0.3.1-py2.5.egg", "has_sig": false, "md5_digest": "298fe90c38a1834b7116bb4719f1817c", "packagetype": "bdist_egg", "python_version": "2.5", "requires_python": null, "size": 49008, "upload_time": "2014-03-26T18:23:06", "url": "https://files.pythonhosted.org/packages/03/e8/6a5ce0b20e2d2709d53a60e1ebe477908981d0ecaa428ac6505469532a43/ibm_db_sa-0.3.1-py2.5.egg" }, { "comment_text": "SQLAlchemy adapter egg ", "digests": { "md5": "cd931ddf5370bf1350d7900840b0c0c6", "sha256": "0c730423ed97b2fc85825798f762588bff28c993228a5422e18a4ef7447f6172" }, "downloads": -1, "filename": "ibm_db_sa-0.3.1-py2.6.egg", "has_sig": false, "md5_digest": "cd931ddf5370bf1350d7900840b0c0c6", "packagetype": "bdist_egg", "python_version": "2.6", "requires_python": null, "size": 48946, "upload_time": "2014-03-26T18:23:30", "url": "https://files.pythonhosted.org/packages/a4/a6/2075acecca6645f64013f7be31bf1cf034fb5979d77028f95fb9fb060e4b/ibm_db_sa-0.3.1-py2.6.egg" }, { "comment_text": "SQLAlchemy adapter egg ", "digests": { "md5": "9cf26683955c58f96789ba8577651f97", "sha256": "308074976395a7f8d279352eeb0171f46bc41c36afe295771bd2caeb8a76ac50" }, "downloads": -1, "filename": "ibm_db_sa-0.3.1-py2.7.egg", "has_sig": false, "md5_digest": "9cf26683955c58f96789ba8577651f97", "packagetype": "bdist_egg", "python_version": "2.7", "requires_python": null, "size": 48726, "upload_time": "2014-03-26T18:23:49", "url": "https://files.pythonhosted.org/packages/d6/7a/09ee64424551905fdfd265fa0becfcef3cbc179a2dfc2f688725b905296b/ibm_db_sa-0.3.1-py2.7.egg" }, { "comment_text": "SQLAlchemy adapter source ", "digests": { "md5": "f79124dbb8c524c46540575140e074ac", "sha256": "d72121d0ecc7e5e024bff065e73e694fe6aa9198b9fcda8c929f227d6edc763f" }, "downloads": -1, "filename": "ibm_db_sa-0.3.1.tar.gz", "has_sig": false, "md5_digest": "f79124dbb8c524c46540575140e074ac", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 22765, "upload_time": "2014-03-26T18:22:04", "url": "https://files.pythonhosted.org/packages/34/46/8b4a36403427bfbe178864b2456b354fdc9176d2efca9014c11ccc511a51/ibm_db_sa-0.3.1.tar.gz" } ], "0.3.2": [ { "comment_text": "SQLAlchemy adapter source", "digests": { "md5": "bb165bac4de5ec2fd30f1d823875360a", "sha256": "b709b9ada7557a2048164038fc8b51d3f392caf043250df31fcf62a9045e4b3c" }, "downloads": -1, "filename": "ibm_db_sa-0.3.2.tar.gz", "has_sig": false, "md5_digest": "bb165bac4de5ec2fd30f1d823875360a", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 24034, "upload_time": "2014-10-20T12:30:32", "url": "https://files.pythonhosted.org/packages/65/f0/b6a2790134cd7393f288a80f5f035f69b1813b1d7a0bd8a52528b9d19ec3/ibm_db_sa-0.3.2.tar.gz" } ], "0.3.3": [ { "comment_text": "Source Code", "digests": { "md5": "c825de17cbc5a81ef2659a194be1a506", "sha256": "0185c76d54d9aab5f0e95ff129ad956ca55c474afd6741ca55605a3b9029eacd" }, "downloads": -1, "filename": "ibm_db_sa-0.3.3.tar.gz", "has_sig": false, "md5_digest": "c825de17cbc5a81ef2659a194be1a506", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 24197, "upload_time": "2016-08-31T11:03:42", "url": "https://files.pythonhosted.org/packages/0d/e8/53e626c03a531eab4de86a67c96726081ac90263982048a78485069a013c/ibm_db_sa-0.3.3.tar.gz" } ], "0.3.4": [ { "comment_text": "", "digests": { "md5": "dbbcba9a8f440cf2f1e8b304b57827c0", "sha256": "e35fcc8a95dfa52a0e14928681e748d49696575a4815d07902e27a15e8c1142a" }, "downloads": -1, "filename": "ibm_db_sa-0.3.4.tar.gz", "has_sig": false, "md5_digest": "dbbcba9a8f440cf2f1e8b304b57827c0", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 25638, "upload_time": "2018-08-29T03:30:24", "url": "https://files.pythonhosted.org/packages/97/7a/0b0fa69103683f51cf30a5d7ee75465c136cae17618b90d984709968915a/ibm_db_sa-0.3.4.tar.gz" } ], "0.3.5": [ { "comment_text": "", "digests": { "md5": "c1aded5150af58dbe307be3a157cdf5d", "sha256": "6e87b3ff98ff9444465ca0f0a97e484baf78986eddf7b2f47a2a80581a8b6d37" }, "downloads": -1, "filename": "ibm_db_sa-0.3.5.tar.gz", "has_sig": false, "md5_digest": "c1aded5150af58dbe307be3a157cdf5d", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 27822, "upload_time": "2019-05-31T08:57:02", "url": "https://files.pythonhosted.org/packages/a4/7f/8301cafde62a8a86f7ca9b5b64663431900217742b799797739760c5b9ea/ibm_db_sa-0.3.5.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "c1aded5150af58dbe307be3a157cdf5d", "sha256": "6e87b3ff98ff9444465ca0f0a97e484baf78986eddf7b2f47a2a80581a8b6d37" }, "downloads": -1, "filename": "ibm_db_sa-0.3.5.tar.gz", "has_sig": false, "md5_digest": "c1aded5150af58dbe307be3a157cdf5d", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 27822, "upload_time": "2019-05-31T08:57:02", "url": "https://files.pythonhosted.org/packages/a4/7f/8301cafde62a8a86f7ca9b5b64663431900217742b799797739760c5b9ea/ibm_db_sa-0.3.5.tar.gz" } ] }