From eb92f823c31a5e702af7005231f0d6915aad3342 Mon Sep 17 00:00:00 2001
From: benj <benj@rse8.com>
Date: Mon, 24 Apr 2023 13:24:45 -0700
Subject: email templates, sendgrid, creds, and some experimental things

Started playing with namespace configs and integrating with zanzibar impls. Still lot's of experimenting and dead code going on.
---
 crates/secd/store/sqlite/sql/find_credential.sql  | 12 ++++++++++++
 crates/secd/store/sqlite/sql/write_credential.sql | 19 +++++++++++++++++++
 2 files changed, 31 insertions(+)
 create mode 100644 crates/secd/store/sqlite/sql/find_credential.sql
 create mode 100644 crates/secd/store/sqlite/sql/write_credential.sql

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

diff --git a/crates/secd/store/sqlite/sql/find_credential.sql b/crates/secd/store/sqlite/sql/find_credential.sql
new file mode 100644
index 0000000..9062914
--- /dev/null
+++ b/crates/secd/store/sqlite/sql/find_credential.sql
@@ -0,0 +1,12 @@
+select c.credential_public_id
+       , i.identity_public_id
+       , c.data
+       , c.created_at
+       , c.revoked_at
+       , c.deleted_at
+from credential c
+join identity   i using (identity_id)
+where (($1 is null) or (c.credential_public_id = $1))
+and (($2 is null) or (i.identity_public_id = $2))
+and (($3 is null) or (c.type = $3))
+and (($3 is null or $4 is null) or (c.data->$3->>'key' = $4))
diff --git a/crates/secd/store/sqlite/sql/write_credential.sql b/crates/secd/store/sqlite/sql/write_credential.sql
new file mode 100644
index 0000000..3319226
--- /dev/null
+++ b/crates/secd/store/sqlite/sql/write_credential.sql
@@ -0,0 +1,19 @@
+insert into credential (
+       credential_public_id
+       , identity_id
+       , partial_key
+       , type
+       , data
+       , created_at
+       , revoked_at
+       , deleted_at
+) values (
+       $1
+       , (select identity_id from identity where identity_public_id = $2)
+       , $3
+       , $4
+       , $5
+       , $6
+       , $7
+       , $8
+);
-- 
cgit v1.2.3