[Zope-DB] ZODB and ZSQL

[Dario Lopez-Kästen]

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.

/dario


----- 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'.
How
> can I extract data from both in one turn using the foreign key 'name'?
e.g.
> I want this result:
>
> name - email - place
>