talos-access / backend /seed_test_data.py
Greg
Claude Opus 4.7 (1M context)
Preparar despliegue en fly.io: monolito dockerizado + seeder demo
6aa6081
Raw History Blame Contribute Delete
10.1 kB
"""Seed script: clears all data except admin user, then creates test data."""
import sys
import os
sys.path.insert(0, os.path.dirname(os.path.abspath(__file__)))
from app.core.database import SessionLocal, engine
from app.models import *
from sqlalchemy import text
def seed():
db = SessionLocal()
try:
admin = db.query(User).filter(User.role == "admin").first()
if not admin:
print("No admin user found. Aborting.")
return
account_id = admin.account_id
admin_id = admin.id
admin_password_hash = admin.password_hash
print(f"Admin: {admin.name} {admin.lastname} (account_id={account_id})")
# Disable FK checks for truncation
db.execute(text("SET FOREIGN_KEY_CHECKS = 0"))
# Delete in dependency order, preserving admin
for tbl in [AuditLog, FaceEncoding, Attendance, SectionSchedule, Enrollment,
TeacherSubject, TeacherSection, SectionSubject, Section, Subject,
UserPermission, User]:
if tbl == User:
db.query(User).filter(User.account_id == account_id, User.id != admin_id).delete(synchronize_session=False)
else:
db.query(tbl).filter(tbl.account_id == account_id).delete(synchronize_session=False)
# Also delete users with different account_id (e.g. any orphans)
db.query(User).filter(User.id != admin_id).delete(synchronize_session=False)
db.execute(text("SET FOREIGN_KEY_CHECKS = 1"))
db.commit()
print("Cleared: all non-admin data.")
# --- Create Subjects ---
subject_data = [
("Matemáticas", "MAT-01"),
("Lenguaje", "LEN-01"),
("Ciencias", "CIE-01"),
("Historia", "HIS-01"),
("Inglés", "ING-01"),
]
subjects = []
for name, code in subject_data:
sub = Subject(account_id=account_id, name=name, code=code)
db.add(sub)
db.flush()
subjects.append(sub)
print(f"Created {len(subjects)} subjects.")
# --- Create Sections ---
section_names = [
"1er Grado A", "2do Grado A", "3er Grado A",
"4to Grado A", "5to Grado A",
]
sections = []
for i, name in enumerate(section_names):
sec = Section(
account_id=account_id,
subject_id=subjects[i].id,
name=name,
academic_period="2025-2026",
max_students=40,
)
db.add(sec)
db.flush()
# Link all subjects to this section
for sub in subjects:
db.add(SectionSubject(account_id=account_id, section_id=sec.id, subject_id=sub.id))
sections.append(sec)
print(f"Created {len(sections)} sections with subject links.")
# --- Create Teachers ---
teacher_data = [
("María", "González", "V-10000001", "maria.gonzalez@test.com", "1234567890"),
("José", "Martínez", "V-10000002", "jose.martinez@test.com", "1234567891"),
("Ana", "Rodríguez", "V-10000003", "ana.rodriguez@test.com", "1234567892"),
]
teachers = []
for name, lastname, card_id, email, phone in teacher_data:
t = User(
account_id=account_id, name=name, lastname=lastname,
card_id=card_id, email=email, phone_number=phone,
role="teacher", is_active="1",
password_hash=admin_password_hash, # same hash so password works
)
db.add(t)
db.flush()
# Assign all subjects to teacher
for sub in subjects:
db.add(TeacherSubject(account_id=account_id, teacher_id=t.id, subject_id=sub.id))
teachers.append(t)
print(f"Created {len(teachers)} teachers with subject assignments.")
# --- Create Administrativos ---
admin_staff_data = [
("Rosa", "Mendoza", "V-40000001", "rosa.mendoza@test.com", "1234567920"),
("Luis", "Torres", "V-40000002", "luis.torres@test.com", "1234567921"),
]
admin_staff = []
for name, lastname, card_id, email, phone in admin_staff_data:
a = User(
account_id=account_id, name=name, lastname=lastname,
card_id=card_id, email=email, phone_number=phone,
role="administrativo", is_active="1",
password_hash=admin_password_hash,
)
db.add(a)
db.flush()
admin_staff.append(a)
print(f"Created {len(admin_staff)} administrativos.")
# --- Create Obreros ---
obrero_data = [
("Pedro", "García", "V-50000001", "pedro.garcia@test.com", "1234567922"),
("Manuel", "Rivas", "V-50000002", "manuel.rivas@test.com", "1234567923"),
("José", "Silva", "V-50000003", "jose.silva@test.com", "1234567924"),
]
obreros = []
for name, lastname, card_id, email, phone in obrero_data:
o = User(
account_id=account_id, name=name, lastname=lastname,
card_id=card_id, email=email, phone_number=phone,
role="obrero", is_active="1",
password_hash=admin_password_hash,
)
db.add(o)
db.flush()
obreros.append(o)
print(f"Created {len(obreros)} obreros.")
# --- Create Representatives ---
rep_data = [
("Pedro", "Pérez", "V-20000001", "pedro.perez@test.com", "1234567893"),
("Luisa", "Fernández", "V-20000002", "luisa.fernandez@test.com", "1234567894"),
("Carlos", "López", "V-20000003", "carlos.lopez@test.com", "1234567895"),
("Marta", "Díaz", "V-20000004", "marta.diaz@test.com", "1234567896"),
("Jorge", "Ramírez", "V-20000005", "jorge.ramirez@test.com", "1234567897"),
]
representatives = []
for name, lastname, card_id, email, phone in rep_data:
r = User(
account_id=account_id, name=name, lastname=lastname,
card_id=card_id, email=email, phone_number=phone,
role="representative", is_active="1",
password_hash=admin_password_hash,
)
db.add(r)
db.flush()
representatives.append(r)
print(f"Created {len(representatives)} representatives.")
# --- Create Students (3 per section, 15 total) ---
student_data = [
("Sofía", "Pérez", "V-30000001", "sofia.perez@test.com", "1234567898", 0),
("Mateo", "Pérez", "V-30000002", "mateo.perez@test.com", "1234567899", 0),
("Valentina", "Pérez", "V-30000003", "valentina.perez@test.com", "1234567900", 0),
("Santiago", "Fernández", "V-30000004", "santiago.fernandez@test.com", "1234567901", 1),
("Isabella", "Fernández", "V-30000005", "isabella.fernandez@test.com", "1234567902", 1),
("Nicolás", "Fernández", "V-30000006", "nicolas.fernandez@test.com", "1234567903", 1),
("Camila", "López", "V-30000007", "camila.lopez@test.com", "1234567904", 2),
("Sebastián", "López", "V-30000008", "sebastian.lopez@test.com", "1234567905", 2),
("Gabriela", "López", "V-30000009", "gabriela.lopez@test.com", "1234567906", 2),
("Daniel", "Díaz", "V-30000010", "daniel.diaz@test.com", "1234567907", 3),
("Emily", "Díaz", "V-30000011", "emily.diaz@test.com", "1234567908", 3),
("Samuel", "Díaz", "V-30000012", "samuel.diaz@test.com", "1234567909", 3),
("Victoria", "Ramírez", "V-30000013", "victoria.ramirez@test.com", "1234567910", 4),
("Benjamín", "Ramírez", "V-30000014", "benjamin.ramirez@test.com", "1234567911", 4),
("Luciana", "Ramírez", "V-30000015", "luciana.ramirez@test.com", "1234567912", 4),
]
students = []
for name, lastname, card_id, email, phone, rep_idx in student_data:
s = User(
account_id=account_id,
name=name, lastname=lastname,
card_id=card_id, email=email, phone_number=phone,
role="student", is_active="1",
parent_id=representatives[rep_idx].id,
password_hash=admin_password_hash,
)
db.add(s)
db.flush()
students.append(s)
# Enroll students: first 3 in section 0, next 3 in section 1, etc.
for i, student in enumerate(students):
sec_idx = i // 3
db.add(Enrollment(
account_id=account_id,
section_id=sections[sec_idx].id,
student_id=student.id,
))
print(f"Created {len(students)} students with enrollments.")
# --- Link teachers to sections (2 teachers per section, rotating) ---
for i, sec in enumerate(sections):
t1 = teachers[i % len(teachers)]
t2 = teachers[(i + 1) % len(teachers)]
db.add(TeacherSection(account_id=account_id, section_id=sec.id, teacher_id=t1.id))
db.add(TeacherSection(account_id=account_id, section_id=sec.id, teacher_id=t2.id))
print("Linked teachers to sections.")
db.commit()
print("\nSeed complete! Created:")
print(f" - {len(subjects)} subjects")
print(f" - {len(sections)} sections")
print(f" - {len(teachers)} teachers")
print(f" - {len(admin_staff)} administrativos")
print(f" - {len(obreros)} obreros")
print(f" - {len(representatives)} representatives")
print(f" - {len(students)} students")
print(f" - All users share admin's password hash")
except Exception as e:
db.rollback()
print(f"Error: {e}")
raise
finally:
db.close()
if __name__ == "__main__":
seed()