summaryrefslogtreecommitdiff
path: root/internal/store/sqlite.go
diff options
context:
space:
mode:
Diffstat (limited to 'internal/store/sqlite.go')
-rw-r--r--internal/store/sqlite.go76
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) {