diff options
Diffstat (limited to 'internal/data')
| -rw-r--r-- | internal/data/users.sql.go | 23 |
1 files changed, 18 insertions, 5 deletions
diff --git a/internal/data/users.sql.go b/internal/data/users.sql.go index 1ca03ce..c92021d 100644 --- a/internal/data/users.sql.go +++ b/internal/data/users.sql.go @@ -16,30 +16,43 @@ const createUser = `-- name: CreateUser :one INSERT INTO users ( id, name, public_key ) VALUES ( - ?, 'User' || abs(random()) % 1000000, ? + ?, ?, ? ) RETURNING id, name, public_key ` type CreateUserParams struct { ID snowflake.ID + Name string PublicKey ed25519.PublicKey } func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) (User, error) { - row := q.db.QueryRowContext(ctx, createUser, arg.ID, arg.PublicKey) + row := q.db.QueryRowContext(ctx, createUser, arg.ID, arg.Name, arg.PublicKey) var i User err := row.Scan(&i.ID, &i.Name, &i.PublicKey) return i, err } -const getUser = `-- name: GetUser :one +const getUserById = `-- name: GetUserById :one SELECT id, name, public_key FROM users WHERE id = ? ` -func (q *Queries) GetUser(ctx context.Context, id snowflake.ID) (User, error) { - row := q.db.QueryRowContext(ctx, getUser, id) +func (q *Queries) GetUserById(ctx context.Context, id snowflake.ID) (User, error) { + row := q.db.QueryRowContext(ctx, getUserById, id) + var i User + err := row.Scan(&i.ID, &i.Name, &i.PublicKey) + return i, err +} + +const getUserByPublicKey = `-- name: GetUserByPublicKey :one +SELECT id, name, public_key FROM users +WHERE public_key = ? +` + +func (q *Queries) GetUserByPublicKey(ctx context.Context, publicKey ed25519.PublicKey) (User, error) { + row := q.db.QueryRowContext(ctx, getUserByPublicKey, publicKey) var i User err := row.Scan(&i.ID, &i.Name, &i.PublicKey) return i, err |