/
payment_repository.go
100 lines (78 loc) · 2.21 KB
/
payment_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
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
package repository
import (
"context"
"database/sql"
"waroeng_pgn1/domain"
)
type paymentRepository struct {
database *sql.DB
collection string
}
func NewPaymentRepository(db *sql.DB, collection string) domain.PaymentRepository {
return &paymentRepository{
database: db,
collection: collection,
}
}
func (pr *paymentRepository) Create(c context.Context, payment *domain.Payment) error {
stmt, err := pr.database.Prepare(`INSERT INTO payment (id, id_order, status, metode_pembayaran) VALUES (?, ?, ?, ?)`)
if err != nil {
panic(err)
}
defer stmt.Close()
_, err = stmt.Exec(payment.ID, payment.IDOrder, payment.Status, payment.MetodePembayaran)
if err != nil {
return err
}
return nil
}
func (pr *paymentRepository) GetById(c context.Context, id string) (domain.Payment, error) {
var payment domain.Payment
stmt, err := pr.database.Prepare(`SELECT id, id_order, status, metode_pembayaran FROM payment WHERE id = ?`)
if err != nil {
panic(err)
}
defer stmt.Close()
rows, err := stmt.Query(id)
if err != nil {
return payment, err
}
for rows.Next() {
err = rows.Scan(&payment.ID, &payment.IDOrder, &payment.Status, &payment.MetodePembayaran)
if err != nil {
return payment, err
}
}
return payment, nil
}
func (pr *paymentRepository) GetByIdOrder(c context.Context, id string) (domain.Payment, error) {
var payment domain.Payment
stmt, err := pr.database.Prepare(`SELECT id, id_order, status, metode_pembayaran FROM payment WHERE id_order = ?`)
if err != nil {
panic(err)
}
defer stmt.Close()
rows, err := stmt.Query(id)
if err != nil {
return payment, err
}
for rows.Next() {
err = rows.Scan(&payment.ID, &payment.IDOrder, &payment.Status, &payment.MetodePembayaran)
if err != nil {
return payment, err
}
}
return payment, nil
}
func (pr *paymentRepository) UpdateById(c context.Context, id string, payment domain.Payment) (domain.Payment, error) {
stmt, err := pr.database.Prepare(`UPDATE payment SET id_order = ?, status = ?, metode_pembayaran = ? WHERE id = ?`)
if err != nil {
panic(err)
}
defer stmt.Close()
_, err = stmt.Exec(payment.IDOrder, payment.Status, payment.MetodePembayaran, id)
if err != nil {
return payment, err
}
return payment, nil
}