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()