Example #1
0
	def setUp(self):
		#create, insert three records
		self.conn = dbapi.connect(uri="http://example.org/testdb/", create=True)
		cur = self.conn.cursor()
		#create a table
		cur.execute(test_create_table_syntax)
		cur.execute(test_insert_1)
		cur.execute(test_insert_2)
		cur.execute(test_insert_3)
Example #2
0
def setup_test_db():
    print "Creating tests"
    conn = dbapi.connect(uri="http://example.org/testdb/", create=True)
    cur = conn.cursor()
    #create a table
    cur.execute(test_create_table_syntax)
    #insert 3 records
    #insert record 2 first to show up any ordering issues!
    cur.execute(test_insert_syntax2)
    cur.execute(test_insert_syntax)
    cur.execute(test_insert_syntax3)
    return conn
Example #3
0
 def setUp(self):
     # create, insert three records
     self.conn = dbapi.connect(uri="http://example.org/testdb/", create=True)
     cur = self.conn.cursor()
     # create joined tables
     cur.execute(test_create_user_table)
     cur.execute(test_create_tx_table)
     # insert account records
     cur.execute(test_insert_checking)
     cur.execute(test_insert_saving)
     # insert tx records
     cur.execute(test_insert_checking_A)
     cur.execute(test_insert_checking_B)
     cur.execute(test_insert_checking_C)
     cur.execute(test_insert_checking_D)
     cur.execute(test_insert_saving_A)
     cur.execute(test_insert_saving_B)