def setUp(self):
self.isq = InlineSQLite()
self.isq.runOperation(
"create table foobar_test (val1 string, val2 string)")
self.isq.runOperation('insert into foobar_test values ("a", "b")')
class InlineSQLiteTest(unittest.TestCase):
def setUp(self):
self.isq = InlineSQLite()
self.isq.runOperation(
"create table foobar_test (val1 string, val2 string)")
self.isq.runOperation('insert into foobar_test values ("a", "b")')
def test_init(self):
self.assertTrue(hasattr(self.isq, "autoCommit"))
self.assertTrue(hasattr(self.isq, "conn"))
self.assertTrue(hasattr(self.isq, "curs"))
def test_runQuery(self):
self.isq.curs = Mock()
self.isq.curs.__iter__ = Mock(return_value=iter([1, 2, 3]))
res = self.isq.runQuery("a query")
self.assertEqual(res, [1, 2, 3])
def test_runOperation(self):
self.isq.runOperation('insert into foobar_test values ("c", "d")')
res = self.isq.runQuery("select count(*) from foobar_test")
self.assertEqual(res[0][0], 2)
def test_runOperationMany(self):
self.isq.runOperationMany('insert into foobar_test values (?, ?)',
[["a", "b"], ["c", "d"]])
res = self.isq.runQuery("select count(*) from foobar_test")
self.assertEqual(res[0][0], 3)
def test_commit(self):
self.isq.conn = Mock()
self.isq.commit()
self.isq.conn.commit.assert_called_with()
def test_rollback(self):
self.isq.conn = Mock()
self.isq.rollback()
self.isq.conn.rollback.assert_called_with()
def test_close(self):
self.isq.conn = Mock()
self.isq.close()
self.isq.conn.close.assert_called_with()
def setUp(self):
self.isq = InlineSQLite()
self.isq.runOperation(
"create table nothing (val1 string, val2 string)")
self.isq.runOperation('insert into nothing values ("a", "b")')
def setUp(self):
self.isq = InlineSQLite()
self.isq.runOperation(
"create table `nothing` (val1 string, val2 string)")
self.isq.runOperation('insert into `nothing` values ("a", "b")')
class InlineSQLiteTest(unittest.TestCase):
def setUp(self):
self.isq = InlineSQLite()
self.isq.runOperation(
"create table nothing (val1 string, val2 string)")
self.isq.runOperation('insert into nothing values ("a", "b")')
def test_init(self):
self.assertTrue(hasattr(self.isq, "autoCommit"))
self.assertTrue(hasattr(self.isq, "conn"))
self.assertTrue(hasattr(self.isq, "curs"))
def test_runQuery(self):
self.isq.curs = Mock()
self.isq.curs.__iter__ = Mock(return_value=iter([1, 2, 3]))
res = self.isq.runQuery("a query")
self.assertEqual(res, [1, 2, 3])
def test_runOperation(self):
self.isq.runOperation('insert into nothing values ("c", "d")')
res = self.isq.runQuery("select count(*) from nothing")
self.assertEqual(res[0][0], 2)
def test_runOperationMany(self):
self.isq.runOperationMany(
'insert into nothing values (?, ?)',
[["a", "b"], ["c", "d"]]
)
res = self.isq.runQuery("select count(*) from nothing")
self.assertEqual(res[0][0], 3)
def test_commit(self):
self.isq.conn = Mock()
self.isq.commit()
self.isq.conn.commit.assert_called_with()
def test_rollback(self):
self.isq.conn = Mock()
self.isq.rollback()
self.isq.conn.rollback.assert_called_with()
def test_close(self):
self.isq.conn = Mock()
self.isq.close()
self.isq.conn.close.assert_called_with()
