Skip to main content

A PloneFormGen adapter that saves form input data in a SQL database

Project description

Introduction

collective.pfg.sqladapter adds a form action adapter to PloneFormGen that saves form input data in a SQL database using SQLAlchemy.

Setup

To install collective.pfg.sqladapter add it to the list of eggs in your buildout.

To configure the database, use z3c.saconfig and define a named scoped session “collective.pfg.sqladapter” in your configure.zcml or in the “zcml-additional” parameter of your buildout.

Example:

<configure xmlns="http://namespaces.zope.org/db">
    <engine name="collective.pfg.sqladapter" url="mysql://user:password@localhost/database" />
    <session name="collective.pfg.sqladapter" engine="collective.pfg.sqladapter" />
</configure>

Run buildout and restart your instance. Then install the product using Quickinstaller.

Usage

To save form input data in your SQL database add a “SQLAdapter” in your Form Folder and enter the name of the table where the input data should be stored.

If a table with the given name does not exist in your database, it will be created with columns corresponding to the fields in your form. Thus the “SQLAdapter” should be added after all fields were added.

Changelog

1.0 (2012-02-20)

  • Initial release

Release history Release notifications

This version

1.0

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for collective.pfg.sqladapter, version 1.0
Filename, size File type Python version Upload date Hashes
Filename, size collective.pfg.sqladapter-1.0.tar.gz (14.1 kB) File type Source Python version None Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page