Janady13/missionmatch / .github/workflows/ci.yml

Source identity

Field	Recorded value
Source type	GitHub source
Original record	Janady13/missionmatch / .github/workflows/ci.yml
Date	Not specified in source
Repository	Janady13/missionmatch
Revision	720d47fae476b0d38477ae4401697d372b1ea2bc
Branch	feature/opportunity-to-outcome
Path or archive member	.github/workflows/ci.yml
Original SHA-256	eb7dd78587a5f6c953cab8d31ae902550aaee6dc28e88d66ec8ca374f006c5d2
Git blob SHA	0f5f8c8e416453908a924b8d134b97de28e56858
Reading-copy SHA-256	eb7dd78587a5f6c953cab8d31ae902550aaee6dc28e88d66ec8ca374f006c5d2

Original source ↗

Every recorded occurrence

These 2 records contain identical original source bytes. Their paths and revisions remain part of the archive.

Original record	Branch or archive	Revision / identifier	Original location
Janady13/missionmatch / .github/workflows/ci.yml	feature/opportunity-to-outcome	720d47fae476b0d38477ae4401697d372b1ea2bc	Open original
Janady13/missionmatch / .github/workflows/ci.yml	feature/aioe-upgrade	2178e7298d0e5d9af83afa12402fd587f0ba6ed8	Open original

Recovered source transcript

Download complete source text ↓49 lines · 2.0 KB

# The required merge gate. Marking this workflow required on the default branch (repository
# settings, branch protection) is the operator step that makes red unmergeable; the workflow itself
# runs exactly the same make build-test-gates a developer runs locally, so CI and local can never
# disagree about what green means. Migrations are additionally proven reversible up, down, up
# against a disposable Postgres 16 service container.
name: build-test-gates

on:
  pull_request:
  push:
    branches: [master, main]

jobs:
  build-test-gates:
    runs-on: ubuntu-latest
    services:
      postgres:
        image: pgvector/pgvector:pg16
        env:
          POSTGRES_PASSWORD: ci
          POSTGRES_DB: mm_ci
        ports: ['5432:5432']
        options: >-
          --health-cmd "pg_isready -U postgres"
          --health-interval 5s
          --health-timeout 5s
          --health-retries 10
    steps:
      - uses: actions/checkout@v4
      - uses: actions/setup-go@v5
        with:
          go-version-file: go.mod
      - uses: actions/setup-node@v4
        with:
          node-version: 22
          cache: npm
          cache-dependency-path: frontend/package-lock.json
      - name: build-test-gates
        run: make build-test-gates
      - name: migrations up, down one, up (reversibility gate)
        env:
          PGPASSWORD: ci
        run: |
          psql -h 127.0.0.1 -U postgres -d mm_ci -c "CREATE ROLE missionmatch_app NOLOGIN NOBYPASSRLS" || true
          psql -h 127.0.0.1 -U postgres -d mm_ci -c "CREATE ROLE missionmatch_compliance NOLOGIN NOBYPASSRLS" || true
          go run github.com/pressly/goose/v3/cmd/goose@latest -dir db/migrations postgres "postgres://postgres:ci@127.0.0.1:5432/mm_ci?sslmode=disable" up
          go run github.com/pressly/goose/v3/cmd/goose@latest -dir db/migrations postgres "postgres://postgres:ci@127.0.0.1:5432/mm_ci?sslmode=disable" down
          go run github.com/pressly/goose/v3/cmd/goose@latest -dir db/migrations postgres "postgres://postgres:ci@127.0.0.1:5432/mm_ci?sslmode=disable" up