@Override protected void geometryMappingSnippet( StringBuffer sql, GeometryMapping mapping, List<StringBuffer> ddls, TableName table ) { MappingExpression me = mapping.getMapping(); if ( me instanceof DBField ) { DBField dbField = (DBField) me; sql.append( ",\n " ); sql.append( dbField.getColumn() ); sql.append( " geometry" ); ddls.addAll( getGeometryCreate( mapping, (DBField) me, table ) ); } else { LOG.info( "Skipping geometry mapping -- not mapped to a db field. " ); } }
@Override protected void geometryMappingSnippet( StringBuffer sql, GeometryMapping mapping, List<StringBuffer> ddls, TableName table ) { MappingExpression me = mapping.getMapping(); if ( me instanceof DBField ) { DBField dbField = (DBField) me; sql.append( ",\n " ); sql.append( dbField.getColumn() ); sql.append( " sdo_geometry" ); ddls.addAll( getGeometryCreate( mapping, (DBField) me, table ) ); } else { LOG.info( "Skipping geometry mapping -- not mapped to a db field. " ); } }
@Override protected void featureMappingSnippet( StringBuffer sql, FeatureMapping mapping ) { SQLIdentifier col = mapping.getJoinedTable().get( mapping.getJoinedTable().size() - 1 ).getFromColumns().get( 0 ); if ( col != null ) { sql.append( ",\n " ); sql.append( col ); sql.append( " varchar(2000)" ); } MappingExpression hrefMe = mapping.getHrefMapping(); if ( hrefMe instanceof DBField ) { sql.append( ",\n " ); sql.append( ( (DBField) hrefMe ).getColumn() ); sql.append( " varchar(2000)" ); } }
@Override protected void featureMappingSnippet( StringBuffer sql, FeatureMapping mapping ) { SQLIdentifier col = mapping.getJoinedTable().get( mapping.getJoinedTable().size() - 1 ).getFromColumns().get( 0 ); if ( col != null ) { sql.append( ",\n " ); sql.append( col ); sql.append( " text" ); } MappingExpression hrefMe = mapping.getHrefMapping(); if ( hrefMe instanceof DBField ) { sql.append( ",\n " ); sql.append( ( (DBField) hrefMe ).getColumn() ); sql.append( " text" ); } }
@Override protected void featureMappingSnippet( StringBuffer sql, FeatureMapping mapping ) { SQLIdentifier col = mapping.getJoinedTable().get( mapping.getJoinedTable().size() - 1 ).getFromColumns().get( 0 ); if ( col != null ) { sql.append( ",\n " ); sql.append( col ); sql.append( " varchar(2000)" ); } MappingExpression hrefMe = mapping.getHrefMapping(); if ( hrefMe instanceof DBField ) { sql.append( ",\n " ); sql.append( ( (DBField) hrefMe ).getColumn() ); sql.append( " varchar(2000)" ); } }
private List<StringBuffer> getGeometryCreate( GeometryMapping mapping, DBField dbField, TableName table ) { List<StringBuffer> ddls = new ArrayList<StringBuffer>(); StringBuffer sql = new StringBuffer(); String schema = table.getSchema() == null ? "" : table.getSchema(); String column = dbField.getColumn(); String srid = mapping.getSrid(); // TODO String geometryType = "GEOMETRY"; int dim = 2; sql.append( "SELECT ADDGEOMETRYCOLUMN('" + schema.toLowerCase() + "', '" + table.getTable().toLowerCase() + "','" + column + "','" + srid + "','" + geometryType + "', " + dim + ")" ); ddls.add( sql ); return ddls; }
@Override protected void primitiveMappingSnippet( StringBuffer sql, PrimitiveMapping mapping ) { MappingExpression me = mapping.getMapping(); if ( me instanceof DBField ) { DBField dbField = (DBField) me; sql.append( ",\n " ); sql.append( dbField.getColumn() ); sql.append( " " ); sql.append( getDBType( mapping.getType().getBaseType() ) ); } }
@Override protected void primitiveMappingSnippet( StringBuffer sql, PrimitiveMapping mapping ) { MappingExpression me = mapping.getMapping(); if ( me instanceof DBField ) { DBField dbField = (DBField) me; sql.append( ",\n " ); sql.append( dbField.getColumn() ); sql.append( " " ); sql.append( getDBType( mapping.getType().getBaseType() ) ); } }
@Override protected void primitiveMappingSnippet( StringBuffer sql, PrimitiveMapping mapping ) { MappingExpression me = mapping.getMapping(); if ( me instanceof DBField ) { DBField dbField = (DBField) me; sql.append( ",\n " ); sql.append( dbField.getColumn() ); sql.append( " " ); sql.append( getDBType( mapping.getType().getBaseType() ) ); } }
private List<StringBuffer> getGeometryCreate( GeometryMapping mapping, DBField dbField, TableName table ) { List<StringBuffer> ddls = new ArrayList<StringBuffer>(); String schema = table.getSchema() == null ? "" : table.getSchema(); String column = dbField.getColumn(); String srid = mapping.getSrid(); double[] dom = mapping.getCRS().getValidDomain(); StringBuffer sql = new StringBuffer(); sql.append( "INSERT INTO user_sdo_geom_metadata(TABLE_NAME,COLUMN_NAME,DIMINFO,SRID) VALUES (" + "'" + table.toString().toUpperCase() + "','" + column.toUpperCase() + "',SDO_DIM_ARRAY(" + "SDO_DIM_ELEMENT('X', " + dom[0] + ", " + dom[2] + ", 0.00000005), SDO_DIM_ELEMENT('Y', " + dom[1] + ", " + dom[3] + ", 0.00000005)), null)" ); ddls.add( sql ); sql = new StringBuffer(); sql.append( "CREATE INDEX " + table.getTable().toUpperCase() + "_" + column.toUpperCase() + " ON " + table.toString().toUpperCase() + "(" + column.toUpperCase() + ") INDEXTYPE IS MDSYS.SPATIAL_INDEX" ); ddls.add( sql ); return ddls; }
private void map( PrimitiveMapping mapping, List<MappableStep> remaining ) throws UnmappableException { final PrimitiveMapping primMapping = mapping; final MappingExpression me = primMapping.getMapping(); ParticleConverter<?> converter = null; if ( fs != null ) { converter = fs.getConverter( primMapping ); } if ( !( me instanceof DBField ) ) { final String qualifiedExpr = me.toString().replace( "$0", currentTableAlias ); propMapping = new PropertyNameMapping( converter, joins, qualifiedExpr, null ); return; } propMapping = new PropertyNameMapping( converter, joins, ( (DBField) me ).getColumn(), currentTableAlias ); }
return null; column = ( (DBField) me ).getColumn();
private void map( GeometryMapping mapping, List<MappableStep> remaining ) throws UnmappableException { GeometryMapping geomMapping = mapping; MappingExpression me = geomMapping.getMapping(); if ( !( me instanceof DBField ) ) { throw new UnmappableException( "Mappings to non-DBField geometries is currently not supported." ); } ParticleConverter<?> converter = null; if ( fs != null ) { converter = fs.getConverter( geomMapping ); } propMapping = new PropertyNameMapping( converter, joins, ( (DBField) me ).getColumn(), currentTableAlias ); }
MappingExpression mapping = pm.getMapping(); if ( mapping instanceof DBField ) { writer.writeAttribute( "mapping", ( (DBField) mapping ).getColumn() ); } else { writer.writeAttribute( "mapping", mapping.toString() );
PrimitiveValue primitiveValue = getPrimitiveValue( value ); if ( primitiveValue != null ) { String column = ( (DBField) me ).getColumn(); currentRow.addPreparedArgument( column, primitiveValue, converter ); @SuppressWarnings("unchecked") ParticleConverter<Geometry> converter = (ParticleConverter<Geometry>) fs.getConverter( mapping ); String column = ( (DBField) me ).getColumn(); currentRow.addPreparedArgument( column, geom, converter ); LOG.debug( "Skipping feature mapping (href). Not mapped to database column." ); } else { String column = ( (DBField) me ).getColumn(); row.addPreparedArgument( column, href );
+ "'. Currently, only DBFields are supported in table-driven mode." ); String columnName = ( (DBField) mapping ).getColumn(); if ( propName == null ) { LOG.debug( "Using column name for property name." );
+ "'. Currently, only DBFields are supported." ); String columnName = ( (DBField) mapping ).getColumn(); if ( propName == null ) { LOG.debug( "Using column name for property name." );