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_session.sql | 11 +++++++++++
 1 file changed, 11 insertions(+)
 create mode 100644 crates/secd/store/sqlite/sql/find_session.sql

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

diff --git a/crates/secd/store/sqlite/sql/find_session.sql b/crates/secd/store/sqlite/sql/find_session.sql
new file mode 100644
index 0000000..31640dd
--- /dev/null
+++ b/crates/secd/store/sqlite/sql/find_session.sql
@@ -0,0 +1,11 @@
+select distinct
+       i.identity_public_id
+       , s.created_at
+       , s.expired_at
+       , s.revoked_at
+from session  s
+join identity i using (identity_id)
+where (($1 is null) or (s.token_hash = $1))
+and (($2 is null) or (i.identity_public_id = $2))
+and (($3 is null) or (s.expired_at > $3))
+and ((revoked_at is null) or ($4 is null) or (s.revoked_at > $4));
-- 
cgit v1.2.3

