diff options
Diffstat (limited to 'internal/store/sqlite.go')
| -rw-r--r-- | internal/store/sqlite.go | 76 |
1 files changed, 0 insertions, 76 deletions
diff --git a/internal/store/sqlite.go b/internal/store/sqlite.go index ad88166..e8c9eac 100644 --- a/internal/store/sqlite.go +++ b/internal/store/sqlite.go @@ -140,77 +140,6 @@ func (s *Store) runMigrations() error { // Meals operations // SaveMeals saves multiple meals to the database -func (s *Store) SaveMeals(meals []models.Meal) error { - tx, err := s.db.Begin() - if err != nil { - return err - } - defer func() { _ = tx.Rollback() }() - - stmt, err := tx.Prepare(` - INSERT OR REPLACE INTO meals - (id, recipe_name, date, meal_type, recipe_url, updated_at) - VALUES (?, ?, ?, ?, ?, CURRENT_TIMESTAMP) - `) - if err != nil { - return err - } - defer func() { _ = stmt.Close() }() - - for _, meal := range meals { - _, err := stmt.Exec( - meal.ID, - meal.RecipeName, - meal.Date, - meal.MealType, - meal.RecipeURL, - ) - if err != nil { - return err - } - } - - return tx.Commit() -} - -// GetMeals retrieves meals from the database -func (s *Store) GetMeals(startDate, endDate time.Time) ([]models.Meal, error) { - rows, err := s.db.Query(` - SELECT id, recipe_name, date, meal_type, recipe_url - FROM meals - WHERE date BETWEEN ? AND ? - ORDER BY date ASC, - CASE meal_type - WHEN 'breakfast' THEN 1 - WHEN 'lunch' THEN 2 - WHEN 'dinner' THEN 3 - ELSE 4 - END - `, startDate, endDate) - if err != nil { - return nil, err - } - defer func() { _ = rows.Close() }() - - var meals []models.Meal - for rows.Next() { - var meal models.Meal - err := rows.Scan( - &meal.ID, - &meal.RecipeName, - &meal.Date, - &meal.MealType, - &meal.RecipeURL, - ) - if err != nil { - return nil, err - } - meals = append(meals, meal) - } - - return meals, rows.Err() -} - // Cache metadata operations // GetCacheMetadata retrieves cache metadata for a key @@ -536,11 +465,6 @@ func (s *Store) GetShoppingItemChecks(source string) (map[string]bool, error) { return checks, rows.Err() } -// GetMealsByDateRange retrieves meals within a specific date range -func (s *Store) GetMealsByDateRange(start, end time.Time) ([]models.Meal, error) { - return s.GetMeals(start, end) -} - // 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) { |
