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)