Products.SQLAlchemyDA A generic database adapter for Zope 2
Download

Products.SQLAlchemyDA Ranking & Summary

Products.SQLAlchemyDA Tags

database Zope database Zope database adapter adapter

Products.SQLAlchemyDA Description

A generic database adapter for Zope 2 Products.SQLAlchemyDA is a generic database adapter for ZSQL methods. Since it is based on SQLAlchemy, SQLAlchemyDA supports all databases out-of-the box that are supported by SQLAlchemy (Postgres, MySQL, Oracle, SQLite, MS-SQL, Firebird, Informix).Installation: * download and install SQLAlchemy as egg or from the sources from Cheeseshop (easy_install sqlalchemy). See http://www.sqlalchemy.org for details * download and install z3c.sqlalchemy as egg or from the sources from Cheeseshop (easy_install z3c.sqlalchemy). See http://cheeseshop.python.org/pypi/z3c.sqlalchemy/ for details. * unpack the archive containing SQLAlchemyDA inside the "Products" directory of your Zope instance home. * after restarting Zope you go to the ZMI and create an instance of "SQLAlchemyDA" (as you would create some DA instance) * click on the new created SQLAlchemyDA instance within the ZMI and configure your database connection through the "Properties" tab. The connection parameter 'dsn' must be specified as a valid SQLAlchemy DSN like < dbschema >://< username >:< password >@< hostname >/< databasename > Example: postgres://admin:123@localhost:5432/TestDB * ZSQL methods should see the new DA through the selection widget of available database adapters * NOTE: you must have the low-level Python DB drivers installed in order to access a particular database. See http://www.sqlalchemy.org/docs/dbengine.html#dbengine_supported for details.Configuration of SQLAlchemyDA: * 'dsn' - SQLAlchemy compliant Database Set Name (see www.sqlalchemy.org/docs) * 'transactional' - uncheck this property if you are working with a non-transactional database like older versions of MySQL. Uncheck this property only if you see any commit() related error. Otherwise leave this property checked. Changing this property requires a Zope restart. * 'quoting_style' - affects how strings are quoted in SQL. By default 'standard' quotes strings correctly. Setting the value to 'no-quote' might solve quoting issues with some databases.Using SQLAlchemyDA:SQLAlchemyDA works as a database adapter as documented within "The Zope Book"http://www.plope.com/Books/2_7Edition/RelationalDatabases.stxand can be used like any other DA together with ZSQL methods.Tested with databases: * Postgres 7.4, 8.0-8.2 * SQLite 3.3.X * Oracle 10g * MySQL is only supported for MySQL databases with transaction support. (see also z3c/sqlalchemy/README.txt) Requirements: · Zope · Python · SQLAlchemy · z3c.sqlalchemy What's New in This Release: · Fixed typo in type mapping

Products.SQLAlchemyDA Related Software