def get_more_restaurants(query,num):
db=DataBase()
morequery = query.replace('DESC LIMIT 5',f'DESC LIMIT 5 OFFSET {num}')
df=db.fetch_restaurants_by_sql(morequery)
print("SQL Query: " + morequery)
return df
def get_restaurant(type,region,aspects):
db=DataBase()
query = "SELECT rest_name, rest_address, rest_region, AVG(rest_food_rating) as rest_food_rating, AVG(rest_srvc_rating) as rest_srvc_rating, AVG(rest_ambi_rating) as rest_ambi_rating, AVG(rest_prce_rating) as rest_prce_rating, AVG(w_rest_rating) as w_rest_rating FROM restaurant"
query = query + searchby_foodtype_region(type,region) + sort_by_aspect(aspects)
df=db.fetch_restaurants_by_sql(query)
print("SQL Query: " + query)
return df,query