def test_create_db(self): script_path = joinpath( dirname(realpath(__file__)).rsplit(os.sep, 1)[0], 'sql/create_db.sql') dbmgr = DBManager(self.db_name) dbmgr.create_db(script_path) select_query = "SELECT count(*) FROM " self.assertEqual(dbmgr.query(select_query + "stream")[0][0], 0) self.assertEqual(dbmgr.query(select_query + "user")[0][0], 0) self.assertEqual(dbmgr.query(select_query + "device")[0][0], 0) self.assertEqual(dbmgr.query(select_query + "like")[0][0], 0) self.assertEqual(dbmgr.query(select_query + "comment")[0][0], 0) self.assertEqual(dbmgr.query(select_query + "job_period")[0][0], 0) self.assertEqual(dbmgr.query(select_query + "photo")[0][0], 0) self.assertEqual(dbmgr.query(select_query + "access")[0][0], 0)
def create_db(self): script_path = joinpath( dirname(realpath(__file__)).rsplit(os.sep, 1)[0], 'sql/create_db.sql') dbmgr = DBManager(self.db_name) dbmgr.create_db(script_path)
def create_db(self): script_path = joinpath(dirname(realpath(__file__)).rsplit(os.sep, 1)[0], 'sql/create_db.sql') dbmgr = DBManager(self.db_name) dbmgr.create_db(script_path)