rails_mysql_ci.yml

name: rails_mysql CI

on:
  pull_request:
  push:
    branches: [ main ]
    paths: [ rails_mysql/** ]
  workflow_dispatch:

env:
  rails_app_root: rails_mysql
  DB_HOST: mysql

defaults:
  run:
    working-directory: rails_mysql

jobs:
  scan_ruby:
    runs-on: ubuntu-latest

    steps:
      - name: Checkout code
        uses: actions/checkout@v4

      - name: Set up Ruby
        uses: ruby/setup-ruby@v1
        with:
          working-directory: ${{ env.rails_app_root }}
          bundler-cache: true

      - name: Scan for common Rails security vulnerabilities using static analysis
        run: ./bin/brakeman --no-pager

  lint:
    runs-on: ubuntu-latest

    steps:
      - name: Checkout code
        uses: actions/checkout@v4

      - name: Set up Ruby
        uses: ruby/setup-ruby@v1
        with:
          working-directory: ${{ env.rails_app_root }}
          bundler-cache: true

      - name: Lint code for consistent style
        run: ./bin/rubocop -f github

  rspec:
    runs-on: ubuntu-latest
    permissions:
      contents: read

    services:
      mysql:
        image: mysql:latest
        env:
          MYSQL_ALLOW_EMPTY_PASSWORD: yes
        ports:
          - "3306:3306"

    steps:
      - name: Checkout the repo
        uses: actions/checkout@v4

      - name: Set up Ruby
        uses: ruby/setup-ruby@v1
        with:
          working-directory: ${{ env.rails_app_root }}
          bundler-cache: true

      - name: Create database
        run: |
          sleep 3 # Waiting to make sure MySQL is up and running
          ./bin/rails db:reset

      - name: Run RSpec
        run: ./bin/rspec --format json --out tmp/rspec_results.json --format progress

      - name: Generate RSpec report
        uses: SonicGarden/rspec-report-action@v5
        with:
          json-path: ${{ env.rails_app_root }}/tmp/rspec_results.json
        if: always()