def test_diff_tables(self): dc = datachecker() db_helper = DBHelper() new_table = 'extracted_full_info_today' old_table = 'info_tmp' old_db = DB_test new_db = DB_1 db_helper.recr_table(old_table,old_db,'info_template',DB_1) entrys =dc.diff_tables(table_old=old_table,table_new=new_table,db_old=old_db,db_new=new_db) db_helper.batch_insert(entrys,table=old_table,db=old_db)
def __init__(self): self.db = DBHelper() self.dc = datachecker() self.sb = submitter() self.dd = data_drawer() self.sg = segger() self.id = indexer() self.pc = prechecker() self.dmg_on = DMG_ON self.test_on = TEST_ON if len(sys.argv) < 4: self.table_old = "refined_info" self.db_old = DB_1 self.table_new = "extracted_info" self.db_new = DB_1 else: self.table_old = sys.argv[1] self.db_old = sys.argv[2] self.table_new = sys.argv[3] self.db_new = sys.argv[4]
def setUp(self): self.dc = datachecker() self.db = DBHelper() self.samples =self.db.get_results_by_clms(columns='*',table= 'samples',database=DB_test,isdict=True)
def test_load_data_fromdb(self): dc = datachecker() new_entrys = dc.get_list_fromDB("*",self.table_new,DB_1, isdict=True) self.assertEqual(13,len(new_entrys))
def test_load_columns(self): dc = datachecker() columns = dc.load_columns(KEY_FIELDS_PATH) self.assertEqual(6,len(columns))