You may wish to look at z3c.dobbin, though the issue I have found in my 
own experimentation, is with association tables for many to many 
relationships which throws in a wrench into this otherwise elegant 
solution. There may be something to around this in future.

Hermann Himmelbauer wrote:
> Hi,
> In my current SQLAlchemy / Zope-based design, I need the following:
> 
> - SQLAlchemy table definitions
> - classes + mappers
> - Zope interfaces
> 
> The problem with this design is that much data has to be defined twice, e.g. 
> the datatype "varchar(50)" should be represented by an interface with 
> TextLine(max_length="50"). Moreover, any changes such as adding columns etc. 
> also have to be done in the interface and the table definition.
> 
> To overcome this, I just had the idea to use the interface/schema definitions 
> for the table definition itself. Probably I'm not the first who had this 
> idea, but I'm not aware of such an extension to interfaces.
> 
> Any thoughts on this?
> 
> Best Regards,
> Hermann
> 

_______________________________________________
Zope-Dev maillist  -  Zope-Dev@zope.org
http://mail.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope )

Reply via email to