[Zope] Generic SQL insert

Chris Withers chris at simplistix.co.uk
Mon Apr 17 10:02:01 EDT 2006


Robert (Jamie) Munro wrote:
> Whenever I'm using SQL databases in zope, I always seem to have to make
> a ZSQL instance for inserting into every table in my database, and they
> are all nearly the same - they just have a list of all the fields in the
> database in the parameters, then they say:
> 
> insert into [table] ([list of fields]) values ([list of <dtml-sqlvar>s])

You're probably better off looking into an ORM like SQLAlchemy...

Chris

-- 
Simplistix - Content Management, Zope & Python Consulting
            - http://www.simplistix.co.uk



More information about the Zope mailing list