crates/secd/store/sqlite/sql/write_session.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

insert into session (
       identity_id
       , secret_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;
--