from pic_md5_result import get_md5_value
#将数据的处理分装成函数defmul_procee(data):
mysql2 = ConnectMySQL(Config)
flag =0for data_item in data:
flag +=1id= data_item["id"]
img = data_item['upload_image']
img_decode = base64.b64decode(img)
img_array = np.fromstring(img_decode, np.uint8)
value = get_md5_value(img_array)
mysql2.undate_md5(value,id)if __name__ =='__main__':
mysql = ConnectMySQL(Config)
data = mysql.select_data()
n =len(data)//2000#根据数据总量分割每个进程处理的数据量
data_list =[]for i inrange(n+1):
da = data[i *2000:(i +1)*2000]
data_list.append(da)
p = Pool(len(data_list))#根据切分的数量确定进程池数量
p.map(mul_procee, data_list)
p.close()
p.join()
1.2多参数,有返回情况
from pic_md5_result import get_md5_value
#将数据的处理分装成函数defmul_procee(data,datas):
flag =0for da in datas:if da >data:
flag =1else:continuereturn flag
defjob(z):return is_diff(z[0], z[1])if __name__ =='__main__':
mysql = ConnectMySQL(Config)
data = mysql.select_data()
n =len(data)//2000#根据数据总量分割每个进程处理的数据量
data_list =[]for i inrange(n+1):
da = data[i *2000:(i +1)*2000]
das =(1,da)
data_list.append(das)
p = Pool(len(data_list))#根据切分的数量确定进程池数量
res = p.map(job, data_list)
p.close()
p.join()print(res)
1 批量更新数据库操作1.1单参数,无返回情况from pic_md5_result import get_md5_value#将数据的处理分装成函数def mul_procee(data): mysql2 = ConnectMySQL(Config) flag = 0 for data_item in data: flag +=1 id = data_item["id"] img = data_item['upload_ima