db-postgres.yaml

name: Postgres DB

on: [pull_request, workflow_call]

jobs:
  # Label of the container job
  test-postgres:
    runs-on: ubuntu-latest

    strategy:
      matrix:
        node-version: [18.x]

    services:
      postgres:
        image: postgres
        env:
          POSTGRES_USER: root
          POSTGRES_PASSWORD: postgres
        options: >-
          --health-cmd pg_isready
          --health-interval 10s
          --health-timeout 5s
          --health-retries 5
        ports:
          - 5432:5432

    steps:
      - uses: actions/checkout@v4
        with:
          submodules: 'true'
      - name: Use Node.js ${{ matrix.node-version }}
        uses: actions/setup-node@v4
        with:
          node-version: ${{ matrix.node-version }}
      - name: npm install, build, and test
        run: |
          npm ci --loglevel error
          npm run build
          echo CREATE EXTENSION tsm_system_rows\; | psql
          gunzip -c test/data/postgres/malloytest-postgres.sql.gz | psql
          npm run test-silent -- -- test packages/malloy-db-postgres
          export MALLOY_DATABASES=duckdb,postgres
          npm run build-duckdb-db
          npm run test-silent -- -- test/src/databases/multi-connection/multi_connection.spec.ts
        env:
          MALLOY_DATABASES: postgres
          PGHOST: localhost
          PGPORT: 5432
          PGUSER: root
          PGPASSWORD: postgres