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(): """