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

Project details


Release history Release notifications | RSS feed

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.

Source Distribution

collective.pfg.sqladapter-1.0.tar.gz (14.1 kB view hashes)

Uploaded Source

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page