package jnpf.elnMapper;
|
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import org.apache.ibatis.annotations.Select;
|
import org.junit.Test;
|
|
import java.lang.reflect.Method;
|
import java.util.List;
|
import java.util.Locale;
|
|
import static org.junit.Assert.assertFalse;
|
import static org.junit.Assert.assertTrue;
|
|
public class ElnTemplateMapperTest {
|
|
@Test
|
public void querySelectsCurrentAvailableTemplateWithinTenant() throws Exception {
|
Method method = ElnTemplateMapper.class.getMethod(
|
"selectLatestTemplateFiles", IPage.class, String.class, String.class);
|
Select select = method.getAnnotation(Select.class);
|
assertTrue("查询方法必须声明 @Select", select != null);
|
String sql = String.join(" ", select.value()).toLowerCase(Locale.ROOT)
|
.replaceAll("\\s+", " ");
|
|
assertTrue(sql.contains("from eln_template_current_version c"));
|
assertTrue(sql.contains("join eln_template m"));
|
assertTrue(sql.contains("m.f_tenant_id = c.f_tenant_id"));
|
assertTrue(sql.contains("m.f_id = c.dangqian_muban_id"));
|
assertTrue(sql.contains("c.f_tenant_id = #{tenantid}"));
|
assertTrue(sql.contains("m.jianyan_xiangmu = #{jianyanxiangmu}"));
|
assertTrue(sql.contains("m.biz_status = 'published'"));
|
assertTrue(sql.contains("m.biz_enabled = 'enabled'"));
|
assertTrue(sql.contains("m.shengxiao_riqi <= current_timestamp"));
|
assertTrue(sql.contains("coalesce(m.f_delete_mark, 0) = 0"));
|
assertFalse(sql.contains("order by"));
|
assertTrue("分页应交给 MyBatis-Plus 根据数据库方言生成", !sql.contains("limit"));
|
}
|
|
@Test
|
public void codeQuerySelectsCurrentAvailableTemplateWithinTenant() throws Exception {
|
Method method = ElnTemplateMapper.class.getMethod(
|
"selectLatestTemplateFilesByTestDefinitionCode",
|
IPage.class, String.class, String.class);
|
Select select = method.getAnnotation(Select.class);
|
assertTrue("查询方法必须声明 @Select", select != null);
|
String sql = String.join(" ", select.value()).toLowerCase(Locale.ROOT)
|
.replaceAll("\\s+", " ");
|
|
assertTrue(sql.contains("from eln_template_current_version c"));
|
assertTrue(sql.contains("join eln_template m"));
|
assertTrue(sql.contains("c.f_tenant_id = #{tenantid}"));
|
assertTrue(sql.contains(
|
"m.jianyan_xiangmu_bianma = #{testdefinitioncode}"));
|
assertTrue(sql.contains("m.biz_status = 'published'"));
|
assertTrue(sql.contains("m.biz_enabled = 'enabled'"));
|
assertTrue(sql.contains("coalesce(c.f_delete_mark, 0) = 0"));
|
assertTrue(sql.contains("coalesce(m.f_delete_mark, 0) = 0"));
|
assertFalse(sql.contains("order by"));
|
assertFalse(sql.contains("limit"));
|
}
|
|
@Test
|
public void recordCreationQueryMatchesCurrentTemplateByProjectCode() throws Exception {
|
Method method = ElnTemplateMapper.class.getMethod(
|
"selectCurrentPublishedByTestDefinition", String.class, String.class);
|
Select select = method.getAnnotation(Select.class);
|
String sql = String.join(" ", select.value()).toLowerCase(Locale.ROOT)
|
.replaceAll("\\s+", " ");
|
|
assertTrue(sql.contains(
|
"m.jianyan_xiangmu_bianma = #{testdefinitioncode}"));
|
assertFalse(sql.contains("m.jianyan_xiangmu = #{testdefinitionid}"));
|
}
|
|
@Test
|
public void queryResolvesTemplateCategoriesWithinTenant() throws Exception {
|
Method method = ElnTemplateMapper.class.getMethod(
|
"selectTemplateCategories", String.class, List.class);
|
Select select = method.getAnnotation(Select.class);
|
assertTrue("查询方法必须声明 @Select", select != null);
|
String sql = String.join(" ", select.value()).toLowerCase(Locale.ROOT)
|
.replaceAll("\\s+", " ");
|
|
assertTrue(sql.contains("from eln_template_category"));
|
assertTrue(sql.contains("f_tenant_id = #{tenantid}"));
|
assertTrue(sql.contains("coalesce(f_delete_mark, 0) = 0"));
|
assertTrue(sql.contains("f_id in"));
|
}
|
|
@Test
|
public void latestTemplateCodeQueryGroupsBeforeDialectPagination() throws Exception {
|
Method method = ElnTemplateMapper.class.getMethod(
|
"selectLatestTemplateCodes", IPage.class, String.class,
|
String.class, String.class, String.class, String.class, String.class);
|
Select select = method.getAnnotation(Select.class);
|
assertTrue("查询方法必须声明 @Select", select != null);
|
String sql = String.join(" ", select.value()).toLowerCase(Locale.ROOT)
|
.replaceAll("\\s+", " ");
|
|
assertTrue(sql.contains("from eln_template m"));
|
assertTrue(sql.contains("m.f_tenant_id = #{tenantid}"));
|
assertTrue(sql.contains("coalesce(m.f_delete_mark, 0) = 0"));
|
assertTrue(sql.contains("<if test='mubanfenlei != null'>"));
|
assertTrue(sql.contains("m.muban_fenlei = #{mubanfenlei}"));
|
assertTrue(sql.contains("m.jianyan_xiangmu_mingcheng like #{keywordpattern}"));
|
assertTrue(sql.contains("group by m.muban_bianhao"));
|
assertTrue(sql.contains(
|
"case when max(coalesce(m.chuangjian_shijian, m.f_creator_time)) "
|
+ "is null then 1 else 0 end asc"));
|
assertTrue(sql.contains(
|
"max(coalesce(m.chuangjian_shijian, m.f_creator_time)) desc"));
|
assertFalse(sql.contains("f_last_modify_time"));
|
assertTrue(sql.contains("max(m.f_id) desc"));
|
assertFalse(sql.contains("limit"));
|
}
|
|
@Test
|
public void directoryQueryKeepsTemplatesWithoutCurrentVersionAndGroupsBeforePagination()
|
throws Exception {
|
Method method = ElnTemplateMapper.class.getMethod(
|
"selectTemplateDirectory", IPage.class, String.class,
|
String.class, String.class, String.class, String.class, String.class);
|
Select select = method.getAnnotation(Select.class);
|
assertTrue("查询方法必须声明 @Select", select != null);
|
String sql = String.join(" ", select.value()).toLowerCase(Locale.ROOT)
|
.replaceAll("\\s+", " ");
|
|
assertTrue(sql.contains("from eln_template m"));
|
assertTrue(sql.contains("left join eln_template_current_version c"));
|
assertTrue(sql.contains("left join eln_template e"));
|
assertTrue(sql.contains("c.f_tenant_id = m.f_tenant_id"));
|
assertTrue(sql.contains("c.muban_bianhao = m.muban_bianhao"));
|
assertTrue(sql.contains("coalesce(c.f_delete_mark, 0) = 0"));
|
assertTrue(sql.contains("e.f_id = c.dangqian_muban_id"));
|
assertTrue(sql.contains("e.muban_bianhao = m.muban_bianhao"));
|
assertTrue(sql.contains("coalesce(e.f_delete_mark, 0) = 0"));
|
assertTrue(sql.contains("e.f_id as shengxiaomubanid"));
|
assertTrue(sql.contains("e.muban_banben as shengxiaomubanbanben"));
|
assertTrue(sql.contains("<if test='bizstatus != null'>"));
|
assertTrue(sql.contains("e.biz_status = #{bizstatus}"));
|
assertTrue(sql.contains("<if test='bizenabled != null'>"));
|
assertTrue(sql.contains("e.biz_enabled = #{bizenabled}"));
|
assertTrue(sql.contains("group by m.muban_bianhao"));
|
assertFalse(sql.contains("limit"));
|
}
|
}
|
