-
Notifications
You must be signed in to change notification settings - Fork 1k
Expand file tree
/
Copy pathquery.sql.go
More file actions
136 lines (116 loc) · 3.86 KB
/
query.sql.go
File metadata and controls
136 lines (116 loc) · 3.86 KB
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
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
// Code generated by sqlc. DO NOT EDIT.
// versions:
// sqlc v1.29.0
// source: query.sql
package db
import (
"context"
"database/sql"
"github.com/lib/pq"
)
const query_enum_array_table = `-- name: query_enum_array_table :many
SELECT id, value FROM array_enum_table
`
func (q *Queries) query_enum_array_table(ctx context.Context) ([]ArrayEnumTable, error) {
rows, err := q.db.QueryContext(ctx, query_enum_array_table)
if err != nil {
return nil, err
}
defer rows.Close()
var items []ArrayEnumTable
for rows.Next() {
var i ArrayEnumTable
if err := rows.Scan(&i.ID, pq.Array(&i.Value)); 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 query_param_enum_table = `-- name: query_param_enum_table :one
SELECT id, other, value FROM query_param_enum_table WHERE value = $1
`
func (q *Queries) query_param_enum_table(ctx context.Context, value NullQueryParamEnumTableEnum) (QueryParamEnumTable, error) {
row := q.db.QueryRowContext(ctx, query_param_enum_table, value)
var i QueryParamEnumTable
err := row.Scan(&i.ID, &i.Other, &i.Value)
return i, err
}
const query_param_struct_enum_table = `-- name: query_param_struct_enum_table :one
SELECT id FROM query_param_struct_enum_table WHERE id = $1 AND value = $2
`
type query_param_struct_enum_tableParams struct {
ID int32
Value NullQueryParamStructEnumTableEnum
}
func (q *Queries) query_param_struct_enum_table(ctx context.Context, arg query_param_struct_enum_tableParams) (int32, error) {
row := q.db.QueryRowContext(ctx, query_param_struct_enum_table, arg.ID, arg.Value)
var id int32
err := row.Scan(&id)
return id, err
}
const query_return_enum_table = `-- name: query_return_enum_table :one
SELECT value FROM query_return_enum_table WHERE id = $1
`
func (q *Queries) query_return_enum_table(ctx context.Context, id int32) (NullQueryReturnEnumTableEnum, error) {
row := q.db.QueryRowContext(ctx, query_return_enum_table, id)
var value NullQueryReturnEnumTableEnum
err := row.Scan(&value)
return value, err
}
const query_return_full_table = `-- name: query_return_full_table :many
SELECT id, value FROM query_return_full_table
`
func (q *Queries) query_return_full_table(ctx context.Context) ([]QueryReturnFullTable, error) {
rows, err := q.db.QueryContext(ctx, query_return_full_table)
if err != nil {
return nil, err
}
defer rows.Close()
var items []QueryReturnFullTable
for rows.Next() {
var i QueryReturnFullTable
if err := rows.Scan(&i.ID, &i.Value); 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 query_return_struct_enum_table = `-- name: query_return_struct_enum_table :one
SELECT value, another FROM query_return_struct_enum_table WHERE id = $1
`
type query_return_struct_enum_tableRow struct {
Value NullQueryReturnStructEnumTableEnum
Another sql.NullInt32
}
func (q *Queries) query_return_struct_enum_table(ctx context.Context, id int32) (query_return_struct_enum_tableRow, error) {
row := q.db.QueryRowContext(ctx, query_return_struct_enum_table, id)
var i query_return_struct_enum_tableRow
err := row.Scan(&i.Value, &i.Another)
return i, err
}
const query_sqlc_embed_table = `-- name: query_sqlc_embed_table :one
SELECT query_sqlc_embed_table.id, query_sqlc_embed_table.value FROM query_sqlc_embed_table WHERE id = $1
`
type query_sqlc_embed_tableRow struct {
QuerySqlcEmbedTable QuerySqlcEmbedTable
}
func (q *Queries) query_sqlc_embed_table(ctx context.Context, id int32) (query_sqlc_embed_tableRow, error) {
row := q.db.QueryRowContext(ctx, query_sqlc_embed_table, id)
var i query_sqlc_embed_tableRow
err := row.Scan(&i.QuerySqlcEmbedTable.ID, &i.QuerySqlcEmbedTable.Value)
return i, err
}