-
Notifications
You must be signed in to change notification settings - Fork 4
/
fetch.go
46 lines (38 loc) · 934 Bytes
/
fetch.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
package transferspg
import (
"context"
"fmt"
"github.com/jpgsaraceni/suricate-bank/app/domain/entities/transfer"
)
func (r Repository) Fetch(ctx context.Context) ([]transfer.Transfer, error) {
const query = `
SELECT
id,
account_origin_id,
account_destination_id,
amount,
created_at
FROM transfers;
`
rows, err := r.pool.Query(ctx, query)
if err != nil {
return nil, fmt.Errorf("%w: %s", ErrFetch, err.Error())
}
defer rows.Close()
var transferList []transfer.Transfer
for rows.Next() {
var transferReturned transfer.Transfer
err := rows.Scan(
&transferReturned.ID,
&transferReturned.AccountOriginID,
&transferReturned.AccountDestinationID,
&transferReturned.Amount,
&transferReturned.CreatedAt,
)
if err != nil {
return nil, fmt.Errorf("%w: %s", ErrScanningRows, err.Error())
}
transferList = append(transferList, transferReturned)
}
return transferList, nil
}