authen
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_gen_activate_url
Parameters
Name
Type
Mode
grant_type
text
IN
user_id
integer
IN
prop_ids
int4[]
IN
Definition
declare reset_token text; encrypt_pass_policy text; pass_policy_data text; url text; base_url text; P record; BEGIN reset_token := fn_gen_password_reset_token(grant_type, user_id, prop_ids); raise notice E'token:\n%', reset_token; base_url := coalesce(fn_get_config(prop_ids[1], 'APPLICATION_URL', null), 'https://fromas.cloud'); select * into P from sp_get_password_policy($2); pass_policy_data := P.description||'|'||P.regex||'|'||P.min_length::text||'|'||P.max_length::text; encrypt_pass_policy := base32_encode(convert_to(pass_policy_data, 'UTF8')); url := base_url||'/activate?uid='||reset_token||'&p='||encrypt_pass_policy; raise notice E'URL:\n%', url; return url; -- return base_url||'/activate/?uid='||urlencode(encrypt_key)||'&p='||urlencode(encrypt_pass_policy); END;