@Test
    void testNullAttrQuery() {
        val impl = new SingleRowJdbcPersonAttributeDao(testDataSource, "SELECT name, email, shirt_color FROM user_table WHERE {0}");
        impl.setQueryAttributeMapping(Map.of("uid", "netid"));
        impl.setUsernameAttributeProvider(new SimpleUsernameAttributeProvider("uid"));
        val columnsToAttributes = new HashMap<String, Object>();
        columnsToAttributes.put("name", "firstName");
        columnsToAttributes.put("shirt_color", "dressShirtColor");
        impl.setResultAttributeMapping(columnsToAttributes);

        val attribs = impl.getPerson("susan").getAttributes();
        assertNull(attribs.get("dressShirtColor"));
        assertEquals(List.of("Susan"), attribs.get("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