[Zope] OQL for ZODB - (SQL like for objects Databases)

Emmanuel DISCORS webmaster@advl.org
Sun, 30 Jul 2000 23:10:08 +0200


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  -  Zope@zope.org
> > 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 )