Re: [Archetypes-users] Connecting an AT front end to a SQL database back end

[Charlie C. <ch...@be...>]

Am 25.03.2008 um 22:49 schrieb Ken Winter:
> 1. The existing AT-RDB interfaces that I have found (SQLStorage,  
> SQLAlchemy,
> Znolk, APE) seem to be overkill for my purposes, as they want to set  
> up my
> RDB tables for me, create persistent ZODB objects, and keep the ZODB  
> in sync
> with the RDB contents.  If someone could tell me how to dumb down  
> SQLStorage
> (or one of the others) so that it just provides a simple link to  
> queries,
> that would be fine.


I'd have to agree with you on ORM's being overkill.

You can access both a Zope DA instance and ZSQL methods from Product  
code via the context pretty much as you would do from a PythonScript.  
For more information on integrating with Archetypes - although I would  
highly recommend moving to formlib - Martin Aspeli's book has a whole  
chapter devoted to integrating an RDBMS.

Charlie
--
Charlie Clark
Helmholtzstr. 20
Düsseldorf
D- 40215
Tel: +49-211-938-5360
GSM: +49-178-782-6226