delete_source_task.sql

-- FUNCTION: code_src.delete_source_task(numeric)

-- DROP FUNCTION code_src.delete_source_task(numeric);

CREATE OR REPLACE FUNCTION code_src.delete_source_task(
	taskid numeric)
    RETURNS text
    LANGUAGE 'plpgsql'

    COST 100
    VOLATILE 
	SECURITY DEFINER
AS $BODY$
DECLARE   
  o_status text;
  o_message text;  
  o_json text;  
BEGIN
/*
  Summary:
    Delete a task for source.
  Testing:
    SELECT delete_source_task(1000000059);
*/
    o_status = 'OK';
    o_message = '';
	SELECT delete_task(taskid) INTO o_json; 
	SELECT delete_transaction_by_task_id(taskid) INTO o_json;		
    
    SELECT row_to_json(c) INTO o_json
	FROM
	(
	  SELECT o_status status, 
	       o_message message
	) c;
	RETURN o_json;
EXCEPTION 
  WHEN OTHERS THEN
    o_status = SQLSTATE;
	o_message = SQLERRM;	
	SELECT row_to_json(c) INTO o_json
	FROM
	(
	  SELECT o_status status, 
	       o_message message
	) c;
    RETURN o_json;
END;  
$BODY$;

ALTER FUNCTION code_src.delete_source_task(numeric) OWNER TO network;
GRANT EXECUTE ON FUNCTION code_src.delete_source_task(numeric) TO anchorto_run