Backup database #229

	name: Backup database

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

	jobs:
	run-heroku-cli-commands:
	runs-on: ubuntu-latest

	steps:
	- name: Checkout code
	uses: actions/checkout@v3

	- name: Install Heroku CLI
	run: curl https://cli-assets.heroku.com/install.sh \| sh

	- name: Authenticate with Heroku
	env:
	HEROKU_OAUTH_TOKEN: ${{ secrets.HEROKU_OAUTH_TOKEN }}
	run: \|
	echo "machine api.heroku.com" > ~/.netrc
	echo " login ${{ secrets.HEROKU_OAUTH_TOKEN }}" >> ~/.netrc
	echo " password ${{ secrets.HEROKU_OAUTH_TOKEN }}" >> ~/.netrc
	echo "machine git.heroku.com" >> ~/.netrc
	echo " login ${{ secrets.HEROKU_OAUTH_TOKEN }}" >> ~/.netrc
	echo " password ${{ secrets.HEROKU_OAUTH_TOKEN }}" >> ~/.netrc

	- name: Run Heroku pg:backups:download
	run: heroku pg:backups:download --app dluhc-planning-considerations --output data/latest_backup.dump

	- name: Set up git
	run: \|
	git config --global user.name 'github-actions[bot]'
	git config --global user.email 'github-actions[bot]@users.noreply.github.com'

	- name: Commit and push changes
	run: \|
	git add data/latest_backup.dump
	if ! git diff-index --quiet HEAD --; then
	git commit -m "Add latest database backup"
	git push
	else
	echo "No changes to commit"
	fi
	env:
	GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }}

Provide feedback