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