Packages

eventstore

1.4.1
1.4.8 1.4.7 1.4.6 1.4.4 1.4.3 1.4.2 1.4.1 1.4.0 1.3.2 1.3.1 1.3.0 1.2.3 1.2.2 1.2.1 1.2.0 1.1.0 1.0.3 1.0.2 1.0.1 1.0.0 1.0.0-rc.0 0.17.0 0.16.2 0.16.1 0.16.0 0.15.1 0.15.0 0.14.0 0.14.0-rc.0 0.13.2 0.13.1 0.13.0 0.12.1 0.12.0 0.11.0 0.11.0-rc.0 0.10.1 0.10.0 0.9.0 0.8.1 0.8.0 0.7.4 0.7.3 0.7.2 0.7.1 0.7.0 0.6.2 0.6.1 0.6.0 0.5.2 0.5.1 0.5.0 0.4.3 0.4.2 0.4.1 0.4.0 0.3.0 0.2.1 0.2.0 0.1.0 0.0.5 0.0.4 0.0.3 0.0.2 0.0.1

Event store using PostgreSQL for persistence.

HexDocs

Current section

Files

Jump to
Readme
65 Versions
5 Dependencies
8 Dependants
Files
Activity
eventstore priv event_store migrations v1.3.0.sql
Raw

priv/event_store/migrations/v1.3.0.sql 

DO $migration$

BEGIN

  CREATE OR REPLACE FUNCTION notify_events()

    RETURNS trigger AS $func$

  DECLARE

    channel text;

    payload text;

  BEGIN

      -- Payload text contains:

      --  * `stream_uuid`

      --  * `stream_id`

      --  * first `stream_version`

      --  * last `stream_version`

      -- Each separated by a comma (e.g. 'stream-12345,1,1,5')



      channel := TG_TABLE_SCHEMA || '.events';

      payload := NEW.stream_uuid || ',' || NEW.stream_id || ',' || COALESCE(OLD.stream_version, 0) + 1 || ',' || NEW.stream_version;



      -- Notify events to listeners

      PERFORM pg_notify(channel, payload);



      RETURN NULL;

  END;

  $func$ LANGUAGE plpgsql;



  DROP TRIGGER event_notification ON streams;



  CREATE TRIGGER event_notification

  AFTER INSERT OR UPDATE ON streams

  FOR EACH ROW EXECUTE PROCEDURE notify_events();



  -- Record schema migration

  INSERT INTO schema_migrations (major_version, minor_version, patch_version) VALUES (1, 3, 0);

END;

$migration$ LANGUAGE plpgsql;