grahamc/hydra2 - Change H4KMCXGUC5MA7AZUN33GQQWCP66UP7T6IYGJB6HY5AUSKVS32YZAC

Use triggers for all notifications on Builds table changes

Created by Eelco Dolstra on July 8, 2015

H4KMCXGUC5MA7AZUN33GQQWCP66UP7T6IYGJB6HY5AUSKVS32YZAC

Dependencies

In channels

main

Change contents

Deletion in src/lib/Hydra/Helper/Nix.pm at line 436 [6.436]
B:BD[4.1589] → [5.1204:1262]
```
        $db->storage->dbh->do("notify builds_cancelled");
```
Deletion in src/lib/Hydra/Helper/Nix.pm at line 472 [6.436]
B:BD[7.3072] → [8.1743:1802]
```
        $db->storage->dbh->do("notify builds_restarted");
```
Deletion in src/script/hydra-evaluator at line 237 [10.1319]
B:BD[9.51] → [2.0:59]
```
            $db->storage->dbh->do("notify builds_added");
```

Insertion in src/sql/hydra.sql at line 206 [10.1]

[3.135]


create function notifyBuildsAdded() returns trigger as 'begin notify builds_added; return null; end;' language plpgsql;
create trigger BuildsAdded after insert on Builds execute procedure notifyBuildsAdded();

Replacement in src/sql/hydra.sql at line 210 [10.1]

B:BD[3.136] → [3.136:285]

create function notifyBuildDeleted() returns trigger as $$
  begin
    execute 'notify builds_deleted';
    return null;
  end;
$$ language plpgsql;

[3.136]

[3.285]

create function notifyBuildsDeleted() returns trigger as 'begin notify builds_deleted; return null; end;' language plpgsql;
create trigger BuildsDeleted after delete on Builds execute procedure notifyBuildsDeleted();
create function notifyBuildRestarted() returns trigger as 'begin notify builds_restarted; return null; end;' language plpgsql;
create trigger BuildRestarted after update on Builds for each row
  when (old.finished = 1 and new.finished = 0) execute procedure notifyBuildRestarted();

Replacement in src/sql/hydra.sql at line 217 [10.1]

B:BD[3.286] → [3.286:394]

create trigger BuildDeleted after delete on Builds
  for each row
  execute procedure notifyBuildDeleted();

[3.286]

[3.394]

create function notifyBuildCancelled() returns trigger as 'begin notify builds_cancelled; return null; end;' language plpgsql;
create trigger BuildCancelled after update on Builds for each row
  when (old.finished = 0 and new.finished = 1 and new.buildStatus = 4) execute procedure notifyBuildCancelled();

Replacement in src/sql/upgrade-35.sql at line 1 [3.404]

B:BD[3.404] → [3.405:554]

create function notifyBuildDeleted() returns trigger as $$
  begin
    execute 'notify builds_deleted';
    return null;
  end;
$$ language plpgsql;

[3.404]

[3.554]

create function notifyBuildsAdded() returns trigger as 'begin notify builds_added; return null; end;' language plpgsql;
create trigger BuildsAdded after insert on Builds execute procedure notifyBuildsAdded();
create function notifyBuildsDeleted() returns trigger as 'begin notify builds_deleted; return null; end;' language plpgsql;
create trigger BuildsDeleted after delete on Builds execute procedure notifyBuildsDeleted();
create function notifyBuildRestarted() returns trigger as 'begin notify builds_restarted; return null; end;' language plpgsql;
create trigger BuildRestarted after update on Builds for each row
  when (old.finished = 1 and new.finished = 0) execute procedure notifyBuildRestarted();

Replacement in src/sql/upgrade-35.sql at line 11 [3.404]

B:BD[3.555] → [3.555:663]

create trigger BuildDeleted after delete on Builds
  for each row
  execute procedure notifyBuildDeleted();

[3.555]

create function notifyBuildCancelled() returns trigger as 'begin notify builds_cancelled; return null; end;' language plpgsql;
create trigger BuildCancelled after update on Builds for each row
  when (old.finished = 0 and new.finished = 1 and new.buildStatus = 4) execute procedure notifyBuildCancelled();