def get_food_order(user, item):
return database.sql_get(
'SELECT name, item FROM food_orders WHERE name=? AND item=?',
(user, item))
def get_bug_report():
return database.sql_get(
'SELECT report, user_name, date FROM bug_report ORDER BY date')
def get_query(query_str: str):
return database.sql_get(query_str)
def get_restaurant_rating(restaurant):
return database.sql_get(
'SELECT rating FROM restaurant_database where restaurant LIKE ? LIMIT 1',
(restaurant, ))
def get_restaurants():
return database.sql_get(
'SELECT restaurant, rating, url FROM restaurant_database ORDER BY rating DESC'
)
def get_food_orders():
return database.sql_get(
'SELECT name, item FROM food_orders ORDER BY item ASC')
def get_food_order_by_user(user):
return database.sql_get(
'SELECT name, item FROM food_orders WHERE name =? ORDER BY item ASC',
(user, ))
def get_food_order_items():
return database.sql_get(
'SELECT item FROM food_orders GROUP BY item ORDER BY item ASC')