Pin the ListTasks archived boolean fix in the backend store #194

2026-10-05T03:20:53Z

weichen commented

2026-10-05 03:20:53 +00:00

feature/store-pg-archived-literal 任务卡

任务主记录：Agent-System-Backend PR #65 https://git-home.u1680832.nyat.app:30319/weichen/Agent-System-Backend/pulls/65；状态：进行中；owner：weichen

基线与授权

权威仓：ssh://git@git-ssh.u1680832.nyat.app:31411/weichen/Agent-System-Dev.git；目标分支：main；R0（initial_base_sha）= 989ed378dd
工作区：/home/weichen/projects/Agent-System-Dev-wt-feature-store-pg-archived-literal（worktree）；分支：feature/store-pg-archived-literal
授权与交付终点：修复 postgres 档 GET /api/conversations 500，推进 backend 与 Dev gitlink PR。合入与 dev 部署在 PR 就绪后执行。不改 schema，不处理登录前 401。

目标与非目标

目标：ListTasks 默认未归档视图把 archived 绑成 Go bool，消除 PG boolean = integer（42883）。
非目标：不改迁移（PG BOOLEAN / SQLite INTEGER 保持），不改认证 401。

同步记录

节点	sync_base_sha	tested_head_sha	checked_at
启动	`989ed378dd`	`989ed378dd`	2026-10-05T03:15:37Z

结果与验证（完成后填写）

结果：backend 8d82408 将 ListTasks 的 archived=0 改为 archived=? 绑定 false；openTestStore 兼容 URL 与键值对 DSN，search_path 保留 public。
验证：修复前 pg1 上 TestConversationFlagsAndTaskList 报 SQLSTATE 42883。修复后 AGENT_PG_TEST_DSN=<pg1> go test ./internal/store -count=1 通过；backend go vet ./... && go test ./... -count=1 通过；Dev 仓 make test 通过（2026-10-05）。
影响与剩余项：只推进 modules/backend gitlink。backend PR #65 与本仓 PR 待所有者合入；合入后重新部署 dev 并用 GET /api/conversations 验收。401 不在本次范围。
| 同步前验收 | 989ed378dd | e1ec73941e | 2026-10-05T03:20:05Z |

# feature/store-pg-archived-literal 任务卡任务主记录：Agent-System-Backend PR #65 https://git-home.u1680832.nyat.app:30319/weichen/Agent-System-Backend/pulls/65；状态：进行中；owner：weichen ## 基线与授权 - 权威仓：ssh://git@git-ssh.u1680832.nyat.app:31411/weichen/Agent-System-Dev.git；目标分支：main；R0（initial_base_sha）= 989ed378ddd83b3bc3f47d2b497857dfe024d87f - 工作区：/home/weichen/projects/Agent-System-Dev-wt-feature-store-pg-archived-literal（worktree）；分支：feature/store-pg-archived-literal - 授权与交付终点：修复 postgres 档 `GET /api/conversations` 500，推进 backend 与 Dev gitlink PR。合入与 dev 部署在 PR 就绪后执行。不改 schema，不处理登录前 401。 ## 目标与非目标 - 目标：`ListTasks` 默认未归档视图把 `archived` 绑成 Go bool，消除 PG `boolean = integer`（42883）。 - 非目标：不改迁移（PG BOOLEAN / SQLite INTEGER 保持），不改认证 401。 ## 同步记录 | 节点 | sync_base_sha | tested_head_sha | checked_at | |---|---|---|---| | 启动 | 989ed378ddd83b3bc3f47d2b497857dfe024d87f | 989ed378ddd83b3bc3f47d2b497857dfe024d87f | 2026-10-05T03:15:37Z | ## 结果与验证（完成后填写） - 结果：backend `8d82408` 将 `ListTasks` 的 `archived=0` 改为 `archived=?` 绑定 `false`；`openTestStore` 兼容 URL 与键值对 DSN，search_path 保留 public。 - 验证：修复前 pg1 上 `TestConversationFlagsAndTaskList` 报 SQLSTATE 42883。修复后 `AGENT_PG_TEST_DSN=<pg1> go test ./internal/store -count=1` 通过；backend `go vet ./... && go test ./... -count=1` 通过；Dev 仓 `make test` 通过（2026-10-05）。 - 影响与剩余项：只推进 `modules/backend` gitlink。backend PR #65 与本仓 PR 待所有者合入；合入后重新部署 dev 并用 `GET /api/conversations` 验收。401 不在本次范围。 | 同步前验收 | 989ed378ddd83b3bc3f47d2b497857dfe024d87f | e1ec73941eb3a98dfe25b516b1ede39b9d6c68c9 | 2026-10-05T03:20:05Z |

weichen added 3 commits 2026-10-05 03:20:54 +00:00

Record the task card for feature-store-pg-archived-literal 5b50956e4f

Pin the ListTasks archived boolean fix in the backend store e1ec73941e

Why: the default unarchived task list still compared a BOOLEAN column
to the integer literal 0, so GET /api/conversations returned 500 on
the postgres tier after the previous dialect fix.

Evidence: backend PR #65 (8d82408). Before the fix, TestConversationFlagsAndTaskList
on pg1 failed with SQLSTATE 42883; after, go test ./internal/store -count=1
passed on pg1. Dev make test passed on this pin.

Impact: modules/backend gitlink moves to 8d82408. No other surface changes.

Refs: Agent-System-Backend#65
Co-authored-by: Cursor <cursoragent@cursor.com>

Record the sync checkpoint

ci / test (pull_request) Successful in 1m56s

Details

7af9b900b3

weichen referenced this issue from a commit

2026-10-05 03:21:07 +00:00

Record the Dev pull request on the task card

weichen added 1 commit 2026-10-05 03:21:07 +00:00

Record the Dev pull request on the task card

ci / test (pull_request) Successful in 1m55s

Details

080de2dbd0

Why: the task card is the main record and needs the Dev PR link
alongside the backend PR.

Evidence: Dev PR #194 is open; make test already passed after task-sync.

Impact: task card text only.

Refs: Agent-System-Dev#194, Agent-System-Backend#65
Co-authored-by: Cursor <cursoragent@cursor.com>

weichen merged commit 1a033b41a6 into main

2026-10-05 03:21:22 +00:00

Sign in to join this conversation.

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: weichen/Agent-System-Dev#194