From 310d17b25d8dbcd8e930148334e7bd7bb144f407 Mon Sep 17 00:00:00 2001 From: Peter Stone Date: Thu, 16 Jul 2026 06:08:23 +0000 Subject: Add schema for task budgets and availability blocks Creates migrations/025_task_budgets_and_availability.sql with: - New availability_blocks table for manual weekly availability templates - estimated_minutes column on native_tasks for time budgeting - budget_tracked flag on projects and labels for opt-in tracking Fixes pre-existing bug in sqlite_test.go's setupTestStoreWithNativeTasks where project_id column was missing from the schema, causing test failures. Updates all hand-rolled test helpers (sqlite_test.go, native_tasks_test.go) to include the new columns, and adds availability_test.go with newAvailabilityTestStore helper for Task 4's availability CRUD tests. All store tests pass, including the two that were previously failing (TestGetNativeTasksByDateRange_ExcludesOverdue, TestGetOverdueNativeTasks_IncludesOnlyPastDue). Co-Authored-By: Claude Sonnet 5 Claude-Session: https://claude.ai/code/session_01PQaPGQVSfmKUiHXB87qRTC --- internal/store/native_tasks_test.go | 9 ++++++--- 1 file changed, 6 insertions(+), 3 deletions(-) (limited to 'internal/store/native_tasks_test.go') diff --git a/internal/store/native_tasks_test.go b/internal/store/native_tasks_test.go index cf9ea49..1b4bdf2 100644 --- a/internal/store/native_tasks_test.go +++ b/internal/store/native_tasks_test.go @@ -41,7 +41,8 @@ func newNativeTasksTestStore(t *testing.T) *Store { recurrence_interval INTEGER DEFAULT 1, recurrence_weekdays TEXT DEFAULT '', recurrence_series_id TEXT DEFAULT '', - next_occurrence_override TEXT DEFAULT '' + next_occurrence_override TEXT DEFAULT '', + estimated_minutes INTEGER DEFAULT 0 ) `); err != nil { t.Fatal(err) @@ -52,7 +53,8 @@ func newNativeTasksTestStore(t *testing.T) *Store { name TEXT NOT NULL, color TEXT DEFAULT '', created_at DATETIME DEFAULT CURRENT_TIMESTAMP, - archived BOOLEAN DEFAULT 0 + archived BOOLEAN DEFAULT 0, + budget_tracked BOOLEAN DEFAULT 0 ) `); err != nil { t.Fatal(err) @@ -60,7 +62,8 @@ func newNativeTasksTestStore(t *testing.T) *Store { if _, err := db.Exec(` CREATE TABLE labels ( name TEXT PRIMARY KEY, - color TEXT NOT NULL + color TEXT NOT NULL, + budget_tracked BOOLEAN DEFAULT 0 ) `); err != nil { t.Fatal(err) -- cgit v1.2.3