if (dao.isTableExists()) { List<TileMatrixSet> results = dao.queryForAll(); dao.update(tileMatrixSet); .queryForId(tileMatrixSet.getId()); TestCase.assertEquals(updatedMaxY, updatedTileMatrixSet.getMaxY()); QueryBuilder<TileMatrixSet, String> qb = dao.queryBuilder(); qb.where().lt(TileMatrixSet.COLUMN_MIN_X, 0.0).and() .lt(TileMatrixSet.COLUMN_MIN_Y, 0.0); PreparedQuery<TileMatrixSet> preparedQuery = qb.prepare(); List<TileMatrixSet> queryTileMatrixSet = dao .query(preparedQuery); UpdateBuilder<TileMatrixSet, String> ub = dao.updateBuilder(); ub.updateColumnValue(TileMatrixSet.COLUMN_MIN_X, updatedMin); ub.updateColumnValue(TileMatrixSet.COLUMN_MIN_Y, updatedMin); .lt(TileMatrixSet.COLUMN_MIN_Y, 0.0); PreparedUpdate<TileMatrixSet> update = ub.prepare(); int updated = dao.update(update); TestCase.assertEquals(queryTileMatrixSet.size(), updated); .queryForId(updatedQueryTileMatrixSet.getId()); TestCase.assertNotNull(reloadedTileMatrixSet); TestCase.assertEquals(updatedMin,
/** * {@inheritDoc} */ @Override public TileDao getTileDao(String tableName) { TileMatrixSetDao dao = getTileMatrixSetDao(); List<TileMatrixSet> tileMatrixSetList; try { tileMatrixSetList = dao.queryForEq(TileMatrixSet.COLUMN_TABLE_NAME, tableName); } catch (SQLException e) { throw new GeoPackageException("Failed to retrieve " + TileDao.class.getSimpleName() + " for table name: " + tableName + ". Exception retrieving " + TileMatrixSet.class.getSimpleName() + ".", e); } if (tileMatrixSetList.isEmpty()) { throw new GeoPackageException( "No Tile Table exists for table name: " + tableName); } else if (tileMatrixSetList.size() > 1) { // This shouldn't happen with the table name primary key on tile // matrix set table throw new GeoPackageException("Unexpected state. More than one " + TileMatrixSet.class.getSimpleName() + " matched for table name: " + tableName + ", count: " + tileMatrixSetList.size()); } return getTileDao(tileMatrixSetList.get(0)); }
if (dao.isTableExists()) { List<TileMatrixSet> results = dao.queryForAll(); dao.delete(tileMatrixSet); TileMatrixSet queryTileMatrixSet = dao.queryForId(tileMatrixSet .getId()); TestCase.assertNull(queryTileMatrixSet); results = dao.queryForAll(); if (!results.isEmpty()) { QueryBuilder<TileMatrixSet, String> qb = dao.queryBuilder(); qb.where().eq(TileMatrixSet.COLUMN_SRS_ID, tileMatrixSet.getSrsId()); PreparedQuery<TileMatrixSet> query = qb.prepare(); List<TileMatrixSet> queryResults = dao.query(query); int count = queryResults.size(); .deleteBuilder(); db.where().eq(TileMatrixSet.COLUMN_SRS_ID, tileMatrixSet.getSrsId()); PreparedDelete<TileMatrixSet> deleteQuery = db.prepare(); int deleted = dao.delete(deleteQuery);
if (tileMatrixSetDao.isTableExists()) { List<TileMatrixSet> results = tileMatrixSetDao.queryForAll(); for (TileMatrixSet tileMatrixSet : results) {
if (dao.isTableExists()) { List<TileMatrixSet> results = dao.queryForAll(); if (expectedResults != null) { TestCase.assertEquals( TileMatrixSet queryTileMatrixSet = dao.queryForId(tileMatrixSet .getId()); TestCase.assertNotNull(queryTileMatrixSet); List<TileMatrixSet> queryTileMatrixSetList = dao.queryForEq( TileMatrixSet.COLUMN_SRS_ID, tileMatrixSet.getSrsId()); TestCase.assertNotNull(queryTileMatrixSetList); tileMatrixSet.getSrsId()); queryTileMatrixSetList = dao.queryForFieldValues(fieldValues); TestCase.assertNotNull(queryTileMatrixSetList); TestCase.assertTrue(queryTileMatrixSetList.size() >= 1); QueryBuilder<TileMatrixSet, String> qb = dao.queryBuilder(); qb.where().eq(TileMatrixSet.COLUMN_SRS_ID, tileMatrixSet.getSrsId()); PreparedQuery<TileMatrixSet> query = qb.prepare(); queryTileMatrixSetList = dao.query(query);
TestCase.assertTrue(dao.isTableExists()); TileMatrixSet tileMatrixSet = dao.queryForId(coverageTable);
if (!tileMatrixSetDao.isTableExists() || !tileMatrixSetDao.idExists(tableName)) { update = true; tileMatrixSet = tileMatrixSetDao.queryForId(tableName);
TileMatrixSetDao dao = geoPackage.getTileMatrixSetDao(); if (dao.isTableExists()) { long count = dao.countOf(); TestCase.assertEquals(count, dao.getTileTables().size()); tileMatrixSet.setMaxX(contents.getMaxX()); tileMatrixSet.setMaxY(contents.getMaxY()); dao.create(tileMatrixSet); long newCount = dao.countOf(); TestCase.assertEquals(count + 1, newCount); TestCase.assertEquals(newCount, dao.getTileTables().size()); TestCase.assertTrue(dao.getTileTables().contains( contents.getTableName())); TileMatrixSet queryTileMatrixSet = dao.queryForId(tileMatrixSet .getId()); TestCase.assertEquals(contents.getId(),
/** * {@inheritDoc} */ @Override public TileDao getTileDao(Contents contents) { if (contents == null) { throw new GeoPackageException("Non null " + Contents.class.getSimpleName() + " is required to create " + TileDao.class.getSimpleName()); } TileMatrixSet tileMatrixSet = null; try { tileMatrixSet = getTileMatrixSetDao().queryForId( contents.getTableName()); } catch (SQLException e) { throw new GeoPackageException("No " + TileMatrixSet.class.getSimpleName() + " could be retrieved for " + Contents.class.getSimpleName() + " " + contents.getId()); } if (tileMatrixSet == null) { throw new GeoPackageException("No " + TileMatrixSet.class.getSimpleName() + " exists for " + Contents.class.getSimpleName() + " " + contents.getId()); } return getTileDao(tileMatrixSet); }
if (tileMatrixSetDao.isTableExists()) { ForeignCollection<TileMatrixSet> tileMatrixSetCollection = srs .getTileMatrixSet(); if (!tileMatrixSetCollection.isEmpty()) { tileMatrixSetDao.delete(tileMatrixSetCollection);
tileMatrixSet.setMaxX(maxX); tileMatrixSet.setMaxY(maxY); tileMatrixSetDao.create(tileMatrixSet);
/** * {@inheritDoc} */ @Override public boolean createTileMatrixSetTable() { verifyWritable(); boolean created = false; TileMatrixSetDao dao = getTileMatrixSetDao(); try { if (!dao.isTableExists()) { created = tableCreator.createTileMatrixSet() > 0; } } catch (SQLException e) { throw new GeoPackageException("Failed to check if " + TileMatrixSet.class.getSimpleName() + " table exists and create it", e); } return created; }
|| tileMatrixSetDao.isTableExists()); if (tileMatrixSetDao.isTableExists()) { TileMatrixDao tileMatrixDao = geoPackage.getTileMatrixDao(); TestCase.assertTrue(tileMatrixSetDao.isTableExists()); TestCase.assertTrue(tileMatrixDao.isTableExists()); tileMatrixSetDao.countOf()); for (String tileTable : geoPackage.getTileTables()) { TestCase.assertTrue(geoPackage.isTable(tileTable)); TestCase.assertNull(contentsDao.queryForId(tileTable)); TestCase.assertEquals(geoPackage.getTables(ContentsDataType.GRIDDED_COVERAGE).size(), tileMatrixSetDao.countOf()); TestCase.assertFalse(tileMatrixSetDao.isTableExists()); TestCase.assertFalse(tileMatrixDao.isTableExists());
tileMatrixSetDao.update(tileMatrixSet);
/** * Get all the tile table names * * @return tile tables * @throws SQLException * upon failure */ public List<String> getTileTables() throws SQLException { List<String> tableNames = new ArrayList<String>(); List<TileMatrixSet> tileMatrixSets = queryForAll(); for (TileMatrixSet tileMatrixSet : tileMatrixSets) { tableNames.add(tileMatrixSet.getTableName()); } return tableNames; }
if (tileMatrixSetDao.isTableExists()) { List<TileMatrixSet> results = tileMatrixSetDao.queryForAll();
TestCase.assertTrue(tileMatrixSetDao.isTableExists()); TileMatrixDao tileMatrixDao = geoPackage.getTileMatrixDao(); TestCase.assertTrue(tileMatrixDao.isTableExists()); .queryForId(coverageTable);
if (!tileMatrixSetDao.isTableExists() || !tileMatrixSetDao.idExists(tableName)) { update = true; tileMatrixSet = tileMatrixSetDao.queryForId(tableName);
try { TileMatrixSet tileMatrixSet = getTileMatrixSetDao() .queryForId(table); tableBoundingBox = tileMatrixSet.getBoundingBox(projection); } catch (SQLException e) {
if (tileMatrixSetDao.isTableExists()) { TileMatrixSet tileMatrixSet = contents .getTileMatrixSet(); if (tileMatrixSet != null) { tileMatrixSetDao.delete(tileMatrixSet);