[T-009] 建立 PostgreSQL 双 Schema 与 Bell 配额投影基础 #31

New Issue

2026-08-07T17:30:14+08:00

ila commented

2026-08-07 17:30:14 +08:00

任务映射

task_id: T-009
task_file: docs/tasks/T-009.md
context_ref: 8a4514076e9921b12bc26380b2aceee9334e947d
deps: T-008
write_paths:
- docs/tasks/T-009.md
- deploy/postgres/
- scripts/test_postgres.ps1
- Sense/internal/store/
- Sense/internal/config/
- Sense/cmd/sense-api/main.go
- Sense/go.mod
- Sense/go.sum
- Sense/README.md
- docs/03-tech-stack.md
- docs/04-architecture.md
- docs/06-tasks.md
- docs/api.md
- docs/current-state.md
- tests/test_postgres_contract.py

问题与方案

T-008 已冻结契约，但 Sense 仍只有 SQLite。按 docs/tasks/T-009.md 使用本机 PostgreSQL 17.10 二进制建立双 schema、Bell 配额只读投影和 Sense PostgreSQL repository；自动测试使用隔离临时集群，不修改现有 5432 实例。

验收入口

./scripts/test_postgres.ps1 -PgRoot D:\pgsql17
./init.ps1
python -m unittest discover -s tests -p "test_*.py"
python scripts/validate_harness_governance.py

协作状态

expected_claim_branch: claims/T-009
work_branch: agent/codex/T-009
claimed_by: codex
lease_until: 2026-08-07T21:32:19Z

## 任务映射 - task_id: `T-009` - task_file: `docs/tasks/T-009.md` - context_ref: `8a4514076e9921b12bc26380b2aceee9334e947d` - deps: `T-008` - write_paths: - `docs/tasks/T-009.md` - `deploy/postgres/` - `scripts/test_postgres.ps1` - `Sense/internal/store/` - `Sense/internal/config/` - `Sense/cmd/sense-api/main.go` - `Sense/go.mod` - `Sense/go.sum` - `Sense/README.md` - `docs/03-tech-stack.md` - `docs/04-architecture.md` - `docs/06-tasks.md` - `docs/api.md` - `docs/current-state.md` - `tests/test_postgres_contract.py` ## 问题与方案 T-008 已冻结契约，但 Sense 仍只有 SQLite。按 `docs/tasks/T-009.md` 使用本机 PostgreSQL 17.10 二进制建立双 schema、Bell 配额只读投影和 Sense PostgreSQL repository；自动测试使用隔离临时集群，不修改现有 5432 实例。 ## 验收入口 - `./scripts/test_postgres.ps1 -PgRoot D:\pgsql17` - `./init.ps1` - `python -m unittest discover -s tests -p "test_*.py"` - `python scripts/validate_harness_governance.py` ## 协作状态 - expected_claim_branch: `claims/T-009` - work_branch: `agent/codex/T-009` - claimed_by: `codex` - lease_until: `2026-08-07T21:32:19Z`

ila added the kind/task

labels 2026-08-07 17:31:00 +08:00

ila self-assigned this 2026-08-07 17:31:01 +08:00

ila added

and removed

labels 2026-08-07 17:32:01 +08:00

ila commented

2026-08-07 17:32:20 +08:00

CLAIM

task: T-009
claimed_by: codex
allocated_by: ila
context_ref: 8a4514076e
claim_branch: claims/T-009
work_branch: agent/codex/T-009
write_paths:

docs/tasks/T-009.md
deploy/postgres/
scripts/test_postgres.ps1
Sense/internal/store/
Sense/internal/config/
Sense/cmd/sense-api/main.go
Sense/go.mod
Sense/go.sum
Sense/README.md
docs/03-tech-stack.md
docs/04-architecture.md
docs/06-tasks.md
docs/api.md
docs/current-state.md
tests/test_postgres_contract.py
claimed_at: 2026-08-07T09:32:19Z
lease_until: 2026-08-07T21:32:19Z

CLAIM task: T-009 claimed_by: codex allocated_by: ila context_ref: 8a4514076e9921b12bc26380b2aceee9334e947d claim_branch: claims/T-009 work_branch: agent/codex/T-009 write_paths: - docs/tasks/T-009.md - deploy/postgres/ - scripts/test_postgres.ps1 - Sense/internal/store/ - Sense/internal/config/ - Sense/cmd/sense-api/main.go - Sense/go.mod - Sense/go.sum - Sense/README.md - docs/03-tech-stack.md - docs/04-architecture.md - docs/06-tasks.md - docs/api.md - docs/current-state.md - tests/test_postgres_contract.py claimed_at: 2026-08-07T09:32:19Z lease_until: 2026-08-07T21:32:19Z

ila added

and removed

labels 2026-08-07 17:53:30 +08:00

ila referenced a pull request that will close this issue

2026-08-07 17:53:30 +08:00

[T-009] 建立 PostgreSQL 双 Schema 与 Bell 配额投影基础 #33

ila closed this issue

2026-08-07 17:54:47 +08:00