def input_url3(self):
loads = self.load_mid_without_limit()
db = MySql()
for i in loads:
pn = 1
mid = i[0]
sql1 = f'''select sum from getbvlist where mid={mid}'''
res = int(db.fetch_one(sql1)[0])
while (res > 0):
res = res - 100
pn += 1
url = self.format_url_3(mid, pn)
sql = f'''Insert Into getbvlist values({mid},"{url}",1,{res})'''
print(sql)
db.execute(sql)
print(mid)
def deal_url_1_res(self, res, mid):
info = {}
for i, j in res["data"].items():
if i in self.need:
if j == "":
j = " "
info[i] = j
sql2 = f'''insert into upbasic values({info["mid"]},"{info["name"]}","{info["sex"]}","null",{info["level"]},"{info["birthday"]}",{info["coins"]},null,null,null)'''
sql1 = f'''select mid from upbasic where mid = {mid}'''
sql3 = f'''update baida_up set url_1_valid = 0 where mid = {mid}'''
db = MySql()
call = db.fetch_one(sql1)
print(call)
if call == None:
print(sql2)
db.execute(sql2)
db.execute(sql3)
print("ok")
