Am Mittwoch 03 September 2008 16:02:17 schrieb Brian Sutherland: > On Wed, Sep 03, 2008 at 02:43:31PM +0200, 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? > > I'm much more in favour of the reverse procedure. I think the database > is the canonical store of this information and that SQLAlchemy should > read that and make it available for doing form validation.
But isn't exactly that the real meaning of interfaces? So I have the impression that at the beginning of the design process, I'd model the interfaces, which describe and express everything I expect from the underlying objects. And when that is done, I'd program the underlying objects. And for content objects, the storage could be in an RDB (SQLAlchemy), or somewhere else. And for that, the table structure could be derived from the interface. If I model it the other way round, the power of interfaces is somehow crippled: - The tables can already be documented in the table declaration itself, so the interfaces are only useful for extra documentation, such as mapper properties and class properties. - The interface values are of mediocre value for forms, too, as the forms will often need a change of the schema. (E.g. think of an add person form, where the name is required and in comparison a search form, where the name may not be required and thus the name-schema cannot be 1:1 used, or, even simpler, think of a change of the title). I currently either copy the schemas into my form, or even write separate interfaces. - The real reason I need the interfaces is that I have to include them in my configure.zcml in order to make the underlying objects read/writeable. But this is in my case only annoying, but not helpful at all. Best Regards, Hermann -- [EMAIL PROTECTED] GPG key ID: 299893C7 (on keyservers) FP: 0124 2584 8809 EF2A DBF9 4902 64B4 D16B 2998 93C7 _______________________________________________ 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 )