LinkDesk/backend/check_admin_user.py

11 lines
313 B
Python

import sqlite3
conn = sqlite3.connect('database.db')
cursor = conn.cursor()
cursor.execute('SELECT email, is_admin, is_approved FROM users WHERE is_admin = 1')
rows = cursor.fetchall()
print("Admin users:")
for row in rows:
print(f" Email: {row[0]}, is_admin: {row[1]}, is_approved: {row[2]}")
conn.close()