Revision 47580 trunk/org.gvsig.desktop/org.gvsig.desktop.plugin/org.gvsig.sqlite/org.gvsig.sqlite.provider/src/main/java/org/gvsig/sqlite/dal/geopackage/GeopackageGeometryColumns.java
| GeopackageGeometryColumns.java | ||
|---|---|---|
| 177 | 177 |
break; |
| 178 | 178 |
} |
| 179 | 179 |
String s = String.format( |
| 180 |
"INSERT INTO \"main\".\"gpkg_geometry_columns\" (\"table_name\", \"column_name\", \"geometry_type_name\", \"srs_id\", \"z\", \"m\") VALUES ('%s', '%s', '%s', '%s', '%s', '%s')",
|
|
| 180 |
"INSERT INTO \"gpkg_geometry_columns\" (\"table_name\", \"column_name\", \"geometry_type_name\", \"srs_id\", \"z\", \"m\") VALUES ('%s', '%s', '%s', '%s', '%s', '%s')",
|
|
| 181 | 181 |
tableName, |
| 182 | 182 |
geomName, |
| 183 | 183 |
geometryTypeName, |
| ... | ... | |
| 188 | 188 |
|
| 189 | 189 |
return s; |
| 190 | 190 |
} |
| 191 |
|
|
| 191 | 192 |
public static String buildDeleteSQL(String tableName, String geomName) {
|
| 192 | 193 |
String s = String.format( |
| 193 |
"DELETE FROM \"main\".\"gpkg_geometry_columns\" WHERE \"table_name\" = '%s' and \"column_name\" = '%s'",
|
|
| 194 |
"DELETE FROM \"gpkg_geometry_columns\" WHERE \"table_name\" = '%s' and \"column_name\" = '%s'", |
|
| 194 | 195 |
tableName, |
| 195 | 196 |
geomName |
| 196 | 197 |
); |
| 197 | 198 |
|
| 198 | 199 |
return s; |
| 199 | 200 |
} |
| 201 |
|
|
| 202 |
public static String buildDeleteSQL(String tableName) {
|
|
| 203 |
String s = String.format( |
|
| 204 |
"DELETE FROM \"gpkg_geometry_columns\" WHERE \"table_name\" = '%s'", |
|
| 205 |
tableName |
|
| 206 |
); |
|
| 207 |
|
|
| 208 |
return s; |
|
| 209 |
} |
|
| 200 | 210 |
} |
Also available in: Unified diff