class SysCrawlerTaskInfo:
def __init__(self):
self.dbpool = MyPymysqlPool("default")
def findAll(self):
sql = "select * from sys_crawler_task_info t"
return self.dbpool.getAll(sql)
def updateDelete(self, id, val):
sql = " update sys_crawler_task_info set delete_flag = %d where uuid='%s'" % (
val, id)
return self.dbpool.update(sql)
def __del__(self):
self.dbpool.dispose()
if __name__ == '__main__':
pass
def run():
dbconn = MyPymysqlPool("default")
myMd5 = hashlib.md5()
sql = "select * from 电影天堂_detail t where 下载地址 !='' and not exists(select 1 from addr_thund a where t.`主键` = a.`主键`)"
result = dbconn.getAll(sql)
for row in result:
addrjson = row["下载地址"]
jsonarr = json.loads(str(addrjson).replace("\'", "\""),
encoding="utf-8")
for addrobj in jsonarr:
addr = addrobj["地址"]
if addr != "":
if isinstance(addr, list):
for add in addr:
insertdata(dbconn, row["主键"], add)
insertdata(dbconn, row["主键"], addr)
dbconn.dispose()
from common.Mysql_Utils import MyPymysqlPool
dbpool = MyPymysqlPool("default")
#cr = "create table sys_dic_utf8_code(code int primary key,info varchar(3),delete_flag int); "
#dbpool.update(cr);
for i in range(1,55296):
print(i,chr(i) )
sql ="insert into sys_dic_utf8_code(code,info,delete_flag) values(%d,'%s',0)" %(i,chr(i).replace("\\","\\\\").replace("'","\\'"))
dbpool.insert(sql)
dbpool.dispose()