CREATE OR REPLACE FUNCTION backfill_exploitability(updateday date) RETURNS boolean
    LANGUAGE plpgsql
    AS $$
BEGIN
-- stored procudure to delete and replace one day of
-- product_adu, optionally only for a specific product
-- intended to be called by backfill_matviews

DELETE FROM exploitability_reports
WHERE report_date = updateday;

PERFORM update_exploitability(updateday, false);

RETURN TRUE;
END; $$;
