Spaces:
Paused
Paused
File size: 881 Bytes
4223796 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 | import sqlite3
conn = sqlite3.connect('E:/crowdata/backend/crowdata.db')
cursor = conn.cursor()
# Verify current state
cursor.execute('SELECT email, is_verified, is_superuser FROM users WHERE email IN ("admin@crowdata.ar", "crowsistemas@proton.me")')
for row in cursor.fetchall():
print(f'BEFORE: Email: {row[0]}, verified: {row[1]}, superuser: {row[2]}')
# Update with explicit 1 values
cursor.execute('UPDATE users SET is_verified = 1, is_superuser = 1 WHERE email = "admin@crowdata.ar"')
cursor.execute('UPDATE users SET is_verified = 1, is_superuser = 1 WHERE email = "crowsistemas@proton.me"')
conn.commit()
# Verify
cursor.execute('SELECT email, is_verified, is_superuser FROM users WHERE email IN ("admin@crowdata.ar", "crowsistemas@proton.me")')
for row in cursor.fetchall():
print(f'AFTER: Email: {row[0]}, verified: {row[1]}, superuser: {row[2]}')
conn.close() |