summaryrefslogtreecommitdiff
path: root/internal/data/frequencies.sql.go
diff options
context:
space:
mode:
authorKyren223 <Kyren223@proton.me>2024-11-23 22:43:41 +0200
committerKyren223 <Kyren223@proton.me>2024-11-23 22:43:41 +0200
commitc17319d6fd23a0c85668ec55ee2a3cea9995b6fe (patch)
treeb8aa323fb2b0bb694696fc6455d10b68242e87e1 /internal/data/frequencies.sql.go
parent91bbd29dbe2738459cef83b5204844a2c136a84f (diff)
Fixed typo and generated sqlc code
Diffstat (limited to 'internal/data/frequencies.sql.go')
-rw-r--r--internal/data/frequencies.sql.go98
1 files changed, 97 insertions, 1 deletions
diff --git a/internal/data/frequencies.sql.go b/internal/data/frequencies.sql.go
index ae7cd43..3782309 100644
--- a/internal/data/frequencies.sql.go
+++ b/internal/data/frequencies.sql.go
@@ -60,10 +60,28 @@ func (q *Queries) DeleteFrequency(ctx context.Context, id snowflake.ID) error {
return err
}
+const getFrequencyById = `-- name: GetFrequencyById :one
+SELECT id, network_id, name, hex_color, perms, position FROM frequencies
+WHERE id = ?
+`
+
+func (q *Queries) GetFrequencyById(ctx context.Context, id snowflake.ID) (Frequency, error) {
+ row := q.db.QueryRowContext(ctx, getFrequencyById, id)
+ var i Frequency
+ err := row.Scan(
+ &i.ID,
+ &i.NetworkID,
+ &i.Name,
+ &i.HexColor,
+ &i.Perms,
+ &i.Position,
+ )
+ return i, err
+}
+
const getNetworkFrequencies = `-- name: GetNetworkFrequencies :many
SELECT id, network_id, name, hex_color, perms, position FROM frequencies
WHERE network_id = ?
-ORDER BY id
`
func (q *Queries) GetNetworkFrequencies(ctx context.Context, networkID snowflake.ID) ([]Frequency, error) {
@@ -96,6 +114,84 @@ func (q *Queries) GetNetworkFrequencies(ctx context.Context, networkID snowflake
return items, nil
}
+const setFrequencyColor = `-- name: SetFrequencyColor :one
+UPDATE frequencies SET
+ hex_color = ?
+WHERE id = ?
+RETURNING id, network_id, name, hex_color, perms, position
+`
+
+type SetFrequencyColorParams struct {
+ HexColor *string
+ ID snowflake.ID
+}
+
+func (q *Queries) SetFrequencyColor(ctx context.Context, arg SetFrequencyColorParams) (Frequency, error) {
+ row := q.db.QueryRowContext(ctx, setFrequencyColor, arg.HexColor, arg.ID)
+ var i Frequency
+ err := row.Scan(
+ &i.ID,
+ &i.NetworkID,
+ &i.Name,
+ &i.HexColor,
+ &i.Perms,
+ &i.Position,
+ )
+ return i, err
+}
+
+const setFrequencyName = `-- name: SetFrequencyName :one
+UPDATE frequencies SET
+ name = ?
+WHERE id = ?
+RETURNING id, network_id, name, hex_color, perms, position
+`
+
+type SetFrequencyNameParams struct {
+ Name string
+ ID snowflake.ID
+}
+
+func (q *Queries) SetFrequencyName(ctx context.Context, arg SetFrequencyNameParams) (Frequency, error) {
+ row := q.db.QueryRowContext(ctx, setFrequencyName, arg.Name, arg.ID)
+ var i Frequency
+ err := row.Scan(
+ &i.ID,
+ &i.NetworkID,
+ &i.Name,
+ &i.HexColor,
+ &i.Perms,
+ &i.Position,
+ )
+ return i, err
+}
+
+const setFrequencyPerms = `-- name: SetFrequencyPerms :one
+UPDATE frequencies SET
+ perms = ?
+WHERE id = ?
+RETURNING id, network_id, name, hex_color, perms, position
+`
+
+type SetFrequencyPermsParams struct {
+ Perms int64
+ ID snowflake.ID
+}
+
+func (q *Queries) SetFrequencyPerms(ctx context.Context, arg SetFrequencyPermsParams) (Frequency, error) {
+ row := q.db.QueryRowContext(ctx, setFrequencyPerms, arg.Perms, arg.ID)
+ var i Frequency
+ err := row.Scan(
+ &i.ID,
+ &i.NetworkID,
+ &i.Name,
+ &i.HexColor,
+ &i.Perms,
+ &i.Position,
+ )
+ return i, err
+}
+
const swapFrequencies = `-- name: SwapFrequencies :exec
UPDATE frequencies SET
position = CASE