diff options
| -rw-r--r-- | tests/cracha.go | 3 | ||||
| -rw-r--r-- | 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: |