Re: [sqlalchemy] Update from an identical joined table with SQLAlchemy

2013-07-19 Thread Ed Singleton
On 15 Jul 2013, at 18:11, Michael Bayer mike...@zzzcomputing.com wrote: On Jul 15, 2013, at 11:06 AM, Ed Singleton singleto...@gmail.com wrote: I have two tables in SQLAlchemy which are identical and I want to update one from the other where the rows have the same primary key, and I want to

Re: [sqlalchemy] Update from an identical joined table with SQLAlchemy

2013-07-19 Thread Ed Singleton
On 19 Jul 2013, at 16:01, Michael Bayer mike...@zzzcomputing.com wrote: On Jul 19, 2013, at 9:53 AM, Ed Singleton singleto...@gmail.com wrote: On 15 Jul 2013, at 18:11, Michael Bayer mike...@zzzcomputing.com wrote: On Jul 15, 2013, at 11:06 AM, Ed Singleton singleto...@gmail.com wrote: I

Re: [sqlalchemy] Update from an identical joined table with SQLAlchemy

2013-07-19 Thread Michael Bayer
On Jul 19, 2013, at 12:14 PM, Ed Singleton singleto...@gmail.com wrote: A sample script is below (bear in mind that the script contains the two errors and I wouldn't now expect it to work anyway). OK this example is calling UPDATE towards email_table as the target, but then specifies

Re: [sqlalchemy] Update from an identical joined table with SQLAlchemy

2013-07-19 Thread Michael Bayer
On Jul 19, 2013, at 9:53 AM, Ed Singleton singleto...@gmail.com wrote: On 15 Jul 2013, at 18:11, Michael Bayer mike...@zzzcomputing.com wrote: On Jul 15, 2013, at 11:06 AM, Ed Singleton singleto...@gmail.com wrote: I have two tables in SQLAlchemy which are identical and I want to update

[sqlalchemy] Update from an identical joined table with SQLAlchemy

2013-07-15 Thread Ed Singleton
I have two tables in SQLAlchemy which are identical and I want to update one from the other where the rows have the same primary key, and I want to do it in an efficient way. I tried joining the tables on the primary key, but SQLAlchemy doesn't appear to support updates on joined tables at the

Re: [sqlalchemy] Update from an identical joined table with SQLAlchemy

2013-07-15 Thread Michael Bayer
On Jul 15, 2013, at 11:06 AM, Ed Singleton singleto...@gmail.com wrote: I have two tables in SQLAlchemy which are identical and I want to update one from the other where the rows have the same primary key, and I want to do it in an efficient way. I tried joining the tables on the primary