elemes

Commit Graph

Author	SHA1	Message	Date
a2nr	d602b0f642	feat(student-management): kelola siswa round-trip CSV + bulk delete (PG) - Export siswa terpilih/seluruh + progress ke CSV round-trip (token tidak pernah diekspor; teacher tidak ikut; urutan deterministik) - Import preview all-or-nothing: siswa existing di-restore (nama+progress, token lama dipertahankan), siswa baru dibuat dari student_id kosong + token; conflict tidak menyebut raw token/digest - Bulk delete multi-seleksi dengan validasi ketat (teacher terlindungi, zero-delete bila ada ID bermasalah) - fix(import): deteksi delimiter berbasis schema — menerima titik koma (;) maupun koma (,), ekspor tetap ';' + BOM; header tab/campuran ditolak dengan pesan jelas (regresi: file Excel/Sheets kini bisa diimpor) - refactor: progress_status.py — kontrak status legacy tunggal dipakai storage PG, export, dan import; report siswa hanya role student - UI /progress: dialog import/export + bulk delete, selection store, respon import tanpa raw token; APP_VERSION 22 -> 26 - ops: ORIGIN env var di podman-compose.yml - docs: README section 9 (workflow round-trip + delimiter) dan docs/11-database-migration (kelola siswa via round-trip CSV) - test: parser round-trip (45), repositories, route management (24, PostgreSQL), frontend 91, fixtures CSV valid/invalid	2026-08-09 07:29:19 +07:00
a2nr	ac37db5c91	feat(storage): migrasi penyimpanan CSV ke PostgreSQL (SQLAlchemy + Alembic) - facade storage: csv_backend + postgres_backend, dipilih via STORAGE_BACKEND - token disimpan sebagai HMAC-SHA256 digest (TOKEN_PEPPER), tanpa plaintext - schema alembic 0001: users, access_tokens, lessons, student_progress - importer CSV idempotent + dry-run + sparse model (not_started tanpa row) - lesson registry: sync dari home.md (lesson hilang di-deactivate, bukan dihapus) - routes progress/auth: report & reset via DB, validasi via token hash - elemes.sh: dbupgrade/dbstatus/dbimport/synclessons/dbverify/dbbackup/dbrestore/dbexport - podman-compose: service postgres (PG18), tokens_siswa.csv mount :ro - frontend: api client + progress page; tests kontrak dual-backend + isolasi DB - load-test: skenario database (locustfile_db.py) - docs: 01-11 termasuk 11-database-migration.md (arsitektur & operasional)	2026-08-08 04:57:08 +00:00

Author

SHA1

Message

Date

a2nr

d602b0f642

feat(student-management): kelola siswa round-trip CSV + bulk delete (PG)

- Export siswa terpilih/seluruh + progress ke CSV round-trip (token tidak
  pernah diekspor; teacher tidak ikut; urutan deterministik)
- Import preview all-or-nothing: siswa existing di-restore (nama+progress,
  token lama dipertahankan), siswa baru dibuat dari student_id kosong +
  token; conflict tidak menyebut raw token/digest
- Bulk delete multi-seleksi dengan validasi ketat (teacher terlindungi,
  zero-delete bila ada ID bermasalah)
- fix(import): deteksi delimiter berbasis schema — menerima titik koma
  (;) maupun koma (,), ekspor tetap ';' + BOM; header tab/campuran ditolak
  dengan pesan jelas (regresi: file Excel/Sheets kini bisa diimpor)
- refactor: progress_status.py — kontrak status legacy tunggal dipakai
  storage PG, export, dan import; report siswa hanya role student
- UI /progress: dialog import/export + bulk delete, selection store,
  respon import tanpa raw token; APP_VERSION 22 -> 26
- ops: ORIGIN env var di podman-compose.yml
- docs: README section 9 (workflow round-trip + delimiter) dan
  docs/11-database-migration (kelola siswa via round-trip CSV)
- test: parser round-trip (45), repositories, route management (24,
  PostgreSQL), frontend 91, fixtures CSV valid/invalid

2026-08-09 07:29:19 +07:00

a2nr

ac37db5c91

feat(storage): migrasi penyimpanan CSV ke PostgreSQL (SQLAlchemy + Alembic)

- facade storage: csv_backend + postgres_backend, dipilih via STORAGE_BACKEND
- token disimpan sebagai HMAC-SHA256 digest (TOKEN_PEPPER), tanpa plaintext
- schema alembic 0001: users, access_tokens, lessons, student_progress
- importer CSV idempotent + dry-run + sparse model (not_started tanpa row)
- lesson registry: sync dari home.md (lesson hilang di-deactivate, bukan dihapus)
- routes progress/auth: report & reset via DB, validasi via token hash
- elemes.sh: dbupgrade/dbstatus/dbimport/synclessons/dbverify/dbbackup/dbrestore/dbexport
- podman-compose: service postgres (PG18), tokens_siswa.csv mount :ro
- frontend: api client + progress page; tests kontrak dual-backend + isolasi DB
- load-test: skenario database (locustfile_db.py)
- docs: 01-11 termasuk 11-database-migration.md (arsitektur & operasional)

2026-08-08 04:57:08 +00:00

2 Commits