crates/secd/store/sqlite/sql/find_identity_by_code.sql


1
2
3
4
5
6
7
8
9
10
11

select identity_email_validation_id
from email_validation
where email_validation_public_id = $1::uuid
--
select
        identity_public_id
        , data
        , i.created_at
from identity            i
left join identity_email ie using (identity_id)
where ie.identity_email_validation_id = ?1;