Products.SQLAlchemyDA 0.5.1

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.stx

and 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)

last updated on:
October 5th, 2010, 12:57 GMT
price:
FREE!
developed by:
Andreas Jung
license type:
GPL (GNU General Public License) 
category:
ROOT \ Database \ Database APIs

FREE!

In a hurry? Add it to your Download Basket!

user rating

UNRATED
0.0/5
 

0/5

What's New in This Release:
  • Fixed typo in type mapping
read full changelog

Add your review!

SUBMIT