Introduce change password functionality

1 files changed, 39 insertions, 0 deletions

diff --git a/model/users.sql.go b/model/users.sql.go
index e63dacc..bd881b7 100644
--- a/model/users.sql.go
+++ b/model/users.sql.go
@@ -9,6 +9,24 @@ import (
 	"context"
 )
 
+const getPwdById = `-- name: GetPwdById :one
+ SELECT pwd
+   FROM users
+ WHERE id = $1
+`
+
+// GetPwdById
+//
+//	SELECT pwd
+//	  FROM users
+//	WHERE id = $1
+func (q *Queries) GetPwdById(ctx context.Context, id int32) (string, error) {
+	row := q.db.QueryRow(ctx, getPwdById, id)
+	var pwd string
+	err := row.Scan(&pwd)
+	return pwd, err
+}
+
 const getUserById = `-- name: GetUserById :one
 SELECT id, name, pwd, description
   FROM users
@@ -88,3 +106,24 @@ func (q *Queries) GetUsers(ctx context.Context) ([]User, error) {
 	}
 	return items, nil
 }
+
+const updatePwd = `-- name: UpdatePwd :exec
+ UPDATE users
+    SET pwd = $1
+  WHERE id = $2
+`
+
+type UpdatePwdParams struct {
+	Pwd string
+	ID  int32
+}
+
+// UpdatePwd
+//
+//	UPDATE users
+//	   SET pwd = $1
+//	 WHERE id = $2
+func (q *Queries) UpdatePwd(ctx context.Context, arg UpdatePwdParams) error {
+	_, err := q.db.Exec(ctx, updatePwd, arg.Pwd, arg.ID)
+	return err
+}