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


1
2
3
4
5
6
7
8
9
10
11

insert into secd.session (
       identity_id
       , token_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 (token_hash) do update
  set revoked_at = excluded.revoked_at;