def get_shows_page_followed(page):
if int(page) <= 0:
result = execute_sql(sqltype='Fetch', sql=f'select * from shows where showid < 1000 and status = "Followed"')
else:
start = int(page) * 1000
end = int(page) * 1000 + 999
result = execute_sql(sqltype='Fetch', sql=f'select * from shows where status = "Followed" and showid between {start} and {end}')
result = convert_to_dict_within_list(result, data_type='DB', field_list=shows.field_list)
return result
def get_show_by_name_followed(showname):
result = execute_sql(sqltype='Fetch', sql=f'select * from shows '
f'where showname = "{showname}" and status = "Followed"')
result = convert_to_dict_within_list(result, data_type='DB', field_list=shows.field_list)
return f'{result}'
def get_show_by_name_wild(showname):
result = execute_sql(sqltype='Fetch', sql=f'select * from shows '
f'where showname like "%{showname}%"')
result = convert_to_dict_within_list(result, data_type='DB', field_list=shows.field_list)
return f'{result}'
def get_show_by_id(showid):
result = execute_sql(sqltype='Fetch', sql=f'select * from shows '
f'where `showid` = {showid}')
result = convert_to_dict_within_list(result, data_type='DB', field_list=shows.field_list)
return f'{result}'
def get_shows_followed_id_json():
result = execute_sql(sqltype='Fetch', sql=f'select * from shows where status = "Followed"')
result = convert_to_dict_within_list(result, data_type='DB', field_list=shows.field_list, need_id=True, need_json=True)
return result
