talos-access / backend /seed.py
Greg
Claude Opus 4.7 (1M context)
Preparar despliegue en fly.io: monolito dockerizado + seeder demo
6aa6081
Raw History Blame Contribute Delete
5.2 kB
"""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()