It might seem intimidating, but hooking Zope up to a MySQL database is easier than you think. And once you've got the two talking nice to each other, it becomes even simpler to create dynamic, Zope-based Web applications. Take a look.
Here too, the process is similar - first create a Z SQL Method containing an INSERT query, and then invoke the Method from a DTML script. There's one important difference here, though - since the data to be entered is not hard-wired, but rather user-defined, the query string must be constructed dynamically.
In order to see how this works, create a new Z SQL Method - I've called mine "insertMethod" - and add the following values to the argument field:
title director cast genre
These arguments can then be used to dynamically construct a query. Here's what
I would put into the query template:
INSERT INTO dvd (title, director, cast, genre) values (<dtml-sqlvar
type="string">, <dtml-sqlvar director type="string">,
type="string">, <dtml-sqlvar genre type="string">)
I'm sure the linkage between the arguments and the query template is now clear
- the arguments passed to the Z SQL Method can be accessed in the query template to dynamically create a new INSERT query every time the method is invoked.
In case you're wondering, the <dtml-sqlvar> construct is very similar to the <dtml-var> construct, except that it comes with a couple of additional, SQL-specific features - for example, the "type" attribute, which makes it possible to specify the data type of the values being inserted and thereby catch errors before the data gets inserted into the database, and the ability to automatically "quote" values before inserting them into the database.
So that takes care of the SQL. Now, how about a form to invoke this method and pass arguments to it?
When this form is submitted, the form processor will need to invoke the "insertMethod" Z SQL Method, use the form variables to dynamically fill up the query template and execute the INSERT query. Here's what it looks like:
<a href="list">View the entire collection</a> or
Fairly simple, this - the <dtml-call> construct is used to invoke the selected
Z SQL Method, and a neat little result screen is displayed. The form variables submitted to the form processor are automatically picked up by the Z SQL Method and used to construct the INSERT query string.