[Zope-DB] Example for RDB persistency in zope products?
dieter at handshake.de
Fri Jun 25 14:59:02 EDT 2004
Nick Bower wrote at 2004-6-25 20:22 +0200:
>Does anyone have any examples of how I code relational database
>persistency into an object (at a Zope product level)?
>I've an application written to view and manage complex organisational
>data in Python scripts, ZPTs and ZSQL methods, and would like to move it
>to the product level and into persistent object land. However, the RDB
>persistency aspect is what I'm most confused about.
>I've seen people talk about doing the following:
>1. Inherit from ZSQL methods for their business objects
>2. Call ZSQL methods from their business object logic
>3. Using an existing DA, such as psycopg, directly, bypassing ZSQL
>methods, and calling the DA connection methods from business logic
>4. Writing their own DA for integration with business logic
>3. would have seemed to me like the practical way to go, but I'm just
>not sure where to start for lack of documentation promoting any way
>other than using ZSQL.
I would use Z SQL Methods.
If necessary, I would use them as class variables:
from Products.ZSQLMethods.SQL import SQL
mySQLMethod1 = SQL('mySQLMethod1', ''
connection_id, arguments1, template1)
mySQLMethod2 = SQL('mySQLMethod2', ''
connection_id, arguments2, template2)
You can then access them via "YourInstance.mySQLMethod1", ...
More information about the Zope-DB