'test executing update statement with arraydmlrowcount mode'

def testExecutingUpdate(self):

    self.cursor.execute('truncate    table    TestArrayDML')
    rows = [(1, 'First', 100), (2, 'Second', 200), (3, 'Third', 300), (4, 'Fourth', 300), (5, 'Fifth', 300), (6, 'Sixth', 400), (7, 'Seventh', 400), (8, 'Eighth', 500)]
    sql = 'insert    into    TestArrayDML    (IntCol,StringCol,IntCol2)    values    (:1,    :2,    :3)'
    self.cursor.executemany(sql, rows)
    rows = [('One', 100), ('Two', 200), ('Three', 300), ('Four', 400)]
    sql = 'update    TestArrayDML    set    StringCol    =    :1    where    IntCol2    =    :2'
    self.cursor.executemany(sql, rows, arraydmlrowcounts=True)
    self.failUnlessEqual(self.cursor.getarraydmlrowcounts(), [1, 1, 3, 2])
