name: Hubspot Data to S3

on:
  # schedule:
  #   - cron: '30 17 * * *' 
  workflow_dispatch:

jobs:
  hubspot_raw_to_s3:
    name: HubSpot → S3 (Operations)
    runs-on: [self-hosted, mist]
    timeout-minutes: 4320

    steps:
      - uses: actions/checkout@v4

      - name: Build Docker image
        run: |
          docker build -f .devcontainer/Dockerfile -t latest-image .

      - name: Run raw HubSpot export
        run: |
          docker run \
            -u $(id -u):$(id -g) \
            -v ${{ github.workspace }}:/workspaces/insight \
            -w /workspaces/insight/backend \
            latest-image \
            bash -c "
              poetry install &&
              poetry run python src/dashboard/scripts/hubspot_to_s3.py
            "

  hubspot_sales_forecast_to_s3:
    name: HubSpot → S3 (sales forecast)
    runs-on: [self-hosted, mist]
    timeout-minutes: 720

    steps:
      - uses: actions/checkout@v4

      - name: Build Docker image
        run: |
          docker build -f .devcontainer/Dockerfile -t latest-image .

      - name: Run sales forecast export
        run: |
          docker run \
            -u $(id -u):$(id -g) \
            -v ${{ github.workspace }}:/workspaces/insight \
            -w /workspaces/insight/backend \
            latest-image \
            bash -c "
              poetry install &&
              poetry run python src/dashboard/scripts/hubspot_to_s3_sales_forecast.py
            "