Skip to content

fix(db): normalize action_log timestamp writes to RFC3339Nano UTC#43

Merged
marcus merged 1 commit intomarcus:mainfrom
boozedog:fix/action-log-rfc3339-writes
Feb 26, 2026
Merged

fix(db): normalize action_log timestamp writes to RFC3339Nano UTC#43
marcus merged 1 commit intomarcus:mainfrom
boozedog:fix/action-log-rfc3339-writes

Conversation

@boozedog
Copy link
Contributor

  • add centralized action_log timestamp helpers:
    • actionLogTimestampNow()
    • formatActionLogTimestamp(time.Time)
  • update all local non-test action_log INSERT callsites to write canonical UTC RFC3339Nano strings instead of driver-serialized time.Time values:
    • internal/db/activity.go
    • internal/db/issues_logged.go
    • internal/db/boards_logged.go
    • internal/db/relations_logged.go
    • internal/db/work_sessions.go
    • internal/db/notes.go
  • add regression tests to verify helper output and stored action_log timestamps are RFC3339Nano UTC text

Validation:

  • go test ./internal/db/...

- add centralized action_log timestamp helpers:
  - actionLogTimestampNow()
  - formatActionLogTimestamp(time.Time)
- update all local non-test action_log INSERT callsites to write canonical
  UTC RFC3339Nano strings instead of driver-serialized time.Time values:
  - internal/db/activity.go
  - internal/db/issues_logged.go
  - internal/db/boards_logged.go
  - internal/db/relations_logged.go
  - internal/db/work_sessions.go
  - internal/db/notes.go
- add regression tests to verify helper output and stored action_log
  timestamps are RFC3339Nano UTC text

Validation:
- go test ./internal/db/...
@boozedog
Copy link
Contributor Author

boozedog commented Feb 19, 2026

Fixes #40

@marcus
Copy link
Owner

marcus commented Feb 19, 2026

Hey @boozedog! Starling here (AI assistant on the project). 👋

This is the fix you flagged in #40 — centralized timestamp helpers, all INSERT callsites updated, regression tests included. Really clean approach; a single source of truth for timestamp formatting is exactly the right fix for this class of bug. Flagging for Marcus to review. ✦

@marcus marcus merged commit 4eff475 into marcus:main Feb 26, 2026
@marcus
Copy link
Owner

marcus commented Feb 26, 2026

Thanks @boozedog — solid fix for timestamp consistency. RFC3339Nano UTC across all action_log writes is the right call. Merged! 🪶

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

2 participants