christian/commitea
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity

SQLite cache bootstrap + single-issue mirror upsert #3

New Issue
Closed
opened 2026-07-08 15:15:08 +00:00 by christian · 0 comments
christian commented 2026-07-08 15:15:08 +00:00
Owner
Copy Link

Cache schema (issues,labels,milestones,comments,issue_events) + an upsert writing one reconciled issue and reading it back through extractLabelFacts. Pure row<->domain mappers in core; better-sqlite3 driver in apps/desktop/src/main.

Acceptance: reconcile one issue's labels, read back, assert estimateDays/priority/hardDeadline.

Open scope: confirm the seam — pure mappers in core, native driver in main. If reconcile orchestration should live in core too, define the injected-IO boundary here.

Cache schema (`issues`,`labels`,`milestones`,`comments`,`issue_events`) + an upsert writing one reconciled issue and reading it back through `extractLabelFacts`. Pure row<->domain mappers in core; `better-sqlite3` driver in `apps/desktop/src/main`. **Acceptance:** reconcile one issue's labels, read back, assert estimateDays/priority/hardDeadline. **Open scope:** confirm the seam — pure mappers in core, native driver in main. If reconcile *orchestration* should live in core too, define the injected-IO boundary here.
christian added this to the P1 — Sync + data model milestone 2026-07-08 15:15:08 +00:00
christian added the
est
2d
p
1
 labels 2026-07-08 15:15:08 +00:00
christian added a new dependency 2026-07-08 15:15:41 +00:00
#1 Gitea read client behind an injected fetch
christian added a new dependency 2026-07-08 15:15:42 +00:00
#4 Full reconcile-on-launch of the work repo
christian added a new dependency 2026-07-08 15:15:46 +00:00
#24 apply_changes unified mutation tool
christian removed a dependency 2026-07-09 05:21:02 +00:00
#4 Full reconcile-on-launch of the work repo
christian self-assigned this 2026-07-09 14:51:02 +00:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
deadline
hard
CommiTea: milestone has a hard deadline
est
1d
CommiTea estimate: 1 ideal-day(s)
est
2d
CommiTea estimate: 2 ideal-day(s)
est
3d
CommiTea estimate: 3 ideal-day(s)
est
5d
CommiTea estimate: 5 ideal-day(s)
est
8d
CommiTea estimate: 8 ideal-day(s)
p
1
CommiTea priority 1 (1 = most urgent)
p
2
CommiTea priority 2 (1 = most urgent)
p
3
CommiTea priority 3 (1 = most urgent)
p
4
CommiTea priority 4 (1 = most urgent)
No Label
est
2d
p
1
Milestone
No items
No Milestone P1 — Sync + data model
Projects
Clear projects
No project
Assignees
Clear assignees
christian
No Assignees christian
1 Participants
Notifications
Due Date
No due date set.
Blocks
#24 apply_changes unified mutation tool
christian/commitea
Depends on
#1 Gitea read client behind an injected fetch
christian/commitea
Reference: christian/commitea#3
No description provided.
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?