Re: [Sqlalchemy-users] UPDATE with subselects in WHERE

[Michael Bayer]

oh wacky, total bug.  just fixed it in rev 1348. On Apr 28, 2006, at 2:44 AM, Dale Sedivec wrote: users = Table("users", engine,               Column("id", Integer, primary_key=True),               Column("name", String, unique=True, nullable=False)) users.create() passwords = Table("passwords", engine,                   Column("user_id", Integer, ForeignKey("users.id"),                          primary_key=True),                   Column("password", String, nullable=False)) passwords.create() users.insert().execute(name="bob") bob_id = users.select(users.c.name == "bob").execute().fetchone().id passwords.insert().execute(user_id=bob_id, password="foo") subselect = select([users.c.id], users.c.name == "bob") passwords.update(passwords.c.user_id == subselect).execute(password="XXX")