| """ |
| Institutional User and Demo Student Seeder. |
| Ensures default administrative and demo student accounts exist in local SQLite. |
| """ |
|
|
| from __future__ import annotations |
|
|
| import datetime |
|
|
| from sqlalchemy import select |
|
|
| from backend.app.api.auth.hasher import hash_password |
| from backend.app.storage.database import SessionLocal |
| from backend.app.storage.models.entities import StudentModel, UserModel |
|
|
|
|
| def seed_default_accounts() -> None: |
| """Seeds baseline institutional accounts for local college deployment.""" |
| db = SessionLocal() |
| try: |
| |
| stmt_admin = select(UserModel).where(UserModel.username == "admin") |
| admin_u = db.execute(stmt_admin).scalar_one_or_none() |
| if not admin_u: |
| admin_u = UserModel( |
| id="usr_admin_root", |
| username="admin", |
| email="admin@college.edu", |
| password_hash=hash_password("admin123"), |
| role="officer", |
| is_active=True, |
| ) |
| db.add(admin_u) |
| else: |
| admin_u.password_hash = hash_password("admin123") |
|
|
| |
| stmt = select(UserModel).where(UserModel.username == "officer") |
| officer = db.execute(stmt).scalar_one_or_none() |
| if not officer: |
| officer = UserModel( |
| id="usr_officer_root", |
| username="officer", |
| email="tpo@college.edu", |
| password_hash=hash_password("officer123"), |
| role="officer", |
| is_active=True, |
| ) |
| db.add(officer) |
| else: |
| officer.password_hash = hash_password("officer123") |
|
|
| |
| stmt_coord = select(UserModel).where(UserModel.username == "coordinator") |
| coord = db.execute(stmt_coord).scalar_one_or_none() |
| if not coord: |
| coord = UserModel( |
| id="usr_coord_root", |
| username="coordinator", |
| email="coordinator@college.edu", |
| password_hash=hash_password("coord123"), |
| role="coordinator", |
| is_active=True, |
| ) |
| db.add(coord) |
| else: |
| coord.password_hash = hash_password("coord123") |
|
|
| |
| stmt_rec = select(UserModel).where(UserModel.username == "recruiter_google") |
| recruiter = db.execute(stmt_rec).scalar_one_or_none() |
| if not recruiter: |
| recruiter = UserModel( |
| id="usr_recruiter_google", |
| username="recruiter_google", |
| email="campus_recruiter@google.com", |
| password_hash=hash_password("recruiter123"), |
| role="recruiter_readonly", |
| company_id="comp_1", |
| is_active=True, |
| ) |
| db.add(recruiter) |
| else: |
| recruiter.password_hash = hash_password("recruiter123") |
|
|
| |
| stmt_stu = select(StudentModel).where(StudentModel.roll_no == "PIPE_001") |
| stu = db.execute(stmt_stu).scalar_one_or_none() |
| if not stu: |
| stu = StudentModel( |
| id="stu_pipe_001", |
| roll_no="PIPE_001", |
| name="Rohit Sharma", |
| email="rohit.sharma@college.edu", |
| branch="CSE", |
| program="B.Tech", |
| cgpa=8.5, |
| tenth_percentage=88.0, |
| twelfth_percentage=85.0, |
| date_of_birth=datetime.date(2004, 1, 1), |
| ) |
| db.add(stu) |
| db.flush() |
|
|
| stmt_stu_user = select(UserModel).where(UserModel.username == "PIPE_001") |
| stu_user = db.execute(stmt_stu_user).scalar_one_or_none() |
| if not stu_user: |
| stu_user = UserModel( |
| id="usr_stu_pipe_001", |
| username="PIPE_001", |
| email="rohit.sharma@college.edu", |
| password_hash=hash_password("123456"), |
| role="student", |
| student_id=stu.id, |
| is_active=True, |
| ) |
| db.add(stu_user) |
| else: |
| stu_user.password_hash = hash_password("123456") |
|
|
| |
| stmt_stu2 = select(StudentModel).where(StudentModel.roll_no == "PIPE_002") |
| stu2 = db.execute(stmt_stu2).scalar_one_or_none() |
| if not stu2: |
| stu2 = StudentModel( |
| id="stu_pipe_002", |
| roll_no="PIPE_002", |
| name="Siddharth Verma", |
| email="sid.verma@college.edu", |
| branch="Civil Engineering", |
| program="B.Tech", |
| cgpa=6.5, |
| tenth_percentage=72.0, |
| twelfth_percentage=68.0, |
| date_of_birth=datetime.date(2004, 2, 2), |
| ) |
| db.add(stu2) |
| db.flush() |
|
|
| stmt_stu2_user = select(UserModel).where(UserModel.username == "PIPE_002") |
| stu2_user = db.execute(stmt_stu2_user).scalar_one_or_none() |
| if not stu2_user: |
| stu2_user = UserModel( |
| id="usr_stu_pipe_002", |
| username="PIPE_002", |
| email="sid.verma@college.edu", |
| password_hash=hash_password("123456"), |
| role="student", |
| student_id=stu2.id, |
| is_active=True, |
| ) |
| db.add(stu2_user) |
| else: |
| stu2_user.password_hash = hash_password("123456") |
|
|
| db.commit() |
| finally: |
| db.close() |
|
|
