feat: location hierarchy CRUD API #81

New Issue

forbes · 2026-02-13T19:03:44Z

forbes commented

2026-02-13 19:03:44 +00:00

Ref: docs/ROADMAP.md § Appendix B / 1.6 Location & Inventory APIs

Database tables exist (locations table in migrations/001_initial.sql) but no repository layer, routes, or handlers are implemented.

Database schema (already exists):

CREATE TABLE locations (
    id UUID PRIMARY KEY DEFAULT uuid_generate_v4(),
    path TEXT UNIQUE NOT NULL,  -- e.g., 'lab/shelf-a/bin-3'
    name TEXT NOT NULL,
    parent_id UUID REFERENCES locations(id),
    location_type TEXT NOT NULL,
    depth INTEGER NOT NULL DEFAULT 0,
    metadata JSONB DEFAULT '{}',
    created_at TIMESTAMPTZ NOT NULL DEFAULT now()
);

Tasks:

Create internal/db/locations.go — repository with CRUD methods, hierarchy traversal
Create internal/api/location_handlers.go — HTTP handlers
Register routes in internal/api/routes.go:
- GET /api/locations �� list locations (flat or tree)
- POST /api/locations — create location
- GET /api/locations/{path} — get location by path
- DELETE /api/locations/{path} — delete location (reject if inventory exists)
Add tests for repository and handlers
Support parent_id for nested hierarchy and depth auto-calculation

Related: #56 (broader inventory-location model issue)

**Ref:** `docs/ROADMAP.md` § Appendix B / 1.6 Location & Inventory APIs Database tables exist (`locations` table in `migrations/001_initial.sql`) but no repository layer, routes, or handlers are implemented. **Database schema (already exists):** ```sql CREATE TABLE locations ( id UUID PRIMARY KEY DEFAULT uuid_generate_v4(), path TEXT UNIQUE NOT NULL, -- e.g., 'lab/shelf-a/bin-3' name TEXT NOT NULL, parent_id UUID REFERENCES locations(id), location_type TEXT NOT NULL, depth INTEGER NOT NULL DEFAULT 0, metadata JSONB DEFAULT '{}', created_at TIMESTAMPTZ NOT NULL DEFAULT now() ); ``` **Tasks:** - [ ] Create `internal/db/locations.go` — repository with CRUD methods, hierarchy traversal - [ ] Create `internal/api/location_handlers.go` — HTTP handlers - [ ] Register routes in `internal/api/routes.go`: - `GET /api/locations` �� list locations (flat or tree) - `POST /api/locations` — create location - `GET /api/locations/{path}` — get location by path - `DELETE /api/locations/{path}` — delete location (reject if inventory exists) - [ ] Add tests for repository and handlers - [ ] Support `parent_id` for nested hierarchy and `depth` auto-calculation Related: #56 (broader inventory-location model issue)

forbes referenced this issue

2026-02-13 19:03:52 +00:00

feat: inventory tracking API #82

forbes referenced this issue from a commit

2026-02-15 09:09:44 +00:00

feat: location hierarchy CRUD API

forbes referenced a pull request that will close this issue

2026-02-15 09:09:56 +00:00

feat: location hierarchy CRUD API #106

forbes referenced this issue from a commit

2026-02-15 09:16:07 +00:00

feat: location hierarchy CRUD API