'test executing delete statement with arraydmlrowcount mode'

def testExecutingDelete(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 = [(200,), (300,), (400,)]
    statement = 'delete    from    TestArrayDML    where    IntCol2    =    :1'
    self.cursor.executemany(statement, rows, arraydmlrowcounts=True)
    self.failUnlessEqual(self.cursor.getarraydmlrowcounts(), [1L, 3L, 2L])
