"""Seed script: creates default plans, admin user, and demo data for testing.""" from sqlalchemy import text from app.core.database import SessionLocal, engine, Base from app.core.security import hash_password from app.models.plan import Plan from app.models.account import Account from app.models.user import User from app.models.subject import Subject from app.models.section import Section from app.models.teacher_section import TeacherSection from app.models.enrollment import Enrollment def seed(): Base.metadata.create_all(bind=engine) db = SessionLocal() if db.query(Plan).count() == 0: plans = [ Plan(name="basic", features=["manual_checkin"], price=0), Plan(name="premium", features=["manual_checkin", "qr_checkin"], price=2999), Plan(name="pro", features=["manual_checkin", "qr_checkin", "facial_checkin"], price=5999), ] db.add_all(plans) db.commit() if db.query(Account).count() == 0: demo = Account( organization_name="Demo School", address="Av. Principal 123", category="school", plan_id=1, ) db.add(demo) db.commit() demo = db.query(Account).first() if db.query(User).filter(User.email == "admin@talos.com").count() == 0: admin = User( account_id=demo.id, name="Admin", lastname="Sistema", email="admin@talos.com", password_hash=hash_password("admin123"), role="admin", ) db.add(admin) db.commit() # Demo teacher if db.query(User).filter(User.email == "teacher@talos.com").count() == 0: teacher = User( account_id=demo.id, name="Carlos", lastname="Méndez", email="teacher@talos.com", password_hash=hash_password("teacher123"), role="teacher", card_id="TCH-001", phone_number="0412-1112233", ) db.add(teacher) db.commit() teacher = db.query(User).filter(User.email == "teacher@talos.com").first() # Demo subject subj = db.query(Subject).filter(Subject.name == "Matemáticas").first() if not subj: subj = Subject( account_id=demo.id, name="Matemáticas", code="MAT-101", description="Matemáticas básicas", ) db.add(subj) db.commit() # Demo section sec = db.query(Section).filter(Section.name == "1A").first() if not sec: sec = Section( account_id=demo.id, name="1A", subject_id=subj.id, academic_period="2025-2026", max_students=30, ) db.add(sec) db.commit() # Assign teacher to section if teacher and sec: existing = db.query(TeacherSection).filter( TeacherSection.teacher_id == teacher.id, TeacherSection.section_id == sec.id, ).first() if not existing: db.add(TeacherSection( account_id=demo.id, teacher_id=teacher.id, section_id=sec.id, )) db.commit() # Demo students demo_students = [ ("Luis", "García", "CARD-10", "0414-1000001"), ("Ana", "Martínez", "CARD-11", "0414-1000002"), ("Pedro", "Rodríguez", "CARD-12", "0414-1000003"), ("María", "López", "CARD-13", "0414-1000004"), ("José", "Hernández", "CARD-14", "0414-1000005"), ("Sofía", "González", "CARD-15", "0414-1000006"), ("Diego", "Pérez", "CARD-16", "0414-1000007"), ("Valentina", "Sánchez", "CARD-17", "0414-1000008"), ("Andrés", "Ramírez", "CARD-18", "0414-1000009"), ("Camila", "Torres", "CARD-19", "0414-1000010"), ] for name, lastname, card_id, phone in demo_students: student = db.query(User).filter(User.card_id == card_id).first() if not student: student = User( account_id=demo.id, name=name, lastname=lastname, card_id=card_id, phone_number=phone, role="student", is_active="1", ) db.add(student) db.commit() # Enroll in section student = db.query(User).filter(User.card_id == card_id).first() if sec: enrolled = db.query(Enrollment).filter( Enrollment.student_id == student.id, Enrollment.section_id == sec.id, ).first() if not enrolled: db.add(Enrollment( account_id=demo.id, student_id=student.id, section_id=sec.id, )) db.commit() # Fix any double-encoded JSON in existing plans db.execute( text("UPDATE plans SET features = JSON_EXTRACT(features, '$') WHERE JSON_VALID(features) AND NOT JSON_TYPE(features) IN ('ARRAY', 'OBJECT')") ) db.commit() db.close() print("Seed complete.") if __name__ == "__main__": seed()