protected String getRecordLine(int recordNum, ColumnGenerator... extraCols) { String idStr = Integer.toString(recordNum); StringBuilder sb = new StringBuilder(); sb.append(idStr); sb.append("\t"); sb.append(getMsgPrefix()); sb.append(idStr); for (ColumnGenerator gen : extraCols) { sb.append("\t"); sb.append(gen.getExportText(recordNum)); } sb.append("\n"); return sb.toString(); }
int colNum = 0; for (ColumnGenerator gen : extraCols) { sb.append(", col").append(colNum++).append(' ').append(gen.getType());
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)); } } }
int colNum = 0; for (ColumnGenerator gen : extraColumns) { sb.append(", \"" + forIdx(colNum++) + "\" " + gen.getType());
int colNum = 0; for (ColumnGenerator gen : extraColumns) { sb.append(", \"" + forIdx(colNum++) + "\" " + gen.getType());
/** 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); }
@Override public void createTable(ColumnGenerator... extraColumns) throws SQLException { super.createTable(extraColumns); names = new String[extraColumns.length]; types = new String[extraColumns.length]; for (int i = 0; i < extraColumns.length; ++i) { names[i] = forIdx(i); types[i] = extraColumns[i].getType(); } createProcedure(names, types); }