Simple SQL CRUD With PloneFormGen

A step-by-step lesson in using PloneFormGen to read, insert and update rows in a single SQL table.

1. Introduction One of the goals of PloneFormGen is that it should be useful for simple update operations on an external database.
2. Database Table & Form In this step, we create a simple database table and a matching form.
3. Inserting rows In this step, we create a method to insert a row, and show how to make simple use of it.
4. Reading a Row, Filling in the Fields If we want to update records, we're going to have to get rows from our SQL table and use the columns to populate our form fields.
5. Updating or Inserting as Necessary In this step, we'll create an update SQL method and show how to selectively update or insert data.
6. A Note on Security It takes extra steps to secure a database connection and SQL methods.

All content on one page (useful for printing, presentation mode etc.)