From ff3140a4089819489130a0908178a63eff20f708 Mon Sep 17 00:00:00 2001 From: Kyren223 Date: Sun, 3 Nov 2024 19:33:30 +0200 Subject: feat: add username and timestamp to messages --- query/users.sql | 8 ++++++-- 1 file changed, 6 insertions(+), 2 deletions(-) (limited to 'query') diff --git a/query/users.sql b/query/users.sql index 28ca8b9..4d6275c 100644 --- a/query/users.sql +++ b/query/users.sql @@ -1,12 +1,16 @@ --- name: GetUser :one +-- name: GetUserById :one SELECT * FROM users WHERE id = ?; +-- name: GetUserByPublicKey :one +SELECT * FROM users +WHERE public_key = ?; + -- name: CreateUser :one INSERT INTO users ( id, name, public_key ) VALUES ( - ?, 'User' || abs(random()) % 1000000, ? + ?, ?, ? ) RETURNING *; -- cgit v1.3.1