Code: Alles auswählen
def show_tickets(connection, user_id):
cursor = connection.cursor()
if is_admin(connection, user_id):
cursor.execute("SELECT id, author_id, topic, content FROM ticket")
else:
cursor.execute("SELECT id, author_id, topic, content FROM ticket WHERE author_id = ?",(user_id,))
return cursor.fetchall()