aboutsummaryrefslogtreecommitdiff
path: root/crates/secd/store/pg/sql
diff options
context:
space:
mode:
authorbenj <benj@rse8.com>2022-12-08 11:16:32 -0800
committerbenj <benj@rse8.com>2022-12-08 11:16:32 -0800
commit3a4de13528fc85dcbe6bc9055d97ba5cc87f5712 (patch)
treeea07f93e4de9d178f9dd786a0d772ee8b21cb0c3 /crates/secd/store/pg/sql
parent2c4eb2d311919ad9fb70738199ecf99bf20c9fce (diff)
downloadsecdiam-3a4de13528fc85dcbe6bc9055d97ba5cc87f5712.tar
secdiam-3a4de13528fc85dcbe6bc9055d97ba5cc87f5712.tar.gz
secdiam-3a4de13528fc85dcbe6bc9055d97ba5cc87f5712.tar.bz2
secdiam-3a4de13528fc85dcbe6bc9055d97ba5cc87f5712.tar.lz
secdiam-3a4de13528fc85dcbe6bc9055d97ba5cc87f5712.tar.xz
secdiam-3a4de13528fc85dcbe6bc9055d97ba5cc87f5712.tar.zst
secdiam-3a4de13528fc85dcbe6bc9055d97ba5cc87f5712.zip
update schema to `secd`
add dummy `dev` command to cli
Diffstat (limited to 'crates/secd/store/pg/sql')
-rw-r--r--crates/secd/store/pg/sql/find_email_validation.sql8
-rw-r--r--crates/secd/store/pg/sql/find_identity.sql6
-rw-r--r--crates/secd/store/pg/sql/find_identity_by_code.sql6
-rw-r--r--crates/secd/store/pg/sql/read_email_raw_id.sql2
-rw-r--r--crates/secd/store/pg/sql/read_identity_raw_id.sql2
-rw-r--r--crates/secd/store/pg/sql/read_session.sql4
-rw-r--r--crates/secd/store/pg/sql/write_email.sql6
-rw-r--r--crates/secd/store/pg/sql/write_email_validation.sql4
-rw-r--r--crates/secd/store/pg/sql/write_identity.sql2
-rw-r--r--crates/secd/store/pg/sql/write_session.sql4
10 files changed, 22 insertions, 22 deletions
diff --git a/crates/secd/store/pg/sql/find_email_validation.sql b/crates/secd/store/pg/sql/find_email_validation.sql
index d16d8e7..96a8cc4 100644
--- a/crates/secd/store/pg/sql/find_email_validation.sql
+++ b/crates/secd/store/pg/sql/find_email_validation.sql
@@ -8,10 +8,10 @@ select
, ev.created_at
, ev.expires_at
, ev.revoked_at
-from auth.email_validation ev
-join auth.identity_email ie using (identity_email_id)
-join auth.email e using (email_id)
-join auth.identity i using (identity_id)
+from secd.email_validation ev
+join secd.identity_email ie using (identity_email_id)
+join secd.email e using (email_id)
+join secd.identity i using (identity_id)
where (($1 is null) or (email_validation_public_id = $1))
and (($2 is null) or (code = $2));
--
diff --git a/crates/secd/store/pg/sql/find_identity.sql b/crates/secd/store/pg/sql/find_identity.sql
index 3a86a83..f4c9cbf 100644
--- a/crates/secd/store/pg/sql/find_identity.sql
+++ b/crates/secd/store/pg/sql/find_identity.sql
@@ -2,8 +2,8 @@ select
identity_public_id,
data,
i.created_at
-from auth.identity i
-join auth.identity_email ie using (identity_id)
-join auth.email e using (email_id)
+from secd.identity i
+join secd.identity_email ie using (identity_id)
+join secd.email e using (email_id)
where (($1 is null) or (i.identity_public_id = $1))
and (($2 is null) or (e.address = $2))
diff --git a/crates/secd/store/pg/sql/find_identity_by_code.sql b/crates/secd/store/pg/sql/find_identity_by_code.sql
index 9df6614..e016a0e 100644
--- a/crates/secd/store/pg/sql/find_identity_by_code.sql
+++ b/crates/secd/store/pg/sql/find_identity_by_code.sql
@@ -1,11 +1,11 @@
select identity_email_id
-from auth.email_validation
+from secd.email_validation
where email_validation_public_id = $1::uuid
--
select
identity_public_id
, data
, i.created_at
-from auth.identity i
-left join auth.identity_email ie using (identity_id)
+from secd.identity i
+left join secd.identity_email ie using (identity_id)
where ie.identity_email_id = $1;
diff --git a/crates/secd/store/pg/sql/read_email_raw_id.sql b/crates/secd/store/pg/sql/read_email_raw_id.sql
index f62331c..6604fb0 100644
--- a/crates/secd/store/pg/sql/read_email_raw_id.sql
+++ b/crates/secd/store/pg/sql/read_email_raw_id.sql
@@ -1 +1 @@
-select email_id from auth.email where address = $1
+select email_id from secd.email where address = $1
diff --git a/crates/secd/store/pg/sql/read_identity_raw_id.sql b/crates/secd/store/pg/sql/read_identity_raw_id.sql
index d550cc0..5b5d95c 100644
--- a/crates/secd/store/pg/sql/read_identity_raw_id.sql
+++ b/crates/secd/store/pg/sql/read_identity_raw_id.sql
@@ -1,2 +1,2 @@
-select identity_id from auth.identity where identity_public_id = $1;
+select identity_id from secd.identity where identity_public_id = $1;
--
diff --git a/crates/secd/store/pg/sql/read_session.sql b/crates/secd/store/pg/sql/read_session.sql
index febc1ab..e5fd26d 100644
--- a/crates/secd/store/pg/sql/read_session.sql
+++ b/crates/secd/store/pg/sql/read_session.sql
@@ -3,6 +3,6 @@ select
, s.created_at
, s.expires_at
, s.revoked_at
-from auth.session s
-join auth.identity i using (identity_id)
+from secd.session s
+join secd.identity i using (identity_id)
where secret_hash = $1;
diff --git a/crates/secd/store/pg/sql/write_email.sql b/crates/secd/store/pg/sql/write_email.sql
index 75fc494..cdcc971 100644
--- a/crates/secd/store/pg/sql/write_email.sql
+++ b/crates/secd/store/pg/sql/write_email.sql
@@ -1,11 +1,11 @@
-insert into auth.email (
+insert into secd.email (
address
) values (
$1
) on conflict (address) do nothing
returning email_id;
--
-select email_id from auth.email where address = $1;
+select email_id from secd.email where address = $1;
--
-insert into auth.identity_email (identity_id, email_id, created_at) values ($1, $2, $3);
+insert into secd.identity_email (identity_id, email_id, created_at) values ($1, $2, $3);
--
diff --git a/crates/secd/store/pg/sql/write_email_validation.sql b/crates/secd/store/pg/sql/write_email_validation.sql
index 98fc60e..d99a04c 100644
--- a/crates/secd/store/pg/sql/write_email_validation.sql
+++ b/crates/secd/store/pg/sql/write_email_validation.sql
@@ -1,4 +1,4 @@
-insert into auth.email_validation
+insert into secd.email_validation
(
email_validation_public_id
, identity_email_id
@@ -12,7 +12,7 @@ values (
$1
, (
select identity_email_id
- from auth.identity_email
+ from secd.identity_email
where identity_id = $2
and email_id = $3
)
diff --git a/crates/secd/store/pg/sql/write_identity.sql b/crates/secd/store/pg/sql/write_identity.sql
index eed1710..7d53ee1 100644
--- a/crates/secd/store/pg/sql/write_identity.sql
+++ b/crates/secd/store/pg/sql/write_identity.sql
@@ -1,4 +1,4 @@
-insert into auth.identity (
+insert into secd.identity (
identity_public_id,
data,
created_at
diff --git a/crates/secd/store/pg/sql/write_session.sql b/crates/secd/store/pg/sql/write_session.sql
index cd5892b..86cde55 100644
--- a/crates/secd/store/pg/sql/write_session.sql
+++ b/crates/secd/store/pg/sql/write_session.sql
@@ -1,4 +1,4 @@
-insert into auth.session (
+insert into secd.session (
identity_id
, secret_hash
, created_at
@@ -6,7 +6,7 @@ insert into auth.session (
, expires_at
, revoked_at
) values (
- (select identity_id from auth.identity where identity_public_id = $1)
+ (select identity_id from secd.identity where identity_public_id = $1)
, $2
, $3
, $4