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()
