dummy_user.py

from app import app, db, User

# Use application context
with app.app_context():
    # Create the database
    db.create_all()

    # Add dummy users
    dummy_users = [
        User(role='student', username='12345', dob='2000-01-01'),
        User(role='staff', username='emp001', dob='1985-12-12'),
        # User(role='admin', username='admin', dob='admin')  # Admin uses fixed credentials
    ]

    # Add users to the database
    for user in dummy_users:
        db.session.add(user)

    # Commit the changes
    db.session.commit()

    print("Dummy users created successfully!")