On Apr 27, 11:45 am, mdipierro <[email protected]> wrote:
> On 26 Apr, 20:28, rbp <[email protected]> wrote:
>
>
>
> > hello,
>
> > I read in this thread (http://groups.google.com/group/web2py/
> > browse_thread/thread/add0a8ff0a086111) that cross database joins are
> > supported.
> > I'm trying to get this working.
>
> > I define my tables like this:
>
> > db1 = SQLDB("sqlite://db1.db")
> > db2 = SQLDB("sqlite://db2.db")
>
> > db1.define_table('a',
> > SQLField('name', 'string'),
> > )
>
> > db2.define_table('b',
> > SQLField('a_id', 'integer', requires=IS_IN_DB(db1, 'a.id', '%
> > (name)s')),
> > SQLField('name', 'string'),
> > )
>
> yes you can do this. IS_NOT_IN_DB instead may behave in a weird way.
>
>
>
> > In the appadmin interface the tables are connected so I assume the
> > above is correct.
> > Unfortunately I haven't figured out the right syntax for cross
> > database joins.
>
> > If I try:
> > db2(db2.b.a_id == db1.a.id).select(db1.a.name, db2.b.name)
> > or:
> > db2().select(db1.a.name, db2.b.name, left=db2.b.on(db2.b.a_id ==
> > db1.a.id))
> > Then I get "OperationalError: no such table: db1"
>
> > What is the correct cross database join syntax?
>
> This is not possible sorry.
>
> Massimo
oh really. How do you recommend I combine data across databases?
Should I select from db2 with
db2().select(db2.b.a_id, db2.b.name)
and then do a separate query to manually replace db2.b.a_id with
db1.a.name?
Richard
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
