@Test
    void testMultiPersonQuery() {
        val impl = new SingleRowJdbcPersonAttributeDao(testDataSource, "SELECT netid, name, email FROM user_table WHERE {0}");
        impl.setQueryAttributeMapping(Map.of("shirt", "shirt_color"));
        impl.setUsernameAttributeProvider(new SimpleUsernameAttributeProvider("uid"));

        val columnsToAttributes = new HashMap<String, Object>();
        columnsToAttributes.put("netid", "uid");
        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("shirt", List.of("blue"));

        val results = impl.getPeopleWithMultivaluedAttributes(queryMap);
        if (results.size() <= 1) {
            fail("Repository should have returned multiple people in the set");
        }

    }
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