Packages
eventstore
1.4.2
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.
Current section
Files
Jump to
Current section
Files
lib/event_store/sql/statements/insert_link_events.sql.eex
WITH
stream AS (
UPDATE <%= schema %>.streams
SET stream_version = stream_version + $2::bigint
WHERE stream_id = $1::bigint
RETURNING stream_version - $2 as initial_stream_version
),
linked_events (index, event_id) AS (
VALUES
<%= for i <- 0..(number_of_events - 1) do %>
<%= unless i == 0 do %>,<% end %>
($<%= i * 2 + 3 %>::bigint, $<%= i * 2 + 4 %>::uuid)
<% end %>
)
INSERT INTO <%= schema %>.stream_events
(
stream_id,
stream_version,
event_id,
original_stream_id,
original_stream_version
)
SELECT
$1,
stream.initial_stream_version + linked_events.index,
linked_events.event_id,
original_stream_events.original_stream_id,
original_stream_events.stream_version
FROM linked_events
CROSS JOIN stream
INNER JOIN <%= schema %>.stream_events as original_stream_events
ON original_stream_events.event_id = linked_events.event_id
AND original_stream_events.stream_id = original_stream_events.original_stream_id;