pas.plugins.sqlalchemy 0.2

SQLAlchemy-based PAS user/group/prop store.

SQLAlchemy PAS plugin

This package is a fork of the SQLPASPlugin. It uses SQLAlchemy as the database abstraction layer; some tests have been rewritten but most are preserved. It’s used in production with a PostgreSQL database.

Setup

To configure the plugin with a database, use z3c.saconfig and define a named scoped session “pas.plugins.sqlalchemy”.

Example:

<include package="z3c.saconfig" file="meta.zcml" />
<db:engine name="pas" url="postgres://localhost/pas" />
<db:session name="pas.plugins.sqlalchemy" engine="pas" />

Install the plugin using the included GenericSetup-profile. Note that tables will created automatically on installation.

You can reinstall anytime to create non-existing tables. Note that tables are preserved on uninstallation.

Memberdata

The users table has an extensive number of metadata fields; it’s on the to-do to figure out a nice way to make this pluggable.

Credits

Authors

• Rocky Burt <[e-mail]> of ServerZen Software

• Nate Aune <[e-mail]> of Jazkarta

• Stefan Eletzhofer <[e-mail]> of InQuant

• Malthe Borch <[e-mail]>

Contributors

• Ruda Porto Filgueiras <[e-mail]>

• Daniel Nouri <[e-mail]>

• Dorneles Treméa <[e-mail]> of Jarn

• Wichert Akkerman <[e-mail]> of Simplon

• Riccardo Lemmi <[e-mail]> of Reflab Srl

Sponsors

• Thanks to ChemIndustry.com Inc. for financing the development of SQLPASPlugin

• Thanks to Statens Byggeforskninginstitut (http://www.sbi.dk) for sponsoring the caching support.

• Thanks to Gis & Web S.r.l. (http://www.gisweb.it) for sponsoring the groups management support.

License

GNU GPL v2 (see LICENCE.txt for details)

Changelog

0.2 (released 2009/7/17)

• Changed the ‘listed’ and ‘ext_editor’ column type to ‘Integer’ match the Plone model. [seletz]

0.1 (released 2009/7/17)

• Initial public release.