0018_event_mutation_epoch.up.sql (1739B)
1 ALTER TABLE radroots_runtime_source_generations 2 ADD COLUMN mutation_epoch INTEGER NOT NULL DEFAULT 0 CHECK (mutation_epoch >= 0); 3 4 UPDATE radroots_runtime_source_generations 5 SET mutation_epoch = 1 6 WHERE EXISTS ( 7 SELECT 1 FROM radroots_runtime_events 8 WHERE source_generation = generation 9 ); 10 11 CREATE TRIGGER radroots_runtime_source_generations_mutation_guard 12 BEFORE UPDATE OF mutation_epoch ON radroots_runtime_source_generations 13 WHEN NEW.mutation_epoch < OLD.mutation_epoch 14 BEGIN 15 SELECT RAISE(ABORT, 'runtime source mutation epoch cannot regress'); 16 END; 17 18 CREATE TRIGGER radroots_runtime_events_mutation_insert 19 AFTER INSERT ON radroots_runtime_events 20 BEGIN 21 SELECT CASE WHEN ( 22 SELECT mutation_epoch FROM radroots_runtime_source_generations 23 WHERE generation = NEW.source_generation 24 ) = 9223372036854775807 25 THEN RAISE(ABORT, 'runtime event mutation epoch overflow') END; 26 UPDATE radroots_runtime_source_generations 27 SET mutation_epoch = mutation_epoch + 1 28 WHERE generation = NEW.source_generation; 29 END; 30 31 CREATE TRIGGER radroots_runtime_events_mutation_update 32 AFTER UPDATE OF admission_stage, admitted_contract_id, admitted_registry_version 33 ON radroots_runtime_events 34 WHEN NEW.admission_stage IS NOT OLD.admission_stage 35 OR NEW.admitted_contract_id IS NOT OLD.admitted_contract_id 36 OR NEW.admitted_registry_version IS NOT OLD.admitted_registry_version 37 BEGIN 38 SELECT CASE WHEN ( 39 SELECT mutation_epoch FROM radroots_runtime_source_generations 40 WHERE generation = NEW.source_generation 41 ) = 9223372036854775807 42 THEN RAISE(ABORT, 'runtime event mutation epoch overflow') END; 43 UPDATE radroots_runtime_source_generations 44 SET mutation_epoch = mutation_epoch + 1 45 WHERE generation = NEW.source_generation; 46 END;