[Zope] Understand ZODB Query?
Heri
htan@gmx.de
Tue, 11 Mar 2003 21:37:43 +0800
This is a multi-part message in MIME format.
------=_NextPart_000_0011_01C2E816.730ECEB0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi,
I'm starting to develop a zope products and I'm still confused on how to =
use ZODB.
My current application development is using RDBMS concept such as =
following samples:
employee table:
Row First Name Last Name Age
=3D=3D=3D =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=3D=3D=3D=3D =
=3D=3D=3D
1 Bob McBob 42
2 John Johnson 24
3 Steve Smith 38
- I can easily perform SQL statement to lookup for some information such =
as, total employee, who are above 30 years old, and who has the Lastname =
of 'Smith'.
- I can easily retrieve information from multiple tables and combine it =
as data objects.
But how can I do this in ZODB?
I was looking at =
http://www.zope.org/Documentation/Books/ZDG/current/index_html
but it just tell me briefly how to store objects and simple retrieval.
I need to do complex queries or perform some transaction.
Can anyone help me the way to query data in ZODB?
thanks,
Heri
------=_NextPart_000_0011_01C2E816.730ECEB0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1141" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I'm starting to develop a zope products =
and I'm=20
still confused on how to use ZODB.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>My current application development is =
using RDBMS=20
concept such as following samples:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>employee table:</FONT></DIV>
<DIV><FONT face=3DArial>Row First =
Name Last=20
Name Age<BR>=3D=3D=3D =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =
=3D=3D=3D=3D=3D=3D=3D=3D=3D =20
=3D=3D=3D<BR>1 =20
Bob &nbs=
p; =20
McBob =20
42<BR>2 =20
John &nb=
sp; =20
Johnson =
24<BR>3 =20
Steve &n=
bsp;=20
Smith &n=
bsp; =20
38<BR></DIV>
<DIV></FONT><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>- I can easily perform SQL statement =
to</FONT><FONT=20
face=3DArial size=3D2> lookup for some information such as, total =
employee, who are=20
above 30 years old, and who has the Lastname of 'Smith'.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>- I can easily retrieve information =
from multiple=20
tables and combine it as data objects.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>But how can I do this in =
ZODB?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I was looking at <A=20
href=3D"http://www.zope.org/Documentation/Books/ZDG/current/index_html">h=
ttp://www.zope.org/Documentation/Books/ZDG/current/index_html</A></FONT><=
/DIV>
<DIV><FONT face=3DArial size=3D2>but it just tell me briefly how to =
store objects=20
and simple retrieval.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I need to do complex queries or perform =
some=20
transaction.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Can anyone help me the way to query =
data in=20
ZODB?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial =
size=3D2>thanks,<BR>Heri</FONT></DIV></BODY></HTML>
------=_NextPart_000_0011_01C2E816.730ECEB0--