integration.yml

name: Integration

on: push

jobs:
  integration:
    runs-on: ubuntu-18.04
    container: python:3.8.12-slim

    services:
      postgres:
        image: postgres
        env:
          POSTGRES_DB: database
          POSTGRES_HOST_AUTH_METHOD: trust
          POSTGRES_PASSWORD: password

    steps:
      - name: Install container dependencies
        run: |
          apt-get update
          apt-get install -y make software-properties-common gnupg2 postgresql-client
          add-apt-repository -y ppa:git-core/ppa
          apt-get install -y git
      - name: Repository checkout
        uses: actions/checkout@v2
      - name: Set up Python 3.8
        uses: actions/setup-python@v2
        with:
          python-version: 3.8
      - name: Install service dependencies
        run: |
          python3 -m pip install --upgrade pip
          pip3 install pipenv
          make init
      - name: Create database schema
        run: |
          psql -f "sql/table.sql" postgresql://postgres:password@postgres:5432/database
      - name: Run ci bundle command
        run: |
          make ci-bundle
        env:
          DB_URL: postgresql://postgres:password@postgres:5432/database