18F/openFEC

SET search_path = real_efile, pg_catalog;

--
-- Name: rollback_real_time_filings(bigint); Type: FUNCTION; Schema: real_efile; Owner: fec
--

CREATE FUNCTION rollback_real_time_filings(p_repid bigint) RETURNS pg_catalog.text
    LANGUAGE plpgsql
    AS $$
declare 
 cur_del CURSOR FOR
    SELECT  table_name
       FROM information_schema.tables
       WHERE  table_schema='real_efile';
v_table text;
begin
   OPEN cur_del;  
 loop
  fetch cur_del into v_table;
   EXIT WHEN NOT FOUND;
  -- RAISE NOTICE 'delete from % where repid= %',v_table,p_repid;
    execute 'delete from real_efile.'||v_table ||' where repid='||p_repid;
 end loop;
close cur_del; 
return 'SUCCESS';
end
$$;

ALTER FUNCTION real_efile.rollback_real_time_filings(p_repid bigint) OWNER TO fec;