crates/secd/store/sqlite/sql/read_session.sql


1
2
3
4
5
6
7
8

select
        i.identity_public_id
        , s.created_at
        , s.expired_at
        , s.revoked_at
from session  s
join identity i using (identity_id)
where secret_hash = ?1;