Forgot your password?
New user?
Document Actions
Simple SQL CRUD With PloneFormGen
This Tutorial applies to: Any version.
A step-by-step lesson in using PloneFormGen to read, insert and update rows in a single SQL table.
smcmahon
All content on one page (useful for printing, presentation mode etc.)
- Introduction One of the goals of PloneFormGen is that it should be useful for simple update operations on an external database.
- Database Table & Form In this step, we create a simple database table and a matching form.
- Inserting rows In this step, we create a method to insert a row, and show how to make simple use of it.
- 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.
- Updating or Inserting as Necessary In this step, we'll create an update SQL method and show how to selectively update or insert data.
- A Note on Security It takes extra steps to secure a database connection and SQL methods.
