HowDoIUseSQLScript

Zope3 relational database access using SQLScript

0. Preamble

Zope3 has two solid mechanisms for integrating to a relational database:

SQLScript (ZSQL Method in Zope)

SQLAlchemy

I chose to use SQLScript over SQLAlchemy because:

It uses plain and simple SQL (no new language to learn);

There is no magic, it just executes the SQL that you provide;

It suits the Zope3 view / viewlet paradigm well

The examples are available in an accompanying document called HowDoIUseSQLScript.shar . This is a UNIX Shell Archive. Execute it to extract the files. ( I was unable to attach files in this wiki ).

Code Generator for formlib or z3c.form

There is significant work in getting the zope3 configurations right for the patterns in this tutorial. To make life easier, I have written a generator. Download it using Subversion:

svn checkout http://zope3tutorial.googlecode.com/svn/trunk/ zope3tutorial-read-only

Contents

SQLDemo1 Installation

SQLDemo2 Using SQL from Code

SQLDemo3 A structure for code

SQLDemo4 Useful patterns for SQL in Zope

SQLDemo5 Caching

SQLDemo6 Content Based Approaches

... --PjotrPrins?, Wed, 09 Jan 2008 06:52:53 +0000 reply

Thanks, Kevin for this comprehensive explanation.

... --timh, Thu, 15 May 2008 01:51:45 -0400 reply

Hi Kevin

I am trying to play with your Code Generator, but can't find utility.ump.folder which is used in you generator template. Its not in the svn on google code. Can you make it available ?

Thanks

Tim

... --kevingill, Thu, 15 May 2008 10:55:50 -0400 reply

I uploaded the UMP code that is needed by the generated code. This code is not suitable for deployment. (It should be considered for learning purposes only.)