From c17319d6fd23a0c85668ec55ee2a3cea9995b6fe Mon Sep 17 00:00:00 2001 From: Kyren223 Date: Sat, 23 Nov 2024 22:43:41 +0200 Subject: Fixed typo and generated sqlc code --- internal/data/frequencies.sql.go | 98 +++++++++++++++++++++++++++++++++++++++- 1 file changed, 97 insertions(+), 1 deletion(-) (limited to 'internal/data/frequencies.sql.go') 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 -- cgit v1.3.1