crates/secd/store/pg/sql/find_address_validation.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

select av.address_validation_public_id
       , i.identity_public_id
       , a.address_public_id
       , a.type
       , a.value
       , a.created_at
       , av.method
       , av.token_hash
       , av.code_hash
       , av.attempts
       , av.created_at
       , av.expires_at
       , av.revoked_at
       , av.validated_at
from secd.address_validation av
join secd.address            a  using(address_id)
left join secd.identity      i  using(identity_id)
where (($1::uuid is null) or (address_validation_public_id = $1));