Jens
faeb58ef6d
GeoIntel release gates / Compile, test, contracts and builds (push) Successful in 1m49s
GeoIntel release gates / Python and npm vulnerability policy (push) Successful in 21s
GeoIntel release gates / Production AI image, SBOM and container scan (push) Successful in 5m39s
GeoIntel release gates / Deploy exact gated revision to Unraid (push) Failing after 58m43s
723 B
723 B
Codex Pass 02 — Database and Models
Goal
Add SQLAlchemy/Alembic/PostGIS-ready database foundation.
Must implement
- database session management;
- base model conventions;
- models for Project, Area, Dataset, AnalysisRun, Metric, Export, Job;
- migration scaffold;
- geometry field strategy documented in code comments or docs;
- indexes for FK and future geometry operations;
- tests for model imports.
Must preserve
- PostGIS as spatial database;
- additive migration approach;
- UUID or chosen ID strategy consistently.
Must not implement
- destructive migrations;
- live GRB/OSM fetch;
- AI tables beyond V1 scaffold unless already specified.
Output
Use docs/M6_FINAL_HANDOFF_TEMPLATE.md.