dnd-side-project-dnd-7th-6-backend

photalks 발표 자료 : https://docs.google.com/presentation/d/1yAEmEFSCZ0iIHhLGO61lS0GpmhWkrTDL/edit?usp=sharing&ouid=112953165871692061444&rtpof=true&sd=true
photalks 소개글 : https://velog.io/@jynam821/%EC%9D%B8%EC%83%9D%EB%84%A4%EC%BB%B7%EC%97%90%EC%84%9C-%EC%82%AC%EC%A7%84-%EC%B0%8D%EC%96%B4%EB%B3%B8-%EC%82%AC%EB%9E%8C-%EC%97%AC%EA%B8%B0%EC%97%AC%EA%B8%B0-%EB%AA%A8%EC%97%AC%EB%9D%BC-qf6y3cfb
앱 베타 버전 배포

(신고하기 기능 추가 후 앱 배포 예정)

1. Used Tools

• Spring Boot 2.6.6.RELEASE
• Gradle 7+
• flyway 6.5.7
• mapstruct 1.4.2.Final
• querydsl 1.0.10
• hibernate-spatial
• mysql
• aws s3
• Spring Security
• KAKAO MAP API V2
• jenkins
• ...

2. 개발 환경 구성

Requirements

• mysql
• jdk 11+

3. 로컬 개발환경 구성

DataBase

• Local Configuration
  • url : jdbc:mysql://localhost:3306/hot6
  • user : master
  • password :
• Create Database

mysql --protocol tcp -uroot -p
<your password>

CREATE DATABASE IF NOT EXISTS `hot6` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
USE `hot6`;
GRANT ALL ON album.* TO 'master'@'%';
GRANT USAGE ON album.* TO 'master'@'%';
FLUSH PRIVILEGES;

• Table Migration

  • IntelliJ -> Gradle -> album-flyway -> Task -> flyway
    • Run flywayClean
    • Run flywayMigrate

• project 내 mysql password 적용 필요

  • flyway/src/main/resources/application.yml

    flyway:
    enabled: true
    baseline-on-migrate: true
    baseline-version: 1
    locations: classpath:db/migration/schema
    url: jdbc:mysql://localhost:3306/hot6
    schemas: test
    user: root
    password: <your password>
    
    

  • flyway/build.gradle

    // default flyway configuration : local
      flyway {
          url = 'jdbc:mysql://localhost:3306/hot6?'
          user = 'root'
          password = '<your password>'
      }
    

  • api/src/main/resources/application.yml

    datasource:
      url: jdbc:mysql://localhost:3306/hot6
      username: root
      password: <your password>
      driver-class-name: com.mysql.cj.jdbc.Driver
    

  • admin/src/main/resources/application.yml

    datasource:
      url: jdbc:mysql://localhost:3306/hot6
      username: root
      password: <your password>
      driver-class-name: com.mysql.cj.jdbc.Driver
    

4. 아키텍처

5. 기획