|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
ObjectFilterToSQL
SQLEncoderDB2
public class SQLEncoderDB2
Generate a WHERE clause for DB2 Spatial Extender based on a spatial filter.
The following spatial filter operations are supported:
modules/plugin/db2 (gt-db2.jar)
Field Summary |
---|
Fields inherited from class FilterToSQL |
---|
capabilities, encodingFunction, featureType, IO_ERROR, mapper, out |
Constructor Summary | |
---|---|
SQLEncoderDB2()
Construct an SQLEncoderDB2 |
Method Summary | |
---|---|
protected void |
addSelectivity()
|
protected FilterCapabilities |
createFilterCapabilities()
Sets the DB2 filter capabilities. |
String |
db2Geom(Geometry geom)
Construct a geometry from the WKT representation of a geometry |
HashMap |
getPredicateMap()
|
void |
setSelectivityClause(String string)
Sets a SELECTIVITY clause that can be included with the spatial predicate to influence the query optimizer to exploit a spatial index if it exists. |
void |
setSRID(int srid)
Set the value of the srid value to be used if a DB2 Spatial Extender geometry needs to be constructed. |
Object |
visit(BBOX filter,
Object extraData)
|
Object |
visit(Beyond filter,
Object extraData)
|
Object |
visit(Contains filter,
Object extraData)
|
Object |
visit(Crosses filter,
Object extraData)
|
Object |
visit(Disjoint filter,
Object extraData)
|
Object |
visit(DWithin filter,
Object extraData)
|
Object |
visit(Equals filter,
Object extraData)
|
Object |
visit(ExcludeFilter filter,
Object extraData)
|
Object |
visit(Id filter,
Object extraData)
Encodes an FidFilter. |
Object |
visit(IncludeFilter filter,
Object extraData)
|
Object |
visit(Intersects filter,
Object extraData)
|
Object |
visit(Overlaps filter,
Object extraData)
|
Object |
visit(Touches filter,
Object extraData)
|
Object |
visit(Within filter,
Object extraData)
|
protected Object |
visitBinarySpatialOperator(BinarySpatialOperator filter,
Object extraData)
|
protected Object |
visitBinarySpatialOperator(BinarySpatialOperator filter,
Object extraData,
String db2Predicate)
|
void |
visitLiteralGeometry(Literal expression)
Construct the appropriate geometry type from the WKT representation of a literal expression |
Methods inherited from class FilterToSQL |
---|
encode, encode, encodeToString, encodeToString, escapeName, evaluateLiteral, getCapabilities, getFIDMapper, setCapabilities, setFeatureType, setFIDMapper, setSqlNameEscape, setWriter, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visit, visitBinaryComparisonOperator, visitNullFilter, writeLiteral |
Methods inherited from class Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public SQLEncoderDB2()
Method Detail |
---|
public HashMap getPredicateMap()
public String db2Geom(Geometry geom)
geom
- the constructor for the geometry.public void setSRID(int srid)
This is specifically the DB2 Spatial Extender spatial reference system identifier and not a coordinate system identifier ala EPSG.
srid
- Spatial reference system identifier to be used.protected FilterCapabilities createFilterCapabilities()
createFilterCapabilities
in class FilterToSQL
public void setSelectivityClause(String string)
The parameter should be of the form:
"SELECTIVITY 0.001"
where the numeric value is the fraction of rows that will be returned
by using the index scan. This doesn't have to be true. The value
0.001 is typically used to force the use of the spatial in all cases if
the spatial index exists.
string
- a selectivity clausepublic Object visit(Id filter, Object extraData)
visit
in interface FilterVisitor
visit
in class FilterToSQL
filter
-
RuntimeException
- DOCUMENT ME!SQLEncoder.visit(org.geotools.filter.FidFilter)
public Object visit(DWithin filter, Object extraData)
visit
in interface FilterVisitor
visit
in class FilterToSQL
public Object visit(Beyond filter, Object extraData)
visit
in interface FilterVisitor
visit
in class FilterToSQL
protected Object visitBinarySpatialOperator(BinarySpatialOperator filter, Object extraData)
visitBinarySpatialOperator
in class FilterToSQL
FilterVisitor#visit()}
protected Object visitBinarySpatialOperator(BinarySpatialOperator filter, Object extraData, String db2Predicate)
public Object visit(BBOX filter, Object extraData)
visit
in interface FilterVisitor
visit
in class FilterToSQL
public Object visit(Contains filter, Object extraData)
visit
in interface FilterVisitor
visit
in class FilterToSQL
public Object visit(Crosses filter, Object extraData)
visit
in interface FilterVisitor
visit
in class FilterToSQL
public Object visit(Disjoint filter, Object extraData)
visit
in interface FilterVisitor
visit
in class FilterToSQL
public Object visit(Equals filter, Object extraData)
visit
in interface FilterVisitor
visit
in class FilterToSQL
public Object visit(Intersects filter, Object extraData)
visit
in interface FilterVisitor
visit
in class FilterToSQL
public Object visit(Overlaps filter, Object extraData)
visit
in interface FilterVisitor
visit
in class FilterToSQL
public Object visit(Touches filter, Object extraData)
visit
in interface FilterVisitor
visit
in class FilterToSQL
public Object visit(Within filter, Object extraData)
visit
in interface FilterVisitor
visit
in class FilterToSQL
public void visitLiteralGeometry(Literal expression) throws IOException
visitLiteralGeometry
in class FilterToSQL
expression
- the expression turn into a geometry constructor.
IOException
- Passes back exception if generated by
this.out.write()protected void addSelectivity() throws IOException
IOException
public Object visit(ExcludeFilter filter, Object extraData)
visit
in interface FilterVisitor
visit
in class FilterToSQL
FilterVisitor#visit(ExcludeFilter, Object)}
Writes the SQL for the IncludeFilter by writing "FALSE".
public Object visit(IncludeFilter filter, Object extraData)
visit
in interface FilterVisitor
visit
in class FilterToSQL
FilterVisitor#visit(IncludeFilter, Object)}
Writes the SQL for the IncludeFilter by writing "TRUE".
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |