

@testing.requires.update_from
def test_exec_three_table(self):
    users = self.tables.users
    addresses = users.tables.addresses
    dingalings = self.tables.dingalings
    testing.db.execute(addresses.update().values(email_address=users.c.name).where((users.c.id == addresses.c.user_id)).where((users.c.name == 'ed')).where((addresses.c.id == dingalings.c.address_id)).where((dingalings.c.id == 1)))
    expected = [(1, 7, 'x', 'jack@bean.com'), (2, 8, 'x', 'ed'), (3, 8, 'x', 'ed@bettyboop.com'), (4, 8, 'x', 'ed@lala.com'), (5, 9, 'x', 'fred@fred.com')]
    self._assert_addresses(addresses, expected)

dataset/ETHPy150Open zzzeek/sqlalchemy/test/sql/test_update.py UpdateFromRoundTripTest.test_exec_three_table/VarMisuse@27/32 `self`->`users`