From c2268c285648ef02ece04de0d9df0813c6d70ff8 Mon Sep 17 00:00:00 2001
From: benj <benj@rse8.com>
Date: Sat, 24 Dec 2022 00:43:38 -0800
Subject: refactor everything with more abstraction and a nicer interface

---
 crates/secd/store/sqlite/sql/find_email_validation.sql | 18 ------------------
 1 file changed, 18 deletions(-)
 delete mode 100644 crates/secd/store/sqlite/sql/find_email_validation.sql

(limited to 'crates/secd/store/sqlite/sql/find_email_validation.sql')

diff --git a/crates/secd/store/sqlite/sql/find_email_validation.sql b/crates/secd/store/sqlite/sql/find_email_validation.sql
deleted file mode 100644
index d7f311c..0000000
--- a/crates/secd/store/sqlite/sql/find_email_validation.sql
+++ /dev/null
@@ -1,18 +0,0 @@
-select
-        ev.email_validation_public_id
-        , i.identity_public_id
-        , e.address
-        , ev.code
-        , ev.is_oauth_derived
-        , ev.created_at
-        , ev.expired_at
-        , ev.validated_at
-        , iev.revoked_at
-        , iev.deleted_at
-from email_validation               ev
-join email                          e   using (email_id)
-left join identity_email_validation iev using (email_validation_id)
-left join identity                  i   using (identity_id)
-where ((?1 is null) or (email_validation_public_id = ?1))
-and   ((?2 is null) or (code = ?2));
---
-- 
cgit v1.2.3

