crates/secd/store/sqlite/sql/find_identity.sql


1
2
3
4
5
6
7
8
9
10
11

select
        identity_public_id
        , data
        , i.created_at
        , i.deleted_at
from identity       i
join identity_email_validation iev using (identity_id)
join email_validation          ev  using (email_validation_id)
join email                     e   using (email_id)
where ((?1 is null) or (i.identity_public_id = ?1))
and   ((?2 is null) or (e.address = ?2));