@Override public DefaultColumnInfo map(final int index, final ResultSet r, final StatementContext ctx) throws SQLException { final String tableName = r.getString("table_name"); final String columnName = r.getString("column_name"); final Integer scale = r.getInt("numeric_scale"); final Integer precision = r.getInt("numeric_precision"); final boolean isNullable = r.getBoolean("is_nullable"); final Integer maximumLength = r.getInt("character_maximum_length"); final String dataType = r.getString("data_type"); return new DefaultColumnInfo(tableName, columnName, scale, precision, isNullable, maximumLength, dataType); } }
out.newTable(tableName, ImmutableList.<ColumnInfo>of( new DefaultColumnInfo(tableName, "first_name", 0, 0, true, 0, "varchar"), new DefaultColumnInfo(tableName, "last_name", 0, 0, true, 0, "varchar"), new DefaultColumnInfo(tableName, "age", 0, 0, true, 0, "tinyint")) );