Phase 1: Transplant Thoth source into Kiwi #2

New issue

Closed

opened 2026-03-28 14:59:51 -07:00 by pyr0ball · 0 comments

pyr0ball commented

2026-03-28 14:59:51 -07:00

Owner

Migrate the legacy Thoth codebase into Kiwi and replace the Postgres/Alembic stack with CF-core SQLite.

Tasks

Copy Thoth source (app/, frontend/) into kiwi repo
Remove async SQLAlchemy, Alembic, PostgreSQL deps
Port 4 Alembic schema revisions → app/db/migrations/001–004_*.sql (integer PKs, no UUIDs)
Write app/db/store.py using CF-core get_connection() + run_migrations()
Replace app/core/config.py (pydantic-settings) with CF-core load_env() + require_env()
Add circuitforge-core editable install to pyproject.toml
Write manage.sh (start/stop/restart/status/logs/open)
Write compose.yml (api + web containers)
Smoke-test: health endpoint, barcode scan, inventory CRUD

Migrate the legacy Thoth codebase into Kiwi and replace the Postgres/Alembic stack with CF-core SQLite. ## Tasks - [ ] Copy Thoth source (app/, frontend/) into kiwi repo - [ ] Remove async SQLAlchemy, Alembic, PostgreSQL deps - [ ] Port 4 Alembic schema revisions → `app/db/migrations/001–004_*.sql` (integer PKs, no UUIDs) - [ ] Write `app/db/store.py` using CF-core `get_connection()` + `run_migrations()` - [ ] Replace `app/core/config.py` (pydantic-settings) with CF-core `load_env()` + `require_env()` - [ ] Add circuitforge-core editable install to `pyproject.toml` - [ ] Write `manage.sh` (start/stop/restart/status/logs/open) - [ ] Write `compose.yml` (api + web containers) - [ ] Smoke-test: health endpoint, barcode scan, inventory CRUD