mirror of
https://github.com/zitadel/zitadel.git
synced 2025-08-11 23:17:33 +00:00
21167a4bba
# Which Problems Are Solved The execution handler projection handles all events to check if an execution has to be provided to the worker to execute. In this logic all events would be processed from the beginning which is not necessary. # How the Problems Are Solved Add the current state to the execution handler projection, to avoid processing all existing events. # Additional Changes Add custom configuration to the default, so that the transactions are limited to some events. # Additional Context None
22 lines
1.1 KiB
SQL
22 lines
1.1 KiB
SQL
INSERT INTO projections.current_states AS cs ( instance_id
|
|
, projection_name
|
|
, last_updated
|
|
, sequence
|
|
, event_date
|
|
, position
|
|
, filter_offset)
|
|
SELECT instance_id
|
|
, 'projections.execution_handler'
|
|
, now()
|
|
, $1
|
|
, $2
|
|
, $3
|
|
, 0
|
|
FROM eventstore.events2 AS e
|
|
WHERE aggregate_type = 'instance'
|
|
AND event_type = 'instance.added'
|
|
ON CONFLICT (instance_id, projection_name) DO UPDATE SET last_updated = EXCLUDED.last_updated,
|
|
sequence = EXCLUDED.sequence,
|
|
event_date = EXCLUDED.event_date,
|
|
position = EXCLUDED.position,
|
|
filter_offset = EXCLUDED.filter_offset; |