node.js.yml

name: Node.js CI

on:
  push:
    branches: ['master', 'dev']
  pull_request:
    branches: ['master', 'dev']

jobs:
  test:
    env:
          DATABASE_URL: mysql://prisma:prisma@localhost:3306/prisma
          JWT_SECRET: ${{ secrets.JWT_SECRET }}
          JWT_REFRESH_SECRET: ${{ secrets.JWT_REFRESH_SECRET }}
          EMAIL_PASSWORD: ${{ secrets.EMAIL_PASSWORD }}
          EMAIL_USERNAME: ${{ secrets.EMAIL_USERNAME }}
          TEST_EMAIL: ${{ secrets.TEST_EMAIL }}
    runs-on: ubuntu-latest

    strategy:
      matrix:
        node-version: [18.x]

    services:
      mysql:
        image: mysql:8.0
        env:
          MYSQL_USER: prisma
          MYSQL_PASSWORD: prisma
          MYSQL_DATABASE: prisma
          MYSQL_ROOT_PASSWORD: prisma
        ports:
          - 3306:3306
        options: --health-cmd="mysqladmin ping" --health-interval=10s --health-timeout=5s --health-retries=3

    steps:
      - uses: actions/checkout@v3
      - name: Use Node.js ${{ matrix.node-version }}
        uses: actions/setup-node@v3
        with:
          node-version: ${{ matrix.node-version }}
          cache: 'npm'
      - name: Install dependencies
        working-directory: backend
        run: npm ci
      - name: Build application
        working-directory: backend
        run: npm run build --if-present
      - name: Generate Prisma
        working-directory: backend
        run: npm run generate
      - name: Run database migrations
        working-directory: backend
        run: npx prisma migrate deploy
        env:
          DATABASE_URL: mysql://prisma:prisma@localhost:3306/prisma

      - name: Run tests
        working-directory: backend
        run: npm test