crates/secd/store/pg/sql/find_session.sql


1
2
3
4
5
6
7
8
9
10
11

select distinct
       i.identity_public_id
       , s.created_at
       , s.expired_at
       , s.revoked_at
from secd.session  s
join secd.identity i using (identity_id)
where (($1::bytea is null) or (s.token_hash = $1))
and (($2::uuid is null) or (i.identity_public_id = $2))
and (($3::timestamptz is null) or (s.expired_at > $3))
and ((revoked_at is null) or ($4::timestamptz is null) or (s.revoked_at > $4));