Weekly Database Update #76

	name: Weekly Database Update

	on:
	schedule:
	- cron: "0 0 * * 0" # Run every Sunday at midnight
	workflow_dispatch: # Manual trigger

	env:
	GITHUB_PAT: ${{ secrets.GITHUB_TOKEN }}
	TELRAAM_KEY: ${{ secrets.TELRAAM_KEY }}

	jobs:
	update:
	runs-on: ubuntu-latest

	steps:
	- name: Checkout Repository
	uses: actions/checkout@v2

	- name: Set up R environment
	uses: r-lib/actions/setup-r@v2
	with:
	r-version: 4.x

	- name: Install system dependencies
	run: sudo apt-get update && sudo apt-get install -y libcurl4-openssl-dev libssl-dev

	- name: install packages
	run: Rscript install-packages-update.R

	- name: Run R script
	run: Rscript update-database.R

	- name: Commit and Push Changes
	run: \|
	git config --global user.email '[email protected]'
	git config --global user.name 'GitHub Actions'
	git add .
	git commit -m 'Update data files'
	git push origin ${{ github.ref }}

Provide feedback