

@testing.only_on('mysql', 'Multi table update')
def test_exec_multitable(self):
    (users, addresses) = (self.tables.users, self.tables.addresses)
    values = {
        addresses.c.email_address: users.c.name,
        users.c.name: 'ed2',
    }
    testing.db.execute(addresses.update().values(values).where((users.c.id == addresses.c.user_id)).where((users.c.name == 'ed')))
    expected = [(1, 7, 'x', 'jack@bean.com'), (2, 8, 'x', 'ed'), (3, 8, 'x', 'ed'), (4, 8, 'x', 'ed'), (5, 9, 'x', 'fred@fred.com')]
    self._assert_addresses(addresses, expected)
    expected = [(7, 'jack'), (8, 'ed2'), (9, 'fred'), (10, 'chuck')]
    self._assert_users(self, expected)

dataset/ETHPy150Open zzzeek/sqlalchemy/test/sql/test_update.py UpdateFromRoundTripTest.test_exec_multitable/VarMisuse@211/274 `users`->`self`