File size: 1,151 Bytes
6ea020b
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
import sqlite3

def migrate():
    conn = sqlite3.connect("lab_database.db")
    cursor = conn.cursor()
    
    # We will add columns to the 'user' table
    columns_to_add = [
        ("failed_login_attempts", "INTEGER DEFAULT 0 NOT NULL"),
        ("locked_until", "DATETIME"),
        ("session_token", "VARCHAR")
    ]
    
    for col_name, col_type in columns_to_add:
        try:
            cursor.execute(f"ALTER TABLE user ADD COLUMN {col_name} {col_type};")
            print(f"Added {col_name} to user table.")
        except sqlite3.OperationalError as e:
            # Column likely already exists
            print(f"Could not add {col_name} (may already exist): {e}")
            
    # For any existing rows, give them a session token or initialization
    # actually session_token can be NULL and will be filled upon next login.
    # We can just update failed_login_attempts to 0 if it was null due to alter table.
    cursor.execute("UPDATE user SET failed_login_attempts = 0 WHERE failed_login_attempts IS NULL;")
    
    conn.commit()
    conn.close()
    print("Migration complete!")

if __name__ == "__main__":
    migrate()