NexLab_System / migrations /migrate_security.py
alisaleem97's picture
Upload folder using huggingface_hub
6ea020b verified
Raw History Blame Contribute Delete
1.15 kB
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()