ci_census.yml

name: "[CI] Census"

on:
  push:
    branches:
      - master
      - release/*
      - "*-stable"
  pull_request:

env:
  RUBY_VERSION: 3.3.4

jobs:
  test-report:
    runs-on: ubuntu-latest

    services:
      postgres:
        image: postgres:11
        ports: ["5432:5432"]
        options: >-
          --health-cmd pg_isready
          --health-interval 10s
          --health-timeout 5s
          --health-retries 5
        env:
          POSTGRES_PASSWORD: postgres
    env:
      DATABASE_USERNAME: postgres
      DATABASE_PASSWORD: postgres
      DATABASE_HOST: localhost
    steps:
      - uses: actions/checkout@v4
        with:
          fetch-depth: 1

      - uses: ruby/setup-ruby@master
        with:
          ruby-version: ${{ env.RUBY_VERSION }}

      - name: Recover Ruby dependency cache
        uses: actions/cache@v4
        with:
          path: ./vendor/bundle
          key: ${{ runner.OS }}-rubydeps-${{ hashFiles('Gemfile.lock') }}
          restore-keys: |
            ${{ runner.OS }}-rubydeps-${{ env.cache-name }}-
            ${{ runner.OS }}-rubydeps-
            ${{ runner.OS }}-

      - name: Set bundle local config vendor/bundle path
        run: bundle config set --local path 'vendor/bundle'

      - name: Install Ruby deps
        uses: nick-invision/retry@v3
        with:
          timeout_minutes: 10
          max_attempts: 3
          retry_on: error
          command: |
            cd decidim-census
            bundle install --jobs 4 --retry 3

      - name: Generate census test_app
        run: |
          cd decidim-census
          bundle exec rake test_app
          cd spec/decidim_dummy_app/
          bundle exec rails decidim_census:install:migrations

      - name: Ensure pgcrypto migration runs first
        run: |
          MIGRATION_FILE=$(find db/migrate -name '*enable_pgcrypto*' | head -1)
          if [ -n "$MIGRATION_FILE" ]; then
            DIR=$(dirname "$MIGRATION_FILE")
            DESCRIPTION=$(basename "$MIGRATION_FILE" | sed 's/^[0-9]*//')
            mv "$MIGRATION_FILE" "${DIR}/00000000000001${DESCRIPTION}"
            echo "Renamed to: ${DIR}/00000000000001${DESCRIPTION}"
          else
            echo "WARNING: pgcrypto migration not found!"
            exit 1
          fi

      - name: Run migrations
        run: |
          RAILS_ENV=test bundle exec rails db:migrate

      - name: Run RSpec
        uses: nick-invision/retry@v3
        with:
          timeout_minutes: 10
          max_attempts: 3
          retry_on: error
          command: |
            cd decidim-census
            CI=1 RAILS_ENV=test bundle exec rspec --backtrace