#!/usr/bin/python#!/usr/bin/envpython#-*-coding:utf-8-*-#@Time:2018/6/1522:46#@Author:Kwan#@File:insert_db.py#@Software:PyCharmimportsqlite3importrandomimportdatetime#conn=sqlite3.connect('local.db')##c=conn.cursor()##c.execute("insertintosystem_cfgvalues(?,?,?)",(2,'test2',1))##conn.commit()##conn.close()defmake_date():#defmake_card_number(bits):#counter=bits#number_list=[]#whilecounter:#number_list.append(str(random.randrange(0,10)))#counter-=1#returnnumber_listnumber_list=[str(x)forxinrange(0,10)]card_number=''card_number=card_number.join(tuple(random.choices(number_list,k=10)))#card_number=''#card_number=card_number.join(tuple(make_card_number(10)))car_type=random.choice(('m','p'))localtime=datetime.date.isoformat(datetime.datetime.now())data_title=['card_number','car_type','localtime']data_dict=dict.fromkeys(data_title)data_dict['card_number']=card_numberdata_dict['car_type']=car_typedata_dict['localtime']=localtimereturndata_dictdefinsert_data(list):conn=sqlite3.connect('test.db')c=conn.cursor()try:id=max(c.execute("selectmax(id)frommonthly_card").fetchall())max_id=int(id[0])fordatainlist:card_number=data['card_number']db_car_number=c.execute("selectcard_numberfrommonthly_card").fetchall()ifcard_numberindb_car_number:breakelse:car_type=data['car_type']localtime=data['localtime']max_id+=1c.execute("insertintomonthly_cardvalues(?,?,?,?)",(max_id,card_number,car_type,localtime))exceptsqlite3.OperationalError:sql='''createtableifnotexistsmonthly_card(idintprimarykeynotnull,card_numbertextnotnull,car_typetextnotnull,validtextnotnull);'''c.execute(sql)id=0fordatainlist:try:card_number=data['card_number']db_car_number=c.execute("selectcard_numberfrommonthly_card").fetchall()ifcard_numberindb_car_number:breakelse:car_type=data['car_type']localtime=data['localtime']id+=1c.execute("insertintomonthly_cardvalues(?,?,?,?)",(id,card_number,car_type,localtime))exceptsqlite3.OperationalError:card_number=data['car_number']car_type=data['car_type']localtime=data['localtime']id+=1c.execute("insertintomonthly_cardvalues(?,?,?,?)",(id,card_number,car_type,localtime))#print(type(id_1))#id=id_1.fetchall()conn.commit()conn.close()#defselect_data():#conn=sqlite3.connect('test.db')#c=conn.cursor()#db_car_number=c.execute("selectcard_number")#test1=make_date()#my_list=[]#my_list.append(test1)#insert_data(my_list)#print('OK')n=500my_list=[]whilen:my_list.append(make_date())n-=1insert_data(my_list)print('OK')