Spring Boot + TestContainer + Liquibase를 활용한 통합테스트

dependencies { // ... testImplementation "org.testcontainers:testcontainers:1.16.0" testImplementation "org.testcontainers:junit-jupiter:1.16.0" testImplementation "org.testcontainers:mariadb:1.16.0" }

public class MariaDBExtension implements BeforeAllCallback, AfterAllCallback { public static JdbcDatabaseContainer<?> container; @Override public void beforeAll(final ExtensionContext context) throws Exception { // 운영 환경 DB 버전과 동일하게 설정 final String IMAGE_NAME = "mariadb:10.2.14"; container = new MariaDBContainer(IMAGE_NAME) .withDatabaseName("test") .withUsername("test") .withPassword("1q2w3e4r") .withUrlParam("characterEncoding", StandardCharsets.UTF_8.name()) .withUrlParam("serverTimezone", "Asia/Seoul") .withCommand("mysqld", "--character-set-server=utf8mb4", "--collation-server=utf8mb4_general_ci"); container.start(); System.setProperty("spring.datasource.url", container.getJdbcUrl()); System.setProperty("spring.datasource.username", container.getUsername()); System.setProperty("spring.datasource.password", container.getPassword()); } @Override public void afterAll(final ExtensionContext context) throws Exception { container.stop(); } } @ExtendWith(MariaDBExtension.class) // TestContainer MariaDB 확장 클래스 등록 @Ignore // 통합테스트는 자동 테스트에서 제외되도록 Ignore 처리 @Transactional // 테스트 트랜잭션 선언시 테스트 메서드 종료 후 데이터 Rollback 처리됨(쓰레드 불일치 주의) @SpringBootTest(webEnvironment = SpringBootTest.WebEnvironment.RANDOM_PORT) public class ControllerIntegraionTest { // 테스트 코드 ... }

# generateChangeLog를 통해 기존 DB의 스키마를 liquibase changelog 파일로 생성 $ liquibase --changelogFile=db-changelog.1.0.0.xml generateChangeLog # changeLogFile의 내용을 대상 DB와 싱크를 맞춰보고 DATABASECHANGELOG 테이블에 입력할 # INSERT SQL문을 출력하여 sync 검증 $ liquibase --changelogFile=db-changelog.1.0.0.xml changelogSyncSQL # 실제로 sync 처리를 하여 DATABASECHANGELOG 테이블 생성 및 changeLogFile 내용을 입력 $ liquibase --changelogFile=db-changelog.1.0.0.xml changelogSync

buildscript { //... repositories { mavenCentral() } // 플러그인 추가 dependencies { classpath "org.liquibase:liquibase-gradle-plugin:2.0.3" } } // 플러그인 적용 apply plugin: 'org.liquibase.gradle' dependencies { //... // liquibase 적용 liquibaseRuntime 'org.liquibase:liquibase-core:4.4.3' liquibaseRuntime 'org.mariadb.jdbc:mariadb-java-client:2.7.3' liquibaseRuntime 'ch.qos.logback:logback-core:1.2.3' liquibaseRuntime 'ch.qos.logback:logback-classic:1.2.3' testImplementation 'org.mariadb.jdbc:mariadb-java-client:2.7.3' testImplementation 'org.liquibase:liquibase-core:4.4.3' } test { useJUnitPlatform() } liquibase { activities { main { changeLogFile 'src/main/resources/db/changelog/db.changelog-master.xml' url 'jdbc:mariadb://기존DB:3306/test-db?characterEncoding=UTF-8&serverTimezone=Asia/Seoul' username 'username' password 'password' driver 'org.mariadb.jdbc.Driver' logLevel 'debug' } } }

$ gradle generateChangeLog $ gradle changelogSyncSQL $ gradle changelogSync

@Configuration @EnableTransactionManagement @Profile("test") public class TestDataBaseConfig { @Bean public DataSource dataSource() { DriverManagerDataSource ds = new DriverManagerDataSource(); ds.setUrl(container.getJdbcUrl()); ds.setUsername(container.getUsername()); ds.setPassword(container.getPassword()); ds.setSchema(container.getDatabaseName()); return ds; } @Bean public SpringLiquibase springLiquibase(DataSource dataSource) { SpringLiquibase liquibase = new SpringLiquibase(); liquibase.setTestRollbackOnUpdate(true); liquibase.setDataSource(dataSource); liquibase.setDefaultSchema(container.getDatabaseName()); liquibase.setChangeLog("classpath:/db/init/db.changelog-init.xml"); return liquibase; } }