sql-cli-test-and-build-workflow.yml

name: SQL CLI Test and Build

on:
  pull_request:
  push:
    branches-ignore:
      - 'dependabot/**'
    paths:
      - 'sql-cli/**'
      - '.github/workflows/sql-cli-test-and-build-workflow.yml'

jobs:
  build:
    runs-on: ubuntu-latest
    defaults:
      run:
        working-directory: sql-cli
    strategy:
      matrix:
        python-version: [3.8]
        opensearch-version: [ latest ]

    steps:
      - name: Checkout SQL CLI
        uses: actions/checkout@v3

      - name: Set up Python ${{ matrix.python-version }}
        uses: actions/setup-python@v4
        with:
          python-version: ${{ matrix.python-version }}

      - name: Install Python Dependencies
        run: |
          python -m pip install --upgrade pip
          pip install -r requirements-dev.txt
          pip install setuptools wheel
      
        # tests are designed to run against http://localhost:9200, so we have to disable/remove security plugin
      - name: Download and run OpenSearch
        run: |
          docker run -p 9200:9200 -e "discovery.type=single-node" -e "DISABLE_SECURITY_PLUGIN=true" --name test -d opensearchproject/opensearch:${{ matrix.opensearch-version }}

      - name: Wait for cluster to start
        uses: nick-fields/retry@v2
        with:
          timeout_seconds: 1
          max_attempts: 30
          command: curl -q localhost:9200

      - name: Run Tox Testing
        run: tox

      - name: Build Artifact
        run: python setup.py sdist bdist_wheel

      - name: Create Artifact Path
        run: |
          mkdir -p opensearchsql-builds
          cp -r ./dist/*.tar.gz ./dist/*.whl opensearchsql-builds/

      - name: Upload Artifact
        uses: actions/upload-artifact@v4
        with:
          name: opensearchsql
          path: sql-cli/opensearchsql-builds

      - name: Clean up container
        if: always()
        run: |
          docker container stop test
          docker container rm test