Re: [Zope] OQL for ZODB - (SQL like for objects Databases)
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 )
RE: [Zope] OQL for ZODB - (SQL like for objects Databases)
Indeed it does. As a result, it doesn't help at all for O-R mapping. I've heard that PJE's DataSkins (part of ZPatterns) have features which make them useful for O-R mapping, though I haven't looked at them. > 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). ___ 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 )
Re: [Zope] OQL for ZODB - (SQL like for objects Databases)
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 )
[Zope] OQL for ZODB - (SQL like for objects Databases)
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 )