-
Notifications
You must be signed in to change notification settings - Fork 0
/
product_repository.go
58 lines (47 loc) · 1.72 KB
/
product_repository.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
56
57
58
package repository
import (
"tokobelanja-kelompok7/model/entity"
"gorm.io/gorm"
)
type ProductRepository interface {
Save(product entity.Product) (entity.Product, error)
FindAll() ([]entity.Product, error)
FindAllByCategoryId(id_category int) ([]entity.Product, error)
FindById(id_product int) (entity.Product, error)
Update(id_product int, product entity.Product) (entity.Product, error)
Delete(id_product int) error
}
type productRepository struct {
db *gorm.DB
}
func NewProductRepository(db *gorm.DB) *productRepository {
return &productRepository{db}
}
func (r *productRepository) Save(product entity.Product) (entity.Product, error) {
err := r.db.Preload("Category").Preload("Category").Create(&product).Error
return product, err
}
func (r *productRepository) FindAll() ([]entity.Product, error) {
var products []entity.Product
err := r.db.Preload("Category").Find(&products).Error
return products, err
}
func (r *productRepository) FindAllByCategoryId(id_category int) ([]entity.Product, error) {
var products []entity.Product
err := r.db.Preload("Category").Where("category_id = ?", id_category).Find(&products).Error
return products, err
}
func (r *productRepository) FindById(id_product int) (entity.Product, error) {
var product entity.Product
err := r.db.Preload("Category").Where("id = ?", id_product).Find(&product).Error
return product, err
}
func (r *productRepository) Update(id_product int, product entity.Product) (entity.Product, error) {
err := r.db.Preload("Category").Where("id = ?", id_product).Updates(&product).Error
return product, err
}
func (r *productRepository) Delete(id_product int) error {
var product entity.Product
err := r.db.Where("id = ?", id_product).Delete(&product).Error
return err
}