github.com/nais/knorten@v0.0.0-20240104110906-55926958e361/pkg/database/migrations/019_move_egress_to_team_values.sql (about)

     1  -- +goose Up
     2  ALTER TABLE teams DROP COLUMN "restrict_airflow_egress";
     3  
     4  -- Set up default values for each Airflow already installed
     5  insert into chart_team_values (team_id, "key", "value", chart_type)
     6  select distinct team_id, 'restrictEgress,omit', 'false', 'airflow'::chart_type from chart_team_values where chart_type = 'airflow';
     7  
     8  -- +goose Down
     9  ALTER TABLE teams ADD COLUMN "restrict_airflow_egress" BOOLEAN NOT NULL DEFAULT false;
    10  
    11  -- Remove restrictEgress,omit key for each installed Airflow
    12  delete from chart_team_values where "key" = 'restrictEgress,omit' and chart_type = 'airflow';