

def test_render_table_mysql(self):
    (users, addresses) = (self.tables.users, self.tables.addresses)
    self.assert_compile(users.update().values(name='newname').where((users.c.id == addresses.c.user_id)).where((addresses.c.email_address == 'e1')), 'UPDATE users, addresses SET users.name=%s WHERE users.id = addresses.user_id AND addresses.email_address = %s', checkparams={
        'email_address_1': 'e1',
        'name': 'newname',
    }, dialect=mysql.dialect())

dataset/ETHPy150Open zzzeek/sqlalchemy/test/sql/test_update.py UpdateFromCompileTest.test_render_table_mysql/original