summaryrefslogtreecommitdiff
path: root/internal
diff options
context:
space:
mode:
Diffstat (limited to 'internal')
-rw-r--r--internal/handlers/handlers.go150
-rw-r--r--internal/handlers/timeline.go27
-rw-r--r--internal/handlers/timeline_logic.go36
-rw-r--r--internal/models/timeline.go30
-rw-r--r--internal/models/types.go7
-rw-r--r--internal/store/sqlite.go84
-rw-r--r--internal/store/sqlite_test.go120
7 files changed, 429 insertions, 25 deletions
diff --git a/internal/handlers/handlers.go b/internal/handlers/handlers.go
index 5c86ce2..ee28a87 100644
--- a/internal/handlers/handlers.go
+++ b/internal/handlers/handlers.go
@@ -62,7 +62,7 @@ func (h *Handler) HandleDashboard(w http.ResponseWriter, r *http.Request) {
// Extract tab query parameter for state persistence
tab := r.URL.Query().Get("tab")
if tab == "" {
- tab = "tasks"
+ tab = "timeline"
}
// Aggregate data from all sources
@@ -626,6 +626,18 @@ func (h *Handler) handleAtomToggle(w http.ResponseWriter, r *http.Request, compl
}
case "trello":
err = h.trelloClient.UpdateCard(ctx, id, map[string]interface{}{"closed": complete})
+ case "bug":
+ // Bug IDs are prefixed with "bug-", extract the numeric ID
+ var bugID int64
+ if _, parseErr := fmt.Sscanf(id, "bug-%d", &bugID); parseErr != nil {
+ JSONError(w, http.StatusBadRequest, "Invalid bug ID format", parseErr)
+ return
+ }
+ if complete {
+ err = h.store.ResolveBug(bugID)
+ } else {
+ err = h.store.UnresolveBug(bugID)
+ }
default:
JSONError(w, http.StatusBadRequest, "Unknown source: "+source, nil)
return
@@ -684,7 +696,7 @@ func (h *Handler) handleAtomToggle(w http.ResponseWriter, r *http.Request, compl
}
}
-// getAtomTitle retrieves the title for a task/card from the store
+// getAtomTitle retrieves the title for a task/card/bug from the store
func (h *Handler) getAtomTitle(id, source string) string {
switch source {
case "todoist":
@@ -705,6 +717,16 @@ func (h *Handler) getAtomTitle(id, source string) string {
}
}
}
+ case "bug":
+ if bugs, err := h.store.GetBugs(); err == nil {
+ var bugID int64
+ fmt.Sscanf(id, "bug-%d", &bugID)
+ for _, b := range bugs {
+ if b.ID == bugID {
+ return b.Description
+ }
+ }
+ }
}
return "Task"
}
@@ -943,7 +965,7 @@ func (h *Handler) HandleUpdateTask(w http.ResponseWriter, r *http.Request) {
w.WriteHeader(http.StatusOK)
}
-// HandleTabTasks renders the unified Tasks tab (Todoist + Trello cards with due dates)
+// HandleTabTasks renders the unified Tasks tab (Todoist + Trello cards with due dates + Bugs)
func (h *Handler) HandleTabTasks(w http.ResponseWriter, r *http.Request) {
tasks, err := h.store.GetTasks()
if err != nil {
@@ -957,6 +979,12 @@ func (h *Handler) HandleTabTasks(w http.ResponseWriter, r *http.Request) {
return
}
+ bugs, err := h.store.GetUnresolvedBugs()
+ if err != nil {
+ log.Printf("Warning: failed to fetch bugs: %v", err)
+ bugs = nil
+ }
+
atoms := make([]models.Atom, 0)
for _, task := range tasks {
@@ -973,6 +1001,15 @@ func (h *Handler) HandleTabTasks(w http.ResponseWriter, r *http.Request) {
}
}
+ // Add unresolved bugs as atoms
+ for _, bug := range bugs {
+ atoms = append(atoms, models.BugToAtom(models.Bug{
+ ID: bug.ID,
+ Description: bug.Description,
+ CreatedAt: bug.CreatedAt,
+ }))
+ }
+
for i := range atoms {
atoms[i].ComputeUIFields()
}
@@ -1171,14 +1208,89 @@ func (h *Handler) HandleTabMeals(w http.ResponseWriter, r *http.Request) {
HTMLResponse(w, h.templates, "meals-tab", struct{ Meals []models.Meal }{meals})
}
-// HandleTabShopping renders the Shopping tab (Trello Shopping board + PlanToEat)
+// HandleTabShopping renders the Shopping tab (Trello Shopping board + PlanToEat + User items)
func (h *Handler) HandleTabShopping(w http.ResponseWriter, r *http.Request) {
ctx := r.Context()
stores := h.aggregateShoppingLists(ctx)
HTMLResponse(w, h.templates, "shopping-tab", struct{ Stores []models.ShoppingStore }{stores})
}
-// aggregateShoppingLists combines Trello and PlanToEat shopping items by store
+// HandleShoppingQuickAdd adds a user shopping item
+func (h *Handler) HandleShoppingQuickAdd(w http.ResponseWriter, r *http.Request) {
+ if err := r.ParseForm(); err != nil {
+ JSONError(w, http.StatusBadRequest, "Failed to parse form", err)
+ return
+ }
+
+ name := strings.TrimSpace(r.FormValue("name"))
+ store := strings.TrimSpace(r.FormValue("store"))
+
+ if name == "" {
+ JSONError(w, http.StatusBadRequest, "Name is required", nil)
+ return
+ }
+ if store == "" {
+ store = "Quick Add"
+ }
+
+ if err := h.store.SaveUserShoppingItem(name, store); err != nil {
+ JSONError(w, http.StatusInternalServerError, "Failed to save item", err)
+ return
+ }
+
+ // Return refreshed shopping tab
+ ctx := r.Context()
+ stores := h.aggregateShoppingLists(ctx)
+ HTMLResponse(w, h.templates, "shopping-tab", struct{ Stores []models.ShoppingStore }{stores})
+}
+
+// HandleShoppingToggle toggles a shopping item's checked state
+func (h *Handler) HandleShoppingToggle(w http.ResponseWriter, r *http.Request) {
+ if err := r.ParseForm(); err != nil {
+ JSONError(w, http.StatusBadRequest, "Failed to parse form", err)
+ return
+ }
+
+ id := r.FormValue("id")
+ source := r.FormValue("source")
+ checked := r.FormValue("checked") == "true"
+
+ if source == "user" {
+ var userID int64
+ if _, err := fmt.Sscanf(id, "user-%d", &userID); err != nil {
+ JSONError(w, http.StatusBadRequest, "Invalid user item ID", err)
+ return
+ }
+ if err := h.store.ToggleUserShoppingItem(userID, checked); err != nil {
+ JSONError(w, http.StatusInternalServerError, "Failed to toggle item", err)
+ return
+ }
+ }
+ // Note: Trello and PlanToEat toggle would need their own API calls
+
+ // Return updated item HTML
+ checkedClass := ""
+ checkedAttr := ""
+ textClass := "text-white"
+ if checked {
+ checkedClass = "opacity-50"
+ checkedAttr = "checked"
+ textClass = "line-through text-white/40"
+ }
+ html := fmt.Sprintf(`<li class="flex items-center gap-3 p-3 bg-white/5 hover:bg-white/10 transition-colors rounded-lg border border-white/5 %s">
+ <input type="checkbox" %s
+ hx-post="/shopping/toggle"
+ hx-vals='{"id":"%s","source":"%s","checked":%t}'
+ hx-target="closest li"
+ hx-swap="outerHTML"
+ class="h-5 w-5 rounded bg-black/40 border-white/30 text-green-500 focus:ring-white/30 cursor-pointer flex-shrink-0">
+ <span class="flex-1 %s">%s</span>
+ <span class="text-xs px-2 py-0.5 rounded bg-purple-900/50 text-purple-300">user</span>
+ </li>`, checkedClass, checkedAttr, template.HTMLEscapeString(id), template.HTMLEscapeString(source), !checked, textClass, template.HTMLEscapeString(r.FormValue("name")))
+ HTMLString(w, html)
+}
+
+// aggregateShoppingLists combines Trello, PlanToEat, and user shopping items by store
func (h *Handler) aggregateShoppingLists(ctx context.Context) []models.ShoppingStore {
storeMap := make(map[string]map[string][]models.UnifiedShoppingItem)
@@ -1245,7 +1357,33 @@ func (h *Handler) aggregateShoppingLists(ctx context.Context) []models.ShoppingS
log.Printf("DEBUG [Shopping/PlanToEat]: Client not configured")
}
- // 3. Convert map to sorted slice
+ // 3. Fetch user-added shopping items
+ userItems, err := h.store.GetUserShoppingItems()
+ if err != nil {
+ log.Printf("ERROR [Shopping/User]: %v", err)
+ } else {
+ for _, item := range userItems {
+ storeName := item.Store
+ if storeName == "" {
+ storeName = "Quick Add"
+ }
+
+ if storeMap[storeName] == nil {
+ storeMap[storeName] = make(map[string][]models.UnifiedShoppingItem)
+ }
+
+ unified := models.UnifiedShoppingItem{
+ ID: fmt.Sprintf("user-%d", item.ID),
+ Name: item.Name,
+ Store: storeName,
+ Source: "user",
+ Checked: item.Checked,
+ }
+ storeMap[storeName][""] = append(storeMap[storeName][""], unified)
+ }
+ }
+
+ // 4. Convert map to sorted slice
var stores []models.ShoppingStore
for storeName, categories := range storeMap {
store := models.ShoppingStore{Name: storeName}
diff --git a/internal/handlers/timeline.go b/internal/handlers/timeline.go
index b923d3e..ce0e831 100644
--- a/internal/handlers/timeline.go
+++ b/internal/handlers/timeline.go
@@ -8,6 +8,15 @@ import (
"task-dashboard/internal/models"
)
+// TimelineData holds grouped timeline items for the template
+type TimelineData struct {
+ TodayItems []models.TimelineItem
+ TomorrowItems []models.TimelineItem
+ LaterItems []models.TimelineItem
+ Start time.Time
+ Days int
+}
+
// HandleTimeline renders the timeline view
func (h *Handler) HandleTimeline(w http.ResponseWriter, r *http.Request) {
// Parse query params
@@ -45,15 +54,21 @@ func (h *Handler) HandleTimeline(w http.ResponseWriter, r *http.Request) {
return
}
- data := struct {
- Items []models.TimelineItem
- Start time.Time
- Days int
- }{
- Items: items,
+ // Group items by day section
+ data := TimelineData{
Start: start,
Days: days,
}
+ for _, item := range items {
+ switch item.DaySection {
+ case models.DaySectionToday:
+ data.TodayItems = append(data.TodayItems, item)
+ case models.DaySectionTomorrow:
+ data.TomorrowItems = append(data.TomorrowItems, item)
+ case models.DaySectionLater:
+ data.LaterItems = append(data.LaterItems, item)
+ }
+ }
HTMLResponse(w, h.templates, "timeline-tab", data)
}
diff --git a/internal/handlers/timeline_logic.go b/internal/handlers/timeline_logic.go
index 1aba780..c51262a 100644
--- a/internal/handlers/timeline_logic.go
+++ b/internal/handlers/timeline_logic.go
@@ -13,6 +13,7 @@ import (
// BuildTimeline aggregates and normalizes data into a timeline structure
func BuildTimeline(ctx context.Context, s *store.Store, calendarClient api.GoogleCalendarAPI, start, end time.Time) ([]models.TimelineItem, error) {
var items []models.TimelineItem
+ now := time.Now()
// 1. Fetch Tasks
tasks, err := s.GetTasksByDateRange(start, end)
@@ -23,7 +24,7 @@ func BuildTimeline(ctx context.Context, s *store.Store, calendarClient api.Googl
if task.DueDate == nil {
continue
}
- items = append(items, models.TimelineItem{
+ item := models.TimelineItem{
ID: task.ID,
Type: models.TimelineItemTypeTask,
Title: task.Content,
@@ -31,7 +32,11 @@ func BuildTimeline(ctx context.Context, s *store.Store, calendarClient api.Googl
Description: task.Description,
URL: task.URL,
OriginalItem: task,
- })
+ IsCompleted: task.Completed,
+ Source: "todoist",
+ }
+ item.ComputeDaySection(now)
+ items = append(items, item)
}
// 2. Fetch Meals
@@ -53,14 +58,18 @@ func BuildTimeline(ctx context.Context, s *store.Store, calendarClient api.Googl
mealTime = time.Date(mealTime.Year(), mealTime.Month(), mealTime.Day(), 12, 0, 0, 0, mealTime.Location())
}
- items = append(items, models.TimelineItem{
+ item := models.TimelineItem{
ID: meal.ID,
Type: models.TimelineItemTypeMeal,
Title: meal.RecipeName,
Time: mealTime,
URL: meal.RecipeURL,
OriginalItem: meal,
- })
+ IsCompleted: false, // Meals don't have completion status
+ Source: "plantoeat",
+ }
+ item.ComputeDaySection(now)
+ items = append(items, item)
}
// 3. Fetch Cards
@@ -72,14 +81,18 @@ func BuildTimeline(ctx context.Context, s *store.Store, calendarClient api.Googl
if card.DueDate == nil {
continue
}
- items = append(items, models.TimelineItem{
+ item := models.TimelineItem{
ID: card.ID,
Type: models.TimelineItemTypeCard,
Title: card.Name,
Time: *card.DueDate,
URL: card.URL,
OriginalItem: card,
- })
+ IsCompleted: false, // Cards in timeline are not completed (closed cards filtered out)
+ Source: "trello",
+ }
+ item.ComputeDaySection(now)
+ items = append(items, item)
}
// 4. Fetch Events
@@ -87,16 +100,21 @@ func BuildTimeline(ctx context.Context, s *store.Store, calendarClient api.Googl
events, err := calendarClient.GetEventsByDateRange(ctx, start, end)
if err == nil {
for _, event := range events {
- items = append(items, models.TimelineItem{
+ endTime := event.End
+ item := models.TimelineItem{
ID: event.ID,
Type: models.TimelineItemTypeEvent,
Title: event.Summary,
Time: event.Start,
- EndTime: &event.End,
+ EndTime: &endTime,
Description: event.Description,
URL: event.HTMLLink,
OriginalItem: event,
- })
+ IsCompleted: false, // Events don't have completion status
+ Source: "calendar",
+ }
+ item.ComputeDaySection(now)
+ items = append(items, item)
}
}
}
diff --git a/internal/models/timeline.go b/internal/models/timeline.go
index 4a619fa..469cce4 100644
--- a/internal/models/timeline.go
+++ b/internal/models/timeline.go
@@ -11,6 +11,14 @@ const (
TimelineItemTypeEvent TimelineItemType = "event"
)
+type DaySection string
+
+const (
+ DaySectionToday DaySection = "today"
+ DaySectionTomorrow DaySection = "tomorrow"
+ DaySectionLater DaySection = "later"
+)
+
type TimelineItem struct {
ID string `json:"id"`
Type TimelineItemType `json:"type"`
@@ -20,4 +28,26 @@ type TimelineItem struct {
Description string `json:"description,omitempty"`
URL string `json:"url,omitempty"`
OriginalItem interface{} `json:"-"`
+
+ // UI enhancement fields
+ IsCompleted bool `json:"is_completed"`
+ DaySection DaySection `json:"day_section"`
+ Source string `json:"source"` // "todoist", "trello", "plantoeat", "calendar"
+}
+
+// ComputeDaySection sets the DaySection based on the item's time
+func (item *TimelineItem) ComputeDaySection(now time.Time) {
+ today := time.Date(now.Year(), now.Month(), now.Day(), 0, 0, 0, 0, now.Location())
+ tomorrow := today.AddDate(0, 0, 1)
+ dayAfterTomorrow := today.AddDate(0, 0, 2)
+
+ itemDay := time.Date(item.Time.Year(), item.Time.Month(), item.Time.Day(), 0, 0, 0, 0, item.Time.Location())
+
+ if itemDay.Before(tomorrow) {
+ item.DaySection = DaySectionToday
+ } else if itemDay.Before(dayAfterTomorrow) {
+ item.DaySection = DaySectionTomorrow
+ } else {
+ item.DaySection = DaySectionLater
+ }
}
diff --git a/internal/models/types.go b/internal/models/types.go
index 0284a3a..6dc8716 100644
--- a/internal/models/types.go
+++ b/internal/models/types.go
@@ -103,9 +103,10 @@ type CalendarEvent struct {
// Bug represents a bug report
type Bug struct {
- ID int64 `json:"id"`
- Description string `json:"description"`
- CreatedAt time.Time `json:"created_at"`
+ ID int64 `json:"id"`
+ Description string `json:"description"`
+ CreatedAt time.Time `json:"created_at"`
+ ResolvedAt *time.Time `json:"resolved_at,omitempty"`
}
// CacheMetadata tracks when data was last fetched
diff --git a/internal/store/sqlite.go b/internal/store/sqlite.go
index 5b67234..5b95607 100644
--- a/internal/store/sqlite.go
+++ b/internal/store/sqlite.go
@@ -569,6 +569,7 @@ type Bug struct {
ID int64
Description string
CreatedAt time.Time
+ ResolvedAt *time.Time
}
// SaveBug saves a new bug report
@@ -579,7 +580,30 @@ func (s *Store) SaveBug(description string) error {
// GetBugs retrieves all bugs, newest first
func (s *Store) GetBugs() ([]Bug, error) {
- rows, err := s.db.Query(`SELECT id, description, created_at FROM bugs ORDER BY created_at DESC`)
+ rows, err := s.db.Query(`SELECT id, description, created_at, resolved_at FROM bugs ORDER BY created_at DESC`)
+ if err != nil {
+ return nil, err
+ }
+ defer rows.Close()
+
+ var bugs []Bug
+ for rows.Next() {
+ var b Bug
+ var resolvedAt sql.NullTime
+ if err := rows.Scan(&b.ID, &b.Description, &b.CreatedAt, &resolvedAt); err != nil {
+ return nil, err
+ }
+ if resolvedAt.Valid {
+ b.ResolvedAt = &resolvedAt.Time
+ }
+ bugs = append(bugs, b)
+ }
+ return bugs, rows.Err()
+}
+
+// GetUnresolvedBugs retrieves bugs that haven't been resolved yet
+func (s *Store) GetUnresolvedBugs() ([]Bug, error) {
+ rows, err := s.db.Query(`SELECT id, description, created_at FROM bugs WHERE resolved_at IS NULL ORDER BY created_at DESC`)
if err != nil {
return nil, err
}
@@ -596,6 +620,64 @@ func (s *Store) GetBugs() ([]Bug, error) {
return bugs, rows.Err()
}
+// ResolveBug marks a bug as resolved
+func (s *Store) ResolveBug(id int64) error {
+ _, err := s.db.Exec(`UPDATE bugs SET resolved_at = CURRENT_TIMESTAMP WHERE id = ?`, id)
+ return err
+}
+
+// UnresolveBug marks a bug as unresolved (reopens it)
+func (s *Store) UnresolveBug(id int64) error {
+ _, err := s.db.Exec(`UPDATE bugs SET resolved_at = NULL WHERE id = ?`, id)
+ return err
+}
+
+// UserShoppingItem represents a user-added shopping item
+type UserShoppingItem struct {
+ ID int64
+ Name string
+ Store string
+ Checked bool
+ CreatedAt time.Time
+}
+
+// SaveUserShoppingItem saves a new user shopping item
+func (s *Store) SaveUserShoppingItem(name, store string) error {
+ _, err := s.db.Exec(`INSERT INTO user_shopping_items (name, store) VALUES (?, ?)`, name, store)
+ return err
+}
+
+// GetUserShoppingItems retrieves all user shopping items
+func (s *Store) GetUserShoppingItems() ([]UserShoppingItem, error) {
+ rows, err := s.db.Query(`SELECT id, name, store, checked, created_at FROM user_shopping_items ORDER BY store, created_at DESC`)
+ if err != nil {
+ return nil, err
+ }
+ defer rows.Close()
+
+ var items []UserShoppingItem
+ for rows.Next() {
+ var item UserShoppingItem
+ if err := rows.Scan(&item.ID, &item.Name, &item.Store, &item.Checked, &item.CreatedAt); err != nil {
+ return nil, err
+ }
+ items = append(items, item)
+ }
+ return items, rows.Err()
+}
+
+// ToggleUserShoppingItem toggles the checked state of a user shopping item
+func (s *Store) ToggleUserShoppingItem(id int64, checked bool) error {
+ _, err := s.db.Exec(`UPDATE user_shopping_items SET checked = ? WHERE id = ?`, checked, id)
+ return err
+}
+
+// DeleteUserShoppingItem removes a user shopping item
+func (s *Store) DeleteUserShoppingItem(id int64) error {
+ _, err := s.db.Exec(`DELETE FROM user_shopping_items WHERE id = ?`, id)
+ return err
+}
+
// GetTasksByDateRange retrieves tasks due within a specific date range
func (s *Store) GetTasksByDateRange(start, end time.Time) ([]models.Task, error) {
rows, err := s.db.Query(`
diff --git a/internal/store/sqlite_test.go b/internal/store/sqlite_test.go
index 5719e24..fc8a3b7 100644
--- a/internal/store/sqlite_test.go
+++ b/internal/store/sqlite_test.go
@@ -569,3 +569,123 @@ func TestGetCardsByDateRange(t *testing.T) {
t.Errorf("Expected card1, got %s", results[0].ID)
}
}
+
+// setupTestStoreWithBugs creates a test store with bugs table
+func setupTestStoreWithBugs(t *testing.T) *Store {
+ t.Helper()
+
+ tempDir := t.TempDir()
+ dbPath := filepath.Join(tempDir, "test.db")
+
+ db, err := sql.Open("sqlite3", dbPath)
+ if err != nil {
+ t.Fatalf("Failed to open test database: %v", err)
+ }
+
+ db.SetMaxOpenConns(1)
+
+ store := &Store{db: db}
+
+ schema := `
+ CREATE TABLE IF NOT EXISTS bugs (
+ id INTEGER PRIMARY KEY AUTOINCREMENT,
+ description TEXT NOT NULL,
+ created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
+ resolved_at DATETIME DEFAULT NULL
+ );
+ `
+ if _, err := db.Exec(schema); err != nil {
+ t.Fatalf("Failed to create schema: %v", err)
+ }
+
+ return store
+}
+
+func TestBugResolution(t *testing.T) {
+ store := setupTestStoreWithBugs(t)
+ defer store.Close()
+
+ // Save some bugs
+ if err := store.SaveBug("Bug 1"); err != nil {
+ t.Fatalf("Failed to save bug 1: %v", err)
+ }
+ if err := store.SaveBug("Bug 2"); err != nil {
+ t.Fatalf("Failed to save bug 2: %v", err)
+ }
+ if err := store.SaveBug("Bug 3"); err != nil {
+ t.Fatalf("Failed to save bug 3: %v", err)
+ }
+
+ // Verify all 3 bugs are unresolved
+ unresolved, err := store.GetUnresolvedBugs()
+ if err != nil {
+ t.Fatalf("GetUnresolvedBugs failed: %v", err)
+ }
+ if len(unresolved) != 3 {
+ t.Errorf("Expected 3 unresolved bugs, got %d", len(unresolved))
+ }
+
+ // Resolve bug 2
+ if err := store.ResolveBug(2); err != nil {
+ t.Fatalf("ResolveBug failed: %v", err)
+ }
+
+ // Verify only 2 unresolved bugs remain
+ unresolved, err = store.GetUnresolvedBugs()
+ if err != nil {
+ t.Fatalf("GetUnresolvedBugs after resolve failed: %v", err)
+ }
+ if len(unresolved) != 2 {
+ t.Errorf("Expected 2 unresolved bugs, got %d", len(unresolved))
+ }
+
+ // Verify bug 2 is not in the unresolved list
+ for _, bug := range unresolved {
+ if bug.ID == 2 {
+ t.Error("Bug 2 should have been resolved but is still in unresolved list")
+ }
+ }
+
+ // Verify all bugs still exist in GetBugs (including resolved)
+ allBugs, err := store.GetBugs()
+ if err != nil {
+ t.Fatalf("GetBugs failed: %v", err)
+ }
+ if len(allBugs) != 3 {
+ t.Errorf("Expected 3 total bugs, got %d", len(allBugs))
+ }
+
+ // Verify bug 2 has resolved_at set
+ for _, bug := range allBugs {
+ if bug.ID == 2 {
+ if bug.ResolvedAt == nil {
+ t.Error("Bug 2 should have resolved_at set")
+ }
+ }
+ }
+
+ // Unresolve bug 2
+ if err := store.UnresolveBug(2); err != nil {
+ t.Fatalf("UnresolveBug failed: %v", err)
+ }
+
+ // Verify all 3 bugs are unresolved again
+ unresolved, err = store.GetUnresolvedBugs()
+ if err != nil {
+ t.Fatalf("GetUnresolvedBugs after unresolve failed: %v", err)
+ }
+ if len(unresolved) != 3 {
+ t.Errorf("Expected 3 unresolved bugs after unresolve, got %d", len(unresolved))
+ }
+}
+
+func TestResolveBug_NonExistent(t *testing.T) {
+ store := setupTestStoreWithBugs(t)
+ defer store.Close()
+
+ // Resolving a non-existent bug should not error (no rows affected is fine)
+ err := store.ResolveBug(999)
+ if err != nil {
+ t.Errorf("ResolveBug on non-existent bug should not error, got: %v", err)
+ }
+}