def init_data(): db = DB() for table, data in datas.items(): db.clear(table) for d in data: db.insert(table, d) db.close()
def init_data(): # 用于读取datas字典中的数据。先调用DB类中的clear方法清除表数据,然后循环调用insert方法插入数据 db = DB() for table, data in datas.items(): db.clear(table) for d in data: db.insert(table, d) db.close()
class InitData: def __init__(self): self.db=DB() def init_data(self): for table, data in datas.items(): self.db.clear(table) # print(data) for d in data: self.db.insert(table, d) self.db.close()
def init_data(): db=DB() for table,data in datas.items(): db.clear(table,'school_id',str(10016)) for d in data: for key in d: d[key]="'"+str(d[key])+"'" key=','.join(d.keys()) value=','.join(d.values()) db.insert(table,key,value) db.close()
def init_data(): ''' init_data()函数用于读取datas字典中的数据; 调用DB类中的clear()方法清除表数据; 循环调用insert()方法插入表数据。 ''' db = DB() for table, data in datas.items(): db.clear(table) for d in data: db.insert(table, d) db.close()
def init_data(): db = DB() datas ={ 'kuaigou_sys_user_role_info':[ {'role_id':'1','role_name':'superadmin','role_des':'remark','is_creat_role_list':'N','create_time':'1511342065','update_time':'1511342065'}, {'role_id':'2','role_name':'salesman','role_des':'remark','is_creat_role_list':'N','create_time':'1511342065','update_time':'1511342065'}, {'role_id':'3','role_name':'customer service','role_des':'remark','is_creat_role_list':'N','create_time':'1511342065','update_time':'1511342065'}, ], 'kuaigou_sys_user_info':[ {'user_id':1,'user_name':'admin','user_pass':'******','user_nick_name':'super admin','role_id':1,'effective_mark' :1,'create_time':'1511342065','last_login':'******','region_id':234}, {'user_id':2,'user_name':'*****@*****.**','user_pass':'******','user_nick_name':'jack','role_id':2,'effective_mark':1,'create_time':'1511342065','last_login':'******','region_id':234}, {'user_id':3,'user_name':'*****@*****.**','user_pass':'******','user_nick_name':'rose','role_id':3,'effective_mark':1,'create_time':'1511342065','last_login':'******','region_id':234}, ], 'kuaigou_city_list':[ {'city_id':1,'region_id':234,'city_code':1,'city_create_time':'1494299098','city_updata_time':'1494299098','city_operation_user':'******','operation_user_name':'admin','city_name':'深圳市'}, {'city_id':2,'region_id':2,'city_code':2,'city_create_time':'1494299098','city_updata_time':'1494299098','city_operation_user':'******','operation_user_name':'admin','city_name':'北京市'}, ], 'kuaigou_car_info':[ {'car_id':1,'car_des':'小型面包车','car_status':1,'car_operation_user':1,'car_ext':'乘客|搬运|拆座','creat_time':'1511495941', 'car_operation_user_name':'admin','update_time':'1511495941','car_lenght':1,'car_weight':2,'car_width':3,'car_type':1,'car_size':1}, {'car_id':2,'car_des':'小型货车','car_status':1,'car_operation_user':1,'car_ext':'乘客|搬运|拆座','creat_time':'1511495941', 'car_operation_user_name':'admin','update_time':'1511495941','car_lenght':1,'car_weight':2,'car_width':3,'car_type':2,'car_size':1}, ], 'kuaigou_car_price':[ {'price_id':1,'car_id':1,'region_id':234,'car_start_price':10,'car_start_mileage':10,'car_beyond_mileage':1,'car_beyond_price':5,'create_time':'1494212554','price_operation_user':1,'status':1,'update_time':'1494212554','price_operation_user_name':'admin'}, {'price_id':2,'car_id':1,'region_id':234,'car_start_price':15,'car_start_mileage':20,'car_beyond_mileage':1,'car_beyond_price':6,'create_time':'1494212554','price_operation_user':1,'status':1,'update_time':'1494212554','price_operation_user_name':'admin'}, ] } for table,data in datas.items(): db.clear(table) for d in data: db.insert(table,d) db.close()
def test3_sms_error(self): """短信验证码输入错误""" self.rp.register(yanzheng='000') text_error = self.rp.sms_error() self.assertEqual(text_error, '*短信验证码错误') def test4_register_success(self): """注册成功""" self.rp.register() time.sleep(3) text = self.rs.register_success().text self.assertIn('用户,恭喜您注册成功!', text) # db = DB() # db.delete_user() # db.close() def tearDown(self): self.dr.quit() if __name__ == '__main__': # suite = unittest.TestSuite() # suite.addTest(RegisterTest("test4_register_success")) # runner = unittest.TextTestRunner() # runner.run(suite) unittest.main() db = DB() db.delete_user() db.close()