golang.org/x/build@v0.0.0-20240506185731-218518f32b70/internal/relui/migrations/20211005180646_update_workflows_add_finished.up.sql (about)

     1  -- Copyright 2021 The Go Authors. All rights reserved.
     2  -- Use of this source code is governed by a BSD-style
     3  -- license that can be found in the LICENSE file.
     4  
     5  BEGIN;
     6  
     7  ALTER TABLE workflows
     8      ADD COLUMN finished bool NOT NULL DEFAULT false;
     9  
    10  CREATE INDEX workflows_finished_ix ON workflows (finished) WHERE finished = false;
    11  
    12  ALTER TABLE workflows
    13      ADD COLUMN output jsonb NOT NULL DEFAULT jsonb_build_object();
    14  
    15  ALTER TABLE workflows
    16      ADD COLUMN error text NOT NULL DEFAULT '';
    17  
    18  UPDATE workflows
    19  SET finished = true
    20  WHERE workflows.id NOT IN (
    21      SELECT DISTINCT tasks.workflow_id
    22      FROM tasks
    23      WHERE finished = false
    24  );
    25  
    26  COMMIT;