build.yml

name: 🏗️ Build @last9/openapm

on:
  push:
    branches:
      - '*'

jobs:
  release:
    name: Build
    runs-on: ubuntu-latest
    steps:
      - uses: actions/setup-node@v2
        with:
          node-version: 18.19.0
      - uses: shogo82148/actions-setup-mysql@v1.23.0
        with:
          mysql-version: '8.0'

      - uses: harmon758/postgresql-action@v1
        with:
          postgresql version: '14'
          postgresql user: 'tester'
          postgresql password: 'password'

      - name: Test MySQL Connection
        run: mysql -h localhost -u root -e 'SELECT version()'

      - name: Test Postgres Connection
        run: psql

      - name: Create test DB
        run: mysql -h localhost -u root -e 'CREATE DATABASE test_db'

      - name: Create test DB
        run: psql -h localhost -U tester -c 'CREATE DATABASE testdb'

      - name: 🛎 Checkout
        uses: actions/checkout@v3

      - name: 🧶 Get NPM cache
        uses: actions/cache@v3
        id: cache-npm
        env:
          cache-name: cache-node-modules
        with:
          path: ~/.npm
          key: ${{ runner.os }}-build-${{ env.cache-name }}-${{
            hashFiles('**/package-lock.json') }}
          restore-keys: |
            ${{ runner.os }}-build-${{ env.cache-name }}-
            ${{ runner.os }}-build-
            ${{ runner.os }}-

      - name: 📦 Install dependencies
        run: npm install --frozen-lockfile

      - name: 📦 Install Playwright Deps
        run: npx playwright install --with-deps

      - name: 🧪 Test
        env:
          DB_HOST: localhost
          DB_PORT: 3306
          DB_NAME: test_db
          DB_USER: root
          CI: true
        run: npm run test

      - name: 👷 Build
        run: npm run build