Files

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;