Reuven M. Lerner wrote:

Hi, everyone. I'm working on a Zope product that uses ZSQL methods to connect to PostgreSQL. So far, I've used the Web-based interface to create my methods, but I'm getting a little tired of doing so. Moreover, I would like to be able to check the methods into CVS along with the rest of the product.

I'm sure that there's a simple way to do this; after all, if I can keep my templates in a "zpt" directory, it shouldn't be that hard for me to keep my SQL in a "zsql" directory. But my searches haven't uncovered any obvious answers. Does anyone have any hints as to how I could/should do this? Is there a reason why this isn't a popular way to go about doing things?

http://www.zope.org/Members/jccooper/extzsql/ Even if you don't want to use the Product, the README will show you how it's done without. --jcc