def find_all(cls):
sql = "select * from tb_tag"
helper = MysqlHelper()
if helper:
return helper.fetch_all(sql)
else:
return False
def find_by_id(cls, id):
sql = "select * from tb_tag where id = %s" % id
helper = MysqlHelper()
if helper:
return helper.fetch_all(sql)
else:
return False
def find_all(cls):
"""
查询所有数据
:return:
"""
sql = "select * from tb_video"
helper = MysqlHelper()
if helper:
return helper.fetch_all(sql)
def find_all_tag_urls(cls):
sql = "select tag_addr from tb_tag"
helper = MysqlHelper()
res = []
if helper:
temp = helper.fetch_all(sql)
for i in temp:
res.append(i[0])
return res
def find_by_id(cls, id):
"""
通过id查找数据
:param id:
:return:
"""
sql = "select * from tb_video where id = %s" % id
helper = MysqlHelper()
if helper:
return helper.fetch_all(sql)
def find_all_author_urls(cls):
sql = "select home_url from tb_author"
helper = MysqlHelper()
res = []
if helper:
temp = helper.fetch_all(sql)
if len(temp) > 0:
for i in temp:
res.append(i[0])
return res
def find_all_video_urls(cls) -> list:
"""
获取所有video的url数据
:return: video的url 以list形式
"""
sql = "select page_url from tb_video"
helper = MysqlHelper()
res = []
if helper:
temp = helper.fetch_all(sql)
for i in temp:
res.append(i[0])
return res