Run SQLite Task #27

	name: Run SQLite Task

	on:
	schedule:
	- cron: '0 * * * *' # Run every hour
	workflow_dispatch: # Allow manual trigger

	jobs:
	sqlite-job:
	runs-on: ubuntu-latest

	env:
	TWITTER_USERNAME: ${{ secrets.TWITTER_USERNAME }}
	TWITTER_PASSWORD: ${{ secrets.TWITTER_PASSWORD }}
	TWITTER_EMAIL: ${{ secrets.TWITTER_EMAIL }}
	OPENAI_API_KEY: ${{ secrets.OPENAI_API_KEY }}
	DISCORD_APP_ID: ${{ secrets.DISCORD_APP_ID }}
	DISCORD_TOKEN: ${{ secrets.DISCORD_TOKEN }}
	BIRDEYE_API_KEY: ${{ secrets.BIRDEYE_API_KEY }}

	steps:
	# Step 1: Check out the repository
	- name: Checkout code
	uses: actions/checkout@v3

	# Step 2: Set up Node.js
	- name: Set up Node.js
	uses: actions/setup-node@v3
	with:
	node-version: '23' # Specify the Node.js version you need

	# Step 3: Install dependencies
	- name: Install dependencies
	run: npm install

	# Step 4: Run the script
	- name: Run index.js
	env:
	TWITTER_USERNAME: ${{ env.TWITTER_USERNAME }}
	TWITTER_PASSWORD: ${{ env.TWITTER_PASSWORD }}
	TWITTER_EMAIL: ${{ env.TWITTER_EMAIL }}
	OPENAI_API_KEY: ${{ env.OPENAI_API_KEY }}
	DISCORD_APP_ID: ${{ env.DISCORD_APP_ID }}
	DISCORD_TOKEN: ${{ env.DISCORD_TOKEN }}
	BIRDEYE_API_KEY: ${{ env.BIRDEYE_API_KEY }}
	RUN_ONCE: true
	run: npm run dev

	- name: Commit and Push Changes
	run: \|
	git config user.name "GitHub Actions"
	git config user.email "[email protected]"
	git add ./data/db.sqlite
	git add ./json/
	git commit -m "Update from collection"
	git push

Provide feedback