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