crates/secd/store/pg/sql/write_session.sql


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

insert into secd.session (
       identity_id
       , secret_hash
       , created_at
       , expired_at
       , revoked_at
) values (
         (select identity_id from secd.identity where identity_public_id = $1)
       , $2
       , $3
       , $4
       , $5
) on conflict (secret_hash) do update
  set revoked_at = excluded.revoked_at;
--