[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] correlated update across logical databases

2008-07-17 Thread Ryan Tracey
and sdf_customer.WholesalerID=fc.WholesalerID) where sdf_customer.StatusID in (8, 12) and sdf_customer.FileID in %s % (file_ids_str,) rc = dbengine.execute(sql).rowcount Any help would be much appreciated. Regards, Ryan -- Ryan Tracey Citizen: The World