44 lines
1.6 KiB
SQL
44 lines
1.6 KiB
SQL
-- +goose Up
|
|
-- Provenance and the group key are fixed when an event arrives. own marks an
|
|
-- event that is the echo of a delivery Archie sent, linked to the run that
|
|
-- sent it; such an event never forms or joins a group. The key is the source,
|
|
-- the type and the source's key fields.
|
|
ALTER TABLE events.events
|
|
ADD COLUMN own boolean NOT NULL DEFAULT false,
|
|
ADD COLUMN origin_run_id uuid,
|
|
ADD COLUMN group_key text,
|
|
ADD COLUMN group_filter jsonb;
|
|
|
|
-- A source's key fields are dotted paths into its events' fields; an object
|
|
-- stands for its scalar members. Empty means the default list.
|
|
ALTER TABLE events.sources ADD COLUMN key_fields jsonb NOT NULL DEFAULT '[]';
|
|
|
|
-- A group is the events no trigger matched that share a key. Its source, type
|
|
-- and filter are the trigger it proposes.
|
|
CREATE TABLE events.groups (
|
|
id uuid PRIMARY KEY,
|
|
org_id text NOT NULL,
|
|
key text NOT NULL,
|
|
source text NOT NULL,
|
|
event_type text NOT NULL,
|
|
filter jsonb NOT NULL,
|
|
count bigint NOT NULL,
|
|
first_seen timestamptz NOT NULL,
|
|
last_seen timestamptz NOT NULL,
|
|
UNIQUE (org_id, key)
|
|
);
|
|
|
|
-- The deliveries module recognises an echo by the id its channel gave the
|
|
-- message.
|
|
CREATE INDEX messages_external ON deliveries.messages (org_id, channel, external_id) WHERE external_id IS NOT NULL;
|
|
|
|
-- +goose Down
|
|
DROP INDEX deliveries.messages_external;
|
|
DROP TABLE events.groups;
|
|
ALTER TABLE events.sources DROP COLUMN key_fields;
|
|
ALTER TABLE events.events
|
|
DROP COLUMN group_filter,
|
|
DROP COLUMN group_key,
|
|
DROP COLUMN origin_run_id,
|
|
DROP COLUMN own;
|