diff options
Diffstat (limited to 'internal/store/sqlite.go')
| -rw-r--r-- | internal/store/sqlite.go | 79 |
1 files changed, 0 insertions, 79 deletions
diff --git a/internal/store/sqlite.go b/internal/store/sqlite.go index e8c9eac..1662c6a 100644 --- a/internal/store/sqlite.go +++ b/internal/store/sqlite.go @@ -386,85 +386,6 @@ func (s *Store) ClearSyncToken(service string) error { } // 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 func() { _ = 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 -} - -// SetShoppingItemChecked sets the checked state for an external shopping item -func (s *Store) SetShoppingItemChecked(source, itemID string, checked bool) error { - checkedInt := 0 - if checked { - checkedInt = 1 - } - _, err := s.db.Exec(` - INSERT INTO shopping_item_checks (source, item_id, checked, updated_at) - VALUES (?, ?, ?, CURRENT_TIMESTAMP) - ON CONFLICT(source, item_id) DO UPDATE SET checked = ?, updated_at = CURRENT_TIMESTAMP - `, source, itemID, checkedInt, checkedInt) - return err -} - -// GetShoppingItemChecks returns a map of item_id -> checked for a given source -func (s *Store) GetShoppingItemChecks(source string) (map[string]bool, error) { - rows, err := s.db.Query(`SELECT item_id, checked FROM shopping_item_checks WHERE source = ?`, source) - if err != nil { - return nil, err - } - defer func() { _ = rows.Close() }() - - checks := make(map[string]bool) - for rows.Next() { - var itemID string - var checked int - if err := rows.Scan(&itemID, &checked); err != nil { - return nil, err - } - checks[itemID] = checked == 1 - } - return checks, rows.Err() -} - // GetCardsByDateRange retrieves cards due within a specific date range, // including overdue cards (due before start) so they appear in the timeline. func (s *Store) GetCardsByDateRange(start, end time.Time) ([]models.Card, error) { |
