@Test public void testDeleteGeometryColumnsEntry() throws Exception { FeatureEntry entry = new FeatureEntry(); entry.setTableName("points"); entry.setDataType(Entry.DataType.Feature); entry.setIdentifier("points"); entry.setBounds(new ReferencedEnvelope(-180, 180, -90, 90, CRS.decode("EPSG:4326", true))); entry.setSrid(4326); entry.setGeometryColumn("geom"); entry.setGeometryType(Geometries.POINT); try (Connection cx = geopkg.getDataSource().getConnection()) { geopkg.addGeometryColumnsEntry(entry, cx); } assertTrue(doesEntryExists(GeoPackage.GEOMETRY_COLUMNS, entry)); geopkg.deleteGeometryColumnsEntry(entry); assertFalse(doesEntryExists(GeoPackage.GEOMETRY_COLUMNS, entry)); }
void deleteGeometryColumnsEntry(FeatureEntry e) throws IOException { String sql = format("DELETE FROM %s WHERE table_name = ?", GEOMETRY_COLUMNS); try { Connection cx = connPool.getConnection(); try { PreparedStatement ps = prepare(cx, sql).set(e.getTableName()).log(Level.FINE).statement(); try { ps.execute(); } finally { close(ps); } } finally { close(cx); } } catch (SQLException ex) { throw new IOException(ex); } }
GeoPackage implements Closeable { void deleteGeometryColumnsEntry(FeatureEntry e) throws IOException { String sql = format("DELETE FROM %s WHERE table_name = ?", GEOMETRY_COLUMNS); try { Connection cx = connPool.getConnection(); try { PreparedStatement ps = prepare(cx, sql).set(e.getTableName()).log(Level.FINE).statement(); try { ps.execute(); } finally { close(ps); } } finally { close(cx); } } catch (SQLException ex) { throw new IOException(ex); } } }
GeoPackage implements Closeable { void deleteGeometryColumnsEntry(FeatureEntry e) throws IOException { String sql = format("DELETE FROM %s WHERE table_name = ?", GEOMETRY_COLUMNS); try { Connection cx = connPool.getConnection(); try { PreparedStatement ps = prepare(cx, sql).set(e.getTableName()).log(Level.FINE).statement(); try { ps.execute(); } finally { close(ps); } } finally { close(cx); } } catch (SQLException ex) { throw new IOException(ex); } } GeoPackage();  GeoPackage(File file);  GeoPackage(File file, String user, String passwd);  GeoPackage(File file, String user, String passwd, boolean readOnly);   GeoPackage(DataSource dataSource);  GeoPackage(JDBCDataStore dataStore);  GeoPackage(File file, SQLiteConfig config, Map<String, Object> storeParams); }
GeoPackage implements Closeable { void deleteGeometryColumnsEntry(FeatureEntry e) throws IOException { String sql = format("DELETE FROM %s WHERE table_name = ?", GEOMETRY_COLUMNS); try { Connection cx = connPool.getConnection(); try { PreparedStatement ps = prepare(cx, sql).set(e.getTableName()).log(Level.FINE).statement(); try { ps.execute(); } finally { close(ps); } } finally { close(cx); } } catch (SQLException ex) { throw new IOException(ex); } } GeoPackage();  GeoPackage(File file);  GeoPackage(File file, String user, String passwd);  GeoPackage(File file, String user, String passwd, boolean readOnly);   GeoPackage(DataSource dataSource);  GeoPackage(JDBCDataStore dataStore);  GeoPackage(File file, SQLiteConfig config, Map<String, Object> storeParams); GeoPkgGeomWriter.Configuration getWriterConfiguration(); File getFile(); DataSource getDataSource(); void init(); void close(); void addCRS(int srid); static void addCRS(
            Connection cx,
            int srid,
            String srsName,
            String organization,
            int organizationCoordSysId,
            String definition,
            String description); void addCRS(CoordinateReferenceSystem crs, String auth, int srid); List<Entry> contents(); List<FeatureEntry> features(); FeatureEntry feature(String name); GeoPkgExtension getExtension(String name); T getExtension(Class<T> extensionClass); void create(FeatureEntry entry, SimpleFeatureType schema); void add(FeatureEntry entry, SimpleFeatureCollection collection); void add(FeatureEntry entry, SimpleFeatureSource source, Filter filter); SimpleFeatureWriter writer(
            FeatureEntry entry, boolean append, Filter filter, Transaction tx); SimpleFeatureReader reader(FeatureEntry entry, Filter filter, Transaction tx); static SimpleDateFormat getDateFormat(); void createSpatialIndex(FeatureEntry e); List<TileEntry> tiles(); TileEntry tile(String name); void create(TileEntry entry); void add(TileEntry entry, Tile tile); @SuppressWarnings("PMD.CloseResource") // cx and st get into the TileReader TileReader reader(
            TileEntry entry,
            Integer lowZoom,
            Integer highZoom,
            Integer lowCol,
            Integer highCol,
            Integer lowRow,
            Integer highRow); void addRange(String attribute, Integer low, Integer high, List<String> q); boolean hasSpatialIndex(FeatureEntry entry); Set<Identifier> searchSpatialIndex(
            FeatureEntry entry, Double minX, Double minY, Double maxX, Double maxY); int getTileBound(TileEntry entry, int zoom, boolean isMax, boolean isRow); }
