Files
windmill/backend/migrations/20250707120256_trigger_retries_and_error_handling.up.sql
HugoCasa 328ef605ad feat: triggers error handler and retry (#6138)
* feat: http triggers error handling and retries

* feat: handle sync http triggers

* feat: triggers retry and error handling

* feat: frontend and preprocessor

* fix build

* minimum allow dead code

* check workspace tags in schedules

* fix flow preprocesor + hub urls

* update ee ref

* nit

* nit

* final nits

* schedule UI nits

* migrate workspace settings to svelte 5
2025-07-11 18:55:23 +02:00

47 lines
1.7 KiB
SQL

-- Add error handler and retry fields to http_trigger
ALTER TABLE http_trigger
ADD COLUMN error_handler_path VARCHAR(255) NULL,
ADD COLUMN error_handler_args JSONB NULL,
ADD COLUMN retry JSONB NULL;
-- Add error handler and retry fields to nats_trigger
ALTER TABLE nats_trigger
ADD COLUMN error_handler_path VARCHAR(255) NULL,
ADD COLUMN error_handler_args JSONB NULL,
ADD COLUMN retry JSONB NULL;
-- Add error handler and retry fields to postgres_trigger
ALTER TABLE postgres_trigger
ADD COLUMN error_handler_path VARCHAR(255) NULL,
ADD COLUMN error_handler_args JSONB NULL,
ADD COLUMN retry JSONB NULL;
-- Add error handler and retry fields to mqtt_trigger
ALTER TABLE mqtt_trigger
ADD COLUMN error_handler_path VARCHAR(255) NULL,
ADD COLUMN error_handler_args JSONB NULL,
ADD COLUMN retry JSONB NULL;
-- Add error handler and retry fields to kafka_trigger
ALTER TABLE kafka_trigger
ADD COLUMN error_handler_path VARCHAR(255) NULL,
ADD COLUMN error_handler_args JSONB NULL,
ADD COLUMN retry JSONB NULL;
-- Add error handler and retry fields to websocket_trigger
ALTER TABLE websocket_trigger
ADD COLUMN error_handler_path VARCHAR(255) NULL,
ADD COLUMN error_handler_args JSONB NULL,
ADD COLUMN retry JSONB NULL;
-- Add error handler and retry fields to gcp_trigger
ALTER TABLE gcp_trigger
ADD COLUMN error_handler_path VARCHAR(255) NULL,
ADD COLUMN error_handler_args JSONB NULL,
ADD COLUMN retry JSONB NULL;
-- Add error handler and retry fields to sqs_trigger
ALTER TABLE sqs_trigger
ADD COLUMN error_handler_path VARCHAR(255) NULL,
ADD COLUMN error_handler_args JSONB NULL,
ADD COLUMN retry JSONB NULL;