/** * {@inheritDoc} */ @Override public Contents getTableContents(String table) { ContentsDao contentDao = getContentsDao(); Contents contents = null; try { contents = contentDao.queryForId(table); } catch (SQLException e) { throw new GeoPackageException("Failed to retrieve table contents: " + table, e); } return contents; }
/** * Delete a Contents by id, cascading optionally including the user table * * @param id * id * @param userTable * true if a user table * @return deleted count * @throws SQLException * upon deletion error */ public int deleteByIdCascade(String id, boolean userTable) throws SQLException { int count = 0; if (id != null) { Contents contents = queryForId(id); if (contents != null) { count = deleteCascade(contents, userTable); } else if (userTable) { dropTable(id); } } return count; }
/** * Get the bounding box for the table in the provided projection * * @param projection * desired bounding box projection * @param table * table name * * @return bounding box * @since 3.1.0 */ public BoundingBox getBoundingBox(Projection projection, String table) { BoundingBox boundingBox = null; try { Contents contents = queryForId(table); boundingBox = contents.getBoundingBox(projection); } catch (SQLException e) { throw new GeoPackageException( "Failed to query for contents of table: " + table, e); } return boundingBox; }
/** * {@inheritDoc} */ @Override public AttributesDao getAttributesDao(String tableName) { ContentsDao dao = getContentsDao(); Contents contents = null; try { contents = dao.queryForId(tableName); } catch (SQLException e) { throw new GeoPackageException("Failed to retrieve " + Contents.class.getSimpleName() + " for table name: " + tableName, e); } if (contents == null) { throw new GeoPackageException( "No Contents Table exists for table name: " + tableName); } return getAttributesDao(contents); }
/** * {@inheritDoc} */ @Override public AttributesDao getAttributesDao(String tableName) { ContentsDao dao = getContentsDao(); Contents contents = null; try { contents = dao.queryForId(tableName); } catch (SQLException e) { throw new GeoPackageException("Failed to retrieve " + Contents.class.getSimpleName() + " for table name: " + tableName, e); } if (contents == null) { throw new GeoPackageException( "No Contents Table exists for table name: " + tableName); } return getAttributesDao(contents); }
@Override public void run() { for (int i = 0; i < attemptsPerThread; i++) { try { ContentsDao contentsDao = geoPackage .getContentsDao(); Contents contents = contentsDao .queryForId(tableName); if (contents == null) { throw new Exception( "Contents was null, table name: " + tableName); } TileDao dao = geoPackage.getTileDao(tableName); if (dao == null) { throw new Exception( "Tile DAO was null, table name: " + tableName); } } catch (Exception e) { threadedTileDaoError = true; e.printStackTrace(); break; } } } };
/** * Set the contents in the user related table * * @param table * user related table */ protected void setContents(UserRelatedTable table) { ContentsDao dao = geoPackage.getContentsDao(); Contents contents = null; try { contents = dao.queryForId(table.getTableName()); } catch (SQLException e) { throw new GeoPackageException("Failed to retrieve " + Contents.class.getSimpleName() + " for table name: " + table.getTableName(), e); } if (contents == null) { throw new GeoPackageException( "No Contents Table exists for table name: " + table.getTableName()); } table.setContents(contents); }
Contents contents = contentsDao.queryForId(tableName); if (contents != null) { Date lastChange = contents.getLastChange();
for (String featureTable : geoPackage.getFeatureTables()) { TestCase.assertTrue(geoPackage.isTable(featureTable)); TestCase.assertNotNull(contentsDao.queryForId(featureTable)); geoPackage.deleteTable(featureTable); TestCase.assertFalse(geoPackage.isTable(featureTable)); TestCase.assertNull(contentsDao.queryForId(featureTable)); for (String tileTable : geoPackage.getTileTables()) { TestCase.assertTrue(geoPackage.isTable(tileTable)); TestCase.assertNotNull(contentsDao.queryForId(tileTable)); geoPackage.deleteTable(tileTable); TestCase.assertFalse(geoPackage.isTable(tileTable)); TestCase.assertNull(contentsDao.queryForId(tileTable)); TestCase.assertNotNull(contentsDao.queryForId(attributeTable)); geoPackage.deleteTable(attributeTable); TestCase.assertFalse(geoPackage.isTable(attributeTable)); TestCase.assertNull(contentsDao.queryForId(attributeTable));
Contents updatedContents = dao.queryForId(contents.getId()); TestCase.assertEquals(updatedLastChange, updatedContents.getLastChange()); Contents reloadedContents = dao.queryForId(updatedContent .getId()); TestCase.assertEquals(updatedMinimum,
Contents queryContents = dao.queryForId(contents.getTableName()); TestCase.assertNotNull(queryContents); TestCase.assertEquals(contents.getTableName(),
Contents queryContents = dao.queryForId(tableName); String queryContentsId = queryContents.getId(); TestCase.assertEquals(tableName, queryContents.getTableName()); Contents queryCopiedContents = dao.queryForId(copyTableName); TestCase.assertEquals(copyTableName, queryCopiedContents.getTableName()); TestCase.assertEquals(queryContents.getDataType(), queryContents = dao.queryForId(tableName); TestCase.assertEquals(queryContentsId, queryContents.getId()); TestCase.assertEquals(tableName, queryContents.getTableName());
Contents queryContents = dao.queryForId(contents.getId()); TestCase.assertNull(queryContents);
Contents queryContents = contentsDao.queryForId(contentsId); if (cascade) { TestCase.assertNull(queryContents); Contents queryContents = contentsDao.queryForId(contentsId); if (cascade) { TestCase.assertNull(queryContents);
simpleTable.getTableName())); validateContents(simpleTable, contentsDao.queryForId(simpleTable.getTableName())); TestCase.assertEquals(SimpleAttributesTable.RELATION_TYPE.getDataType(), geoPackage.getTableType(simpleTable.getTableName())); TestCase.assertNotNull(contentsDao.queryForId(simpleTable .getTableName())); geoPackage.deleteTable(simpleTable.getTableName()); TestCase.assertFalse(geoPackage.isTable(simpleTable.getTableName())); TestCase.assertNull(contentsDao.queryForId(simpleTable.getTableName()));
mediaTable.getTableName())); validateContents(mediaTable, contentsDao.queryForId(mediaTable.getTableName())); TestCase.assertEquals(MediaTable.RELATION_TYPE.getDataType(), geoPackage.getTableType(mediaTable.getTableName())); TestCase.assertNotNull(contentsDao.queryForId(mediaTable.getTableName())); geoPackage.deleteTable(mediaTable.getTableName()); TestCase.assertFalse(geoPackage.isTable(mediaTable.getTableName())); TestCase.assertNull(contentsDao.queryForId(mediaTable.getTableName()));
Contents contents = contentsDao.queryForId(tableName); AttributesDao dao = geoPackage.getAttributesDao(contents); TestCase.assertNotNull(dao);