ci.yml

name: Continuous Integration

on:
  pull_request: { branches: [ "main", "csh", "lap" ] }
  push:
    branches: [ "main", "csh", "lap" ]
    tags: [ "*" ]

jobs:
  tests:
    name: Tests
    runs-on: ubuntu-20.04
    env:
      RAILS_ENV: test
      TERM: dumb-color
    services:
      postgres:
        image: postgres:11
        env:
          POSTGRES_USER: seek
          POSTGRES_DB: seek_test
          POSTGRES_PASSWORD: test
        ports:
          - 5432:5432
        options: --health-cmd pg_isready --health-interval 10s --health-timeout 5s --health-retries 5
      mysql:
        image: mysql:5.7
        env:
          MYSQL_USER: seek
          MYSQL_PASSWORD: test
          MYSQL_DATABASE: seek_test
          MYSQL_ROOT_PASSWORD: test
        ports:
          - 33306:3306
        options: --health-cmd="mysqladmin ping" --health-interval=10s --health-timeout=5s --health-retries=3
      virtuoso:
        image: tenforce/virtuoso
        env:
          DBA_PASSWORD: tester
          SPARQL_UPDATE: true
          DEFAULT_GRAPH: http://www.example.com/my-graph
        ports:
          - 8890:8890
          - 1111:1111
    strategy:
      fail-fast: false
      matrix:
        database:
          - mysql
        suite:
          - rails test test/unit
          - rails test test/functional
          - rails test test/integration
          - rspec spec
          # - rake teaspoon
          - rake assets:precompile
          - rake db:setup
          - rake db:migrate
          - rake seek:upgrade
        include:
          - database: postgres
            suite: rails test test/unit
          - database: sqlite3
            suite: rails test test/unit
    steps:
      - name: Install system dependencies
        run: sudo apt update && sudo apt install -y graphicsmagick libcurl4-gnutls-dev libreoffice poppler-utils
        # build-essential git imagemagick libgmp-dev \
        #    libmagick++-dev libmysqlclient-dev libpq-dev libreadline-dev libreoffice libssl-dev \
        #    libxml++2.6-dev libxslt1-dev nodejs openjdk-8-jdk openssh-server poppler-utils zip
      - name: Checkout code
        uses: actions/checkout@v2
      - name: Setup Java
        uses: actions/setup-java@v1
        with:
          java-version: '11' # The JDK version to make available on the path.
      - name: Setup Ruby
        uses: ruby/setup-ruby@v1
        with:
          bundler-cache: true # runs 'bundle install' and caches installed gems automatically
      - name: Setup Python
        uses: actions/setup-python@v2
        with:
          python-version: '3.6'
      - name: Cache pip
        uses: actions/cache@v2
        with:
          # This path is specific to Ubuntu
          path: ~/.cache/pip
          # Look to see if there is a cache hit for the corresponding requirements file
          key: ${{ runner.os }}-pip-${{ hashFiles('requirements.txt') }}
          restore-keys: |
            ${{ runner.os }}-pip-
            ${{ runner.os }}-
      - name: Install Python dependencies
        run: pip install -r requirements.txt
      - name: Create test database
        run: |
          cp test/config/database.github.${{ matrix.database }}.yml config/database.yml
          bundle exec rake db:create
      - name: Set MySQL char set and collation
        if: matrix.database == 'mysql'
        run: echo -e "ALTER DATABASE seek_test CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;\n" | bundle exec rails dbconsole -p
      - name: Checkout previous schema
        if: github.event_name == 'push' && matrix.suite == 'rake db:migrate' && github.event.before != '0000000000000000000000000000000000000000'
        run: |
          git fetch origin ${{ github.event.before }}
          git checkout ${{ github.event.before }} -- db/schema.rb
      - name: Load test database schema
        run: bundle exec rake db:schema:load
      - name: Seed database
        if: matrix.suite == 'rake seek:upgrade'
        run: bundle exec rake db:seed
      - name: Virtuoso config
        if: matrix.suite == 'rails test test/integration'
        run: cp test/config/virtuoso_test_settings.yml config/virtuoso_settings.yml
      - name: Run tests
        run: bundle exec ${{ matrix.suite }}

  build:
    needs: [ "tests" ]
    name: "Build Image"
    runs-on: ubuntu-latest
    steps:
      - name: Checkout
        uses: actions/checkout@v2
      - id: generate-image-tag
        name: Generate Image Tag
        env:
          ref_name: "${{ github.ref_name }}"
          head_ref: "${{ github.head_ref }}"
        run: |
          ref_name="${head_ref:-${ref_name/main/latest}}"
          echo "::set-output name=imageTag::${ref_name#v}"
      - name: Login to Container Registry
        uses: docker/login-action@v1
        with:
          registry: ghcr.io
          username: ${{ github.actor }}
          password: ${{ secrets.GITHUB_TOKEN }}
      - name: Build and Push
        uses: docker/build-push-action@v2
        with:
          context: .
          push: true
          tags: ghcr.io/${{ github.repository }}:${{ steps.generate-image-tag.outputs.imageTag }}