多进程redis存储mysql

一个表不在同一个库中,我是将uid存到redis,进行查询存储数据
import pymysql
import redis
from multiprocessing import Process
import time

r = redis.Redis(host=“127.0.0.1”,password=‘123456’, port=6379)
def insert(key):
con86 = pymysql.Connect(host=’’, user=’’, password=’’, port=,charset=’’,database=’’)
cur86 = con86.cursor()
con92 = pymysql.Connect(host=’’, user=’’, password=’’, port=,charset=’’,database=’’)
cur92 = con92.cursor()
while True:
uid = r.rpop(key).decode(‘utf-8’)
print(uid)
# id = 3
sql2 = f’select id,name,uid from test.wet_base where uid in ({uid})’
start = time.time()
cur86.execute(sql2)
s = cur86.fetchone()
print(sql2)
print(s)
if s:
id = s[0]
name = s[1]
uid = s[2]
list = [id,name,uid]
sql3 = ‘insert into back.student values(%s,%s,%s)’
try:
cur92.execute(sql3, list)
con92.commit()
except Exception as e:
print(e)
con92.rollback()
r.rpush(‘school:id’)
end = time.time()
print(‘Running time: {} Seconds’.format(end - start))
if name == ‘main’:
key=‘school:uid’
for i in range(50):
p=Process(target=insert,args=(key,))
p.start()

记得点赞,关注哦,你们是我前进的动力！！！