GeoPackage implements Closeable { void deleteGeometryColumnsEntry(FeatureEntry e) throws IOException { String sql = format("DELETE FROM %s WHERE table_name = ?", GEOMETRY_COLUMNS); try { Connection cx = connPool.getConnection(); try { PreparedStatement ps = prepare(cx, sql).set(e.getTableName()).log(Level.FINE).statement(); try { ps.execute(); } finally { close(ps); } } finally { close(cx); } } catch (SQLException ex) { throw new IOException(ex); } } GeoPackage();  GeoPackage(File file);  GeoPackage(File file, String user, String passwd);  GeoPackage(File file, String user, String passwd, boolean readOnly);   GeoPackage(DataSource dataSource);  GeoPackage(JDBCDataStore dataStore);  GeoPackage(File file, SQLiteConfig config, Map<String, Object> storeParams); GeoPkgGeomWriter.Configuration getWriterConfiguration(); File getFile(); DataSource getDataSource(); void init(); void close(); void addCRS(int srid); static void addCRS(
            Connection cx,
            int srid,
            String srsName,
            String organization,
            int organizationCoordSysId,
            String definition,
            String description); void addCRS(CoordinateReferenceSystem crs, String auth, int srid); List<Entry> contents(); List<FeatureEntry> features(); FeatureEntry feature(String name); GeoPkgExtension getExtension(String name); T getExtension(Class<T> extensionClass); void create(FeatureEntry entry, SimpleFeatureType schema); void add(FeatureEntry entry, SimpleFeatureCollection collection); void add(FeatureEntry entry, SimpleFeatureSource source, Filter filter); SimpleFeatureWriter writer(
            FeatureEntry entry, boolean append, Filter filter, Transaction tx); SimpleFeatureReader reader(FeatureEntry entry, Filter filter, Transaction tx); static SimpleDateFormat getDateFormat(); void createSpatialIndex(FeatureEntry e); List<TileEntry> tiles(); TileEntry tile(String name); void create(TileEntry entry); void add(TileEntry entry, Tile tile); @SuppressWarnings("PMD.CloseResource") // cx and st get into the TileReader TileReader reader(
            TileEntry entry,
            Integer lowZoom,
            Integer highZoom,
            Integer lowCol,
            Integer highCol,
            Integer lowRow,
            Integer highRow); void addRange(String attribute, Integer low, Integer high, List<String> q); boolean hasSpatialIndex(FeatureEntry entry); Set<Identifier> searchSpatialIndex(
            FeatureEntry entry, Double minX, Double minY, Double maxX, Double maxY); int getTileBound(TileEntry entry, int zoom, boolean isMax, boolean isRow); static final String GEOPACKAGE_CONTENTS; static final String GEOMETRY_COLUMNS; static final String SPATIAL_REF_SYS; static final String DATA_COLUMNS; static final String TILE_MATRIX_METADATA; static final String METADATA; static final String METADATA_REFERENCE; static final String TILE_MATRIX_SET; static final String DATA_COLUMN_CONSTRAINTS; static final String EXTENSIONS; static final String SPATIAL_INDEX; static final String SCHEMA; static final String SKIP_REGISTRATION; static final String DATA_COLUMN; }