[sqlalchemy] Re: correlated update across logical databases

2008-07-21 Thread Ryan Tracey
Hi Michael 2008/7/18 Michael Bayer [EMAIL PROTECTED]: On Jul 18, 2008, at 9:37 AM, Ryan Tracey wrote: sqlalchemy.exc.NoSuchTableError: manufacturer Just to sum up: dbengine = create_engine('mysql://u:[EMAIL PROTECTED]/schema1') meta = MetaData() meta.bind = dbengine Table('tableX',

[sqlalchemy] Re: correlated update across logical databases

2008-07-18 Thread Ryan Tracey
Hi Michael 2008/7/17 Michael Bayer [EMAIL PROTECTED]: On Jul 17, 2008, at 7:12 AM, Ryan Tracey wrote: Hi I would like to do a correlated update involving tables located in two logical databases on the same MySQL server. The commented out code below would work except that the mysql

[sqlalchemy] Re: correlated update across logical databases

2008-07-18 Thread Ryan Tracey
Hi Michael 2008/7/17 Michael Bayer [EMAIL PROTECTED]: On Jul 17, 2008, at 7:12 AM, Ryan Tracey wrote: Hi I would like to do a correlated update involving tables located in two logical databases on the same MySQL server. The commented out code below would work except that the mysql

[sqlalchemy] Re: correlated update across logical databases

2008-07-18 Thread Michael Bayer
On Jul 18, 2008, at 5:43 AM, Ryan Tracey wrote: Just a note on something I picked up concerning stored procedures and MySQL. There's a thread (which I seem unable to locate now) which ended with the suggestion that to get SPs working with SA and MySQL one should edit databases/mysql.py and

[sqlalchemy] Re: correlated update across logical databases

2008-07-18 Thread Michael Bayer
On Jul 18, 2008, at 9:37 AM, Ryan Tracey wrote: sqlalchemy.exc.NoSuchTableError: manufacturer Just to sum up: dbengine = create_engine('mysql://u:[EMAIL PROTECTED]/schema1') meta = MetaData() meta.bind = dbengine Table('tableX', meta, autoload=True) ... Table('tableA', meta,

[sqlalchemy] Re: correlated update across logical databases

2008-07-17 Thread Michael Bayer
On Jul 17, 2008, at 7:12 AM, Ryan Tracey wrote: Hi I would like to do a correlated update involving tables located in two logical databases on the same MySQL server. The commented out code below would work except that the mysql ends up looking for the one table in the wrong database.