Spaces:
Runtime error
Runtime error
Commit History
-
✨ Add database management: Supabase persistence, teacher profiles, admin dashboard
chih.yikuan +1: Claude Opus 4.8 (1M context)Build a durable data foundation for analytics + cross-quiz student tracking. Backend - Migrate from ephemeral SQLite to Supabase Postgres via SQLAlchemy 2.0 async + asyncpg. All tables isolated in a dedicated `classlens` schema so they never collide with other apps sharing the Supabase project. - Alembic migrations (applied on container startup); initial schema migration. - New data model: teachers (email/full_name/school/is_admin), first-class students (matched across quizzes by normalized name), quizzes, raw_files, parsed_data, student_results (per-student-per-quiz analytics backbone), prompts, reports (linked to quiz + student). - Rewrote database.py as a SQLAlchemy repository (same public function names). - Teacher registration captures full_name + school; ADMIN_EMAILS bootstrap. - Raw uploaded files archived to Supabase Storage + raw_files metadata. - Save-to-DB flow: report generation persists student_results + linked report; explicit POST /api/sessions/{id}/save-to-…9f97e28