cese_models_run.yml

name: cese_models_run

on: 
  workflow_dispatch:
  schedule:
    - cron:  '0 8 * * *'

env:
  DBNAME: ${{ secrets.CESE_DBNAME_PROD }}
  HOST: ${{ secrets.HOST }}
  PASSWORD: ${{ secrets.PASSWORD }}
  PORT: ${{ secrets.PORT }}
  TARGET_SCHEMA: ${{ secrets.SCHEMA_PROD }}
  USER: ${{ secrets.USER }}
  PARTICIPATION_HOST_NAME: ${{ secrets.CESE_PARTICIPATION_HOST_NAME }}
  WORKING_DIRECTORY: ./projects/cese
  

jobs:
  cese_models_run:
    name: cese_models_run
    runs-on: ubuntu-latest
    defaults:
      run:
        working-directory: ${{ env.WORKING_DIRECTORY }}

    steps:
      - name: Check out
        uses: actions/checkout@master
      
      - name: Setup Python
        uses: actions/setup-python@v5
        with:
          python-version: "3.12.x"
          cache: 'pip'
        
      - name: Install dependencies
        run: |
          pip install -r requirements.txt
          dbt deps --target prod
      
      - name: Run dbt models
        run: dbt run --target prod

      - name: Test dbt models
        run: dbt test --target prod