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

红太狼 2021-03-18 13:46 305阅读 0赞

## 期望 ##

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();
      }
    
    }