mimic-code/.github/workflows/ci.yml at 0b7287dfbf3ee14bc58e3d1922a4220c23db0eec · MIT-LCP/mimic-code · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
# Post-approval CI for the MIMIC demo builds and derived concepts.
#
# MIMIC-IV:
#   psql   ─▶ psql-concepts   ─┐
#                              ├─▶ equivalence
#   duckdb ─▶ duckdb-concepts ─┘
#
# MIMIC-III (the concepts workflows load the demo themselves):
#   psql-concepts-iii   ─┐
#                        ├─▶ equivalence-iii
#   duckdb-concepts-iii ─┘
#
# Runs on PR approval, or when a maintainer clicks "Run workflow" and picks the
# PR's head branch (Actions tab -> CI -> Run workflow).
# Downstream jobs inherit the gate via `needs`
name: CI

on:
  pull_request_review:
    types: [submitted]
  workflow_dispatch:

jobs:
  psql:
    if: github.event_name == 'workflow_dispatch' || github.event.review.state == 'approved'
    uses: ./.github/workflows/build-psql.yml

  duckdb:
    if: github.event_name == 'workflow_dispatch' || github.event.review.state == 'approved'
    uses: ./.github/workflows/build-duckdb.yml

  psql-concepts:
    needs: psql
    uses: ./.github/workflows/concepts-psql.yml

  duckdb-concepts:
    needs: duckdb
    uses: ./.github/workflows/concepts-duckdb.yml

  equivalence:
    needs: [psql-concepts, duckdb-concepts]
    uses: ./.github/workflows/equivalence.yml

  psql-concepts-iii:
    if: github.event_name == 'workflow_dispatch' || github.event.review.state == 'approved'
    uses: ./.github/workflows/concepts-iii-psql.yml

  duckdb-concepts-iii:
    if: github.event_name == 'workflow_dispatch' || github.event.review.state == 'approved'
    uses: ./.github/workflows/concepts-iii-duckdb.yml

  equivalence-iii:
    needs: [psql-concepts-iii, duckdb-concepts-iii]
    uses: ./.github/workflows/equivalence.yml
    with:
      schema: mimiciii_derived
      pg-artifact: psql-derived-iii
      pg-dump-file: derived-iii.sql
      duckdb-artifact: duckdb-db-iii
      db-file: mimic3.db