diff options
| author | Kyren223 <Kyren223@proton.me> | 2024-11-23 22:43:41 +0200 |
|---|---|---|
| committer | Kyren223 <Kyren223@proton.me> | 2024-11-23 22:43:41 +0200 |
| commit | c17319d6fd23a0c85668ec55ee2a3cea9995b6fe (patch) | |
| tree | b8aa323fb2b0bb694696fc6455d10b68242e87e1 /internal/data/frequencies.sql.go | |
| parent | 91bbd29dbe2738459cef83b5204844a2c136a84f (diff) | |
Fixed typo and generated sqlc code
Diffstat (limited to 'internal/data/frequencies.sql.go')
| -rw-r--r-- | internal/data/frequencies.sql.go | 98 |
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 |
