private void setUpSchema() throws Exception {
        try (val con = testDataSource.getConnection()) {
            con.prepareStatement("CREATE TABLE user_table "
                + "(netid VARCHAR(50), "
                + "attr_name VARCHAR(50), "
                + "attr_val VARCHAR(50))").execute();
            con.prepareStatement("INSERT INTO user_table "
                + "(netid, attr_name, attr_val) "
                + "VALUES ('awp9', 'name', 'Andrew')").execute();
            con.prepareStatement("INSERT INTO user_table "
                + "(netid, attr_name, attr_val) "
                + "VALUES ('awp9', 'email', 'andrew.petro@yale.edu')").execute();
            con.prepareStatement("INSERT INTO user_table "
                + "(netid, attr_name, attr_val) "
                + "VALUES ('awp9', 'shirt_color', 'blue')").execute();
            con.prepareStatement("INSERT INTO user_table "
                + "(netid, attr_name, attr_val) "
                + "VALUES ('edalquist', 'name', 'Eric')").execute();
            con.prepareStatement("INSERT INTO user_table "
                + "(netid, attr_name, attr_val) "
                + "VALUES ('edalquist', 'email', 'edalquist@unicon.net')").execute();
            con.prepareStatement("INSERT INTO user_table "
                + "(netid, attr_name, attr_val) "
                + "VALUES ('edalquist', 'shirt_color', 'blue')").execute();
            con.prepareStatement("INSERT INTO user_table "
                + "(netid, attr_name, attr_val) "
                + "VALUES ('atest', 'name', 'Andrew')").execute();
            con.prepareStatement("INSERT INTO user_table "
                + "(netid, attr_name, attr_val) "
                + "VALUES ('atest', 'email', 'andrew.test@test.net')").execute();
            con.prepareStatement("INSERT INTO user_table "
                + "(netid, attr_name, attr_val) "
                + "VALUES ('atest', 'shirt_color', 'red')").execute();
            con.prepareStatement("INSERT INTO user_table "
                + "(netid, attr_name, attr_val) "
                + "VALUES ('susan', 'name', 'Susan')").execute();
            con.prepareStatement("INSERT INTO user_table "
                + "(netid, attr_name, attr_val) "
                + "VALUES ('susan', 'email', 'susan.test@test.net')").execute();
            con.prepareStatement("INSERT INTO user_table "
                + "(netid, attr_name, attr_val) "
                + "VALUES ('susan', 'shirt_color', null)").execute();
        }
    }
Test the {@link MultiRowJdbcPersonAttributeDao} 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/MultiRowJdbcPersonAttributeDaoTests.java