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.Locale;

import static org.junit.Assert.assertTrue;

public class ElnDianziJiluMubanMapperTest {

    @Test
    public void querySelectsLatestAvailableTemplateWithinTenant() throws Exception {
        Method method = ElnDianziJiluMubanMapper.class.getMethod(
                "selectLatestMubanFiles", 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_dianzi_jilu_muban_guanli"));
        assertTrue(sql.contains("f_tenant_id = #{tenantid}"));
        assertTrue(sql.contains("jianyan_xiangmu = #{jianyanxiangmu}"));
        assertTrue(sql.contains("coalesce(f_delete_mark, 0) = 0"));
        assertTrue(sql.contains("biz_enabled = 'enabled'"));
        assertTrue(sql.contains("shengxiao_riqi <= current_timestamp"));
        assertTrue(sql.contains("trim(muban_file) <> ''"));
        assertTrue(sql.contains("order by shengxiao_riqi desc"));
        assertTrue(sql.contains("chuangjian_shijian desc"));
        assertTrue(sql.contains("f_id desc"));
        assertTrue("分页应交给 MyBatis-Plus 根据数据库方言生成", !sql.contains("limit"));
    }
}