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