8 -- shuffle event_times for randomness.
9 INSERT INTO actor.usr_activity (usr, etype, event_time) VALUES
10 (:usr_one, 1, NOW() - '2 days'::INTERVAL),
11 (:usr_one, 1, NOW() - '1 days'::INTERVAL),
13 (:usr_one, 2, NOW() - '2 days'::INTERVAL),
14 (:usr_one, 2, NOW() - '1 days'::INTERVAL),
16 (:usr_two, 1, NOW() - '2 days'::INTERVAL),
17 (:usr_two, 1, NOW() - '1 days'::INTERVAL),
21 SELECT actor.purge_usr_activity_by_type(1);
22 SELECT actor.purge_usr_activity_by_type(2);
25 (SELECT COUNT(*) FROM actor.usr_activity
26 WHERE usr = :usr_one AND etype = 1),
28 'Confirm only one event row exists'
32 (SELECT DATE(event_time) FROM actor.usr_activity
33 WHERE usr = :usr_one AND etype = 1),
35 'Confirm most recent event is retained'
39 (SELECT COUNT(*) FROM actor.usr_activity
40 WHERE usr = :usr_one AND etype = 2),
42 'Confirm only one event row exists'
46 (SELECT DATE(event_time) FROM actor.usr_activity
47 WHERE usr = :usr_one AND etype = 2),
49 'Confirm most recent event is retained'
53 (SELECT COUNT(*) FROM actor.usr_activity
54 WHERE usr = :usr_two AND etype = 1),
56 'Confirm only one event row exists'
60 (SELECT DATE(event_time) FROM actor.usr_activity
61 WHERE usr = :usr_two AND etype = 1),
63 'Confirm most recent event is retained'
66 SELECT * FROM finish();