feat: add zero-config local seed database #28

Merged
addison merged 19 commits from feat/local-seed-database into main 2026-07-21 21:24:25 -04:00
Collaborator

Summary

  • add a persistent SQL Server 2022 Docker Compose service with idempotent fictional Aptora and Extensions seed data
  • preserve read-only Aptora and read-write Extensions access boundaries
  • add a checked-in development environment and make just run start and seed the local database automatically
  • install Docker Engine and the Compose plugin in Amp orb setup through apt
  • document startup, shutdown, reset, and private .env override workflows

Verification

  • ran .agents/setup twice to verify Docker installation is idempotent
  • ran go test ./internal/config with Go 1.25
  • ran docker compose config --quiet
  • started SQL Server and ran the seed twice successfully
  • verified Aptora has read-only permissions and Extensions has migration/write permissions
  • tested a clean checkout with exactly just deps then just run
  • confirmed Vite and Go started and GET /health returned {"status":"healthy"}
  • ran Prettier and whitespace checks
## Summary - add a persistent SQL Server 2022 Docker Compose service with idempotent fictional Aptora and Extensions seed data - preserve read-only Aptora and read-write Extensions access boundaries - add a checked-in development environment and make `just run` start and seed the local database automatically - install Docker Engine and the Compose plugin in Amp orb setup through apt - document startup, shutdown, reset, and private `.env` override workflows ## Verification - ran `.agents/setup` twice to verify Docker installation is idempotent - ran `go test ./internal/config` with Go 1.25 - ran `docker compose config --quiet` - started SQL Server and ran the seed twice successfully - verified Aptora has read-only permissions and Extensions has migration/write permissions - tested a clean checkout with exactly `just deps` then `just run` - confirmed Vite and Go started and `GET /health` returned `{"status":"healthy"}` - ran Prettier and whitespace checks
Amp-Thread-ID: https://ampcode.com/threads/T-019f8447-fd3f-7449-a6dd-ea538c401ded

Co-authored-by: Addison Emig <[email protected]>
docs: remove unrequested local database spec
All checks were successful
CI / frontend (pull_request) Successful in 27s
CI / backend (pull_request) Successful in 37s
ccfdf6062b
Co-authored-by: Addison Emig <[email protected]>
fix: address seed review findings
All checks were successful
CI / frontend (pull_request) Successful in 28s
CI / backend (pull_request) Successful in 54s
7f60e78f9f
Amp-Thread-ID: https://ampcode.com/threads/T-019f8447-fd3f-7449-a6dd-ea538c401ded

Co-authored-by: Addison Emig <[email protected]>
feat: add realistic invoice seed data
All checks were successful
CI / frontend (pull_request) Successful in 28s
CI / backend (pull_request) Successful in 36s
0d16169b88
Amp-Thread-ID: https://ampcode.com/threads/T-019f8447-fd3f-7449-a6dd-ea538c401ded

Co-authored-by: Addison Emig <[email protected]>
Owner

The seed data doesn't quite match Aptora, but we can improve that in the future.

The seed data doesn't quite match Aptora, but we can improve that in the future.
refactor: standardize just recipe names
All checks were successful
CI / frontend (pull_request) Successful in 39s
CI / backend (pull_request) Successful in 36s
cdfd328b85
Amp-Thread-ID: https://ampcode.com/threads/T-019f8447-fd3f-7449-a6dd-ea538c401ded

Co-authored-by: Addison Emig <[email protected]>
addison deleted branch feat/local-seed-database 2026-07-21 21:24:25 -04:00
Sign in to join this conversation.
No reviewers
No labels
No milestone
No project
No assignees
2 participants
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set

Reference
kwila/office-extensions!28
No description provided.