crowdata / fix_admin.py
YOSOYYONOSOYOTRO's picture
Upload folder using huggingface_hub (part 2)
4223796 verified
Raw
History Blame Contribute Delete
881 Bytes
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()