1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
|
insert into email_validation
(
email_validation_public_id
, email_id
, code
, is_oauth_derived
, created_at
, validated_at
, expired_at
)
values (
?1
, ?2
, ?3
, ?4
, ?5
, ?6
, ?7
) on conflict (email_validation_public_id) do update
set validated_at = excluded.validated_at
, expired_at = excluded.expired_at;
--
insert into identity_email_validation (
identity_id
, email_validation_id
, revoked_at
, deleted_at
) values (
(
select identity_id
from identity
where identity_public_id = ?1
)
, (
select email_validation_id
from email_validation
where email_validation_public_id = ?2
)
, ?3
, ?4
) on conflict (identity_id, email_validation_id) do update
set revoked_at = excluded.revoked_at
, deleted_at = excluded.deleted_at;
|
