private void verifyTableColumnContents(Connection connection, String table, String column, ColumnGenerator gen) throws IOException, SQLException { Statement st = connection.createStatement(); // create a target database table. assertTrue(st.execute("SELECT " + column + " FROM " + table)); ResultSet rs = st.getResultSet(); for (int row = 0; rs.next(); ++row) { assertEquals(gen.getVerifyText(row), rs.getString(1)); } } }
/** Verify that for the max and min values of the 'id' column, the values for a given column meet the expected values. */ protected void assertColMinAndMax(String colName, ColumnGenerator generator) throws SQLException { Connection conn = getConnection(); int minId = getMinRowId(conn); int maxId = getMaxRowId(conn); LOG.info("Checking min/max for column " + colName + " with type " + generator.getType()); String expectedMin = generator.getVerifyText(minId); String expectedMax = generator.getVerifyText(maxId); assertColValForRowId(minId, colName, expectedMin); assertColValForRowId(maxId, colName, expectedMax); }