def test_file_gets_created_on_connect():
filename = absolute_filename('test.db')
db = SQLiteDB(filename)
db._get_connection()
assert_true(os.path.exists(filename))
db.close()
delete_file(filename)
def test_connection_is_singleton():
filename = absolute_filename('test.db')
db = SQLiteDB(filename)
c1 = db._get_connection()
c2 = db._get_connection()
assert_true(c1 is c2)
assert_equal(c1, c2)
db.close()
delete_file(filename)
def test_each_thread_has_its_own_connection():
filename = absolute_filename('test.db')
db = SQLiteDB(filename)
connection1 = db._get_connection()
def other_thread():
connection2 = db._get_connection()
assert_true(connection1 is connection1)
assert_false(connection2 is connection1)
assert_equal(connection1, connection1)
assert_not_equal(connection2, connection1)
db.close()
try:
t1 = threading.Thread(target=other_thread)
t1.start()
t1.join()
finally:
db.close()
delete_file(filename)
