public Object mapRow(ResultSet rs, int rowNum) throws SQLException { String tn = rs.getString("table_name"); String cn = rs.getString("column_name"); String dt = rs.getString("datatype"); String as = rs.getString("arraysize"); String xt = rs.getString("xtype"); log.debug("ColumnMapper: " + tn + "," + cn + "," + dt + "," + as + "," + xt); TapDataType datatype = new TapDataType(dt, as, xt); ColumnDesc col = new ColumnDesc(tn, cn, datatype); col.description = rs.getString("description"); col.utype = rs.getString("utype"); col.ucd = rs.getString("ucd"); col.unit = rs.getString("unit"); col.principal = intToBoolean(rs.getInt("principal")); col.indexed = intToBoolean(rs.getInt("indexed")); col.std = intToBoolean(rs.getInt("std")); col.id = rs.getString("id"); return col; }
/** * Convert a VOTable field into tap_schema column descriptor. * * @param tableName * @param field * @return */ public static ColumnDesc convert(String tableName, VOTableField field) { TapDataType dt = new TapDataType(field.getDatatype(), field.getArraysize(), field.xtype); ColumnDesc ret = new ColumnDesc(tableName, field.getName(), dt); ret.description = field.description; ret.id = field.id; ret.ucd = field.ucd; ret.unit = field.unit; ret.utype = field.utype; ret.indexed = false; ret.principal = false; ret.std = false; return ret; }
ColumnDesc newColumnDesc = new ColumnDesc(columnDesc.getTableName(), columnDesc.getColumnName(), columnDesc.getDatatype()); newTableDesc.getColumnDescs().add(newColumnDesc);
ColumnDesc cd = new ColumnDesc(tn, cn, tt); cd.description = ce.getChildTextTrim("description"); td.getColumnDescs().add(cd);