name: Hubspot Sync

on:
  schedule:
    - cron: '0 6 * * *'   # Every day at 06:00 UTC
  workflow_dispatch:

jobs:
  hubspot-sync:
    runs-on: [self-hosted, mist]
    steps:
      - uses: actions/checkout@v4

      - name: Set up Python
        uses: actions/setup-python@v5
        with:
          python-version: '3.12'

      - name: Install dependencies
        run: |
          pip install poetry
          poetry install --no-root

      - name: Run scripts
        env:
          PYTHONPATH: ${{ github.workspace }}
          DATABASE_URL: ${{ secrets.PROD_DATABASE_URL }}
        run: |
          pwd
          ls -la
          poetry run python etl/hubSpotClient/scripts/hubspot_update_script.py