def doTimeRandEtc(self, nSize): info = { } for a in range(nSize): nRand = randint(1000, 999999) info['a'] = a + 1 info['b'] = nRand info['c'] = getCheckNumber(nRand) x = strInsert % info
def doSelectTest2(self, nRange): """ SELECT count(*), avg(b) FROM t2 WHERE c LIKE '%one%'; SELECT count(*), avg(b) FROM t2 WHERE c LIKE '%two%'; """ info = [''] nStart = 0 for nIndex in range(nRange): info[0] = getCheckNumber(nIndex + 1) nStart += 100 self.cursor.execute(strSelect2, info)
def doInsertTest2(self, nRange): global strInsert info = [0, 0, ''] for a in range(nRange): nRand = randint(1000, 999999) info[0] = a + 1 info[1] = nRand info[2] = getCheckNumber(nRand) self.cursor.execute(strInsertT2, info) self.conn.commit()
def doInsertTest1(self, bCommitEach, nRange): global strInsert info = [0, 0, ''] for a in range(nRange): nRand = randint(1000, 999999) info[0] = a + 1 info[1] = int(nRand) info[2] = getCheckNumber(nRand) self.cursor.execute(strInsertT1, info) if bCommitEach: self.conn.commit() self.conn.commit()