main.yaml

# The "Core" job runs through all the tests which are not dialect specific.
# This includes tests which don't touch the database at all, and tests
# which touch some combination of duckdb,bigquery,postgres but do
# not need to be once times for each dialect.
name: Core

on:
  workflow_call:
    secrets:
      BIGQUERY_KEY:
        required: true

jobs:
  main:
    runs-on: ubuntu-latest

    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 18.x
        uses: actions/setup-node@v4
        with:
          node-version: 18.x
      - name: GCloud auth
        uses: 'google-github-actions/auth@v2'
        with:
          credentials_json: '${{ secrets.BIGQUERY_KEY }}'
      - name: npm install, build, and test
        run: |
          npm ci --loglevel error
          sh scripts/ci-test-sanity-check.sh
          npm run lint
          npm run build
          npm run build-duckdb-db
          echo CREATE EXTENSION tsm_system_rows\; | psql
          gunzip -c test/data/postgres/malloytest-postgres.sql.gz | psql
          npx jest --reporters jest-silent-reporter --reporters summary --config jest.core.config.ts --runInBand
        env:
          CI: true
          PGHOST: localhost
          PGPORT: 5432
          PGUSER: root
          PGPASSWORD: postgres