def get_img_2_mysql(self):
conn = ConnMysql()
sql = "select * from albums order by id limit {0},{1};".format(
self.limit_start, self.limit_cont)
result = conn.sql_select_many(sql)
for i in result:
self.q.put(i)
def get_img_2_mysql(self):
conn = ConnMysql()
while True:
sql = "select * from albums order by id limit {0},{1};".format(self.limit_start, self.limit_cont)
result = conn.sql_select_one(sql)
if len(result) < 1:
print("-"*50 + "数据库读取完毕" + "-"*50)
break
self.q.put(result)
self.limit_start += 1
def handle_finger(self, fmd5, fsha1, fsize, path="xqe/images"):
conn = ConnMysql()
ssql = """select count(*) from finger where fingermd5="%s" and fingersha1="%s";""" % (fmd5, fsha1)
isql = """insert into finger (path,fingermd5,fingersha1,filesize) values ("%s","%s","%s",%s)""" % (path, fmd5, fsha1, fsize)
esql = """select id,path from finger where fingermd5="%s" and fingersha1="%s";""" % (fmd5, fsha1)
flag = conn.sql_select_one(ssql)
if flag["count(*)"] == 0:
conn.sql_change_msg(isql)
res = conn.sql_select_one(esql)
return {"code": 0, "id": res["id"], "path": res["path"]}
else:
res = conn.sql_select_one(esql)
return {"code": 1, "id": res["id"], "path": res["path"]}
def __del__(self):
conn = ConnMysql()
conn.release()
def update_albums(self, img_url, info):
conn = ConnMysql()
sql = """insert into user_albums (albums_name,store_id,albums_href,img_url,other_msg) values ("%s","%s","%s","%s","%s");""" % (
info["albums_name"], info["store_id"], info["albums_href"],
img_url, info["other_msg"])
conn.sql_change_msg(sql)
"""
import time
import random
import requests
import warnings
from workspace import handledata
from workspace.login import QQZone
from setting import IP_POOL
from sqlpool.pool import ConnMysql
from multiprocessing import Manager, Pool
from setting import HEADERS, PROCESSES, QUEUE_MAX_SIZE, WAIT_TIME, END_FLAG
warnings.filterwarnings('ignore')
session = requests.Session()
headers = HEADERS
conn = ConnMysql()
end_flag = 0
def qq_login():
"""
用session登陆QQ空间获取个g_tk
:return: g_tk : str
"""
proxy_ip = random.choice(IP_POOL)
qz = QQZone(session=session, proxies=proxy_ip)
return qz.run()
def get_qq_account():
"""