{ "info": { "author": "Jarn AS", "author_email": "info@jarn.com", "bugtrack_url": null, "classifiers": [], "description": "collective.saoraclefixes\n========================\n\nFix SQLAlchemy 0.4 and 0.5 Oracle quoting and offset/limit problems.\n\nThis package monkeypatches the SQLAlchemy Oracle driver with backports from\nthe SQLAlchemy 0.6 branch. Fixes included are:\n\n- Reserved words. Before 0.6 no Oracle-specific reserved words were included,\n requiring you to rename columns and labels, making it difficult to code\n in a database-neutral fashion.\n\n Note that the oracle reserved words list in this package is a superset of\n the list in SQLAlchemy 0.6 (at least until SQLAlchemy branches/rel_0_6\n r6245). This package includes semi-reserved identifiers as defined by the\n `Oracle V$RESERVED_WORDS view`_\n\n- Bindparameter quoting. Using a reserved word as a bind parameter requires\n quoting as well. Parameters are quoted in the generated SQL code, and all\n use of the parameters during execution correctly uses the quoted versions.\n\n- Limit/offset handling. 0.6 introduces a (much) better method of implementing\n query limits and offsets in Oracle, following recommended Oracle practice.\n The 0.4/0.5 method could result in incorrect ordering, or would completely\n fail when sorting on a aliased column.\n\n The backport includes support for the optimize_limits=False dialect flag.\n For more information on the change, see `SQLAlchemy ticket #536`_.\n\nTo use, simply add an import to this package::\n\n import collective.saoraclefixes # apply oracle fixes\n\nNote that the patches will only apply when SQLAlchemy versions 0.4 and 0.5 are\nused. All patching activity will be logged via python's logger module with\nloglevel DEBUG.\n\n\nLicense\n-------\n\ncollective.saoraclefixes is distributed under the `MIT license\n`_, just like SQLAlchemy.\n\nCredits\n-------\n\nBackporting work\n `Martijn Pieters`_ at Jarn_\n\n\n.. _Oracle V$RESERVED_WORDS view: http://bit.ly/nZkeD\n.. _SQLAlchemy ticket #536: http://www.sqlalchemy.org/trac/ticket/536\n.. _Martijn Pieters: mailto:mj@jarn.com\n.. _Jarn: http://www.jarn.com/\n\n\nChangelog\n=========\n\n1.2 - 2009-08-20\n----------------\n\n* Disable FromClause.default_order_by in 0.4; 0.5 removes this functionality\n altogether, it's not needed, and interferes with the quoting of rowid on\n Oracle.\n\n1.1 - 2009-08-12\n----------------\n\n* Add the improved LIMIT/OFFSET handling from 0.6.\n\n1.0 - 2009-08-05\n----------------\n\n* Initial release", "description_content_type": null, "docs_url": null, "download_url": "UNKNOWN", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "http://svn.plone.org/svn/collective/collective.saoraclefixes", "keywords": "sqlalchemy oracle reservedwords quoting bindparam", "license": "MIT", "maintainer": null, "maintainer_email": null, "name": "collective.saoraclefixes", "package_url": "https://pypi.org/project/collective.saoraclefixes/", "platform": "UNKNOWN", "project_url": "https://pypi.org/project/collective.saoraclefixes/", "project_urls": { "Download": "UNKNOWN", "Homepage": "http://svn.plone.org/svn/collective/collective.saoraclefixes" }, "release_url": "https://pypi.org/project/collective.saoraclefixes/1.2/", "requires_dist": null, "requires_python": null, "summary": "Fixes for the SQLAlchemy 0.4 and 0.5 Oracle driver", "version": "1.2" }, "last_serial": 656930, "releases": { "1.0": [ { "comment_text": "", "digests": { "md5": "4e88d1533f56810d4847f57fae27dbf8", "sha256": "643990d4176721f40a7d6bd21ee3351ca63954f1166834236364c40ba0c97762" }, "downloads": -1, "filename": "collective.saoraclefixes-1.0.zip", "has_sig": false, "md5_digest": "4e88d1533f56810d4847f57fae27dbf8", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 9383, "upload_time": "2009-08-05T17:08:24", "url": "https://files.pythonhosted.org/packages/d1/06/f43c783a629b1027a429295a53dd7b784033d244f5f2d8e9e9c97c2b5497/collective.saoraclefixes-1.0.zip" } ], "1.1": [ { "comment_text": "", "digests": { "md5": "614895c248cd9599baa504075e876721", "sha256": "f857f91bb0de9ba970b33e1aeb825d782052774419f956fbcc1981a0351d7e25" }, "downloads": -1, "filename": "collective.saoraclefixes-1.1.zip", "has_sig": false, "md5_digest": "614895c248cd9599baa504075e876721", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 11708, "upload_time": "2009-08-12T11:39:20", "url": "https://files.pythonhosted.org/packages/0b/94/0685d1586d81a9136d4bae35078a2d8d5470f4ba1ac5c289a224804c4246/collective.saoraclefixes-1.1.zip" } ], "1.2": [ { "comment_text": "", "digests": { "md5": "e6ed7379921d200b2899e68ed80949d9", "sha256": "7d37314bf3732b4fdf80c9cebe36c997d16cd27432111429de11f7f80088fe96" }, "downloads": -1, "filename": "collective.saoraclefixes-1.2.zip", "has_sig": false, "md5_digest": "e6ed7379921d200b2899e68ed80949d9", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 12145, "upload_time": "2009-08-20T14:28:34", "url": "https://files.pythonhosted.org/packages/79/27/d368b4510f349acad826057a6ee4f920252aa3d79693d0030cb99d280a52/collective.saoraclefixes-1.2.zip" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "e6ed7379921d200b2899e68ed80949d9", "sha256": "7d37314bf3732b4fdf80c9cebe36c997d16cd27432111429de11f7f80088fe96" }, "downloads": -1, "filename": "collective.saoraclefixes-1.2.zip", "has_sig": false, "md5_digest": "e6ed7379921d200b2899e68ed80949d9", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 12145, "upload_time": "2009-08-20T14:28:34", "url": "https://files.pythonhosted.org/packages/79/27/d368b4510f349acad826057a6ee4f920252aa3d79693d0030cb99d280a52/collective.saoraclefixes-1.2.zip" } ] }