private void setUpSchema() throws Exception {
        try (val con = testDataSource.getConnection()) {
            con.prepareStatement("CREATE TABLE user_table "
                + "(netid VARCHAR(100), "
                + "name VARCHAR(100), "
                + "email VARCHAR(100), "
                + "shirt_color VARCHAR(100))").execute();

            con.prepareStatement("INSERT INTO user_table "
                + "(netid, name, email, shirt_color) "
                + "VALUES ('awp9', 'Andrew', 'andrew.petro@yale.edu', 'blue')").execute();

            con.prepareStatement("INSERT INTO user_table "
                + "(netid, name, email, shirt_color) "
                + "VALUES ('edalquist', 'Eric', 'edalquist@unicon.net', 'blue')").execute();

            con.prepareStatement("INSERT INTO user_table "
                + "(netid, name, email, shirt_color) "
                + "VALUES ('atest', 'Andrew', 'andrew.test@test.net', 'red')").execute();

            con.prepareStatement("INSERT INTO user_table "
                + "(netid, name, email, shirt_color) "
                + "VALUES ('susan', 'Susan', 'susan.test@test.net', null)").execute();
        }
    }
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