[Zope] Zope Products and SQL

[Farrell, Troy]

Thanks, Dieter.

1) Is fine, assuming the ZSQL method is there.
2) The best of my options - I didn't even think of it.
3) Uh, that sounds like some deep zope wizardry.  I'm still working on
OFS.SimpleItem :)
4) I suppose I could even make my product inherit from an ObjectManager and
let it contain ZSQL Methods - didnt' think of this one either, 'till now.

Thanks,
Troy

-----Original Message-----
From: Dieter Maurer [mailto:dieter@handshake.de]
Sent: Sunday, April 01, 2001 2:29 PM
To: Farrell, Troy
Cc: zope@zope.org
Subject: Re: [Zope] Zope Products and SQL


Farrell, Troy writes:
 > Is there any way (aside from importing database modules ie PoPy) to
execute
 > SQL from a Zope Product?  Is it feasible to make the product inherit from
 > ZSQL methods and have them that way, or it is just easiest to use
ZClasses?
You can have many types of use of Z SQL methods from products:

 * use a Z SQL method instance located and managed in
   the Zope hierarchy.
   Such instances would usually be accessed through acquisition.

 * instantiate a new Z SQL method instance as part
   of your product instances

 * derive one of your product classes from Z SQL methods
   (though I think this is rather rare)