package jnpf.dmsMapper;

import org.apache.ibatis.builder.xml.XMLMapperBuilder;
import org.apache.ibatis.mapping.BoundSql;
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.Collections;

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

class DmsPermissionGroupDisplayMapperTest {
    private MappedStatement statement() throws Exception {
        Configuration configuration = new Configuration();
        String resource = "mapper/DmsPermissionGroupMapper.xml";
        try (InputStream stream = getClass().getClassLoader().getResourceAsStream(resource)) {
            assertNotNull(stream);
            new XMLMapperBuilder(stream, configuration, resource, configuration.getSqlFragments()).parse();
        }
        return configuration.getMappedStatement("jnpf.dmsMapper.DmsPermissionGroupMapper.selectDisplayByIds");
    }

    @Test
    void bindsIdsAndMapsNamesWithoutHidingDisabledHistoricalGroups() throws Exception {
        MappedStatement statement = statement();
        BoundSql bound = statement.getBoundSql(Collections.singletonMap("ids", Arrays.asList("group-1", "group-2")));
        String sql = bound.getSql().replaceAll("\\s+", " ");
        assertTrue(sql.contains("FROM base_permission_group"));
        assertTrue(sql.contains("f_delete_mark IS NULL"));
        assertTrue(sql.contains("f_id IN"));
        assertFalse(sql.contains("enabled_mark"));
        assertFalse(sql.contains("group-1"));
        assertEquals(2, bound.getParameterMappings().size());
        assertEquals("group-1", bound.getAdditionalParameter(bound.getParameterMappings().get(0).getProperty()));
        assertEquals("group-2", bound.getAdditionalParameter(bound.getParameterMappings().get(1).getProperty()));
        assertTrue(statement.getResultMaps().get(0).getResultMappings().stream()
                .anyMatch(mapping -> "id".equals(mapping.getProperty()) && "f_id".equals(mapping.getColumn())));
        assertTrue(statement.getResultMaps().get(0).getResultMappings().stream()
                .anyMatch(mapping -> "fullName".equals(mapping.getProperty()) && "f_full_name".equals(mapping.getColumn())));
    }

    @Test
    void emptyOrNullIdsCannotQueryAllGroups() throws Exception {
        MappedStatement statement = statement();
        assertTrue(statement.getBoundSql(Collections.singletonMap("ids", Collections.emptyList())).getSql().contains("1 = 0"));
        assertTrue(statement.getBoundSql(Collections.singletonMap("ids", null)).getSql().contains("1 = 0"));
    }
}