❌ Remove inexisting episode links #173

	name: ❌ Remove inexisting episode links

	on:
	schedule:
	- cron: "15 2 * * *"
	workflow_dispatch:

	jobs:
	delete:
	name: ❌ Delete inexisting episode links
	runs-on: ubuntu-latest
	steps:
	- name: ⬇️ Checkout repo
	uses: actions/checkout@v4

	- name: ⎔ Setup node
	uses: actions/setup-node@v4
	with:
	node-version: 20

	- name: 📥 Download deps
	run: npm ci

	# We need to manually bump libsql here as otherwise
	# the script will hang in the Github Action. The normal
	# queries from the website work. We can't update generally
	# as otherwise this breaks the deployment on Vercel.
	- name: 📥 Temp - Fix libsql deps
	run: npm install @libsql/[email protected] @prisma/[email protected]

	- name: ❌ Delete links if needed
	run: npm run delete:episode-link
	env:
	NODE_ENV: production
	TURSO_DATABASE_URL: ${{ secrets.TURSO_DATABASE_URL }}
	TURSO_AUTH_TOKEN: ${{ secrets.TURSO_AUTH_TOKEN }}

Provide feedback