/
query.sql.go
76 lines (68 loc) · 1.43 KB
/
query.sql.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
// Code generated by sqlc. DO NOT EDIT.
// versions:
// sqlc v1.17.2
// source: query.sql
package querytest
import (
"context"
)
const listBar = `-- name: ListBar :many
SELECT id_old, ip_old FROM bar_old
`
func (q *Queries) ListBar(ctx context.Context) ([]BarNew, error) {
rows, err := q.db.QueryContext(ctx, listBar)
if err != nil {
return nil, err
}
defer rows.Close()
var items []BarNew
for rows.Next() {
var i BarNew
if err := rows.Scan(&i.IDNew, &i.IpOld); err != nil {
return nil, err
}
items = append(items, i)
}
if err := rows.Close(); err != nil {
return nil, err
}
if err := rows.Err(); err != nil {
return nil, err
}
return items, nil
}
const listFoo = `-- name: ListFoo :many
SELECT id_old as foo_old, id_old as baz_old
FROM bar_old
WHERE ip_old = $1 AND id_old = $2
`
type ListFooParams struct {
IpOld IPProtocol
IDNew int32
}
type ListFooRow struct {
FooNew int32
BazOld int32
}
func (q *Queries) ListFoo(ctx context.Context, arg ListFooParams) ([]ListFooRow, error) {
rows, err := q.db.QueryContext(ctx, listFoo, arg.IpOld, arg.IDNew)
if err != nil {
return nil, err
}
defer rows.Close()
var items []ListFooRow
for rows.Next() {
var i ListFooRow
if err := rows.Scan(&i.FooNew, &i.BazOld); err != nil {
return nil, err
}
items = append(items, i)
}
if err := rows.Close(); err != nil {
return nil, err
}
if err := rows.Err(); err != nil {
return nil, err
}
return items, nil
}