mirror of
https://github.com/Hestia-Homes/survey-extraction.git
synced 2026-06-30 13:10:56 +00:00
37 lines
No EOL
1.3 KiB
YAML
37 lines
No EOL
1.3 KiB
YAML
name: HubSpot Deals to DB loading and Invoice Calculator
|
|
on:
|
|
# schedule:
|
|
# - cron: '0 19 * * 0'
|
|
workflow_dispatch:
|
|
|
|
jobs:
|
|
hubspot-deals-to-db:
|
|
runs-on: ubuntu-22.04
|
|
steps:
|
|
- uses: actions/checkout@v3
|
|
|
|
- name: Set up Python
|
|
uses: actions/setup-python@v4
|
|
with:
|
|
python-version: '3.12'
|
|
|
|
- name: Install dependencies
|
|
run: |
|
|
pip install poetry
|
|
poetry install --no-root
|
|
|
|
- name: run script
|
|
run: |
|
|
pwd
|
|
ls -la
|
|
poetry run python etl/hubspot_to_invoice_rewrite.py
|
|
env:
|
|
PYTHONPATH: ${{ github.workspace }}
|
|
DATABASE_URL: postgresql://postgres:makingwarmhomes@terraform-20250331175522503500000002.cdgzupxvdyp0.eu-west-2.rds.amazonaws.com:5432/surveyDB
|
|
SOUTH_COAST_INSULATION_SERVICE_SHAREPOINT_ID: ${{ secrets.SOUTH_COAST_INSULATION_SERVICE_SHAREPOINT_ID }}
|
|
JJC_SERVICE_SHAREPOINT_ID: ${{ secrets.JJC_SERVICE_SHAREPOINT_ID }}
|
|
BAXTER_KELLY_SERVICE_SHAREPOINT_ID: ${{ secrets.BAXTER_KELLY_SERVICE_SHAREPOINT_ID }}
|
|
SGEC_SERVICE_SHAREPOINT_ID: ${{ secrets.SGEC_SERVICE_SHAREPOINT_ID }}
|
|
SHAREPOINT_CLIENT_ID: ${{ secrets.SHAREPOINT_CLIENT_ID }}
|
|
SHAREPOINT_CLIENT_SECRET: ${{ secrets.SHAREPOINT_CLIENT_SECRET }}
|
|
SHAREPOINT_TENANT_ID: ${{ secrets.SHAREPOINT_TENANT_ID }} |