refactor everything with more abstraction and a nicer interface

1 files changed, 4 insertions, 9 deletions

diff --git a/crates/secd/store/sqlite/sql/write_session.sql b/crates/secd/store/sqlite/sql/write_session.sql
index 480af54..4679912 100644
--- a/crates/secd/store/sqlite/sql/write_session.sql
+++ b/crates/secd/store/sqlite/sql/write_session.sql
@@ -1,15 +1,10 @@
 insert into session (
        identity_id
-       , secret_hash
+       , token_hash
        , created_at
        , expired_at
        , revoked_at
 ) values (
-         (select identity_id from identity where identity_public_id = ?1)
-       , ?2
-       , ?3
-       , ?4
-       , ?5
-) on conflict (secret_hash) do update
-  set revoked_at = excluded.revoked_at;
---
+  (select identity_id from identity where identity_public_id = $1)
+  , $2, $3, $4, $5
+);