sql-test-and-build-workflow.yml

name: SQL Java CI

on:
  pull_request:
  push:
    branches-ignore:
      - 'dependabot/**'
    paths:
      - '**/*.java'
      - '**/*.g4'
      - '!sql-jdbc/**'
      - '**gradle*'
      - '**lombok*'
      - 'integ-test/**'
      - '**/*.jar'
      - '**/*.pom'
      - '.github/workflows/sql-test-and-build-workflow.yml'

jobs:
  build:
    strategy:
      # Run all jobs
      fail-fast: false
      matrix:
        entry:
          - { os: ubuntu-latest, java: 11 }
          - { os: windows-latest, java: 11, os_build_args: -x doctest  -PbuildPlatform=windows }
          - { os: macos-latest, java: 11}
          - { os: ubuntu-latest, java: 17 }
          - { os: windows-latest, java: 17, os_build_args: -x doctest -PbuildPlatform=windows }
          - { os: macos-latest, java: 17 }
    runs-on: ${{ matrix.entry.os }}

    steps:
    - uses: actions/checkout@v3

    - name: Set up JDK ${{ matrix.java }}
      uses: actions/setup-java@v3
      with:
        distribution: 'temurin'
        java-version: ${{ matrix.entry.java }}

    - name: Build with Gradle
      run: ./gradlew --continue build ${{ matrix.entry.os_build_args }}

    - name: Run backward compatibility tests
      if: ${{ matrix.entry.os == 'ubuntu-latest' }}
      run: ./scripts/bwctest.sh

    - name: Create Artifact Path
      run: |
        mkdir -p opensearch-sql-builds
        cp -r ./plugin/build/distributions/*.zip opensearch-sql-builds/

    # This step uses the codecov-action Github action: https://github.com/codecov/codecov-action
    - name: Upload SQL Coverage Report
      if: ${{ always() && matrix.entry.os == 'ubuntu-latest' }}
      uses: codecov/codecov-action@v3
      continue-on-error: true
      with:
        flags: sql-engine
        token: ${{ secrets.CODECOV_TOKEN }}

    - name: Upload Artifacts
      uses: actions/upload-artifact@v2
      continue-on-error: true
      with:
        name: opensearch-sql-${{ matrix.entry.os }}-${{ matrix.entry.java }}
        path: opensearch-sql-builds

    - name: Upload test reports
      if: ${{ always() && matrix.entry.os == 'ubuntu-latest' }}
      uses: actions/upload-artifact@v2
      continue-on-error: true
      with:
        name: test-reports-${{ matrix.entry.os }}-${{ matrix.entry.java }}
        path: |
          sql/build/reports/**
          ppl/build/reports/**
          core/build/reports/**
          common/build/reports/**
          opensearch/build/reports/**
          integ-test/build/reports/**
          protocol/build/reports/**
          legacy/build/reports/**
          plugin/build/reports/**
          doctest/build/testclusters/docTestCluster-0/logs/*
          integ-test/build/testclusters/*/logs/*