Advertisement
Guest User

Untitled

a guest
Jan 17th, 2020
121
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Erlang 1.22 KB | None | 0 0
  1. 16:19:49.675 [info] cargo_wrk process_message Topic <<"order/save">>
  2. 16:19:49.675 [info] cargo_wrk process_message Pid <0.1840.0>
  3. Fired "verif_deallocation"
  4. Time {{2020,1,17},{16,20,0}}
  5. Fired "test"
  6. Time {{2020,1,17},{16,20,0}}
  7. test chronium!
  8. is_on_verification
  9. 300
  10.  
  11.                 WITH last_users_records0 AS (
  12.                         SELECT parent_id, max(date) AS date
  13.                         FROM verifications
  14.                         GROUP BY parent_id
  15.         ),
  16.                 last_users_records AS (
  17.                         SELECT l.parent_id, l.date, v.parent_table, v.verified_until as verif_until
  18.                         FROM last_users_records0 as l
  19.                         INNER JOIN verifications as v
  20.                         ON l.parent_id = v.parent_id AND l.date = v.date
  21.                         WHERE
  22.                         v.status = $1
  23.                 )
  24.                 SELECT
  25.                         v.parent_id as id,
  26.                         v.parent_table as object_type,
  27.                         v.verif_until
  28.                 FROM last_users_records AS v
  29.                 WHERE date_trunc('minute', v.date + interval '1 second' * $2) <= date_trunc('minute',now() at time zone 'utc 0')
  30.         ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement