Update DB #107

	name: Update DB
	on:
	schedule:
	- cron: "0 0 * * 0" # at 00:00 on Sunday
	workflow_dispatch:

	env:
	DB_PATH: db/tlds.txt

	jobs:
	update:
	runs-on: ubuntu-latest
	steps:
	- name: "Install dependencies"
	run: sudo apt install curl -y

	- name: "Check out code"
	uses: actions/checkout@v4

	- name: "Check for updates"
	id: check
	run: \|
	local_ver="$(grep -oP '^# Version \K\d+' ${{ env.DB_PATH }})"
	remote_ver="$(curl -sr 0-20 ${{ secrets.REMOTE_DB }} \| grep -oP '^# Version \K\d+')"

	echo -e "Date: $(date)"
	echo -e "Local version: ${local_ver}"
	echo -e "Remote version: ${remote_ver}"

	if [[ "${local_ver}" -lt "${remote_ver}" ]]; then
	echo "isUpdated=false" >> $GITHUB_OUTPUT
	else
	echo "isUpdated=true" >> $GITHUB_OUTPUT
	fi

	echo "remoteVersion=${remote_ver}" >> $GITHUB_OUTPUT

	- name: "Update DB..."
	if: steps.check.outputs.isUpdated == 'false'
	run: \|
	curl -kLo ${{ env.DB_PATH }} ${{ secrets.REMOTE_DB }}
	insertions=$(git diff --stat ${{ env.DB_PATH }} \| awk '/insertions/ {print $4}')
	if [[ "${insertions}" -lt 1 ]]; then
	echo "isUpdated=true" >> $GITHUB_OUTPUT
	git stash
	fi

	- name: Create Pull Request
	if: steps.check.outputs.isUpdated == 'false'
	uses: peter-evans/create-pull-request@v3
	with:
	body: "Automated update TLDs data."
	branch-suffix: "short-commit-hash"
	branch: "update/db"
	commit-message: "db: Update DB (${{ steps.check.outputs.remoteVersion }})"
	committer: "ghost <ghost@users.noreply.github.com>"
	delete-branch: true
	reviewers: "dwisiswant0"
	title: "db: Update DB (${{ steps.check.outputs.remoteVersion }})"

Provide feedback