Flyway example for Stackoverflow

java

@Configuration
public class FlywayConfiguration {

  @Bean(initMethod = "migrate")
  @FlywayDataSource
  public Flyway firstFlyway(DataSource dataSource) {
    return new Flyway(
        new FluentConfiguration()
            .locations("db/first-migration")
            .schemas("first")
            .outOfOrder(true)
            .dataSource(dataSource)
    );
  }

  @Bean(initMethod = "migrate")
  @FlywayDataSource
  public Flyway secondFlyway(@Qualifier("secondDataSource") DataSource dataSource) {
    return new Flyway(
        new FluentConfiguration()
            .dataSource(dataSource)
            .schemas("second")
            .outOfOrder(true)
            .locations("db/second-migration")
    );
  }
}

@Configuration
public class FlywayTestConfig {

  @Autowired
  @Qualifier("secondFlyway")
  private Flyway secondFlyway;

  @Autowired
  @Qualifier("firstFlyway")
  private Flyway firstFlyway;

  @PostConstruct
  public void cleanBeforeMigrate() {
    secondFlyway.clean();
    secondFlyway.migrate();

    firstFlyway.clean();
    firstFlyway.migrate();
  }
}