springboot~Profile开发环境与单元测试用不同的数据库

期望

1. 希望开发环境dev用mysql
2. 单元测试使用本机的h2数据库

引入依赖

compile(org.springframework.boot:spring-boot-starter-data-jpa)
    runtime(com.h2database:h2)
    runtime(mysql:mysql-connector-java)

两种环境的配置，默认为dev

spring:
  application.name: lind-productCenter
  profiles.active: dev

  rabbitmq:
    host: localhost
    port: 5672
    username: guest
    password: guest
    virtual-host: pilipa
server:
 port: 9090
---
spring:
  profiles: dev
  datasource:
    url: jdbc:mysql://127.0.0.1:3306/productCenter?useSSL=false&allowPublicKeyRetrieval=true&createDatabaseIfNotExist=true
    username: root
    password: 123456
    driver-class-name: com.mysql.jdbc.Driver
  jpa:
      database: MYSQL
      show-sql: true #显示后台处理的SQL语句
      hibernate:
        ddl-auto: update #自动检查实体和数据库表是否一致，如果不一致则会进行更新数据库表

---
spring:
  profiles: test
  datasource:
        platform: h2
        driverClassName: org.h2.Driver
        url: jdbc:h2:mem:testdb
  jpa:
    database-platform: org.hibernate.dialect.H2Dialect
    hibernate:
      ddl-auto: update

单元测试可以提出一个基类，添加注解即可

@SpringBootTest(webEnvironment = SpringBootTest.WebEnvironment.RANDOM_PORT)
@RunWith(SpringRunner.class)
@ActiveProfiles("test")
public class BaseControllerTest {
  @Autowired
  protected WebTestClient http;

  /**
   * action 执行前运行 .
   */
  @Before
  public void before() {
    http = http.mutate()
        .responseTimeout(Duration.ofMillis(300000))
        .build();
  }

}

期望 希望开发环境dev用mysql 单元测试使用本机的h2数据库 引入依赖 compile(org.springframework.boot:spring-boot-starter-data-jpa) runtime(com.h2database:h2) runtime(mysql:mysql-connector-java) 两种环境的配置，默认为dev spring: application.name: lind-productCenter profiles.active: dev rabbitmq: host: localhost port: 5672 username: guest password: guest virtual-host: pilipa server: port: 9090 --- spring: profiles: dev datasource: url: jdbc:mysql://127.0.0.1:3306/productCenter?useSSL=false&allowPublicKeyRetrieval=true&createDatabaseIfNotExist=true username: root password: 123456 driver-class-name: com.mysql.jdbc.Driver jpa: database: MYSQL show-sql: true #显示后台处理的SQL语句 hibernate: ddl-auto: update #自动检查实体和数据库表是否一致，如果不一致则会进行更新数据库表 --- spring: profiles: test datasource: platform: h2 driverClassName: org.h2.Driver url: jdbc:h2:mem:testdb jpa: database-platform: org.hibernate.dialect.H2Dialect hibernate: ddl-auto: update 单元测试可以提出一个基类，添加注解即可 @SpringBootTest(webEnvironment = SpringBootTest.WebEnvironment.RANDOM_PORT) @RunWith(SpringRunner.class) @ActiveProfiles("test") public class BaseControllerTest { @Autowired protected WebTestClient http; /** * action 执行前运行 . */ @Before public void before() { http = http.mutate() .responseTimeout(Duration.ofMillis(300000)) .build(); } }