{ "info": { "author": "Andreas Jung", "author_email": "info@zopyx.com", "bugtrack_url": null, "classifiers": [ "Framework :: Zope2", "Programming Language :: Python", "Topic :: Database" ], "description": "A-like integration of SQLAlchemy based on z3c.sqlalchemy\n========================================================\n\nWhat is SQLAlchemyDA?\n---------------------\n\nSQLAlchemyDA is a generic database adapter for ZSQL methods. Since it is based\non SQLAlchemy, SQLAlchemyDA supports all databases out-of-the box that are\nsupported by SQLAlchemy (Postgres, MySQL, Oracle, SQLite, MS-SQL, Firebird,\nInformix). \n\n\nRequirements:\n-------------\n\n- Zope 2.10+\n- SQLAlchemy >= 0.5.0 (+ database specific low-level Python drivers)\n- z3c.sqlalchemy >= 1.2.0\n\n\nInstallation:\n-------------\n\n- download and install SQLAlchemy as egg or from the sources\n from Cheeseshop (easy_install sqlalchemy). See\n \n http://www.sqlalchemy.org\n\n for details\n\n- download and install z3c.sqlalchemy as egg or from the sources \n from Cheeseshop (easy_install z3c.sqlalchemy). See\n\n http://cheeseshop.python.org/pypi/z3c.sqlalchemy/\n\n for details.\n\n- unpack the archive containing SQLAlchemyDA inside the \"Products\"\n directory of your Zope instance home.\n\n- after restarting Zope you go to the ZMI and create an instance of\n \"SQLAlchemyDA\" (as you would create some DA instance)\n\n- click on the new created SQLAlchemyDA instance within the ZMI\n and configure your database connection through the \"Properties\" tab.\n The connection parameter 'dsn' must be specified as a valid SQLAlchemy DSN \n like\n\n ://:@/\n\n Example:\n \n postgres://admin:123@localhost:5432/TestDB\n\n- ZSQL methods should see the new DA through the selection widget of available\n database adapters\n\n- NOTE: you must have the low-level Python DB drivers installed in order to \n access a particular database. See \n\n http://www.sqlalchemy.org/docs/dbengine.html#dbengine_supported\n\n for details.\n\n\nConfiguration of SQLAlchemyDA:\n------------------------------\n\n- 'dsn' - SQLAlchemy compliant Database Set Name (see www.sqlalchemy.org/docs)\n\n- 'transactional' - uncheck this property if you are working with a non-transactional\n database like older versions of MySQL. Uncheck this property *only* if you see any\n commit() related error. Otherwise leave this property checked. Changing this\n property *requires* a Zope restart.\n\n- 'quoting_style' - affects how strings are quoted in SQL. By default 'standard' \n quotes strings correctly. Setting the value to 'no-quote' might solve quoting issues\n with some databases.\n\n\nUsing SQLAlchemyDA:\n-------------------\n\nSQLAlchemyDA works as a database adapter as documented within \"The Zope Book\"\n\nhttp://www.plope.com/Books/2_7Edition/RelationalDatabases.stx\n\nand can be used like any other DA together with ZSQL methods.\n\n\nTested with databases:\n----------------------\n\n- Postgres 7.4, 8.0-8.2\n- SQLite 3.3.X\n- Oracle 10g\n- MySQL is *only* supported for MySQL databases with transaction support.\n (see also z3c/sqlalchemy/README.txt) \n \n\nKnown issues:\n-------------\n\n\"\"\" Database connection could not be opened ((ProgrammingError) (1064, You\nhave an error in your SQL syntax near 'COMMIT .\n\"\"\"\n\nThis bug might appear with older MySQL versions when opening/closing\nthe connections manually through the ZMI. It should not affect the\nfunctionality of SQLAlchemyDA.\n \n\nAuthor\n======\nSQLAlchemyDA was written by Andreas Jung for Haufe Mediengruppe, Freiburg,\nGermany and ZOPYX Ltd. & Co. KG, Tuebingen, Germany.\n\n\nLicense\n=======\nSQLAlchemyDA is licensed under the Zope Public License 2.1. \nSee LICENSE.txt.\n\n\nContact\n=======\n\n| ZOPYX Ltd. & Co. KG\n| Andreas Jung\n| E-mail: info at zopyx dot com\n| Web: http://www.zopyx.com\n\n\nCredits\n=======\nParts of the SQLAlchemyDA V 0.3.X development has been sponsored by Wayne\nVolkmuth (renovis.com)\n\nCHANGES\n=======\n\n0.5.1 (2010-08-05)\n------------------\n- fixed typo in type mapping\n\n0.5.0 (2010-05-07)\n------------------\n\n- Fixed LP #570208\n- Added a method 'add_extra_engine_options' to set additional engine\n options for SQLAlchemy.create_engine.\n- Removed SOFTWARE_HOME dependency\n- Requires SQLALchemy >= 0.5.0\n\n0.4.1 (2008-06-01)\n------------------\n\n- fixed issue with version.txt file\n\n0.4.0 (2008-01-24)\n------------------\n\n- requires z3c.sqlalchemy (2.0.0 or higher)\n- requires SQLAlchemy 0.4.4 or higer\n\n\n0.3.0 (2007-06-10)\n------------------\n\n- fixed some security assertions\n- added \"Test\" tab for executing SQL queries directly\n- better error handling for ZMI screens\n- no longer depending on a pre-registered SQLAlchemy wrapper. SQLAlchemyDA\n now accepts (as any other DA) a DSN as property 'dsn'\n- DSN can be passed through the add form\n- redirect directly to \"Info\" tab after creating an instance through the ZMI\n- catching some low-level exceptions from the sqlite interface in order to\n make it work with SQLite\n- new properties 'transactional' and 'quoting_style'\n- improved support for Oracle and MySQL\n- SQLAlchemyDA no longer provides access to mapper related functionalities.\n It now acts as a DA for executing SQL statements *only*.\n- fixed unregistration code for a wrapper (hopefully works with Zope 2.8 or\n higher)\n\n- updated documentation\n\n0.2.1 (2007-05-06)\n------------------\n\n- connections can be closed/opened through the ZMI\n- some code cleanup\n- fixed a *very* stupid typo causing ZODB conflict errors\n\n0.2.0 (2007-05-05)\n------------------\n\n- first public release\n\n0.1.0 (2007-04-30)\n------------------\n\n- initial coding", "description_content_type": null, "docs_url": null, "download_url": "UNKNOWN", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "http://opensource.zopyx.com/projects/SQLAlchemyDA", "keywords": "Zope2 Database adapter SQLAlchemy", "license": "ZPL (see LICENSE.txt)", "maintainer": null, "maintainer_email": null, "name": "Products.SQLAlchemyDA", "package_url": "https://pypi.org/project/Products.SQLAlchemyDA/", "platform": "UNKNOWN", "project_url": "https://pypi.org/project/Products.SQLAlchemyDA/", "project_urls": { "Download": "UNKNOWN", "Homepage": "http://opensource.zopyx.com/projects/SQLAlchemyDA" }, "release_url": "https://pypi.org/project/Products.SQLAlchemyDA/0.5.1/", "requires_dist": null, "requires_python": null, "summary": "A generic database adapter for Zope 2", "version": "0.5.1" }, "last_serial": 1613942, "releases": { "0.4.0": [ { "comment_text": "", "digests": { "md5": "3196fb69da4faf310958a86e4b67a0ec", "sha256": "c02b0c8455282e49fbeb40e8f0e637f61a6376849a5c05f545fba4df2987e738" }, "downloads": -1, "filename": "Products.SQLAlchemyDA-0.4.0-py2.4.egg", "has_sig": false, "md5_digest": "3196fb69da4faf310958a86e4b67a0ec", "packagetype": "bdist_egg", "python_version": "2.4", "requires_python": null, "size": 20378, "upload_time": "2008-05-29T04:18:40", "url": "https://files.pythonhosted.org/packages/97/7c/b63f0c4b4c7b08eef71d9d925631986cb755fec4f9edec8bcdf6e160eebe/Products.SQLAlchemyDA-0.4.0-py2.4.egg" } ], "0.4.1": [ { "comment_text": "", "digests": { "md5": "0fd09ec18c935a668edd32803911392b", "sha256": "5dbc8515ff1c848824974c3e99f4f7809eab0057eb81d1a71a634493759c219d" }, "downloads": -1, "filename": "Products.SQLAlchemyDA-0.4.1-py2.4.egg", "has_sig": false, "md5_digest": "0fd09ec18c935a668edd32803911392b", "packagetype": "bdist_egg", "python_version": "2.4", "requires_python": null, "size": 24542, "upload_time": "2008-06-01T11:18:35", "url": "https://files.pythonhosted.org/packages/1e/75/6d5bcab018d468e0c775383c485b536f566e36ab47f58b42f74b401e4554/Products.SQLAlchemyDA-0.4.1-py2.4.egg" } ], "0.5.0": [ { "comment_text": "", "digests": { "md5": "7b3e2845b81983d9f21c5bf7fd4ed4e1", "sha256": "8dfae3cc61da8c161d9252f3ccf4ff799609d2fe9ae77838c4e572df2868f5cd" }, "downloads": -1, "filename": "Products.SQLAlchemyDA-0.5.0.tar.gz", "has_sig": false, "md5_digest": "7b3e2845b81983d9f21c5bf7fd4ed4e1", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 14946, "upload_time": "2010-05-07T19:03:47", "url": "https://files.pythonhosted.org/packages/ce/47/3779e6298c1a21af37d2fa5f1ef38f4581d800f7f8ad8cb8e89c83c3ba00/Products.SQLAlchemyDA-0.5.0.tar.gz" } ], "0.5.1": [ { "comment_text": "", "digests": { "md5": "f7dfea6f347a60453dbe40a000b5f61e", "sha256": "85ea88aea4877919d9d482f915fd5df04db1f504ec29c15917ed0e263534f461" }, "downloads": -1, "filename": "Products.SQLAlchemyDA-0.5.1.tar.gz", "has_sig": false, "md5_digest": "f7dfea6f347a60453dbe40a000b5f61e", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 15598, "upload_time": "2010-08-05T17:20:06", "url": "https://files.pythonhosted.org/packages/de/31/83087bd67b5c91db2422ef57516884acf471676a0ed7d5bcc67b8284e43d/Products.SQLAlchemyDA-0.5.1.tar.gz" } ], "0.6.0b": [ { "comment_text": "", "digests": { "md5": "ee3b68a1fd56ac04c8d4d0ebdf66782e", "sha256": "341900de642351c27a338d4ece1dc30fceb22e9e45c0da7325aad882d3308796" }, "downloads": -1, "filename": "Products.SQLAlchemyDA-0.6.0b.tar.gz", "has_sig": false, "md5_digest": "ee3b68a1fd56ac04c8d4d0ebdf66782e", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 9367, "upload_time": "2015-03-24T04:15:40", "url": "https://files.pythonhosted.org/packages/28/9b/65ab78f708dd87c7bb4699d0fc216ceedf43407da5ee3cbfad958620eecb/Products.SQLAlchemyDA-0.6.0b.tar.gz" } ], "0.6.0b2": [ { "comment_text": "", "digests": { "md5": "ccadf98c7c18290b2b5d17576934441c", "sha256": "091154556117620a3dd0661334dccf45ee4a1c2aa16aa4409c6297eaa3126cd1" }, "downloads": -1, "filename": "Products.SQLAlchemyDA-0.6.0b2.tar.gz", "has_sig": false, "md5_digest": "ccadf98c7c18290b2b5d17576934441c", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 9712, "upload_time": "2015-03-24T14:10:03", "url": "https://files.pythonhosted.org/packages/36/60/57d24d0ca7e8ca72c12b543d1d070d647b352dd7773fd001852c50f66a0a/Products.SQLAlchemyDA-0.6.0b2.tar.gz" } ], "0.6.0b3": [ { "comment_text": "", "digests": { "md5": "91c04173c12243621afc9a1148a83cf2", "sha256": "b7604df5364c2fcb8b71df0e43520385a11e23779048fa8292f6b4b8143bb8a4" }, "downloads": -1, "filename": "Products.SQLAlchemyDA-0.6.0b3.tar.gz", "has_sig": false, "md5_digest": "91c04173c12243621afc9a1148a83cf2", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 10794, "upload_time": "2015-03-24T15:44:48", "url": "https://files.pythonhosted.org/packages/3b/9c/a4c2c255419f5a492bc044ee68960974fe446c7b309a58518a443948d882/Products.SQLAlchemyDA-0.6.0b3.tar.gz" } ], "0.6.0b4": [ { "comment_text": "", "digests": { "md5": "227e0169cf0db202408556b9d06781a1", "sha256": "40837738b6de9c69d83f8e434a65b1b55fca899db30a98a5d584fb093d8aed64" }, "downloads": -1, "filename": "Products.SQLAlchemyDA-0.6.0b4.tar.gz", "has_sig": false, "md5_digest": "227e0169cf0db202408556b9d06781a1", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 16708, "upload_time": "2015-03-24T16:12:59", "url": "https://files.pythonhosted.org/packages/db/b4/dcc87ebeceba56874ac8bbe63c12c4afb5769bd6bf58a21540b6ecdd66f5/Products.SQLAlchemyDA-0.6.0b4.tar.gz" } ], "0.6.0b5": [ { "comment_text": "", "digests": { "md5": "f19c7546d4348c116c80b85c31bde031", "sha256": "f51907b092904b2b289480a417c89d4212ca514c3c641f99a709f44098934d52" }, "downloads": -1, "filename": "Products.SQLAlchemyDA-0.6.0b5.tar.gz", "has_sig": false, "md5_digest": "f19c7546d4348c116c80b85c31bde031", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 17590, "upload_time": "2015-04-22T03:10:24", "url": "https://files.pythonhosted.org/packages/31/cc/c4a639809476f8ff2fe15df8254913df78981fabed263b06fee8f1266a5b/Products.SQLAlchemyDA-0.6.0b5.tar.gz" } ], "0.6.0b6": [ { "comment_text": "", "digests": { "md5": "3773273db00e89c8bd0d7278b0d8c2a7", "sha256": "979c156bb5695054539b8e2966452f41022cd47bb435c9be8acc38513e820d14" }, "downloads": -1, "filename": "Products.SQLAlchemyDA-0.6.0b6.tar.gz", "has_sig": false, "md5_digest": "3773273db00e89c8bd0d7278b0d8c2a7", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 13501, "upload_time": "2015-04-28T01:05:04", "url": "https://files.pythonhosted.org/packages/66/5c/8dff3eb1a6170057bd99a8838f65a35af69d956f4674a826e98c32e43c67/Products.SQLAlchemyDA-0.6.0b6.tar.gz" } ], "0.6.0b7": [ { "comment_text": "", "digests": { "md5": "a8e185ececb129a570dead2996f000ff", "sha256": "52942f42c9f44020658c5ccddc6bd45918097da75a9a916543659c26a90ced83" }, "downloads": -1, "filename": "Products.SQLAlchemyDA-0.6.0b7.tar.gz", "has_sig": false, "md5_digest": "a8e185ececb129a570dead2996f000ff", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 13446, "upload_time": "2015-04-29T15:24:48", "url": "https://files.pythonhosted.org/packages/2d/d1/627bf6cbc65a57866ce7c9dd22d222401609243d994be553331e42836522/Products.SQLAlchemyDA-0.6.0b7.tar.gz" } ], "0.6.1b1": [ { "comment_text": "", "digests": { "md5": "897c0f30f993ac1f8017beedc9898e82", "sha256": "1979a1874176c9e21cdb9e76afa897fca816a44a5a90c0144fa7c280728dc750" }, "downloads": -1, "filename": "Products.SQLAlchemyDA-0.6.1b1.tar.gz", "has_sig": false, "md5_digest": "897c0f30f993ac1f8017beedc9898e82", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 13478, "upload_time": "2015-06-15T16:38:22", "url": "https://files.pythonhosted.org/packages/b0/68/8984628f41476a7104e4ff75273316be1380141cbb18d5d2982452257b13/Products.SQLAlchemyDA-0.6.1b1.tar.gz" } ], "0.6.2b1": [ { "comment_text": "", "digests": { "md5": "633598a9cec7471f57f8a57614ce0483", "sha256": "08d9e33eb1e345c35e1ac88872767de8768efb11407ff8d57380325e44e4aeda" }, "downloads": -1, "filename": "Products.SQLAlchemyDA-0.6.2b1.tar.gz", "has_sig": false, "md5_digest": "633598a9cec7471f57f8a57614ce0483", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 14558, "upload_time": "2015-06-24T04:06:44", "url": "https://files.pythonhosted.org/packages/80/cb/03074beca306997652daf42cefabdc1289c68b152a50254a88f6fdb7ca1f/Products.SQLAlchemyDA-0.6.2b1.tar.gz" } ], "0.6.2b2": [ { "comment_text": "", "digests": { "md5": "5866a27be893f5c11bf2fd92d99a3cdb", "sha256": "8d7df6366622608d13b1b608e09c4d5f93035655044f244c61acb268e401ad26" }, "downloads": -1, "filename": "Products.SQLAlchemyDA-0.6.2b2.tar.gz", "has_sig": false, "md5_digest": "5866a27be893f5c11bf2fd92d99a3cdb", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 15108, "upload_time": "2015-06-30T22:13:46", "url": "https://files.pythonhosted.org/packages/f8/87/c9ef57a2e0080beb9c1fe07c20959440a5aa55018b15277835fa735b4074/Products.SQLAlchemyDA-0.6.2b2.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "f7dfea6f347a60453dbe40a000b5f61e", "sha256": "85ea88aea4877919d9d482f915fd5df04db1f504ec29c15917ed0e263534f461" }, "downloads": -1, "filename": "Products.SQLAlchemyDA-0.5.1.tar.gz", "has_sig": false, "md5_digest": "f7dfea6f347a60453dbe40a000b5f61e", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 15598, "upload_time": "2010-08-05T17:20:06", "url": "https://files.pythonhosted.org/packages/de/31/83087bd67b5c91db2422ef57516884acf471676a0ed7d5bcc67b8284e43d/Products.SQLAlchemyDA-0.5.1.tar.gz" } ] }