-
Notifications
You must be signed in to change notification settings - Fork 2
/
guilds_query.sql.go
150 lines (137 loc) · 3.99 KB
/
guilds_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
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
137
138
139
140
141
142
143
144
145
146
147
148
149
150
// Code generated by sqlc. DO NOT EDIT.
// versions:
// sqlc v1.26.0
// source: guilds_query.sql
package database
import (
"context"
)
const CreateGuild = `-- name: CreateGuild :one
INSERT INTO guilds (guild_id, embed_colour, site_splash_url, site_staff_visible, site_guild_visible, site_allow_invites)
VALUES ($1, $2, $3, $4, $5, $6)
RETURNING
guild_id, embed_colour, site_splash_url, site_staff_visible, site_guild_visible, site_allow_invites
`
type CreateGuildParams struct {
GuildID int64 `json:"guild_id"`
EmbedColour int32 `json:"embed_colour"`
SiteSplashUrl string `json:"site_splash_url"`
SiteStaffVisible bool `json:"site_staff_visible"`
SiteGuildVisible bool `json:"site_guild_visible"`
SiteAllowInvites bool `json:"site_allow_invites"`
}
func (q *Queries) CreateGuild(ctx context.Context, arg CreateGuildParams) (*Guilds, error) {
row := q.db.QueryRow(ctx, CreateGuild,
arg.GuildID,
arg.EmbedColour,
arg.SiteSplashUrl,
arg.SiteStaffVisible,
arg.SiteGuildVisible,
arg.SiteAllowInvites,
)
var i Guilds
err := row.Scan(
&i.GuildID,
&i.EmbedColour,
&i.SiteSplashUrl,
&i.SiteStaffVisible,
&i.SiteGuildVisible,
&i.SiteAllowInvites,
)
return &i, err
}
const CreateOrUpdateGuild = `-- name: CreateOrUpdateGuild :one
INSERT INTO guilds (guild_id, embed_colour, site_splash_url, site_staff_visible, site_guild_visible, site_allow_invites)
VALUES ($1, $2, $3, $4, $5, $6)
ON CONFLICT(guild_id) DO UPDATE
SET embed_colour = EXCLUDED.embed_colour,
site_splash_url = EXCLUDED.site_splash_url,
site_staff_visible = EXCLUDED.site_staff_visible,
site_guild_visible = EXCLUDED.site_guild_visible,
site_allow_invites = EXCLUDED.site_allow_invites
RETURNING
guild_id, embed_colour, site_splash_url, site_staff_visible, site_guild_visible, site_allow_invites
`
type CreateOrUpdateGuildParams struct {
GuildID int64 `json:"guild_id"`
EmbedColour int32 `json:"embed_colour"`
SiteSplashUrl string `json:"site_splash_url"`
SiteStaffVisible bool `json:"site_staff_visible"`
SiteGuildVisible bool `json:"site_guild_visible"`
SiteAllowInvites bool `json:"site_allow_invites"`
}
func (q *Queries) CreateOrUpdateGuild(ctx context.Context, arg CreateOrUpdateGuildParams) (*Guilds, error) {
row := q.db.QueryRow(ctx, CreateOrUpdateGuild,
arg.GuildID,
arg.EmbedColour,
arg.SiteSplashUrl,
arg.SiteStaffVisible,
arg.SiteGuildVisible,
arg.SiteAllowInvites,
)
var i Guilds
err := row.Scan(
&i.GuildID,
&i.EmbedColour,
&i.SiteSplashUrl,
&i.SiteStaffVisible,
&i.SiteGuildVisible,
&i.SiteAllowInvites,
)
return &i, err
}
const GetGuild = `-- name: GetGuild :one
SELECT
guild_id, embed_colour, site_splash_url, site_staff_visible, site_guild_visible, site_allow_invites
FROM
guilds
WHERE
guild_id = $1
`
func (q *Queries) GetGuild(ctx context.Context, guildID int64) (*Guilds, error) {
row := q.db.QueryRow(ctx, GetGuild, guildID)
var i Guilds
err := row.Scan(
&i.GuildID,
&i.EmbedColour,
&i.SiteSplashUrl,
&i.SiteStaffVisible,
&i.SiteGuildVisible,
&i.SiteAllowInvites,
)
return &i, err
}
const UpdateGuild = `-- name: UpdateGuild :execrows
UPDATE
guilds
SET
embed_colour = $2,
site_splash_url = $3,
site_staff_visible = $4,
site_guild_visible = $5,
site_allow_invites = $6
WHERE
guild_id = $1
`
type UpdateGuildParams struct {
GuildID int64 `json:"guild_id"`
EmbedColour int32 `json:"embed_colour"`
SiteSplashUrl string `json:"site_splash_url"`
SiteStaffVisible bool `json:"site_staff_visible"`
SiteGuildVisible bool `json:"site_guild_visible"`
SiteAllowInvites bool `json:"site_allow_invites"`
}
func (q *Queries) UpdateGuild(ctx context.Context, arg UpdateGuildParams) (int64, error) {
result, err := q.db.Exec(ctx, UpdateGuild,
arg.GuildID,
arg.EmbedColour,
arg.SiteSplashUrl,
arg.SiteStaffVisible,
arg.SiteGuildVisible,
arg.SiteAllowInvites,
)
if err != nil {
return 0, err
}
return result.RowsAffected(), nil
}