Portfolio


implementation 'org.springframework.boot:spring-boot-starter-data-jpa'
implementation 'mysql:mysql-connector-java'
implementation 'org.springframework.boot:spring-boot-starter-web'
implementation 'org.flywaydb:flyway-core'


implementation 'org.flywaydb:flyway-core'


plugins {
	id "org.flywaydb.flyway" version "7.2.0"
}

....
dependencies {

	compileOnly "org.flywaydb:flyway-mysql"
  implementation 'org.flywaydb:flyway-core'
}

....제일 하단

flyway {
  url = 'jdbc:mysql://localhost:3306/flyway?useSSL=false&serverTimezone=UTC&characterEncoding=utf8'
  user = 'root'
  password = 'a123456789'
}


plugins {
    id 'org.springframework.boot' version '2.7.1'
    id 'io.spring.dependency-management' version '1.0.11.RELEASE'
    id 'java'

    //flyway
    id "org.flywaydb.flyway" version "7.2.0"
}

group = 'com.example'
version = '0.0.1-SNAPSHOT'
sourceCompatibility = '17'

repositories {
    mavenCentral()
}

dependencies {
    implementation 'org.springframework.boot:spring-boot-starter-data-jpa'
    implementation 'org.springframework.boot:spring-boot-starter-web'
    implementation 'mysql:mysql-connector-java'

    //flyway
    compileOnly "org.flywaydb:flyway-mysql"
    implementation 'org.flywaydb:flyway-core'

    testImplementation 'org.springframework.boot:spring-boot-starter-test'
}

tasks.named('test') {
    useJUnitPlatform()
}

//flyway
flyway {
    url = 'jdbc:mysql://localhost:3306/flyway?useSSL=false&serverTimezone=UTC&characterEncoding=utf8'
    user = 'root'
    password = 'a123456789'
}


spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/flyway
    username: root
    password: a123456789
  jpa:
    database: mysql
    database-platform: org.hibernate.dialect.MySQL8Dialect
    show-sql: true
    hibernate:
      ddl-auto: validate
    properties:
      hibernate:
        format_sql: true
  flyway:
    enabled: true
    baseline-on-migrate: true


@Entity
public class Member {

    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private Long id;

    private String name;

    public Member() {
    }

    public Member(Long id, String name) {
        this.id = id;
        this.name = name;
    }
}


drop table if exists member;

create table member
(
    id   bigint auto_increment,
    name varchar(255),
    primary key (id)
);


@SpringBootApplication
public class FlywaySturdyApplication {

    private final EntityManager em;

    public FlywaySturdyApplication(EntityManager em) {
        this.em = em;
    }

    public static void main(String[] args) {
        SpringApplication app = new SpringApplication(FlywaySturdyApplication.class);
        app.setWebApplicationType(WebApplicationType.NONE);
        ConfigurableApplicationContext run = app.run(args);

        FlywaySturdyApplication flyway = (FlywaySturdyApplication)run.getBean("flywaySturdyApplication");
        Member member = new Member(null, "name");
        flyway.save(member);
    }

    @Transactional
    public void save(Member member) {
        em.persist(member);
    }
}


@Entity
public class Member {
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private Long id;
    private String name;
    private Integer age; //추가
}


## V2__add_age_in_member.sql ##

ALTER TABLE member ADD COLUMN age integer DEFAULT 0;