【SpringBoot3】単体テスト環境を構築(準備編)

plugins {
	id 'java'
	id 'org.springframework.boot' version '3.0.2'
	id 'io.spring.dependency-management' version '1.1.0'
	id 'jacoco'
}

group = 'com.example'
version = '0.0.1-SNAPSHOT'
sourceCompatibility = '17'

configurations {
	compileOnly {
		extendsFrom annotationProcessor
	}
}

repositories {
	mavenCentral()
}

dependencies {
	implementation 'org.springframework.boot:spring-boot-starter-data-jdbc'
	implementation 'org.springframework.boot:spring-boot-starter-thymeleaf'
	implementation 'org.springframework.boot:spring-boot-starter-validation'
	implementation 'org.springframework.boot:spring-boot-starter-web'
	implementation 'org.mybatis.spring.boot:mybatis-spring-boot-starter:3.0.0'
	compileOnly 'org.projectlombok:lombok'
	developmentOnly 'org.springframework.boot:spring-boot-devtools'
	runtimeOnly 'com.h2database:h2'
	runtimeOnly 'com.microsoft.sqlserver:mssql-jdbc'
	annotationProcessor 'org.projectlombok:lombok'
	testImplementation 'org.springframework.boot:spring-boot-starter-test'
testImplementation 'org.mybatis.spring.boot:mybatis-spring-boot-starter-test:3.0.0'
}

tasks.named('test') {
	useJUnitPlatform()
}

server.port = 8084
# DB接続情報
spring.datasource.driverClassName=org.h2.Driver
spring.datasource.url=jdbc:h2:mem:sample;MODE=MSSQLServer
spring.datasource.username=sa
spring.datasource.password=
#この設定で起動時にsrc\test\resources配下のdata.sqlとschema.sqlを実行してくれる
spring.sql.init.mode=always
# h2コンソールを利用するための設定
spring.h2.console.enabled=true
spring.h2.console.path=/h2-console
# SQLSQLログ出力
logging.level.org.springframework=warn
logging.level.com.example.demo.UserDataMapper=debug

-- ユーザーテーブル作成
CREATE TABLE users
(
userid VARCHAR(24) NOT NULL,
name VARCHAR(50) NOT NULL,
email VARCHAR(255) NOT NULL,
PRIMARY KEY(userid)
);

-- テストデータ追加
INSERT INTO users(userid, name, email)
VALUES ('test01', 'テスト01', 'test01@example.com');

INSERT INTO users(userid, name, email)
VALUES ('test02', 'テスト02', 'test02@example.com');

package com.example.demo;

import org.junit.jupiter.api.Test;
import org.mybatis.spring.boot.test.autoconfigure.MybatisTest;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ActiveProfiles;

import com.example.demo.dao.UserDao;
import com.example.demo.entity.User;

import static org.junit.jupiter.api.Assertions.assertEquals;
@MybatisTest
@ActiveProfiles("test")
class DemoApplicationTests {
	@Autowired
	private UserDao userDao;
	@Test
	void DB登録確認テスト(){
		final User act = userDao.findById("test01");
			assertEquals("test01",act.getUserid());
		
	}
}

INSERT INTO users(userid, name, email)
VALUES ('test01', 'テスト01', 'test01@example.com');

gradlew build jacocoTestReport