Revision 196 trunk/org.gvsig.spatialite/org.gvsig.spatialite.provider/src/main/java/org/gvsig/spatialite/dal/operations/SpatiaLiteFetchFeatureTypeOperation.java
SpatiaLiteFetchFeatureTypeOperation.java | ||
---|---|---|
11 | 11 |
import java.util.Map; |
12 | 12 |
import org.apache.commons.lang3.StringUtils; |
13 | 13 |
import org.cresques.cts.IProjection; |
14 |
import org.gvsig.expressionevaluator.ExpressionBuilder; |
|
14 | 15 |
import org.gvsig.fmap.dal.DataTypes; |
15 | 16 |
import org.gvsig.fmap.dal.exception.DataException; |
16 | 17 |
import org.gvsig.fmap.dal.feature.EditableFeatureAttributeDescriptor; |
... | ... | |
129 | 130 |
attr.setGeometryType(gt); |
130 | 131 |
|
131 | 132 |
JDBCSQLBuilderBase sqlbuilder = this.createSQLBuilder(); |
133 |
ExpressionBuilder expbuilder = sqlbuilder.expression(); |
|
134 |
|
|
132 | 135 |
sqlbuilder.select().column().name("geometry_type"); |
133 | 136 |
sqlbuilder.select().column().name("coord_dimension"); |
134 | 137 |
sqlbuilder.select().column().name("srid"); |
135 | 138 |
sqlbuilder.select().column().name("spatial_index_enabled"); |
136 | 139 |
sqlbuilder.select().where().set( |
137 |
sqlbuilder.eq(
|
|
138 |
sqlbuilder.column("f_table_name"),
|
|
139 |
sqlbuilder.constant(this.getTable().getTable().toLowerCase()) // geometry_columns always stores lowercase names
|
|
140 |
expbuilder.eq(
|
|
141 |
expbuilder.column("f_table_name"),
|
|
142 |
expbuilder.constant(this.getTable().getTable().toLowerCase()) // geometry_columns always stores lowercase names
|
|
140 | 143 |
) |
141 | 144 |
); |
142 | 145 |
sqlbuilder.select().where().and( |
143 |
sqlbuilder.eq(
|
|
144 |
sqlbuilder.column("f_geometry_column"),
|
|
145 |
sqlbuilder.constant(attr.getName().toLowerCase()) // geometry_columns always stores lowercase names
|
|
146 |
expbuilder.eq(
|
|
147 |
expbuilder.column("f_geometry_column"),
|
|
148 |
expbuilder.constant(attr.getName().toLowerCase()) // geometry_columns always stores lowercase names
|
|
146 | 149 |
) |
147 | 150 |
); |
148 | 151 |
sqlbuilder.select().from().table().name("geometry_columns"); |
Also available in: Unified diff