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",)])