def addUrl(self, data):
sql = simpleToolSql("url")
res = self.getListFromSql(data['url'])
if len(res) > 0:
return
# print(res)
# return
res = sql.execute(
"insert into zh_article (url,title,archive,folder,type,msgid,created,updated,state,create_at,update_at) values (?,?,?,?,?,?,?,?,?,?,?);",
[(
data['url'],
data['title'],
data['archive'],
data['folder'],
data['type'],
data['msgid'],
data['created'],
data['updated'],
data['state'] if data.__contains__('state') else 0,
time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()),
time.strftime("%Y-%m-%d %H:%M:%S", time.localtime())
)]
)
print(res)
sql.close()
return
def getListFromSql(self, url):
sql = simpleToolSql("url")
# res = sql.query("select * from zh_article where state=0;")
res = sql.query("select * from zh_article where url='" + url + "';")
# print(res)
sql.close()
return res
def getAblums(self):
sql = simpleToolSql("url")
res = sql.query("select * from zh_ablum where update_at<'{t}';".format(
t=(datetime.datetime.now() - datetime.timedelta(hours=72)).strftime("%Y-%m-%d %H:%M:%S")))
# print(res)
sql.close()
return res
def updateUrlState(self, id: int):
sql = simpleToolSql("url")
res = sql.execute("update zh_article set state=1 where id = ?;", (id,))
# 需要加逗号 https://blog.csdn.net/yimaoyingbi/article/details/104323701
print(res)
sql.close()
return
def getListFromSql():
sql = simpleToolSql("url")
# res = sql.query("select * from wx_article where state=0;")
res = sql.query("select * from wx_article;")
print(res)
sql.close()
return res
def getListFromParam(self, paramsql):
sql = simpleToolSql("url")
# res = sql.query("select * from zh_article where state=0;")
res, res_name = sql.queryall("select * from zh_article where " +
paramsql + ";")
# print(res)
sql.close()
return res, res_name
def getAblumListFromSql(self, url):
sql = simpleToolSql("url")
# res = sql.query("select * from zh_article where state=0;")
res = sql.query("select * from zh_ablum where url='{u}' and update_at<'{t}';".format(u=url, t=(
datetime.datetime.now() - datetime.timedelta(hours=72)).strftime("%Y-%m-%d %H:%M:%S")))
# print(res)
sql.close()
return res
def updateAblum(self, id):
sql = simpleToolSql("url")
# res = sql.query("select * from zh_article where state=0;")
# print("-*-*-*-*")
res = sql.execute("update zh_ablum set update_at='{t}' where id={id};".format(
t=datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S"), id=id))
print("更新===", res)
sql.close()
return res
def addUrl():
sql = simpleToolSql("url")
sql.execute(
"insert into wx_article (url,folder,title,state,turn,create_at,update_at) values (?,?,?,?,?,?);",
[("http", 'test', "01", 0, 1, "2020-12-03 09:38:25",
"2020-12-03 09:38:25")])
res = sql.query("select * from wx_article;")
print(res)
sql.close()
return
def updateUrlState(self, id: int):
sql = simpleToolSql("url")
res = sql.execute(
"update wx_article set state=1,update_at=? where id = ?;", (
time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()),
id,
))
# 需要加逗号 https://blog.csdn.net/yimaoyingbi/article/details/104323701
print(res)
sql.close()
return
def getAblumListFromAuthorAndTitle(self, title):
sql = simpleToolSql("url")
# res = sql.query("select * from zh_article where state=0;")
res = sql.query(
"select * from zh_ablum where title='{ti}' and update_at<'{t}';".
format(
ti=title,
t=(datetime.datetime.now() -
datetime.timedelta(hours=2)).strftime("%Y-%m-%d %H:%M:%S")))
# print(res)
sql.close()
return res
def getListFromSql(self, title):
sql = simpleToolSql("url")
# res = sql.query("select * from wx_article where state=0;")
# print(colored("++--+++---++","yellow"), title)
if title.find("'") > -1:
str = 'select * from wx_article where title="' + title + '";'
else:
str = "select * from wx_article where title='" + title + "';"
# res = sql.query("select * from wx_article where title='" + title + "';")
res = sql.query(str)
sql.close()
return res
def addAblum(self, url, author, title):
sql = simpleToolSql("url")
res = self.getAblumListFromAuthorAndTitle(title)
print(res)
# return
if len(res) > 0:
self.updateAblum(res[0][0])
print(res[0][0])
return
res = sql.execute(
"insert into zh_ablum (url,author,title,create_at,update_at) values (?,?,?,?,?);",
[(url, author, title,
time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()),
time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()))])
print(res)
sql.close()
return
def addUrl(self, data):
sql = simpleToolSql("url")
res = self.getListFromSql(data['title'])
if len(res) > 0:
return
# print(res)
# return
res = sql.execute(
"insert into wx_article (url,folder,title,state,msgid,turn,create_at,update_at) values (?,?,?,?,?,?,?,?);",
[(data['link'], data['folder'].replace(
' ', ''), data['title'], 0, data['msgid'], data['turn'],
time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()),
time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()))])
print(colored("--->---->--->", "red"),
colored(data['title'], "red", "on_white"), res)
sql.close()
return
def addAblum(self, url, author, title):
sql = simpleToolSql("url")
res = self.getAblumListFromSql(url)
# print(res)
# return
if len(res) > 0:
self.updateAblum(res[0][0])
print(res[0][0])
return
res = sql.execute(
"insert into wx_ablum (url,author,title,create_at,update_at) values (?,?,?,?,?);",
[(url, author, title,
time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()),
time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()))])
print(colored("写入集合=====", "green"), colored(author, "yellow"),
colored(title, "red"))
sql.close()
return
def getListByTitle(self, title: str):
sql = simpleToolSql("url")
res = sql.query("select * from zh_article where title=" + title + ";")
print(res)
sql.close()
return res
