'executemany should work with "insert ... on update"'

def test_issue_288(self):

    conn = self.connections[0]
    cursor = conn.cursor()
    data = [(0, 'bob', 21, 123), (1, 'jim', 56, 45), (2, 'fred', 100, 180)]
    cursor.executemany('insert\ninto    bulkinsert    (id,    name,\nage,    height)\nvalues    (%s,\n%s    ,    %s,\n%s    )    on    duplicate    key    update\nage    =    values(age)\n    ', data)
    self.assertEqual(cursor._last_executed.strip(), bytearray("insert\ninto    bulkinsert    (id,    name,\nage,    height)\nvalues    (0,\n'bob'    ,    21,\n123    ),(1,\n'jim'    ,    56,\n45    ),(2,\n'fred'    ,    100,\n180    )    on    duplicate    key    update\nage    =    values(age)"))
    cursor.execute('commit')
    self._verify_records(data)
