/
delete_item.go
55 lines (48 loc) · 1.52 KB
/
delete_item.go
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
package trips
import (
"errors"
"time"
"github.com/bradpurchase/grocerytime-backend/internal/pkg/db"
"github.com/bradpurchase/grocerytime-backend/internal/pkg/db/models"
)
// DeleteItem deletes an item from a trip and handles trip category cleanup
// (i.e. if this is the last item in a trip category, it deletes the trip category)
func DeleteItem(itemID interface{}) (deletedItem models.Item, err error) {
item := models.Item{}
if err := db.Manager.Where("id = ?", itemID).First(&item).Error; err != nil {
return deletedItem, errors.New("item not found")
}
categoryID := item.CategoryID
if err := db.Manager.Delete(&item).Error; err != nil {
return deletedItem, err
}
// Touch the GroceryTrip record to update its updated_at timestamp
updateTripQuery := db.Manager.
Model(&models.GroceryTrip{}).
Where("id = ?", item.GroceryTripID).
Update("updated_at", time.Now()).
Error
if err := updateTripQuery; err != nil {
return deletedItem, err
}
// If this was the last item in this trip category, delete the trip category too
var remainingItemsCount int64
categoryItemsCountQuery := db.Manager.
Model(&models.Item{}).
Where("category_id = ?", categoryID).
Count(&remainingItemsCount).
Error
if err := categoryItemsCountQuery; err != nil {
return deletedItem, err
}
if remainingItemsCount == 0 {
deleteCategoryQuery := db.Manager.
Where("id = ?", categoryID).
Delete(&models.GroceryTripCategory{}).
Error
if err := deleteCategoryQuery; err != nil {
return deletedItem, err
}
}
return item, nil
}