Spaces:
Runtime error
Runtime error
Greg
Claude Opus 4.7 (1M context)
Preparar despliegue en fly.io: monolito dockerizado + seeder demo
6aa6081 Download backend/seed.py from Talosware/talos-access: direct link, hf CLI and curl.
- Browser
- Download file 5.2 kB
-
https://huggingface.co/spaces/Talosware/talos-access/resolve/main/backend/seed.py
- Command line
-
hf download hf://spaces/Talosware/talos-access/backend/seed.py
-
curl -L -o seed.py https://huggingface.co/spaces/Talosware/talos-access/resolve/main/backend/seed.py
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() | |