From a9dde2289a34a037426b3bd9377f6a5b042626e7 Mon Sep 17 00:00:00 2001
From: EuAndreh <eu@euandre.org>
Date: Thu, 7 Nov 2024 14:39:55 -0300
Subject: tests/cracha.go: Include userByUUIDSQL() on dumpQueries() output

---
 tests/cracha.go   |  3 ++-
 tests/queries.sql | 54 ++++++++++++++++++++++++++++++++++++------------------
 2 files changed, 38 insertions(+), 19 deletions(-)

diff --git a/tests/cracha.go b/tests/cracha.go
index eda3fea..10b82d7 100644
--- a/tests/cracha.go
+++ b/tests/cracha.go
@@ -1016,10 +1016,11 @@ func test_runCommand() {
 func dumpQueries() {
 	queries := []struct{name string; fn func(string) queryT}{
 		{ "createTables", createTablesSQL },
-		{ "byEmail",           byEmailSQL },
 		{ "register",         registerSQL },
 		{ "sendToken",       sendTokenSQL },
 		{ "confirm",           confirmSQL },
+		{ "byEmail",           byEmailSQL },
+		{ "userByUUID",     userByUUIDSQL },
 		{ "login",               loginSQL },
 		{ "refresh",           refreshSQL },
 		{ "reset",               resetSQL },
diff --git a/tests/queries.sql b/tests/queries.sql
index 85cc5fb..e57a637 100644
--- a/tests/queries.sql
+++ b/tests/queries.sql
@@ -88,24 +88,6 @@
 
 --    read:
 
--- byEmail.sql:
---   write:
-
---    read:
-		SELECT id, timestamp, uuid, salt, pwhash, (
-			CASE WHEN EXISTS (
-				SELECT id FROM "cracha_user_confirmations"
-				WHERE user_id = (
-					SELECT id FROM  "cracha_users"
-					WHERE email = ?
-				)
-			) THEN 1
-			ELSE   0
-			END
-		) as confirmed
-		FROM "cracha_users" WHERE email = ?;
-	
-
 -- register.sql:
 --   write:
 		INSERT INTO "cracha_users" (uuid, email, salt, pwhash)
@@ -145,6 +127,42 @@
 		WHERE token = ?;
 	
 
+-- byEmail.sql:
+--   write:
+
+--    read:
+		SELECT id, timestamp, uuid, salt, pwhash, (
+			CASE WHEN EXISTS (
+				SELECT id FROM "cracha_user_confirmations"
+				WHERE user_id = (
+					SELECT id FROM  "cracha_users"
+					WHERE email = ?
+				)
+			) THEN 1
+			ELSE   0
+			END
+		) as confirmed
+		FROM "cracha_users" WHERE email = ?;
+	
+
+-- userByUUID.sql:
+--   write:
+
+--    read:
+		SELECT id, timestamp, email, salt, pwhash, (
+			CASE WHEN EXISTS (
+				SELECT id FROM "cracha_user_confirmations"
+				WHERE user_id = (
+					SELECT id FROM "cracha_users"
+					WHERE uuid = ?
+				)
+			) THEN 1
+			ELSE   0
+			END
+		) as confirmed
+		FROM "cracha_users" WHERE uuid = ?;
+	
+
 -- login.sql:
 --   write:
 
-- 
cgit v1.2.3