Merge pull request #2 from irfanh94/github_test_workflow #5

	name: Node.js CI with MySQL

	on:
	push:
	branches:
	- main
	pull_request:
	branches:
	- main

	jobs:
	test:
	runs-on: ubuntu-latest

	services:
	mysql:
	image: mysql:8.0
	ports:
	- 3306:3306
	env:
	MYSQL_ROOT_PASSWORD: root
	MYSQL_DATABASE: testdb
	MYSQL_USER: testuser
	MYSQL_PASSWORD: testpassword
	options: --health-cmd="mysqladmin ping --silent" --health-interval=10s --health-timeout=5s --health-retries=3

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

	- name: Set up Node.js 22
	uses: actions/setup-node@v3
	with:
	node-version: 22

	- name: Install dependencies
	run: npm install

	- name: Wait for MySQL to be ready
	run: \|
	until mysqladmin ping --host=127.0.0.1 --user=testuser --password=testpassword --silent; do
	echo "Waiting for MySQL to be ready..."
	sleep 5
	done

	- name: Run Prisma migrations
	env:
	DATABASE_URL: mysql://testuser:[email protected]:3306/testdb
	run: npm run db:migration:migrate

	- name: Run tests
	env:
	APP_SECRET: very-strong-app-secret
	APP_HTTP_PORT: 3000
	APP_HTTP_BODY_LIMIT: 1mb
	APP_HTTP_CORS: "*"
	DATABASE_URL: mysql://testuser:[email protected]:3306/testdb
	DATABASE_CONNECTION_LIMIT: 1
	run: npm run test

Provide feedback