s2.yml

name: SingleStore tests
on: [push]

permissions:  # added using https://github.com/step-security/secure-workflows
  contents: read

jobs:
  Test-Singlestore-integration:
    runs-on: ubuntu-latest

    environment: singlestore

    services:
      singlestoredb:
        image: ghcr.io/singlestore-labs/singlestoredb-dev
        ports:
          - 3306:3306
          - 8080:8080
          - 9000:9000
        env:
          ROOT_PASSWORD: test
          SINGLESTORE_LICENSE: ${{ secrets.SINGLESTORE_LICENSE }}

    steps:
      - name: Harden Runner
        uses: step-security/harden-runner@0d381219ddf674d61a7572ddd19d7941e271515c
        with:
          egress-policy: audit # TODO: change to 'egress-policy: block' after couple of runs

      - name: sanity check using mysql client
        run: |
          mysql -u root -ptest -e "CREATE DATABASE libschematest partitions 2" -h 127.0.0.1
          mysql -u root -ptest -e "set global snapshots_to_keep = 1" -h 127.0.0.1
          mysql -u root -ptest -e "set global minimal_disk_space = 10" -h 127.0.0.1
          mysql -u root -ptest -e "set global log_file_size_partitions = 1048576" -h 127.0.0.1
          mysql -u root -ptest -e "set global log_file_size_ref_dbs = 1048576" -h 127.0.0.1

      - name: Check out repository code
        uses: actions/checkout@692973e3d937129bcbf40652eb9f2f61becf3332

      - name: Set up Go
        uses: actions/setup-go@0a12ed9d6a96ab950c8f026ed9f722fe0da7ef32
        with:
          go-version: 1.20

      - name: Build
        run: go build -v ./...

      - name: Test
        env:
          LIBSCHEMA_SINGLESTORE_TEST_DSN: "root:test@tcp(127.0.0.1:3306)/libschematest?tls=false"
        run: go test ./lsmysql/... ./lssinglestore/... -v

      - name: Run Coverage
        env:
          LIBSCHEMA_SINGLESTORE_TEST_DSN: "root:test@tcp(127.0.0.1:3306)/libschematest?tls=false"
        run: go test -coverprofile=coverage.txt -covermode=atomic -coverpkg=github.com/muir/libschema/... ./lsmysql/... ./lssinglestore/...  

      - name: Upload coverage to Codecov
        uses: codecov/codecov-action@v4
        with:
          token: ${{ secrets.CODECOV_TOKEN }}
          version: "v0.1.15"
          verbose: true
          fail_ci_if_error: true
          flags: singlestore_tests