3 INSERT INTO acq.invoice (id, receiver, provider, shipper, recv_method, inv_ident, closed_by)
4 VALUES (2222, 1, 1, 1, 'EDI', 'ABC123', 10);
6 INSERT INTO action.curbside (id, patron, org, notes)
7 VALUES (2222, 10, 1, 'Private info');
9 INSERT INTO actor.usr_message (usr, message, sending_lib)
10 VALUES (10, 'Private message', 1);
14 SELECT * FROM actor.usr_purge_data(10, 20);
17 (SELECT closed_by FROM acq.invoice WHERE id = 2222)::INTEGER,
19 'Acq invoice is now owned by dest_usr'
23 (SELECT notes FROM action.curbside WHERE id = 2222),
25 'Curbside notes are redacted'
29 ('SELECT id FROM actor.usr_message WHERE usr=10 AND NOT deleted'),
30 'User messages are marked as deleted'
33 SELECT * FROM finish();