[Zope-DB] ZODB and ZSQL

Dario Lopez-Kästen dario@ita.chalmers.se
Fri, 23 Nov 2001 16:22:34 +0100

Hm.. dunno if it will work, but do this in a python script for instance:


# get name somehow

place = <magic to retrieve the 'name' place from zodb that i dont know how
to achieve>

email = context.sql_to_retrieve_email(<name_column>=name)

return {'name': name, 'place': place, 'email': email}


hope this points somewhat in the general direction.


----- Original Message -----
From: "Stephan Goeldi" <stephan_goeldi@hotmail.com>
To: <zope-db@zope.org>
Sent: Friday, November 23, 2001 2:48 PM
Subject: [Zope-DB] ZODB and ZSQL

> Let's assume I have two databases. An external connected SQL database and
> the ZODB. In the external DB I have a table with two columns: 'name' and
> 'email'. In the ZODB I have a table with the columns 'name' and 'place'.
> can I extract data from both in one turn using the foreign key 'name'?
> I want this result:
> name - email - place