test.yml

# Ensures packages test correctly
name: Test Packages

on:
  push:

jobs:
  test:
    name: Test Packages
    runs-on: ubuntu-latest

    strategy:
      fail-fast: false
      matrix:
        mysql-version: [ 8.0, 8.4 ]

    steps:
      - uses: actions/checkout@v4
        with:
          persist-credentials: false

      - name: Start MySQL
        run: |
          docker run \
          --name zongji_test \
          -e MYSQL_ROOT_PASSWORD=my_password \
          -p 3306:3306 \
          -d mysql:${{ matrix.mysql-version }} \
          --server-id=1 \
          --log-bin=/var/lib/mysql/mysql-bin.log \
          --binlog-format=row

      - name: Setup NodeJS
        uses: actions/setup-node@v4
        with:
          node-version-file: '.nvmrc'

      - uses: pnpm/action-setup@v2
        name: Install pnpm
        with:
          version: 9
          run_install: false

      - name: Get pnpm store directory
        shell: bash
        run: |
          echo "STORE_PATH=$(pnpm store path --silent)" >> $GITHUB_ENV

      - uses: actions/cache@v3
        name: Setup pnpm cache
        with:
          path: ${{ env.STORE_PATH }}
          key: ${{ runner.os }}-pnpm-store-${{ hashFiles('**/pnpm-lock.yaml') }}
          restore-keys: |
            ${{ runner.os }}-pnpm-store-

      - name: Install dependencies
        run: pnpm install

      - name: Test
        run: pnpm test