NexLab_System / migrations /migrate_users.py
alisaleem97's picture
Upload folder using huggingface_hub
6ea020b verified
Raw History Blame Contribute Delete
1.62 kB
"""Migration script to add user profile fields and userpermission table."""
import sqlite3
def migrate():
conn = sqlite3.connect("lab_database.db")
cursor = conn.cursor()
# Check and add new columns to user table
cursor.execute("PRAGMA table_info(user)")
columns = [col[1] for col in cursor.fetchall()]
new_columns = [
("date_of_birth", "TEXT"),
("phone_number", "TEXT"),
("address", "TEXT"),
("edited_by", "INTEGER"),
("edited_at", "TEXT"),
]
for col_name, col_type in new_columns:
if col_name not in columns:
cursor.execute(f"ALTER TABLE user ADD COLUMN {col_name} {col_type}")
print(f" [+] Added column user.{col_name}")
else:
print(f" [i] Column user.{col_name} already exists")
# Create userpermission table
cursor.execute("""
CREATE TABLE IF NOT EXISTS userpermission (
id INTEGER PRIMARY KEY AUTOINCREMENT,
user_id INTEGER NOT NULL REFERENCES user(id),
page_key TEXT NOT NULL,
allowed_buttons TEXT
)
""")
print(" [+] userpermission table created/verified")
# Create index on user_id
cursor.execute("CREATE INDEX IF NOT EXISTS idx_userpermission_user_id ON userpermission(user_id)")
cursor.execute("CREATE INDEX IF NOT EXISTS idx_userpermission_page_key ON userpermission(page_key)")
print(" [+] Indexes created/verified")
conn.commit()
conn.close()
print("\n[+] User management migration complete!")
if __name__ == "__main__":
migrate()