github.com/pf-qiu/concourse/v6@v6.7.3-0.20201207032516-1f455d73275f/atc/db/migration/migrations/1530823998_create_teams_trigger.up.sql (about)

     1  BEGIN;
     2    CREATE OR REPLACE FUNCTION on_team_delete() RETURNS TRIGGER AS $$
     3    BEGIN
     4            EXECUTE format('DROP TABLE IF EXISTS team_build_events_%s', OLD.id);
     5            RETURN NULL;
     6    END;
     7    $$ LANGUAGE plpgsql;
     8  
     9  
    10    CREATE OR REPLACE FUNCTION on_team_insert() RETURNS TRIGGER AS $$
    11    BEGIN
    12            EXECUTE format('CREATE TABLE IF NOT EXISTS team_build_events_%s () INHERITS (build_events)', NEW.id);
    13            RETURN NULL;
    14    END;
    15    $$ LANGUAGE plpgsql;
    16  
    17  
    18    DROP TRIGGER IF EXISTS team_build_events_delete_trigger ON teams;
    19    CREATE TRIGGER team_build_events_delete_trigger AFTER DELETE on teams FOR EACH ROW EXECUTE PROCEDURE on_team_delete();
    20  
    21    DROP TRIGGER IF EXISTS team_build_events_insert_trigger ON teams;
    22    CREATE TRIGGER team_build_events_insert_trigger AFTER INSERT on teams FOR EACH ROW EXECUTE PROCEDURE on_team_insert();
    23  COMMIT;
    24