aboutsummaryrefslogtreecommitdiffhomepage
path: root/backend/query.sql
diff options
context:
space:
mode:
Diffstat (limited to 'backend/query.sql')
-rw-r--r--backend/query.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/backend/query.sql b/backend/query.sql
index e69de29..bdcd657 100644
--- a/backend/query.sql
+++ b/backend/query.sql
@@ -0,0 +1,4 @@
+-- name: GetUserAuthFromUsername :one
+SELECT * FROM users
+JOIN user_auths ON users.user_id = user_auths.user_id
+WHERE users.username = $1;