OXYGENHUB
◆ v0.9.20 oxygenhub / crates / hub / migrations / 0102_runner_waves.sql
441 B · SQL · last changed Runner updates in waves: a later wave takes a version once the waves before it proved it; an error stops it (refs andymccall/oxygenflow#84) 8 days ago source blame history raw
1
-- Runner updates in waves (oxygenflow#84): the runner build each job ran
2
-- on, from its claim, to count the jobs that prove a version; and the wave
3
-- a test group's runners take a version in (none: after every wave).
4
ALTER TABLE flow_jobs ADD COLUMN runner_version TEXT NOT NULL DEFAULT '';
5
ALTER TABLE runner_groups ADD COLUMN wave INTEGER;
6
CREATE INDEX flow_jobs_runner_version ON flow_jobs (runner_version) WHERE runner_version <> '';