[Zope-dev] SQL/ZPatterns examples posted to Zope.org

[Steve Spicklemire]

I've had several folks ask for some ZPatterns examples with SQL. I've
*finally* gotten around to providing them.

They're at: http://www.zope.org/Members/sspickle 

The first is a school attendance application 'skeleton' with the
following description:

An example of ZPatterns using SQL. Gadfly is the database so everyone
can use it. There are a couple of novel aspects 1) a 'generic' object
management UI that is acquired by all the Specialists and 2) levers to
manage all the SQL and SkinScript.

After you have the products and folder installed, you'll need to create
the database tables (run createAllTables_html) and then add some data.
There is a very crude admin UI for each Specialist that you can get to
from the main 'view' page by clicking on the link for that Specialist.
Follow the "object model":attendanceModel.gif to see how to hook things up.

If you change any of the ZClass propertysheets you'll need to rerun the
levers to create all the SQL queries and SkinScript. (You'll probably
also need to drop/re-create the relevant database tables)

The second is a school lunch application 'skeleton' which is 99%
similar, except that it uses a filesystem base class for the 'Lunch'
object, just to show how it can be done.

Feedback most welcome!

thanks,
-steve