Function insertTask

internal/app/testhelpers_test.go:33–52

(t *testing.T, db *sql.DB, slug, name, status, priority, wd string, project any)

}

func insertTask(t *testing.T, db *sql.DB, slug, name, status, priority, wd string, project any) {
	t.Helper()
	now := flowdb.NowISO()
	// Session-id invariant: only backlog may have a NULL session_id.
	// Tests that create non-backlog rows get a deterministic per-slug
	// placeholder UUID — unique (so the partial unique index is happy)
	// without needing real Claude session bookkeeping.
	var sessionID any
	if status != "backlog" {
		sessionID = fakeSessionID(slug)
	}
	_, err := db.Exec(
		`INSERT INTO tasks (slug, name, project_slug, status, priority, work_dir, session_id, created_at, updated_at)
		 VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,
		slug, name, project, status, priority, wd, sessionID, now, now,
	)
	if err != nil {
		t.Fatalf("insert task: %v", err)
	}
}

// fakeSessionID makes a deterministic v4-shaped UUID derived from
// slug. Used by insertTask to satisfy the session-id invariant on