every_four_hours.yml

name: Every 4 Hours (Schema, Local Copies, Permissions, All Donations & All Matching)

on:
  schedule:
    # Runs every four hours
    - cron:  '0 */4 * * *'
  workflow_dispatch:

permissions:
  contents: write  # Needed for committing back to the repo


jobs:
  run-script:
    runs-on: ubuntu-latest
    env:
      DB_HOST: ${{ secrets.DB_HOST }}
      DB_PORT: ${{ secrets.DB_Port }}
      DB_USER: ${{ secrets.DB_USER }}
      DB_PASSWORD: ${{ secrets.DB_PASSWORD }}
      INDEXER_DB_HOST: ${{ secrets.INDEXER_DB_HOST }}
      INDEXER_DB_PORT: ${{ secrets.INDEXER_DB_PORT }}
      INDEXER_DB_NAME: ${{ secrets.INDEXER_DB_NAME }}
      INDEXER_DB_USER: ${{ secrets.INDEXER_DB_USER }}
      INDEXER_DB_PASSWORD: ${{ secrets.INDEXER_DB_PASSWORD }}
      MACI_DB_HOST: ${{ secrets.MACI_DB_HOST }}
      MACI_DB_PORT: ${{ secrets.MACI_DB_PORT }}
      MACI_DB_NAME: ${{ secrets.MACI_DB_NAME }}
      MACI_DB_USER: ${{ secrets.MACI_DB_USER }}
      MACI_DB_PASSWORD: ${{ secrets.MACI_DB_PASSWORD }}
      GOOGLE_CREDENTIALS: ${{ secrets.GOOGLE_CREDENTIALS }}
      DUNE_API_KEY: ${{ secrets.DUNE_API_KEY }}
      DB_FDW_USERS: ${{ secrets.DB_FDW_USERS }}

    steps:
    - name: Checkout repository
      uses: actions/checkout@v2
    - name: Set up Python
      uses: actions/setup-python@v2
      with:
        python-version: '3.8'
    - name: Install dependencies
      run: |
        python -m pip install --upgrade pip
        pip install -r requirements.txt
    - name: Update Foreign Schema
      run: python automations/update_foreign_schema.py
      timeout-minutes: 55
    - name: Update Materialized Views
      run: python automations/update_materialized_views.py
      timeout-minutes: 55
    - name: Update Permissions
      run: python automations/create_foreign_data_users.py
      timeout-minutes: 55