def set_query(query_str: str):
database.sql_set(query_str)
def set_restaurant_rating(restaurant, rating):
database.sql_set(
'UPDATE restaurant_database SET rating=? WHERE restaurant LIKE ?',
(rating, restaurant))
def add_bug_report(report, user):
database.sql_set(
'INSERT OR IGNORE INTO bug_report (date, report, user_name) VALUES (CURRENT_TIMESTAMP, ?, ?)',
(report, user))
def add_restaurant(restaurant, rating, url):
database.sql_set(
'INSERT OR IGNORE INTO restaurant_database (restaurant, rating, url) VALUES (?,?,?)',
(restaurant, rating, url))
def remove_food_orders_by_user(user):
database.sql_set('DELETE FROM food_orders WHERE name=?', (user, ))
def remove_food_orders():
database.sql_set('DELETE FROM food_orders')
def remove_food_order(user, item):
database.sql_set('DELETE FROM food_orders WHERE name=? AND item=?',
(user, item))
def add_food_order(user, item, restaurant, date):
database.sql_set(
'INSERT OR IGNORE INTO food_orders (name, item, restaurant, "date") VALUES (?, ?, ?, ?)',
(user, item, restaurant, date))