def get_status(request: DBRequest, user: User):
cursor = request.get_cursor()
cursor.execute(
f"SELECT status FROM user_statuses WHERE _id = '{user.get_id()}'")
def get_user(user: User, request: DBRequest):
cursor = request.get_cursor()
cursor.execute(f"SELECT * FROM users WHERE _id = '{user.get_id()}'")
return cursor.fetchall()
def set_tabnr(request: DBRequest, user: User):
cursor = request.get_cursor()
cursor.execute(
f"UPDATE users SET tabnr = '{user.get_tabnr()}' WHERE _id = '{user.get_id()}'"
)
def create_status(request: DBRequest, user: User, start_status):
cursor = request.get_cursor()
cursor.execute(
f"INSERT INTO user_statuses VALUES('{user.get_id()}', '{start_status}')"
)
def change_status(request: DBRequest, user: User, new_status):
cursor = request.get_cursor()
cursor.execute(
f"UPDATE user_statuses SET status = '{new_status}' WHERE _id = '{user.get_id()}'"
)
def get_all_users(request: DBRequest):
cursor = request.get_cursor()
cursor.execute(f"SELECT * FROM users")
return cursor.fetchall()
def delete_user(user: User, request: DBRequest):
cursor = request.get_cursor()
cursor.execute(f"DELETE FROM users WHERE _id = '{user.get_id()}'")
def update_password(user: User, request: DBRequest):
cursor = request.get_cursor()
cursor.execute(
f"UPDATE users SET password = '******' WHERE _id = '{user.get_id()}'"
)
def update_uname(user: User, request: DBRequest):
cursor = request.get_cursor()
cursor.execute(
f"UPDATE users SET uname = '{user.get_uname()}' WHERE _id = '{user.get_id()}'"
)
def insert_user_v2(user: User, request: DBRequest):
cursor = request.get_cursor()
cursor.execute(
f"INSERT INTO users VALUES ('{user.get_id()}', '{user.get_uname()}', '{user.get_password()}', '{user.get_tabnr()}')"
)