70 feat ranking 기능 구현 #54

	name: BE CI for Dev

	on:
	pull_request:
	branches:
	- dev

	jobs:
	build-and-test:
	runs-on: ubuntu-latest
	env:
	MYSQL_DB_URL: ${{ secrets.MYSQL_DB_URL }}
	MYSQL_DB_PORT: ${{ secrets.MYSQL_DB_PORT }}
	MYSQL_DB_NAME: ${{ secrets.MYSQL_DB_NAME }}
	MYSQL_DB_USERNAME: ${{ secrets.MYSQL_DB_USERNAME }}
	MYSQL_DB_PASSWORD: ${{ secrets.MYSQL_DB_PASSWORD }}
	EC2_SSH_PRIVATE_KEY: ${{ secrets.EC2_SSH_PRIVATE_KEY }}
	EC2_HOST: ${{ secrets.EC2_HOST }}
	RDS_ENDPOINT: ${{ secrets.RDS_ENDPOINT }}

	steps:
	- name: Checkout code
	uses: actions/checkout@v4

	- name: Set up JDK 17
	uses: actions/setup-java@v4
	with:
	java-version: '17'
	distribution: 'corretto'

	- name: Update application.yml
	run: \|
	echo "${{ secrets.APPLICATION }}" > ./src/main/resources/application.yml

	- name: Set up Gradle
	uses: gradle/actions/setup-gradle@v3
	with:
	cache-write-only: true

	- name: Grant Execute Permission For Gradlew
	run: chmod +x gradlew

	- name: Set up SSH key
	run: \|
	mkdir -p ~/.ssh
	echo "${{ secrets.EC2_SSH_PRIVATE_KEY }}" > ~/.ssh/id_rsa
	chmod 600 ~/.ssh/id_rsa

	- name: Add EC2 to known hosts
	run: \|
	ssh-keyscan -H ${{ secrets.EC2_HOST }} >> ~/.ssh/known_hosts

	- name: Set up SSH tunnel to RDS
	run: \|
	ssh -i ~/.ssh/id_rsa -L 3306:${{ secrets.RDS_ENDPOINT }}:3306 -f -N ubuntu@${{ secrets.EC2_HOST }} \|\| exit 1

	- name: Build With Gradle
	run: ./gradlew build

	- name: Run Tests
	run: ./gradlew test

Provide feedback