Code: Alles auswählen
def make_user_to_admin(connection, user_name):
user_exists = connection.cursor().execute("SELECT EXISTS(SELECT 1 FROM user WHERE user_name = ?)", (user_name,)).fetchone()[0]
if user_exists:
connection.cursor().execute("UPDATE user SET admin = ? WHERE user_name = ?",(True, user_name))
connection.commit()
return True
else:
return False
Code: Alles auswählen
def show_tickets(connection, user_id):
if is_admin(connection, user_id):
return connection.cursor().execute("SELECT id, author_id, topic, content FROM ticket").fetchall()
else:
return connection.cursor().execute("SELECT id, author_id, topic, content FROM ticket WHERE author_id = ?",(user_id,)).fetchall()
Wird im main() aufgerufen:
Code: Alles auswählen
def print_menue(connection, user_id):
while True:
print("\nWas möchtest du tun:\n")
print("1 - Ticket erstellen")
print("2 - Meine Tickets ansehen")
print("3 - Abmelden")
print("4 - Account löschen")
if is_admin(connection, user_id):
print("5 - Adminrecht an User geben")
menue_choice = int(input("\n> "))
if menue_choice in range(1,6):
return menue_choice
else:
print("Falsche Eingabe!\n")