Revision 11867 branches/v10/extensions/extJDBC/src/com/iver/cit/gvsig/fmap/drivers/jdbc/postgis/PostGIS.java
PostGIS.java | ||
---|---|---|
111 | 111 |
resul = "CREATE TABLE " + dbLayerDef.getTableName() + " ("; |
112 | 112 |
else */ |
113 | 113 |
// FJP: NUEVO: NO TOLERAMOS CAMPOS QUE SE LLAMEN GID. Lo reservamos para uso nuestro. |
114 |
resul = "CREATE TABLE " + dbLayerDef.getTableName() |
|
114 |
resul = "CREATE TABLE " + dbLayerDef.getComposedTableName()
|
|
115 | 115 |
+ " (gid serial PRIMARY KEY "; |
116 | 116 |
int j=0; |
117 | 117 |
for (int i = 0; i < dbLayerDef.getFieldNames().length; i++) { |
... | ... | |
151 | 151 |
} |
152 | 152 |
|
153 | 153 |
String result = "SELECT AddGeometryColumn('" |
154 |
+ dbLayerDef.getCatalogName() + "', '"
|
|
154 |
+ dbLayerDef.getSchema() + "', '"
|
|
155 | 155 |
+ dbLayerDef.getTableName() + "', '" |
156 | 156 |
+ dbLayerDef.getFieldGeometry() + "', " |
157 | 157 |
+ dbLayerDef.getSRID_EPSG() + ", '" + strGeometryFieldType + "', " |
... | ... | |
215 | 215 |
* @return |
216 | 216 |
*/ |
217 | 217 |
public String getSqlInsertFeature(DBLayerDefinition dbLayerDef, |
218 |
IFeature feat) { |
|
218 |
IFeature feat) {
|
|
219 | 219 |
StringBuffer sqlBuf = new StringBuffer("INSERT INTO " |
220 |
+ dbLayerDef.getTableName() + " ("); |
|
220 |
+ dbLayerDef.getComposedTableName() + " (");
|
|
221 | 221 |
String sql = null; |
222 | 222 |
int numAlphanumericFields = dbLayerDef.getFieldNames().length; |
223 | 223 |
|
... | ... | |
273 | 273 |
WHERE date > '1994-11-28'; |
274 | 274 |
*/ |
275 | 275 |
StringBuffer sqlBuf = new StringBuffer("UPDATE " |
276 |
+ dbLayerDef.getTableName() + " SET"); |
|
276 |
+ dbLayerDef.getComposedTableName() + " SET");
|
|
277 | 277 |
String sql = null; |
278 | 278 |
int numAlphanumericFields = dbLayerDef.getFieldsDesc().length; |
279 | 279 |
|
... | ... | |
325 | 325 |
// nos sirve dentro de un writer para modificar y/o borrar entidades |
326 | 326 |
// Por ahora, cojo el ID del campo que me indica el dbLayerDev |
327 | 327 |
StringBuffer sqlBuf = new StringBuffer("DELETE FROM " |
328 |
+ dbLayerDef.getTableName() + " WHERE "); |
|
328 |
+ dbLayerDef.getComposedTableName() + " WHERE ");
|
|
329 | 329 |
String sql = null; |
330 | 330 |
int indexFieldId = dbLayerDef.getIdFieldID(); |
331 | 331 |
sqlBuf.append(dbLayerDef.getFieldID() + " = " + row.getAttribute(indexFieldId)); |
Also available in: Unified diff