From 5a5c09282416d131ec4a77bc9cf854fa0f29ae12 Mon Sep 17 00:00:00 2001 From: Kyren223 Date: Mon, 20 Jan 2025 17:32:31 +0200 Subject: Implemented user settings both client side and server side --- internal/data/users.sql.go | 35 ++++++++++++++++++++++++++++++++++- 1 file changed, 34 insertions(+), 1 deletion(-) (limited to 'internal/data') diff --git a/internal/data/users.sql.go b/internal/data/users.sql.go index db28ca7..2e20cec 100644 --- a/internal/data/users.sql.go +++ b/internal/data/users.sql.go @@ -73,7 +73,7 @@ func (q *Queries) GetUserById(ctx context.Context, id snowflake.ID) (User, error const getUserByPublicKey = `-- name: GetUserByPublicKey :one SELECT id, name, public_key, description, is_public_dm, is_deleted FROM users -WHERE public_key = ? AND is_deleted = false +WHERE public_key = ? ` func (q *Queries) GetUserByPublicKey(ctx context.Context, publicKey ed25519.PublicKey) (User, error) { @@ -126,3 +126,36 @@ func (q *Queries) SetUserData(ctx context.Context, arg SetUserDataParams) (UserD err := row.Scan(&i.UserID, &i.Data) return i, err } + +const updateUser = `-- name: UpdateUser :one +UPDATE users SET + name = ?, description = ?, is_public_dm = ? +WHERE id = ? +RETURNING id, name, public_key, description, is_public_dm, is_deleted +` + +type UpdateUserParams struct { + Name string + Description string + IsPublicDM bool + ID snowflake.ID +} + +func (q *Queries) UpdateUser(ctx context.Context, arg UpdateUserParams) (User, error) { + row := q.db.QueryRowContext(ctx, updateUser, + arg.Name, + arg.Description, + arg.IsPublicDM, + arg.ID, + ) + var i User + err := row.Scan( + &i.ID, + &i.Name, + &i.PublicKey, + &i.Description, + &i.IsPublicDM, + &i.IsDeleted, + ) + return i, err +} -- cgit v1.3.1