QuickandGitHub
f9bb94a299
* fix(autoscan): bind sources by plugin id * fix(autoscan): skip overlapping source polls
37 lines
950 B
SQL
37 lines
950 B
SQL
-- +goose Up
|
|
-- +goose StatementBegin
|
|
ALTER TABLE public.autoscan_events
|
|
DROP CONSTRAINT IF EXISTS autoscan_events_status_check;
|
|
|
|
ALTER TABLE public.autoscan_events
|
|
ADD CONSTRAINT autoscan_events_status_check
|
|
CHECK (status = ANY (ARRAY[
|
|
'running'::text,
|
|
'success'::text,
|
|
'error'::text,
|
|
'unresolved'::text
|
|
]));
|
|
-- +goose StatementEnd
|
|
|
|
-- +goose Down
|
|
-- +goose StatementBegin
|
|
UPDATE public.autoscan_events
|
|
SET status = 'error',
|
|
error_message = CASE
|
|
WHEN error_message = '' THEN 'poll started but did not finish'
|
|
ELSE error_message
|
|
END
|
|
WHERE status = 'running';
|
|
|
|
ALTER TABLE public.autoscan_events
|
|
DROP CONSTRAINT IF EXISTS autoscan_events_status_check;
|
|
|
|
ALTER TABLE public.autoscan_events
|
|
ADD CONSTRAINT autoscan_events_status_check
|
|
CHECK (status = ANY (ARRAY[
|
|
'success'::text,
|
|
'error'::text,
|
|
'unresolved'::text
|
|
]));
|
|
-- +goose StatementEnd
|