app: working web prototype

1 files changed, 8 insertions, 1 deletions

diff --git a/sql/queries.sql b/sql/queries.sql
index 066781f..3cc8342 100644
--- a/sql/queries.sql
+++ b/sql/queries.sql
@@ -3,10 +3,17 @@
 -- Licence: EUPL-1.2
 
 
--- Fetch a user account by its username.
+-- Fetch a user account by its ID.
 --
 -- :name fetch_account
 -- :result :one-or-none
+select * from accounts where id = :user_id;
+
+
+-- Fetch a user account by its username.
+--
+-- :name fetch_account_username
+-- :result :one-or-none
 select * from accounts where username = :username;