Admin Leaves Consortium

-- really quick just get rid of a single barcode


UPDATE actor.usr SET usrname = usrname || '-deactivated', barred = TRUE, deleted = TRUE, active = FALSE, expire_date =  NOW()
WHERE id in (select usr from actor.card where barcode = '');








create or replace function rogan.byebye(
    byebye          text
)
RETURNS VOID AS $$
DECLARE
    byebyeid int4;
BEGIN

select into byebyeid id from actor.usr where usrname = byebye;

UPDATE actor.usr SET usrname = usrname || '-deactivated', barred = TRUE, deleted = TRUE, active = FALSE, expire_date =  NOW() WHERE id = byebyeid;
UPDATE actor.usr SET barred = TRUE, deleted = TRUE WHERE id = byebyeid;

END
$$ LANGUAGE plpgsql;



drop function rogan.admin_exit(int4,int4);

CREATE OR REPLACE FUNCTION rogan.admin_exit(
        byebye                          INT4,
        hello                           INT4
)
RETURNS VOID AS $$

DECLARE
                bye_mail                TEXT;
                hello_mail              TEXT;

BEGIN


SELECT INTO bye_mail email FROM actor.usr au WHERE au.id = byebye;
SELECT INTO hello_mail email FROM actor.usr au WHERE au.id = hello;
UPDATE actor.usr SET usrname = usrname || '-deactivated', barred = TRUE, deleted = TRUE, active = FALSE, expire_date =  NOW() WHERE id = byebye;
UPDATE actor.usr SET barred = TRUE, deleted = TRUE WHERE id = byebye;
UPDATE reporter.TEMPLATE SET OWNER = hello WHERE OWNER = byebye;
UPDATE reporter.template_folder SET OWNER = hello WHERE OWNER = byebye;
UPDATE reporter.report SET OWNER = hello WHERE OWNER = byebye;
UPDATE reporter.report_folder SET OWNER = hello WHERE OWNER = byebye;
UPDATE reporter.output_folder SET OWNER = hello WHERE OWNER = byebye;
UPDATE reporter.schedule SET runner = hello WHERE runner = byebye;
UPDATE reporter.schedule SET email = hello_mail WHERE email = bye_mail;


END
$$ LANGUAGE plpgsql;

select * from rogan.admin_exit(1987486,1989815);