from main import app, db
from utils.db.db import Admin, Doctor, Patient, AdministrativeAssistant

with app.app_context():
    print("Dropping all existing tables to apply schema changes...")
    db.drop_all()
    
    print("Creating new tables...")
    db.create_all()
    
    # Re-create default admin user
    if not Admin.query.filter_by(username='admin').first():
        admin = Admin(username='admin', password='password')
        db.session.add(admin)
        db.session.commit()
        print("Default admin (admin/password) created.")

    print("Database successfully reset.")