[sqlalchemy] Re: many-to-many relation, 'secondaryjoin' is needed as well

2009-06-23 Thread Aculeus
Can you post your solution? On Jun 2, 6:38 am, Gera88 gger...@gmail.com wrote: Oh I did it Thanks! --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to

[sqlalchemy] Re: ForeignKey schema and Table schema

2009-05-08 Thread Aculeus
= MainUser.id When you really need the schema for the table that is in the other database: SELECT * FROM MainUser INNER JOIN other.OtherUser ON OtherUser.id = MainUser.id On May 7, 9:46 am, Michael Bayer mike...@zzzcomputing.com wrote: Aculeus wrote: This has a severe problem having to hard set

[sqlalchemy] ForeignKey schema and Table schema

2009-05-07 Thread Aculeus
Currently schema requires that you provide a schema for each table that is not in the primary metadata. Example: main_engine = sa.create_engine('mysql://user:p...@localhost/main') other_engine = sa.create_engine('mysql://user:p...@localhost/other') main_metadata = MetaData() other_metadata =