Page History
...
Code Block | ||
---|---|---|
| ||
-- returns eperson_id or NULL if no such eperson was found CREATE OR REPLACE FUNCTION ds5_eperson_delete_by_eperson_id(int) RETURNS int AS $$ #print_strict_params on DECLARE eperson_id_to_delete int; BEGIN DELETE FROM metadatavalue WHERE resource_type_id = 7 AND resource_id = $1; DELETE FROM subscription WHERE eperson_id = $1; DELETE FROM epersongroup2eperson WHERE eperson_id = $1; DELETE FROM eperson WHERE eperson_id = $1; RETURN $1; END $$ LANGUAGE plpgsql; -- returns eperson_id or NULL if no such eperson was found CREATE OR REPLACE FUNCTION ds5_eperson_delete_by_email(character varying) RETURNS int AS $$ #print_strict_params on BEGIN RETURN ds5_eperson_delete_by_eperson_id((SELECT eperson_id FROM eperson WHERE email = $1)); END $$ LANGUAGE plpgsql; SELECT ds5_eperson_delete_by_email('johndoe@example.com'); DROP FUNCTION ds5_eperson_delete_by_eperson_id(int); DROP FUNCTION ds5_eperson_delete_by_email(character varying); |
...
Overview
Content Tools