@Override public void dispose() { if (file != null) { file.close(); } }
static void runSQL(String sql, Connection cx) throws SQLException { Statement st = cx.createStatement(); try { st.execute(sql); } finally { close(st); } }
public static enum DataType { Feature("features"), Raster("rasters"), Tile("tiles"), FeatureWithRaster("featuresWithRasters"); String value; DataType(String value) { this.value = value; } public String value() { return value; } }
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); } }
void deleteGeoPackageContentsEntry(Entry e) throws IOException { String sql = format("DELETE FROM %s WHERE table_name = ?", GEOPACKAGE_CONTENTS); 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); } }
@Override public void dispose() { if (file != null) { file.close(); } }
public void createChangeLog(final String targetTableName, Map<String, ChangeType> changedNodes) throws IOException, SQLException { final GeoPackage geopackage = new GeoPackage(geopackageDbFile); final DataSource dataSource = geopackage.getDataSource(); try (Connection connection = dataSource.getConnection(); GeopkgGeogigMetadata metadata = new GeopkgGeogigMetadata(connection)) { metadata.createChangeLog(targetTableName); metadata.populateChangeLog(targetTableName, changedNodes); } finally { geopackage.close(); } }
public void createChangeLog(final String targetTableName, Map<String, ChangeType> changedNodes) throws IOException, SQLException { final GeoPackage geopackage = new GeoPackage(geopackageDbFile); final DataSource dataSource = geopackage.getDataSource(); try (Connection connection = dataSource.getConnection(); GeopkgGeogigMetadata metadata = new GeopkgGeogigMetadata(connection)) { metadata.createChangeLog(targetTableName); metadata.populateChangeLog(targetTableName, changedNodes); } finally { geopackage.close(); } }
public File createEmptyDatabase() throws Exception { File file = newFile(); GeoPackage geoPackage = new GeoPackage(file); try { geoPackage.init(); } finally { geoPackage.close(); } return file; }
public File createEmptyDatabase() throws Exception { File file = newFile(); GeoPackage geoPackage = new GeoPackage(file); try { geoPackage.init(); } finally { geoPackage.close(); } return file; }