class DBTestCase(unittest.TestCase): def setUp(self): self.db = DBHelper() self.samples =self.db.get_results_by_clms(columns='*',table= 'samples',database=DB_test,isdict=True) def tearDown(self): self.db = None def test_get_max_group_id(self): res =self.db.get_max_group_id('refined_info_2','xyzb') res_2 =self.db.get_max_group_id('info_template','xyzb') print res print res_2 def test_batch_insert(self): entrys =self.db.get_results_by_clms(columns='*',table= 'refined_info',database=DB_1,isdict=True)[:12056] table = 'info_tmp1' self.db.recr_table(table,DB_1,'info_template',DB_1); self.db.batch_insert(entrys,table,DB_1) def test_batch_get(self): entrys =self.db.get_results_by_clms(columns='*',table= 'refined_info',database=DB_1,isdict=True)[:2] for key, value in entrys[1].items(): print key,value,type(value)