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

---
 .../store/sqlite/sql/write_address_validation.sql  | 26 ++++++++++++++++++++++
 1 file changed, 26 insertions(+)
 create mode 100644 crates/secd/store/sqlite/sql/write_address_validation.sql

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

diff --git a/crates/secd/store/sqlite/sql/write_address_validation.sql b/crates/secd/store/sqlite/sql/write_address_validation.sql
new file mode 100644
index 0000000..67ce916
--- /dev/null
+++ b/crates/secd/store/sqlite/sql/write_address_validation.sql
@@ -0,0 +1,26 @@
+insert into address_validation (
+       address_validation_public_id
+       , identity_id
+       , address_id
+       , "method"
+       , token_hash
+       , code_hash
+       , attempts
+       , created_at
+       , expires_at
+       , revoked_at
+       , validated_at
+) values(
+  $1
+  , (
+        select identity_id from identity where identity_public_id = $2
+    )
+  , (
+        select address_id from address where address_public_id = $3
+    )
+  , $4, $5, $6, $7, $8, $9, $10, $11
+) on conflict (address_validation_public_id) do update
+  set identity_id = excluded.identity_id
+      , attempts = excluded.attempts
+      , revoked_at = excluded.revoked_at
+      , validated_at = excluded.validated_at;
-- 
cgit v1.2.3

