Spaces:
Paused
Paused
| 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() |