lib

Core libraries for Radroots
git clone https://radroots.dev/git/lib.git
Log | Files | Refs | README

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;