def test1000Binds(self):
testSet2 = ResultSet()
#Now insert and select a huge number of values
#This depends on the times variable
binds = [ ]
largeInsert = [ ]
times = 1000
#For now I don't want to get too dependent on processData() with many binds, since right now
#it doesn't work. That does make things awkward though.
for i in range(times):
binds = {'column1': 'value1'+str(i), 'column2':'value2'+str(i)}
self.myThread.dbi.processData("insert into test_tablec (column1, column2) values (:column1, :column2)", binds)
sql = "select column1 from test_tablec"
testProxy = self.myThread.dbi.connection().execute(sql)
testSet2.add(testProxy)
self.assertEqual(len(testSet2.fetchall()), times)
dialect = self.myThread.dialect.lower()
if dialect == 'mysql':
self.assertEqual(str(testSet2.fetchall()[1][0]), 'value11')
self.assertEqual(testSet2.fetchone()[0], 'value10')
elif dialect == 'oracle':
self.assertEqual(str(testSet2.fetchall()[1][0]), 'value11')
self.assertEqual(testSet2.fetchone()[0], 'value10')
return
def test1000Binds(self):
testSet2 = ResultSet()
#Now insert and select a huge number of values
#This depends on the times variable
binds = [ ]
largeInsert = [ ]
times = 1000
#For now I don't want to get too dependent on processData() with many binds, since right now
#it doesn't work. That does make things awkward though.
for i in range(times):
binds = {'column1': 'value1'+str(i), 'column2':'value2'+str(i)}
self.myThread.dbi.processData("insert into test_tablec (column1, column2) values (:column1, :column2)", binds)
sql = "select column1 from test_tablec"
testProxy = self.myThread.dbi.connection().execute(sql)
testSet2.add(testProxy)
self.assertEqual(len(testSet2.fetchall()), times)
dialect = self.myThread.dialect.lower()
if dialect == 'mysql':
self.assertEqual(str(testSet2.fetchall()[1][0]), 'value11')
self.assertEqual(testSet2.fetchone()[0], 'value10')
elif dialect == 'oracle':
self.assertEqual(str(testSet2.fetchall()[1][0]), 'value11')
self.assertEqual(testSet2.fetchone()[0], 'value10')
return
def testFullResultSet(self):
"""
Function to test all the functionality of the ResultSet
"""
#ResultSet is a very simple function. This function should
#create a ResultSet, fill it with data, and then read it
#out, all in one go.
testSet = ResultSet()
testDict = {'column1': 'value1', 'column2':'value2'}
binds = [ {'column1':'value3a', 'column2': 'value2a'},
{'column1':'value3b', 'column2': 'value2b'},
{'column1':'value3c', 'column2': 'value2c'}]
self.myThread.dbi.processData('insert into test_tablec (column1, column2) values (:column1, :column2)', testDict)
self.myThread.dbi.processData('insert into test_tablec (column1, column2) values (:column1, :column2)', binds)
testProxy = self.myThread.dbi.connection().execute('select * from test_tablec')
#import pdb
#pdb.set_trace()
testSet.add(testProxy)
#Test to make sure fetchone and fetchall both work
self.assertEqual(str(testSet.fetchone()[0]), 'value1')
self.assertEqual(str(testSet.fetchall()[-1][1]), 'value2c')
def testFullResultSet(self):
"""
Function to test all the functionality of the ResultSet
"""
#ResultSet is a very simple function. This function should
#create a ResultSet, fill it with data, and then read it
#out, all in one go.
testSet = ResultSet()
testDict = {'column1': 'value1', 'column2':'value2'}
binds = [ {'column1':'value3a', 'column2': 'value2a'},
{'column1':'value3b', 'column2': 'value2b'},
{'column1':'value3c', 'column2': 'value2c'}]
self.myThread.dbi.processData('insert into test_tablec (column1, column2) values (:column1, :column2)', testDict)
self.myThread.dbi.processData('insert into test_tablec (column1, column2) values (:column1, :column2)', binds)
testProxy = self.myThread.dbi.connection().execute('select * from test_tablec')
#import pdb
#pdb.set_trace()
testSet.add(testProxy)
#Test to make sure fetchone and fetchall both work
self.assertEqual(str(testSet.fetchone()[0]), 'value1')
self.assertEqual(str(testSet.fetchall()[-1][1]), 'value2c')
