Products.sqlpfgadapter

Introduction

The goal for this package is:

• to make SQL storage from PloneFormGen easy
• to be usable with collective.megaphone

To achieve this, we create a new PloneFormGen action-adapter. This uses SQLAlchemy (collective.lead) to save the form data to the database. (SQLAlchemy should work on most SQL dialects.)

You could also save PFG data in SQL by using a Z SQL Method as an after-validation script, as described in the SQL-CRUD-tutorial. This works, but:

• it's a lot of manual work, and quite cumbersome for ordinary users
• it doesn't work with collective.megaphone (see mailinglist-discussion)

Installing

svn co https://svn.plone.org/svn/collective/Products.PloneFormGen/adapters/Products.sqlpfgadapter/buildout/plone4 sqlpfg-plone4
cd sqlpfg-plone4
python2.6 bootstrap.py
./bin/buildout -c buildout-dvl.cfg

svn co https://svn.plone.org/svn/collective/Products.PloneFormGen/adapters/Products.sqlpfgadapter/buildout/plone3 sqlpfg-plone3
cd sqlpfg-plone3
python2.4 bootstrap.py
./bin/buildout -c buildout-dvl.cfg

Configuration

As a site admin, go to the "SQL Settings" in Plone's control panel. You'll be taken to "@@sqlpfg-controlpanel". Here you can set your database connection settings.

Usage

To save a form's data in the database, add an "SQL Storage" from the "Add new..." menu in the Form Folder. Give it a title and save it.

A database table will be created. Its name is generated (from the Form Folder's id, among others), you can see it by viewing the adapter object. The table has an 'id' column, and a column for each form field.

That's it! From now on, succesfully submitted forms will be stored in the database.

Limitations

This product is under development. For now, we have major limitations:

• Not all PloneFormGen fields work, notably:
  • file field
  • rating-scale field
• Adding and removing fields, or changing their names, doesn't change the database table. Field names for which there is no column will just be discarded.

Compatibility / Dependencies

Tested with:

• Plone: 3.3.5, 4.0
• PloneFormGen: 1.6.0b4, 1.6.0b5
• megaphone: 1.4.1, 2.0b1
• collective.lead 1.0, SQLAlchemy 0.4.8
• SQL: MySQL 5.1.41

This product uses plone.app.registry for its controlpanel. In order for it to work, use its "Known good set" (see section "Developers" above).

Changelog