Merge pull request #27 from SportsTeamRecommend/dev #17

	name: Deploy prod Server

	on:
	push:
	branches:
	- main

	jobs:
	deploy:
	runs-on: ubuntu-latest

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

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

	- name: Grant execute permission for gradlew
	run: chmod +x ./gradlew

	- name: Start MySQL container
	run: docker compose up -d --wait
	env:
	DB_PASSWORD: ${{ secrets.DB_PASSWORD }}

	- name: Build and runs Tests
	run: \|
	./gradlew build
	env:
	SPRING_APPLICATION_NAME: backend
	SPRING_PROFILES_ACTIVE: prod

	SPRING_DATASOURCE_DRIVER-CLASS-NAME: com.mysql.cj.jdbc.Driver
	SPRING_DATASOURCE_URL: jdbc:mysql://localhost:3308/sports_team_recommend_db?useSSL=false&serverTimezone=Asia/Seoul&allowPublicKeyRetrieval=true
	SPRING_DATASOURCE_USERNAME: root
	SPRING_DATASOURCE_PASSWORD: ${{ secrets.DB_PASSWORD }}

	SPRING_JPA_HIBERNATE_DDL_AUTO: create
	SPRING_JPA_PROPERTIES_HIBERNATE_DIALECT: org.hibernate.dialect.MySQLDialect
	SPRING_JPA_PROPERTIES_HIBERNATE_FORMAT_SQL: true
	SPRING_JPA_PROPERTIES_HIBERNATE_SHOW_SQL: true

	- name: Stop MySQL container
	if: always()
	run: docker compose down

	- name: Deploy to EC2
	uses: appleboy/scp-action@master
	with:
	host: ${{ secrets.EC2_HOST }}
	username: ${{ secrets.EC2_USERNAME }}
	key: ${{ secrets.EC2_PRIVATE_KEY }}
	source: "build/libs/backend.jar"
	target: "~"

	- name: Execute Server
	uses: appleboy/ssh-action@master
	with:
	host: ${{ secrets.EC2_HOST }}
	username: ${{ secrets.EC2_USERNAME }}
	key: ${{ secrets.EC2_PRIVATE_KEY }}
	script: sudo bash /home/ubuntu/deploy.sh

Provide feedback