def test_zauto_commit(self):
TestConfig.autocommit = False
connection = Connection(TestConfig)
connection.execute("BEGIN")
connection.execute("INSERT INTO people(name) VALUES(%s)", ["yusufkoc"])
is_in = connection.get_results("SELECT * FROM people WHERE id =%s", ["yusufkoc", ])
assert len(is_in) == 0
connection.execute("COMMIT")
is_in = self.connection.get_results("SELECT * FROM people WHERE name = %s", ["yusufkoc", ])
assert len(is_in) == 1
def test_connectivity_control(self):
connection = Connection(TestConfig)
connection.db_connection = None
self.assertRaises(LurkerNoConnectivityException, connection.get_results, "SELECT * FROM people")
def test_valid_configuration_class(self):
assert isinstance(Connection(TestConfig), Connection)
def test_quick_connect(self):
connection = Connection().quick_connect(TestConfig.user, TestConfig.passwd, TestConfig.db)
assert isinstance(Connection(TestConfig), Connection)
def setUp(self):
self.connection = Connection(TestConfig)
self.connection.execute_many("INSERT INTO people(name) VALUES(%s)", [("1",), ("2",), ("3",)])
