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

期望

希望开发环境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();

}

}