backend_dev_flyway.yml

name: dev flyway 검증

on:
  pull_request:
    types: [opened, reopened, synchronize]
    branches: [develop-be]

permissions: write-all    
jobs:
  build:
    if: contains(github.event.pull_request.labels.*.name, 'backend')
    runs-on: ubuntu-latest
  
    steps:
      - uses: actions/checkout@v3
          
      - name: settings java
        uses: actions/setup-java@v3
        with:
          java-version: '17'
          distribution: 'temurin'
          
      - name: cache gradle
        uses: actions/cache@v2
        with:
          path: |
            ~/.gradle/caches
            ~/.gradle/wrapper
          key: ${{ runner.os }}-gradle-${{ hashFiles('**/*.gradle*', '**/gradle-wrapper.properties') }}
          restore-keys: |
            ${{ runner.os }}-gradle-
            
      - name: chmod gradle
        run: chmod +x backend/ddang/gradlew

      - name: Set up Docker Compose
        run: docker-compose -f .github/workflows/docker-compose.yml up -d

      - name: Wait for MySQL to be ready
        run: |
          while [ -z "$DATABASE_URL" ]; do
            echo "Waiting for MySQL to be ready..."
            export DATABASE_URL=$(echo "SELECT 'ready';" | mysql -h127.0.0.1 -P7777 -utest -ppassword testdb --skip-column-names 2>/dev/null)
            sleep 1
          done
          echo "$DATABASE_URL"
          docker ps
          telnet 127.0.0.1 7777

      - name: Create flyway.conf
        run: |
          touch flyway.conf
          echo "flyway.driver=com.mysql.cj.jdbc.Driver" >> flyway.conf
          echo "flyway.url=mysql://127.0.0.1:7777/testdb" >> flyway.conf
          echo "flyway.user=test" >> flyway.conf
          echo "flyway.password=password" >> flyway.conf
          echo "flyway.encoding=UTF-8" >> flyway.conf
          echo "flyway.locations=filesystem:src/main/resources/db/migration" >> flyway.conf
          echo "flyway.validateOnMigrate=true" >> flyway.conf
        working-directory: ./backend/ddang

      - name: flywayValidate
        run: |
          ./gradlew -Dflyway.configFiles=flyway.conf flywayMigrate --stacktrace
        working-directory: ./backend/ddang
  
      - name: Shut down Docker Compose
        run: docker-compose -f .github/docker-compose.yml down