refresh-data.yaml

name: refresh-data

on:
  workflow_dispatch:
    inputs:
      tags:
        description:
          "run from cmdline"
  schedule:
    - cron: '30 1 * * THU'
  push:
    branches:
      - master
      - main

jobs:
  refresh-data:
    runs-on: ubuntu-latest
    env:
      R_CONFIG_ACTIVE: github
      GITHUB_PAT: ${{ secrets.DJPRDASHDATA_PAT }}
      PG_MASTER_USER: ${{ secrets.PG_MASTER_USER }}
      PG_MASTER_PW: ${{ secrets.PG_MASTER_PW }}
      PG_READ_OPEN_USER: ${{ secrets.PG_READ_OPEN_USER }}
      PG_READ_OPEN_PW: ${{ secrets.PG_READ_OPEN_PW }}
      IVI_REGIONS: ${{ vars.IVI_REGIONS }}
      IVI_ANZSCO4: ${{ vars.IVI_ANZSCO4 }}
    steps:

      - uses: actions/checkout@v3

      - name: Installing extra system dependencies
        run: |
         sudo apt-get update
         sudo apt-get install -y --fix-missing libcurl4-openssl-dev

      - uses: r-lib/actions/setup-r@v2
        with:
          r-version: 'renv' # The R version to download (if necessary) and use.
      - uses: r-lib/actions/setup-renv@v2

      - uses: r-lib/actions/setup-pandoc@v2
      - name: Get Github action IP
        id: ip
        uses: haythem/public-ip@v1.3

      - name: Set AWS environment variables
        run: |
          echo "AWS_DEFAULT_REGION=ap-southeast-2" >> $GITHUB_ENV
          echo "AWS_SG_NAME=sg-0b7365fabbbc1c55b" >> $GITHUB_ENV
      - name: Add Github Actions IP to Security group
        run: |
          aws ec2 authorize-security-group-ingress --group-id ${{ env.AWS_SG_NAME }} --protocol tcp --port 5432 --cidr ${{ steps.ip.outputs.ipv4 }}/32
        env:
          AWS_ACCESS_KEY_ID: ${{ secrets.AWS_ACCESS_KEY_ID }}
          AWS_SECRET_ACCESS_KEY: ${{ secrets.AWS_SECRET_ACCESS_KEY }}
          AWS_DEFAULT_REGION: ${{ env.AWS_DEFAULT_REGION }}

      - name: Get data
        run: Rscript -e 'source(here::here("data-raw", "refresh_data.R"), echo = TRUE)'
      - name: Render README
        run: Rscript -e 'rmarkdown::render(here::here("README.Rmd"))'
      - name: Commit
        run: |
          git config --global user.name 'Henry McMillan'
          git config --global user.email '96028056+Henry-DJPR@users.noreply.github.com'
          git add .
          git commit -m 'refreshing data' || echo "No changes to commit"
          git push --force origin main || echo "No changes to commit"
      - name: Remove Github Actions IP from security group
        run: |
          aws ec2 revoke-security-group-ingress --group-id ${{ env.AWS_SG_NAME }} --protocol tcp --port 5432 --cidr ${{ steps.ip.outputs.ipv4 }}/32
        env:
          AWS_ACCESS_KEY_ID: ${{ secrets.AWS_ACCESS_KEY_ID }}
          AWS_SECRET_ACCESS_KEY: ${{ secrets.AWS_SECRET_ACCESS_KEY }}
          AWS_DEFAULT_REGION: ${{ env.AWS_DEFAULT_REGION }}
        if: always()