def setupClass(cls): cls.db = dbutils.sqlite_create_db( 'test_filtercols.db', sales=cls.sales, census=cls.census) cls.urls = { 'sales': {'url': cls.db, 'table': 'sales'}, 'census': {'url': cls.db, 'table': 'census'} }
def test_sqlite(self): url = dbutils.sqlite_create_db( 'test_filter.db', **{ 'sales': self.sales, 'dates': self.dates }) self.check_filter_db('sqlite', url, na_position='first') self.check_filter_dates('sqlite', url)
def test_insert_sqlite(self): url = dbutils.sqlite_create_db('test_insert.db') self.check_insert_db(url, 'sqlite')
def test_sqlite(self): url = dbutils.sqlite_create_db('test_filter.db', sales=self.sales) self.check_filter_db('sqlite', url, na_position='first')
def setUpClass(cls): cls.url = dbutils.sqlite_create_db('test_cache.db', t1=cls.data, t2=cls.data)
def setUpClass(cls): cls.url = dbutils.sqlite_create_db('test_cache.db', t1=cls.data, t2=cls.data) cls.engine = sa.create_engine(cls.url, encoding=str_utf8)
def test_sqlite(self): url = dbutils.sqlite_create_db('test_alter.db', sales=self.sales) self.db.add('sqlite') self.check_alter(url)