@Test
    void testMultiAttrQuery() {
        val queryAttributeMapping = new LinkedHashMap<String, String>();
        queryAttributeMapping.put("uid", "netid");
        queryAttributeMapping.put("shirtColor", "shirt_color");

        val impl = new SingleRowJdbcPersonAttributeDao(testDataSource, "SELECT name, email FROM user_table WHERE {0}");
        impl.setQueryAttributeMapping(queryAttributeMapping);

        val columnsToAttributes = new HashMap<String, Object>();
        columnsToAttributes.put("name", "firstName");

        val emailAttributeNames = new HashSet<String>();
        emailAttributeNames.add("email");
        emailAttributeNames.add("emailAddress");
        columnsToAttributes.put("email", emailAttributeNames);
        impl.setResultAttributeMapping(columnsToAttributes);

        val queryMap = new HashMap<String, List<Object>>();
        queryMap.put("uid", List.of("awp9"));
        queryMap.put("shirtColor", List.of("blue"));
        queryMap.put("Name", List.of("John"));

        val attribsSet = impl.getPeopleWithMultivaluedAttributes(queryMap);
        assertNotNull(attribsSet);
        val attribs = attribsSet.iterator().next();
        assertEquals(List.of("andrew.petro@yale.edu"), attribs.getAttributes().get("email"));
        assertEquals(List.of("andrew.petro@yale.edu"), attribs.getAttributes().get("emailAddress"));
        assertEquals(List.of("Andrew"), attribs.getAttributeValues("firstName"));
    }
Test the {@link SingleRowJdbcPersonAttributeDao} against a dummy DataSource.

@author andrew.petro@yale.edu
@author Eric Dalquist
@since 7.1.0
support/cas-server-support-jdbc-authentication/src/test/java/org/apereo/cas/jdbc/SingleRowJdbcPersonAttributeDaoTests.java