H2数据库的配置
# 配置数据源相关
# 使用H2数据库
# spring.datasource.platform=h2
# 指定生成数据库的schema文件位置
spring.datasource.schema=classpath:h2-schema.sql
# 指定插入数据库语句的脚本位置
spring.datasource.data=classpath:h2-data.sql
#spring.datasource.url=jdbc:h2:tcp://localhost/~/test
# 使用内存数据库，兼容sql server
spring.datasource.url=jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;MODE=MSSQLServer
spring.datasource.driver-class-name=org.h2.Driver
spring.datasource.username=sa
spring.datasource.password=
h2-schema.sql
drop table IF EXISTS logs_app ;
create table logs_app(id bigint auto_increment, log_file_name varchar(160), log_type smallint, log_path varchar(400), upload_time datetime, upload_ip varchar(50));
h2-data.sql
insert into logs_app(log_file_name, log_type, log_path, upload_time, upload_ip) values('001.txt', 1, '/a/2/3', '2022-03-22 14:14:37', '127.0.0.1');
insert into logs_app(log_file_name, log_type, log_path, upload_time, upload_ip) values('002.txt', 2, '/b/2/3', '2022-03-22 14:14:38', '127.0.0.1');
insert into logs_app(log_file_name, log_type, log_path, upload_time, upload_ip) values('003.txt', 3, '/c/2/3', '2022-03-22 14:14:39', '127.0.0.1');
单元测试用例
@Rollback 默认是true，点进去看一下就知道了
一定要加上@Transactional @Rollback这2个注解，否则单个运行测试没有问题，整个类里面的所有测试方法一起测试的时候会出问题(互相干扰)
@Transactional
@Rollback
@SpringBootTest
class LogInfoMapperTest {
@Autowired
private LogInfoMapper logInfoMapper;
@BeforeEach
void setUp() throws SQLException {
}
@AfterEach
void tearDown() {
}
@Test
void insertLogInfo() {
LogInfoApp logInfoApp = new LogInfoApp();
logInfoApp.setLogFileName("123.txt");
logInfoApp.setLogPath("/1/2/3");
logInfoApp.setLogType((short) 1);
logInfoApp.setUploadIp("127.0.0.1");
logInfoApp.setUploadTime(new Date());
boolean result = logInfoMapper.insertLogInfo(logInfoApp);
assertTrue(result);
}
@Test
void getLogInfoAppById() {
LogInfoApp logInfoApp = logInfoMapper.getLogInfoAppById((long) 1);
assertNotNull(logInfoApp);
assertEquals("001.txt", logInfoApp.getLogFileName());
}
@Test
void deleteLogInfo() {
boolean res = logInfoMapper.deleteLogInfo((long) 3);
assertTrue(res);
}
@Test
void deleteLogInfoFailure() {
boolean res = logInfoMapper.deleteLogInfo((long) 4);
assertFalse(res);
}
}
