use of eu.esdihumboldt.hale.io.jdbc.extension.internal.CustomType in project hale by halestudio.
the class JDBCSchemaReader method getOrCreateColumnType.
/**
* Get or create the type definition for the given column.
*
* @param column the column
* @param overallNamespace the database namespace
* @param types the type index
* @param connection the database connection
* @param tableType the type definition of the table the column is part of
* @param reporter the reporter
* @param catalog the catalog for access to other column types
* @return the type definition for the column type
*/
public static TypeDefinition getOrCreateColumnType(BaseColumn<?> column, final String overallNamespace, DefaultSchema types, Connection connection, TypeDefinition tableType, IOReporter reporter, Catalog catalog) {
// XXX what about shared types?
// TODO the size/width info (VARCHAR(_30_)) is in column, the
// columntype/-name is not sufficient
// getType();
ColumnDataType columnType = column.getColumnDataType();
String localName = columnType.getName();
QName typeName = new QName(overallNamespace, localName);
// check for geometry type
GeometryTypeInfo geomType = GeometryTypeExtension.getInstance().getTypeInfo(columnType.getName(), connection);
@SuppressWarnings("rawtypes") GeometryAdvisor geomAdvisor = null;
if (geomType != null) {
geomAdvisor = geomType.getGeometryAdvisor();
// determine if a type specifically for this column is needed
if (!geomAdvisor.isFixedType(columnType)) {
// must use a specific type definition for this column
// -> use a type name based on the column
// new namespace is the table and column name
String ns = tableType.getName().getNamespaceURI() + '/' + tableType.getName().getLocalPart() + '/' + unquote(column.getName());
typeName = new QName(ns, localName);
}
}
// check for existing type
TypeDefinition existing = types.getType(typeName);
if (existing != null)
return existing;
// create new type
DefaultTypeDefinition type = new DefaultTypeDefinition(typeName);
type.setConstraint(HasValueFlag.ENABLED);
CustomType cust = CustomTypeExtension.getInstance().getCustomType(localName, connection);
/*
* Oracle jdbc was returning sqltype -6 for NUMBER data type, but it is
* bound to boolean by Types.java class. Configured the sqltype 6 for
* NUMBER data type.
*/
if (cust != null) {
type.setConstraint(SQLType.get(cust.getSQLType()));
} else {
type.setConstraint(SQLType.get(columnType.getJavaSqlType().getJavaSqlType()));
}
if (geomType != null && geomAdvisor != null) {
// configure geometry type
@SuppressWarnings("unchecked") Class<? extends Geometry> geomClass = geomAdvisor.configureGeometryColumnType(connection, column, type);
type.setConstraint(GeometryType.get(geomClass));
// always a single geometry
type.setConstraint(Binding.get(GeometryProperty.class));
// remember advisor for type (used in instance writer)
type.setConstraint(geomType.getConstraint());
} else {
// configure type
Class<?> binding = null;
if (cust != null) {
binding = cust.getBinding();
} else {
if (column.getColumnDataType().getJavaSqlType().getJavaSqlType() == Types.ARRAY) {
// TODO let this be handled by a possible advisor?
/*
* Special handling for arrays.
*
* Challenges:
*
* - find the type of contained items
*
* - determine dimensions and size
*/
Class<?> elementBinding;
// determine type/binding of contained items
ColumnDataType cdt = column.getColumnDataType();
ColumnDataType itemType = null;
String dbTypeName = cdt.getDatabaseSpecificTypeName();
// prefix and look up type
if (dbTypeName.startsWith("_")) {
String testName = dbTypeName.substring(1);
itemType = catalog.getSystemColumnDataType(testName);
}
if (itemType == null) {
// generic binding
elementBinding = Object.class;
reporter.error(new IOMessageImpl("Could not determine element type for array column", null));
} else {
elementBinding = itemType.getTypeMappedClass();
// TODO support custom bindings?
// XXX probably needed for Oracle?
}
// dimensions and size cannot be determined from schema
// crawler it seems - would need database specific queries
// (if the info is available at all)
/*
* Postgres:
*
* Dimensions and size are not part of the schema, they can
* only be determined for a value.
*/
// XXX for now, stick to what we can determine
int dimension = SQLArray.UNKNOWN_DIMENSION;
String specificTypeName = (itemType != null) ? (itemType.getDatabaseSpecificTypeName()) : (null);
type.setConstraint(new SQLArray(elementBinding, specificTypeName, dimension, null));
// set binding
if (dimension <= 1) {
// XXX for now, use this representation also if
// dimension is not known
// 1-dimensional -> as multiple occurrences
binding = elementBinding;
} else {
// XXX use collection or something similar instead?
binding = Object.class;
}
} else {
binding = column.getColumnDataType().getTypeMappedClass();
}
}
type.setConstraint(Binding.get(binding));
type.setConstraint(HasValueFlag.ENABLED);
}
if (columnType.getRemarks() != null && !columnType.getRemarks().isEmpty())
type.setDescription(columnType.getRemarks());
types.addType(type);
return type;
}
Aggregations