package jnpf.dmsMapper;

import org.apache.ibatis.mapping.MappedStatement;
import org.apache.ibatis.session.Configuration;
import org.junit.jupiter.api.Test;

import java.util.HashMap;
import java.util.Map;

import static org.junit.jupiter.api.Assertions.assertTrue;

class DmsPrintOperationLogMapperSqlTest {

    @Test
    void parentNameRequiresClosestMarkedAncestorOfEntryMenu() {
        Configuration configuration = new Configuration();
        configuration.addMapper(DmsPrintOperationLogMapper.class);
        MappedStatement statement = configuration.getMappedStatement(
                DmsPrintOperationLogMapper.class.getName() + ".selectParentBizModuleName");
        Map<String, Object> parameters = new HashMap<>();
        parameters.put("menuId", "menu-1");
        parameters.put("parentId", "parent-1");
        String sql = statement.getBoundSql(parameters).getSql().replaceAll("\\s+", " ");

        assertTrue(sql.contains("WITH RECURSIVE ancestors"));
        assertTrue(sql.contains("parent.f_id = child.f_parent_id"));
        assertTrue(sql.contains("parent.f_system_id = child.f_system_id"));
        assertTrue(sql.contains("parent.f_category = child.f_category"));
        assertTrue(sql.contains("f_type = 1 AND f_is_parent_biz_module = 1"));
        assertTrue(sql.contains("f_id = ? AND depth = (SELECT MIN(depth)"));
    }
}