package jnpf.dmsMapper;
|
|
import org.apache.ibatis.builder.xml.XMLMapperBuilder;
|
import org.apache.ibatis.io.Resources;
|
import org.apache.ibatis.mapping.MappedStatement;
|
import org.apache.ibatis.session.Configuration;
|
import org.junit.jupiter.api.Test;
|
|
import java.io.InputStream;
|
import java.util.Arrays;
|
import java.util.HashMap;
|
import java.util.Map;
|
|
import static org.junit.jupiter.api.Assertions.*;
|
|
class DmsWenjianGuidangMapperXmlTest {
|
private Configuration parse() throws Exception {
|
Configuration configuration = new Configuration();
|
String resource = "mapper/DmsWenjianGuidangMapper.xml";
|
try (InputStream in = Resources.getResourceAsStream(resource)) {
|
new XMLMapperBuilder(in, configuration, resource, configuration.getSqlFragments()).parse();
|
}
|
return configuration;
|
}
|
|
@Test
|
void conflictsMatchNativeSerialsAndPreviouslySavedIdsWithinTenant() throws Exception {
|
MappedStatement statement = parse().getMappedStatement(
|
DmsWenjianGuidangMapper.class.getName() + ".selectConflicts");
|
Map<String, Object> params = new HashMap<>();
|
params.put("ids", Arrays.asList("copy-1"));
|
params.put("shenqingId", "current-application");
|
String sql = statement.getBoundSql(params).getSql().replaceAll("\\s+", " ");
|
assertFalse(statement.getResultMaps().get(0).getAutoMapping());
|
assertTrue(sql.contains("p.f_tenant_id = g.f_tenant_id"));
|
assertTrue(sql.contains("g.wenjian_liushui_id = p.dayin_liushuihao"));
|
assertTrue(sql.contains("g.wenjian_liushui_id = p.f_id"));
|
assertTrue(sql.contains("p.f_id IN"));
|
assertTrue(sql.contains("s.f_id != ?"));
|
assertTrue(sql.contains("NOT IN (3, 4, 7, 9)"));
|
assertTrue(sql.contains("p.f_delete_mark IS NULL"));
|
}
|
|
@Test
|
void confirmationStillUsesTenantAndExpectedStatus() throws Exception {
|
Map<String, Object> params = new HashMap<>();
|
params.put("ids", Arrays.asList("copy-1"));
|
String sql = parse().getMappedStatement(DmsWenjianGuidangMapper.class.getName() + ".changeStatus")
|
.getBoundSql(params).getSql().replaceAll("\\s+", " ");
|
assertTrue(sql.contains("f_tenant_id = ?"));
|
assertTrue(sql.contains("AND biz_status = ? AND f_id IN"));
|
assertTrue(sql.contains("f_delete_mark IS NULL"));
|
}
|
}
|
