Thanks to all,
Having Class wine & Drinker in relation.
Drinker can drink (0-N) wines.
Want to do a query like :
MyListOfWine = wine where driker like 'Emmanuel' (Pseudo code)
Is there a way to do that in ZODB ?
E.D.
==
Le dim, 30 jui 2000, vous avez écrit :
> Its probably possible but its probably more work than you're interested
> in.
>
> They speak different languages a relational system is built on relations
> in square/rectangular tables. an object system esp. the ZODB can store
> objects which can be of arbitrary nature, not to mention acquistion and
> inheritance.
>
> a couple of pointers (maybe misleading)
>
> what you need is an object relational mapping that understands the ZODB
> and SQL.
>
> it depends on what you want to do with it and what kind of queries
>
> looking at your original email, this sounds most like you just want...
> ie to be able to retrieve objects based on properties in which case
> ZCatalog is the way to go. A Catalog is an object indexing system built
> on top of the ZODB for maintaining knowledge of objects and they're
> properties for fast searching/retrieval. if you really want an sql
> syntax to the ZODB read on but be warned getting at acquired props will
> require some serious work/design.
>
> you could create an inherited catalog that can layer a simple sql syntax
> over its searches and design it to return objects instead of references.
>
> you could also write a custom ORB that could map into the ZODB according
> to SQL syntax.
>
> although i haven't looked at the source. chris m's Interbase storage
> might be worth a look (it probably stores everything as a BLOB which
> might not be helpful).
>
> Other systems that might be helpful are OZONE an open source java OODBMS
> and Lore an XML storage with searches.
>
> Kapil
>
> E. Discors wrote
> >
> > Hi,
> > Is there a tool like SQL for ZODB ?
> > Where to find more to do some query on ZODB objects ?
> >
> > Many Thanks.
> > Emmanuel.
> >
> > --
> >
> > Emmanuel DISCORS
> > Tel & Fax : 02 54 56 80 61
> >
> > Conception, Informatique, Réseau
> > ADVL ( Au-Delà de Vos Limites )
> > Site web : http://www.advl.org/
> > Archives mOdbc : http://www.advl.org/public/mOdbc/
> >
> > ___
> > Zope maillist - [EMAIL PROTECTED]
> > http://lists.zope.org/mailman/listinfo/zope
> > ** No cross posts or HTML encoding! **
> > (Related lists -
> > http://lists.zope.org/mailman/listinfo/zope-announce
> > http://lists.zope.org/mailman/listinfo/zope-dev )
___
Zope maillist - [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://lists.zope.org/mailman/listinfo/zope-announce
http://lists.zope.org/mailman/listinfo/zope-dev )
