python多线程读取数据库数据_Python多线程写入数据库

def putMst():

mst=b['monster_souls']

sql='''INSERT INTO customer.55(id,编号,元魂珠名,星级,系别,等级,经验,能量等级,魂魄,成长优势,移动速度,吸收速度,

修为,元魂代数,可洗技能数,融合累积点,可分配点数,基本_力,基本_体,基本_念,基本_敏,基本_魂,基本_疾,力转化率,体转化率,念转化率,敏转化率,魂转化率,疾转化率)

VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s);

'''

try:

for k in mst.keys():

cursor.execute(sql,(s[i][2],k,mst[k]['real_name'],mst[k]['mstar'],mst[k]['type_name'],

mst[k]['lv'],mst[k]['exp'],mst[k]['en_lv'],mst[k]['power'],mst[k]['evolution'],mst[k]['speed'],

mst[k]['absorb'],mst[k]['xiuwei'],mst[k]['generation'],mst[k]['erasable'],mst[k]['new_fuse_ap'],

mst[k]['attrib_point'],mst[k]['b_str'],mst[k]['b_con'],mst[k]['b_mind'],mst[k]['b_dex'],

mst[k]['b_int'],mst[k]['b_dog'],mst[k]['t_str'],mst[k]['t_con'],mst[k]['t_mind'],mst[k]['t_dex'],

mst[k]['t_int'],mst[k]['t_dog']))

conn.commit()

print('填写完毕')

except:

pass

def putHbs():

hbs=b['hbs']

sql='''INSERT INTO tb_灵兽基本信息(id,编号,灵兽名,技能名,技能境界,等级,经验,成长值,力,力资质,体,体资质,

敏,敏资质,疾,疾资质,魂,魂资质,念,念资质,潜能,总资质)

VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s);

'''

try:

for k in hbs.keys():

for a in hbs[k]['skills'].keys():

skl=a

cursor.execute(sql,(s[i][2],k,hbs[k]['hb_type'],skl,hbs[k]['skills'][skl],hbs[k]['lv'],hbs[k]['exp'],

hbs[k]['pullulate'],hbs[k]['str'],hbs[k]['a_str'],hbs[k]['con'],hbs[k]['a_con'],

hbs[k]['dex'],hbs[k]['a_dex'],hbs[k]['dog'],hbs[k]['a_dog'],

hbs[k]['int'],hbs[k]['a_int'],hbs[k]['mind'],hbs[k]['a_mind'],hbs[k]['potential'],hbs[k]['attr_total']))

conn.commit()

print('填写完毕')

except:

pass

threads=[]

thread1 = threading.Thread(target=putMst)

thread2 = threading.Thread(target=putHbs)

# 开启新线程

thread1.start()

thread2.start()

# 添加线程到线程列表

threads.append(thread1)

threads.append(thread2)

# 等待所有线程完成

for t in threads:

t.join()

print ("退出主线程")