[Zope] ZSQLMethods
Phil Harris
phil.harris@zope.co.uk
Mon, 4 Dec 2000 16:06:48 -0000
Depending on the number of records in the tables this could get *very* slow
*very* quickly.
Surely the ideal would be to move/copy the tables into the same DB.
Phil
----- Original Message -----
From: "Chris Gray" <cpgray@library.uwaterloo.ca>
To: "Tom Deprez" <tom.deprez@uz.kuleuven.ac.be>
Cc: <zope@zope.org>
Sent: Monday, December 04, 2000 3:21 PM
Subject: Re: [Zope] ZSQLMethods
> Try something like:
>
> <dtml-in selectFromTable1>
> <dtml-in selectFromTable2>
> <dtml-if idFromTable1 = idFromTable2>
> ....display parts of the two records....
> </dtml-if>
> </dtml-in>
> </dtml-in>
>
> This keeps it to two db queries and the join work is done by Zope.
>
> Chris
>
> On Mon, 4 Dec 2000, Tom Deprez wrote:
>
> > Hi Chris,
> >
> > Thanks, is this code still efficient if the tables relate to 1:1 and you
> > need to show a list of all records in a tabulare table?
> >
> > eg key, NAME, ALIAS, ....
> >
> > where NAME is from database1 and ALIAS is from database2
> >
> > The code below would impact that for every record in database1, I've to
> > query database2
> > Is there another way to do this? (more efficient?, ie less database
query)
> >
> > Tom.
> >
> > ----- Original Message -----
> > From: "Chris Gray" <cpgray@library.uwaterloo.ca>
> > To: "Tom Deprez" <tom.deprez@uz.kuleuven.ac.be>
> > Cc: <zope@zope.org>
> > Sent: Monday, December 04, 2000 3:45 PM
> > Subject: Re: [Zope] ZSQLMethods
> >
> >
> > > You want something along these lines:
> > >
> > > <dtml-in selectFromTable1>
> > > <dtml-in expr="selectFromTable2(id=_['id'])">
> > > ....display record....
> > > </dtml-in>
> > > </dtml-in>
> > >
> > > This would be more efficient than pulling out the whole of two tables.
> > >
> > > Chris
> > >
> > > On Mon, 4 Dec 2000, Tom Deprez wrote:
> > >
> > > > Hi,
> > > >
> > > > I'm wondering how the following can be done.
> > > >
> > > > I've 2 databases. I want to do a 'join' with 2 tables, both in a
> > different
> > > > database.
> > > > Is it possible to retrieve data of both tables with a ZSQLMethod and
> > then
> > > > do a programatically join? What's the easiest python way?
> > > >
> > > > Thanks, Tom.
> > > >
> > > > _______________________________________________
> > > > 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 )
> > > >
> > >
> > >
> > > _______________________________________________
> > > 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 )
> > >
> >
>
>
> _______________________________________________
> 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 )