Skip to content
Refresh data

See if this passes the MD token properly #34

Sign in to view logs

See if this passes the MD token properly

See if this passes the MD token properly #34

Workflow file for this run

.github/workflows/update.yml at 82f6c6b
name: Refresh data
on:
push:
branches:
- main
workflow_dispatch:
schedule:
- cron: "21 11 * * *"
jobs:
scheduled:
runs-on: macos-latest
env:
MOTHERDUCK_TOKEN: ${{ secrets.MOTHERDUCK_TOKEN }}
steps:
- name: Checkout
uses: actions/[email protected]
- name: Setup Python
uses: actions/[email protected]
with:
python-version: "3.11.x"
- name: Install Python dependencies
run: |
pip install uv
uv pip install -r requirements.txt --system
- name: Fetch latest data
run: |
cp data/Street_Tree_List.csv Street_Tree_List-old.csv
curl -o Street_Tree_List-unsorted.csv "https://data.sfgov.org/api/views/tkzw-k3nq/rows.csv?accessType=DOWNLOAD"
# Remove heading line and use it to start a new file
head -n 1 Street_Tree_List-unsorted.csv > data/Street_Tree_List.csv
# Sort all but the first line and append to that file
tail -n +2 "Street_Tree_List-unsorted.csv" | sort >> data/Street_Tree_List.csv
# Generate commit message using csv-diff
csv-diff Street_Tree_List-old.csv data/Street_Tree_List.csv --key=TreeID --singular=tree --plural=trees > message.txt
- name: Commit and push if it changed
run: |-
git config user.name "Automated"
git config user.email "[email protected]"
git add data/Street_Tree_List.csv
timestamp=$(date -u)
git commit -F message.txt || exit 0
git push
build_to_motherduck:
uses: ./.github/workflows/build.yml

Check failure on line 46 in .github/workflows/update.yml

View workflow run for this annotation

GitHub Actions / Refresh data

Invalid workflow file 

The workflow is not valid. .github/workflows/update.yml (Line: 46, Col: 11): Secret MOTHERDUCK_TOKEN is required, but not provided while calling.
needs: scheduled