/** * Query and update the gridded coverage * * @return gridded coverage */ public GriddedCoverage queryGriddedCoverage() { try { if (griddedCoverageDao.isTableExists()) { griddedCoverage = griddedCoverageDao.query(tileMatrixSet); } } catch (SQLException e) { throw new GeoPackageException( "Failed to get Gridded Coverage for table name: " + tileMatrixSet.getTableName(), e); } return griddedCoverage; }
/** * Delete by tile matrix set name * * @param tileMatrixSetName * tile matrix set name * @return deleted count */ public int delete(String tileMatrixSetName) { DeleteBuilder<GriddedCoverage, Long> db = deleteBuilder(); int deleted = 0; try { db.where().eq(GriddedCoverage.COLUMN_TILE_MATRIX_SET_NAME, tileMatrixSetName); PreparedDelete<GriddedCoverage> deleteQuery = db.prepare(); deleted = delete(deleteQuery); } catch (SQLException e) { throw new GeoPackageException( "Failed to delete Gridded Coverage by Tile Matrix Set Name: " + tileMatrixSetName, e); } return deleted; }
/** * Query by table name * * @param tileMatrixSetName * tile matrix set name * @return gridded coverage */ public GriddedCoverage query(String tileMatrixSetName) { GriddedCoverage griddedCoverage = null; try { QueryBuilder<GriddedCoverage, Long> qb = queryBuilder(); qb.where().eq(GriddedCoverage.COLUMN_TILE_MATRIX_SET_NAME, tileMatrixSetName); PreparedQuery<GriddedCoverage> query = qb.prepare(); griddedCoverage = queryForFirst(query); } catch (SQLException e) { throw new GeoPackageException( "Failed to query for Gridded Coverage by Tile Matrix Set Name: " + tileMatrixSetName, e); } return griddedCoverage; }
/** * Query by tile matrix set * * @param tileMatrixSet * tile matrix set * @return gridded coverage */ public GriddedCoverage query(TileMatrixSet tileMatrixSet) { return query(tileMatrixSet.getTableName()); }
/** * {@inheritDoc} */ @Override public boolean createGriddedCoverageTable() { verifyWritable(); boolean created = false; GriddedCoverageDao dao = getGriddedCoverageDao(); try { if (!dao.isTableExists()) { created = tableCreator.createGriddedCoverage() > 0; } } catch (SQLException e) { throw new GeoPackageException("Failed to check if " + GriddedCoverage.class.getSimpleName() + " table exists and create it", e); } return created; }
TestCase.assertEquals(1, griddedCoverageDao.create(griddedCoverage)); griddedCoverage = griddedCoverageDao.queryForId(gcId); TestCase.assertNotNull(griddedCoverage); if (defaultScale) {
griddedCoverage .setGridCellEncodingType(GriddedCoverageEncodingType.CENTER); griddedCoverageDao.create(griddedCoverage);
/** * Delete by tile matrix set * * @param tileMatrixSet * tile matrix set * @return deleted count */ public int delete(TileMatrixSet tileMatrixSet) { return delete(tileMatrixSet.getTableName()); }
TestCase.assertEquals(1, griddedCoverageDao.create(griddedCoverage)); griddedCoverage = griddedCoverageDao.queryForId(gcId); TestCase.assertNotNull(griddedCoverage); TestCase.assertEquals(1.0, griddedCoverage.getScale());
griddedCoverage .setGridCellEncodingType(GriddedCoverageEncodingType.CENTER); griddedCoverageDao.create(griddedCoverage);
if (griddedCoverageDao.isTableExists()) { griddedCoverage = griddedCoverageDao.query(tileMatrixSet);
if (griddedCoverageDao.isTableExists()) { griddedCoverage = griddedCoverageDao.query(tileMatrixSet);