class TestSqliteConnection(unittest.TestCase):
db_path = tst_db_path('test_db')
db_path_with_default = tst_db_path('test_db.db')
def setUp(self):
self.cw = SqliteDBConnectionWrapper(path = self.db_path, chunked = True)
self.cw_db = SqliteDBConnectionWrapper(path = self.db_path_with_default, chunked = True)
self.cw_no_chunk = SqliteDBConnectionWrapper(path = self.db_path_with_default)
def test_db_created(self):
# don't change this table please
data = self.cw_db.select('select * from test_table where column = 1').data
self.assertEquals(data[0][0], 1)
self.assertTrue(self.cw._wrapped == None)
def test_db_chunk_created(self):
# don't change this table please
data = self.cw_db.select('select * from test_table_chunk where column = 1',
chunk_name = 'my_chunk.db').data
self.assertEquals(data[0][0], 1)
data = self.cw_db.select('select * from test_table_chunk where column = 1',
chunk_name = 'my_chunk.db').data
self.assertEquals(data[0][0], 1)
def test_db_created(self):
# don't change this table please
data = self.cw_no_chunk.select('select * from test_table where column = 1').data
self.assertEquals(data[0][0], 1)
self.assertRaises(Exception, self.cw_no_chunk.select,
'select * from test_table_chunk where column = 1',chunk_name = 'my_chunk.db')
class TestSqliteConnection(unittest.TestCase):
db_path = tst_db_path('test_db')
db_path_with_default = tst_db_path('test_db.db')
def setUp(self):
self.cw = SqliteDBConnectionWrapper(path=self.db_path, chunked=True)
self.cw_db = SqliteDBConnectionWrapper(path=self.db_path_with_default,
chunked=True)
self.cw_no_chunk = SqliteDBConnectionWrapper(
path=self.db_path_with_default)
def test_db_created(self):
# don't change this table please
data = self.cw_db.select(
'select * from test_table where column = 1').data
self.assertEquals(data[0][0], 1)
self.assertTrue(self.cw._wrapped == None)
def test_db_chunk_created(self):
# don't change this table please
data = self.cw_db.select(
'select * from test_table_chunk where column = 1',
chunk_name='my_chunk.db').data
self.assertEquals(data[0][0], 1)
data = self.cw_db.select(
'select * from test_table_chunk where column = 1',
chunk_name='my_chunk.db').data
self.assertEquals(data[0][0], 1)
def test_db_created(self):
# don't change this table please
data = self.cw_no_chunk.select(
'select * from test_table where column = 1').data
self.assertEquals(data[0][0], 1)
self.assertRaises(Exception,
self.cw_no_chunk.select,
'select * from test_table_chunk where column = 1',
chunk_name='my_chunk.db')
def setUp(self):
self.cw = SqliteDBConnectionWrapper(path=self.db_path, chunked=True)
self.cw_db = SqliteDBConnectionWrapper(path=self.db_path_with_default,
chunked=True)
self.cw_no_chunk = SqliteDBConnectionWrapper(
path=self.db_path_with_default)
def setUp(self):
self.cw = SqliteDBConnectionWrapper(path = self.db_path, chunked = True)
self.cw_db = SqliteDBConnectionWrapper(path = self.db_path_with_default, chunked = True)
self.cw_no_chunk = SqliteDBConnectionWrapper(path = self.db_path_with_default)
