aonestar.public

Parameters

Name	Type	Mode
adate	date	IN
task_index	integer	IN
task_	jsonb	IN
status	text	IN
message	text	IN (DEFAULT NULL)
task_start	timestamp without time zone	IN (DEFAULT NULL)
task_end	timestamp without time zone	IN (DEFAULT NULL)
finished	boolean	IN (DEFAULT false)

Definition

DECLARE 
    _event_data json;
    _task jsonb;
    _status TEXT;
    _start_time timestamptz;
    _finish_time timestamptz;
    execute_time numeric(8,3) = 0;
BEGIN
    SELECT e.status, e.start_time --, e.tasks->$2 
    FROM endday e
    WHERE endday_date = $1
    INTO _status, _start_time; --, _task;

_task = task;

    _finish_time = iif(finished, clock_timestamp(), null);
    _status = iif(finished, iif(status = 'error', 'E', 'S'), 'P');

   -- IF _task->>'status' = 'processing' then
    execute_time = EXTRACT(EPOCH FROM (task_end -task_start )); 
   -- RAISE NOTICE '% - %, %', extract(epoch FROM task_end)::TEXT, extract(epoch FROM task_start)::TEXT, execute_time::text;
   -- END IF;

    _task = jsonb_build_object(
        'id', _task->>'id',
        'name', _task->>'name',
        'type', _task->>'type',
        'status', status,
        'message', message,
        'execute_time', execute_time --to_char(execute_time/1000.000/60, '999.999') 
    ); 

    UPDATE endday 
    SET status = _status,
        finish_time = _finish_time,
        tasks = jsonb_set(tasks, ARRAY[task_index::text], _task) 
    WHERE endday_date = adate;
    commit;

    IF status IN ('error','success') THEN 
        _event_data = jsonb_build_object(
            'date', adate,
            'status', iif(finished, iif(status = 'error', 'error', 'success'), 'processing'),
            'start_time', _start_time,
            'finish_time', _finish_time,
            'task', _task
        );

        perform sp_enqueue_realtime('*', null, 'endday_progress', _event_data);
        RAISE NOTICE 'endday: notify % - %', _task->>'id', status::text; 
    END IF;
END;

sp_endday_update_task

Parameters

Definition