/** * Delete by table name * * @param tableName * table name * @return deleted count */ public int delete(String tableName) { DeleteBuilder<GriddedTile, Long> db = deleteBuilder(); int deleted = 0; try { db.where().eq(GriddedTile.COLUMN_TABLE_NAME, tableName); PreparedDelete<GriddedTile> deleteQuery = db.prepare(); deleted = delete(deleteQuery); } catch (SQLException e) { throw new GeoPackageException( "Failed to delete Gridded Tile by Table Name: " + tableName, e); } return deleted; }
/** * Get the gridded tile * * @return gridded tiles */ public List<GriddedTile> getGriddedTile() { List<GriddedTile> griddedTile = null; try { if (griddedTileDao.isTableExists()) { griddedTile = griddedTileDao .query(tileMatrixSet.getTableName()); } } catch (SQLException e) { throw new GeoPackageException( "Failed to get Gridded Tile for table name: " + tileMatrixSet.getTableName(), e); } return griddedTile; }
/** * Query by table name * * @param tableName * table name * @return gridded tile list */ public List<GriddedTile> query(String tableName) { List<GriddedTile> results = null; try { results = queryForEq(GriddedTile.COLUMN_TABLE_NAME, tableName); } catch (SQLException e) { throw new GeoPackageException( "Failed to query for Gridded Tile objects by Table Name: " + tableName, e); } return results; }
.getStandardDeviation()); TestCase.assertEquals(1, griddedTileDao.create(griddedTile)); long gtId = griddedTile.getId(); TestCase.assertTrue(gtId >= 0); griddedTile = griddedTileDao.queryForId(gtId); TestCase.assertNotNull(griddedTile); if (defaultGTScale) {
/** * Query by table name and table id * * @param tableName * table name * @param tileId * tile id * @return gridded tile */ public GriddedTile query(String tableName, long tileId) { GriddedTile griddedTile = null; try { QueryBuilder<GriddedTile, Long> qb = queryBuilder(); qb.where().eq(GriddedTile.COLUMN_TABLE_NAME, tableName).and() .eq(GriddedTile.COLUMN_TABLE_ID, tileId); PreparedQuery<GriddedTile> query = qb.prepare(); griddedTile = queryForFirst(query); } catch (SQLException e) { throw new GeoPackageException( "Failed to query for Gridded Tile objects by Table Name: " + tableName + ", Tile Id: " + tileId, e); } return griddedTile; }
griddedTile.setTableId(tileId); griddedTileDao.create(griddedTile);
/** * Delete by contents * * @param contents * contents * @return deleted count */ public int delete(Contents contents) { return delete(contents.getTableName()); }
/** * Query by contents * * @param contents * contents * @return gridded tile list */ public List<GriddedTile> query(Contents contents) { return query(contents.getTableName()); }
/** * {@inheritDoc} */ @Override public boolean createGriddedTileTable() { verifyWritable(); boolean created = false; GriddedTileDao dao = getGriddedTileDao(); try { if (!dao.isTableExists()) { created = tableCreator.createGriddedTile() > 0; } } catch (SQLException e) { throw new GeoPackageException("Failed to check if " + GriddedTile.class.getSimpleName() + " table exists and create it", e); } return created; }
.getStandardDeviation()); TestCase.assertEquals(1, griddedTileDao.create(griddedTile)); long gtId = griddedTile.getId(); TestCase.assertTrue(gtId >= 0); griddedTile = griddedTileDao.queryForId(gtId); TestCase.assertNotNull(griddedTile); TestCase.assertEquals(1.0, griddedTile.getScale());
griddedTile.setTableId(tileId); griddedTileDao.create(griddedTile);
/** * Get the gridded tile by id * * @param tileId * tile id * @return gridded tile */ public GriddedTile getGriddedTile(long tileId) { GriddedTile griddedTile = null; try { if (griddedTileDao.isTableExists()) { griddedTile = griddedTileDao.query( tileMatrixSet.getTableName(), tileId); } } catch (SQLException e) { throw new GeoPackageException( "Failed to get Gridded Tile for table name: " + tileMatrixSet.getTableName() + ", tile id: " + tileId, e); } return griddedTile; }