Java Code Examples for mil.nga.geopackage.tiles.matrixset.TileMatrixSetDao#queryForId()
The following examples show how to use
mil.nga.geopackage.tiles.matrixset.TileMatrixSetDao#queryForId() .
You can vote up the ones you like or vote down the ones you don't like,
and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.
Example 1
| Source File: CoverageDataTestUtils.java From geopackage-android with MIT License | 6 votes |
|
/**
* Get the coverage data value at the coordinate
*
* @param geoPackage GeoPackage
* @param algorithm algorithm
* @param latitude latitude
* @param longitude longitude
* @param epsg epsg
* @return coverage data value
* @throws Exception
*/
public static Double getValue(GeoPackage geoPackage,
CoverageDataAlgorithm algorithm, double latitude,
double longitude, long epsg) throws Exception {
Double value = null;
List<String> coverageDataTables = CoverageData.getTables(geoPackage);
TileMatrixSetDao dao = geoPackage.getTileMatrixSetDao();
for (String coverageTable : coverageDataTables) {
TileMatrixSet tileMatrixSet = dao.queryForId(coverageTable);
TileDao tileDao = geoPackage.getTileDao(tileMatrixSet);
Projection requestProjection = ProjectionFactory
.getProjection(epsg);
// Test getting the coverage data value of a single coordinate
CoverageData<?> coverageData = CoverageData.getCoverageData(geoPackage, tileDao, requestProjection);
coverageData.setAlgorithm(algorithm);
value = coverageData.getValue(latitude, longitude);
}
return value;
}
Example 2
| Source File: CoverageDataTestUtils.java From geopackage-android with MIT License | 5 votes |
|
/**
* Get the coverage data for the bounding box
*
* @param geoPackage GeoPackage
* @param algorithm algorithm
* @param boundingBox bounding box
* @param width results width
* @param height results height
* @param epsg epsg code
* @return coverage data results
* @throws Exception
*/
public static CoverageDataResults getValues(GeoPackage geoPackage,
CoverageDataAlgorithm algorithm, BoundingBox boundingBox,
int width, int height, long epsg) throws Exception {
CoverageDataResults values = null;
List<String> coverageDataTables = CoverageData.getTables(geoPackage);
TileMatrixSetDao dao = geoPackage.getTileMatrixSetDao();
for (String coverageTable : coverageDataTables) {
TileMatrixSet tileMatrixSet = dao.queryForId(coverageTable);
TileDao tileDao = geoPackage.getTileDao(tileMatrixSet);
Projection requestProjection = ProjectionFactory
.getProjection(epsg);
// Test getting the coverage data value of a single coordinate
CoverageData<?> coverageData = CoverageData.getCoverageData(geoPackage, tileDao, requestProjection);
coverageData.setAlgorithm(algorithm);
coverageData.setWidth(width);
coverageData.setHeight(height);
values = coverageData.getValues(boundingBox);
}
return values;
}
Example 3
| Source File: CoverageDataTestUtils.java From geopackage-java with MIT License | 5 votes |
|
/**
* Get the coverage data value at the coordinate
*
* @param geoPackage
* GeoPackage
* @param algorithm
* algorithm
* @param latitude
* latitude
* @param longitude
* longitude
* @param epsg
* epsg
* @return coverage data value
* @throws Exception
*/
public static Double getValue(GeoPackage geoPackage,
CoverageDataAlgorithm algorithm, double latitude, double longitude,
long epsg) throws Exception {
Double value = null;
List<String> coverageDataTables = CoverageData.getTables(geoPackage);
TileMatrixSetDao dao = geoPackage.getTileMatrixSetDao();
for (String coverageTable : coverageDataTables) {
TileMatrixSet tileMatrixSet = dao.queryForId(coverageTable);
TileDao tileDao = geoPackage.getTileDao(tileMatrixSet);
Projection requestProjection = ProjectionFactory
.getProjection(epsg);
// Test getting the coverage data value of a single coordinate
CoverageData<?> coverageData = CoverageData.getCoverageData(
geoPackage, tileDao, requestProjection);
coverageData.setAlgorithm(algorithm);
value = coverageData.getValue(latitude, longitude);
}
return value;
}
Example 4
| Source File: CoverageDataTestUtils.java From geopackage-java with MIT License | 5 votes |
|
/**
* Get the coverage data for the bounding box
*
* @param geoPackage
* GeoPackage
* @param algorithm
* algorithm
* @param boundingBox
* bounding box
* @param width
* results width
* @param height
* results height
* @param epsg
* epsg
* @return coverage data results
* @throws Exception
*/
public static CoverageDataResults getValues(GeoPackage geoPackage,
CoverageDataAlgorithm algorithm, BoundingBox boundingBox,
int width, int height, long epsg) throws Exception {
CoverageDataResults values = null;
List<String> coverageDataTables = CoverageData.getTables(geoPackage);
TileMatrixSetDao dao = geoPackage.getTileMatrixSetDao();
for (String coverageTable : coverageDataTables) {
TileMatrixSet tileMatrixSet = dao.queryForId(coverageTable);
TileDao tileDao = geoPackage.getTileDao(tileMatrixSet);
Projection requestProjection = ProjectionFactory
.getProjection(epsg);
// Test getting the coverage data value of a single coordinate
CoverageData<?> coverageData = CoverageData.getCoverageData(
geoPackage, tileDao, requestProjection);
coverageData.setAlgorithm(algorithm);
coverageData.setWidth(width);
coverageData.setHeight(height);
values = coverageData.getValues(boundingBox);
}
return values;
}
Example 5
| Source File: CoverageDataPngImportTest.java From geopackage-android with MIT License | 4 votes |
|
/**
* Test 10 random locations and optionally print
*
* @throws Exception
*/
@Test
public void testRandomLocations() throws Exception {
BoundingBox projectedBoundingBox = null;
List<String> coverageDataTables = CoverageDataPng.getTables(geoPackage);
TileMatrixSetDao dao = geoPackage.getTileMatrixSetDao();
for (String coverageTable : coverageDataTables) {
TileMatrixSet tileMatrixSet = dao.queryForId(coverageTable);
BoundingBox boundingBox = tileMatrixSet.getBoundingBox();
if (PRINT) {
System.out.println("Min Latitude: "
+ boundingBox.getMinLatitude());
System.out.println("Max Latitude: "
+ boundingBox.getMaxLatitude());
System.out.println("Min Longitude: "
+ boundingBox.getMinLongitude());
System.out.println("Max Longitude: "
+ boundingBox.getMaxLongitude());
System.out.println();
}
SpatialReferenceSystemDao srsDao = geoPackage
.getSpatialReferenceSystemDao();
long srsId = tileMatrixSet.getSrsId();
SpatialReferenceSystem srs = srsDao.queryForId(srsId);
Projection projection = srs.getProjection();
Projection requestProjection = ProjectionFactory
.getProjection(ProjectionConstants.EPSG_WORLD_GEODETIC_SYSTEM);
ProjectionTransform coverageToRequest = projection
.getTransformation(requestProjection);
projectedBoundingBox = boundingBox.transform(coverageToRequest);
}
if (PRINT) {
System.out.println("Min Latitude: "
+ projectedBoundingBox.getMinLatitude());
System.out.println("Max Latitude: "
+ projectedBoundingBox.getMaxLatitude());
System.out.println("Min Longitude: "
+ projectedBoundingBox.getMinLongitude());
System.out.println("Max Longitude: "
+ projectedBoundingBox.getMaxLongitude());
System.out.println();
}
double latDistance = projectedBoundingBox.getMaxLatitude()
- projectedBoundingBox.getMinLatitude();
double lonDistance = projectedBoundingBox.getMaxLongitude()
- projectedBoundingBox.getMinLongitude();
for (int i = 0; i < 10; i++) {
// Get a random coordinate
double latitude = latDistance * .9 * Math.random()
+ projectedBoundingBox.getMinLatitude()
+ (.05 * latDistance);
double longitude = lonDistance * .9 * Math.random()
+ projectedBoundingBox.getMinLongitude()
+ (.05 * lonDistance);
testLocation(latitude, longitude);
if (PRINT) {
System.out.println();
}
}
}
Example 6
| Source File: CoverageDataTestUtils.java From geopackage-android with MIT License | 4 votes |
|
/**
* Test the pixel encoding location
*
* @param geoPackage GeoPackage
* @param allowNulls allow nulls
* @throws Exception
*/
public static void testPixelEncoding(GeoPackage geoPackage,
boolean allowNulls) throws Exception {
List<String> coverageDataTables = CoverageData.getTables(geoPackage);
TestCase.assertFalse(coverageDataTables.isEmpty());
TileMatrixSetDao tileMatrixSetDao = geoPackage.getTileMatrixSetDao();
TestCase.assertTrue(tileMatrixSetDao.isTableExists());
TileMatrixDao tileMatrixDao = geoPackage.getTileMatrixDao();
TestCase.assertTrue(tileMatrixDao.isTableExists());
for (String coverageTable : coverageDataTables) {
TileMatrixSet tileMatrixSet = tileMatrixSetDao
.queryForId(coverageTable);
TileDao tileDao = geoPackage.getTileDao(tileMatrixSet);
CoverageData<?> coverageData = CoverageData.getCoverageData(
geoPackage, tileDao);
GriddedCoverage griddedCoverage = coverageData.getGriddedCoverage();
GriddedCoverageEncodingType encoding = griddedCoverage
.getGridCellEncodingType();
TileCursor tileCursor = tileDao.queryForTile(tileDao
.getMaxZoom());
TestCase.assertNotNull(tileCursor);
try {
TestCase.assertTrue(tileCursor.getCount() > 0);
while (tileCursor.moveToNext()) {
TileRow tileRow = tileCursor.getRow();
TileMatrix tileMatrix = tileDao.getTileMatrix(tileRow
.getZoomLevel());
TestCase.assertNotNull(tileMatrix);
GriddedTile griddedTile = coverageData.getGriddedTile(tileRow
.getId());
TestCase.assertNotNull(griddedTile);
byte[] tileData = tileRow.getTileData();
TestCase.assertNotNull(tileData);
BoundingBox boundingBox = TileBoundingBoxUtils.getBoundingBox(
tileMatrixSet.getBoundingBox(), tileMatrix,
tileRow.getTileColumn(), tileRow.getTileRow());
int tileHeight = (int) tileMatrix.getTileHeight();
int tileWidth = (int) tileMatrix.getTileWidth();
int heightChunk = Math.max(tileHeight / 10, 1);
int widthChunk = Math.max(tileWidth / 10, 1);
for (int y = 0; y < tileHeight; y = Math.min(y + heightChunk,
y == tileHeight - 1 ? tileHeight : tileHeight - 1)) {
for (int x = 0; x < tileWidth; x = Math.min(x + widthChunk,
x == tileWidth - 1 ? tileWidth : tileWidth - 1)) {
Double pixelValue = coverageData.getValue(griddedTile,
tileData, x, y);
double pixelLongitude = boundingBox.getMinLongitude()
+ (x * tileMatrix.getPixelXSize());
double pixelLatitude = boundingBox.getMaxLatitude()
- (y * tileMatrix.getPixelYSize());
switch (encoding) {
case CENTER:
case AREA:
pixelLongitude += (tileMatrix.getPixelXSize() / 2.0);
pixelLatitude -= (tileMatrix.getPixelYSize() / 2.0);
break;
case CORNER:
pixelLatitude -= tileMatrix.getPixelYSize();
break;
}
Double value = coverageData.getValue(pixelLatitude,
pixelLongitude);
if (!allowNulls || pixelValue != null) {
TestCase.assertEquals("x: " + x + ", y: " + y
+ ", encoding: " + encoding, pixelValue,
value);
}
}
}
break;
}
} finally {
tileCursor.close();
}
}
}
Example 7
| Source File: CoverageDataTiffImportTest.java From geopackage-android with MIT License | 4 votes |
|
/**
* Test 10 random locations and optionally print
*
* @throws Exception
*/
@Test
public void testRandomLocations() throws Exception {
BoundingBox projectedBoundingBox = null;
List<String> coverageDataTables = CoverageDataTiff.getTables(geoPackage);
TileMatrixSetDao dao = geoPackage.getTileMatrixSetDao();
for (String coverageTable : coverageDataTables) {
TileMatrixSet tileMatrixSet = dao.queryForId(coverageTable);
BoundingBox boundingBox = tileMatrixSet.getBoundingBox();
if (PRINT) {
System.out.println("Min Latitude: "
+ boundingBox.getMinLatitude());
System.out.println("Max Latitude: "
+ boundingBox.getMaxLatitude());
System.out.println("Min Longitude: "
+ boundingBox.getMinLongitude());
System.out.println("Max Longitude: "
+ boundingBox.getMaxLongitude());
System.out.println();
}
SpatialReferenceSystemDao srsDao = geoPackage
.getSpatialReferenceSystemDao();
long srsId = tileMatrixSet.getSrsId();
SpatialReferenceSystem srs = srsDao.queryForId(srsId);
Projection projection = srs.getProjection();
Projection requestProjection = ProjectionFactory
.getProjection(ProjectionConstants.EPSG_WORLD_GEODETIC_SYSTEM);
ProjectionTransform coverageToRequest = projection
.getTransformation(requestProjection);
projectedBoundingBox = boundingBox.transform(coverageToRequest);
}
if (PRINT) {
System.out.println("Min Latitude: "
+ projectedBoundingBox.getMinLatitude());
System.out.println("Max Latitude: "
+ projectedBoundingBox.getMaxLatitude());
System.out.println("Min Longitude: "
+ projectedBoundingBox.getMinLongitude());
System.out.println("Max Longitude: "
+ projectedBoundingBox.getMaxLongitude());
System.out.println();
}
double latDistance = projectedBoundingBox.getMaxLatitude()
- projectedBoundingBox.getMinLatitude();
double lonDistance = projectedBoundingBox.getMaxLongitude()
- projectedBoundingBox.getMinLongitude();
for (int i = 0; i < 10; i++) {
// Get a random coordinate
double latitude = latDistance * .9 * Math.random()
+ projectedBoundingBox.getMinLatitude()
+ (.05 * latDistance);
double longitude = lonDistance * .9 * Math.random()
+ projectedBoundingBox.getMinLongitude()
+ (.05 * lonDistance);
testLocation(latitude, longitude);
if (PRINT) {
System.out.println();
}
}
}
Example 8
| Source File: TileMatrixSetUtils.java From geopackage-android with MIT License | 4 votes |
|
/**
* Test create
*
* @param geoPackage
* @throws SQLException
*/
public static void testCreate(GeoPackage geoPackage) throws SQLException {
SpatialReferenceSystemDao srsDao = geoPackage
.getSpatialReferenceSystemDao();
ContentsDao contentsDao = geoPackage.getContentsDao();
TileMatrixSetDao dao = geoPackage.getTileMatrixSetDao();
if (dao.isTableExists()) {
// Get current count
long count = dao.countOf();
TestCase.assertEquals(count, dao.getTileTables().size());
// Retrieve a random srs
List<SpatialReferenceSystem> results = srsDao.queryForAll();
SpatialReferenceSystem srs = null;
if (!results.isEmpty()) {
int random = (int) (Math.random() * results.size());
srs = results.get(random);
}
// Create a new contents
Contents contents = new Contents();
contents.setTableName("test_contents");
contents.setDataType(ContentsDataType.TILES);
contents.setIdentifier("test_contents");
contents.setDescription("");
// contents.setLastChange(new Date());
contents.setMinX(-180.0);
contents.setMinY(-90.0);
contents.setMaxX(180.0);
contents.setMaxY(90.0);
contents.setSrs(srs);
// Create the user tile table
geoPackage.createTileTable(TestUtils.buildTileTable(contents
.getTableName()));
contentsDao.create(contents);
// Create new matrix tile set
TileMatrixSet tileMatrixSet = new TileMatrixSet();
tileMatrixSet.setContents(contents);
tileMatrixSet.setSrs(contents.getSrs());
tileMatrixSet.setMinX(contents.getMinX());
tileMatrixSet.setMinY(contents.getMinY());
tileMatrixSet.setMaxX(contents.getMaxX());
tileMatrixSet.setMaxY(contents.getMaxY());
dao.create(tileMatrixSet);
// Verify count
long newCount = dao.countOf();
TestCase.assertEquals(count + 1, newCount);
TestCase.assertEquals(newCount, dao.getTileTables().size());
TestCase.assertTrue(dao.getTileTables().contains(
contents.getTableName()));
// Verify saved matrix tile set
TileMatrixSet queryTileMatrixSet = dao.queryForId(tileMatrixSet
.getId());
TestCase.assertEquals(contents.getId(),
queryTileMatrixSet.getTableName());
TestCase.assertEquals(contents.getSrsId().longValue(),
queryTileMatrixSet.getSrsId());
TestCase.assertEquals(contents.getMinX(),
queryTileMatrixSet.getMinX());
TestCase.assertEquals(contents.getMinY(),
queryTileMatrixSet.getMinY());
TestCase.assertEquals(contents.getMaxX(),
queryTileMatrixSet.getMaxX());
TestCase.assertEquals(contents.getMaxY(),
queryTileMatrixSet.getMaxY());
TestCase.assertEquals(contents.getId(), queryTileMatrixSet
.getContents().getId());
TestCase.assertEquals(contents.getSrsId().longValue(),
queryTileMatrixSet.getSrs().getId());
}
}
Example 9
| Source File: TileMatrixSetUtils.java From geopackage-android with MIT License | 4 votes |
|
/**
* Test delete
*
* @param geoPackage
* @throws SQLException
*/
public static void testDelete(GeoPackage geoPackage) throws SQLException {
TileMatrixSetDao dao = geoPackage.getTileMatrixSetDao();
if (dao.isTableExists()) {
List<TileMatrixSet> results = dao.queryForAll();
if (!results.isEmpty()) {
// Choose random tile matrix set
int random = (int) (Math.random() * results.size());
TileMatrixSet tileMatrixSet = results.get(random);
// Delete the tile matrix set
geoPackage.foreignKeys(false);
dao.delete(tileMatrixSet);
// Verify deleted
TileMatrixSet queryTileMatrixSet = dao.queryForId(tileMatrixSet
.getId());
TestCase.assertNull(queryTileMatrixSet);
// Prepared deleted
results = dao.queryForAll();
if (!results.isEmpty()) {
// Choose random tile matrix set
random = (int) (Math.random() * results.size());
tileMatrixSet = results.get(random);
// Find which tile matrix set to delete
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();
// Delete
DeleteBuilder<TileMatrixSet, String> db = dao
.deleteBuilder();
db.where().eq(TileMatrixSet.COLUMN_SRS_ID,
tileMatrixSet.getSrsId());
PreparedDelete<TileMatrixSet> deleteQuery = db.prepare();
int deleted = dao.delete(deleteQuery);
TestCase.assertEquals(count, deleted);
}
}
}
}
Example 10
| Source File: CoverageDataPngImportTest.java From geopackage-java with MIT License | 4 votes |
|
/**
* Test 10 random locations and optionally print
*
* @throws Exception
*/
@Test
public void testRandomLocations() throws Exception {
BoundingBox projectedBoundingBox = null;
List<String> coverageDataTables = CoverageDataPng.getTables(geoPackage);
TileMatrixSetDao dao = geoPackage.getTileMatrixSetDao();
for (String coverageTable : coverageDataTables) {
TileMatrixSet tileMatrixSet = dao.queryForId(coverageTable);
BoundingBox boundingBox = tileMatrixSet.getBoundingBox();
if (PRINT) {
System.out.println("Min Latitude: "
+ boundingBox.getMinLatitude());
System.out.println("Max Latitude: "
+ boundingBox.getMaxLatitude());
System.out.println("Min Longitude: "
+ boundingBox.getMinLongitude());
System.out.println("Max Longitude: "
+ boundingBox.getMaxLongitude());
System.out.println();
}
SpatialReferenceSystemDao srsDao = geoPackage
.getSpatialReferenceSystemDao();
long srsId = tileMatrixSet.getSrsId();
SpatialReferenceSystem srs = srsDao.queryForId(srsId);
Projection projection = srs.getProjection();
Projection requestProjection = ProjectionFactory
.getProjection(ProjectionConstants.EPSG_WORLD_GEODETIC_SYSTEM);
ProjectionTransform coverageToRequest = projection
.getTransformation(requestProjection);
projectedBoundingBox = boundingBox.transform(coverageToRequest);
}
if (PRINT) {
System.out.println("Min Latitude: "
+ projectedBoundingBox.getMinLatitude());
System.out.println("Max Latitude: "
+ projectedBoundingBox.getMaxLatitude());
System.out.println("Min Longitude: "
+ projectedBoundingBox.getMinLongitude());
System.out.println("Max Longitude: "
+ projectedBoundingBox.getMaxLongitude());
System.out.println();
}
double latDistance = projectedBoundingBox.getMaxLatitude()
- projectedBoundingBox.getMinLatitude();
double lonDistance = projectedBoundingBox.getMaxLongitude()
- projectedBoundingBox.getMinLongitude();
for (int i = 0; i < 10; i++) {
// Get a random coordinate
double latitude = latDistance * .9 * Math.random()
+ projectedBoundingBox.getMinLatitude()
+ (.05 * latDistance);
double longitude = lonDistance * .9 * Math.random()
+ projectedBoundingBox.getMinLongitude()
+ (.05 * lonDistance);
testLocation(latitude, longitude);
if (PRINT) {
System.out.println();
}
}
}
Example 11
| Source File: CoverageDataTiffImportTest.java From geopackage-java with MIT License | 4 votes |
|
/**
* Test 10 random locations and optionally print
*
* @throws Exception
*/
@Test
public void testRandomLocations() throws Exception {
BoundingBox projectedBoundingBox = null;
List<String> coverageDataTables = CoverageDataTiff
.getTables(geoPackage);
TileMatrixSetDao dao = geoPackage.getTileMatrixSetDao();
for (String coverageTable : coverageDataTables) {
TileMatrixSet tileMatrixSet = dao.queryForId(coverageTable);
BoundingBox boundingBox = tileMatrixSet.getBoundingBox();
if (PRINT) {
System.out.println("Min Latitude: "
+ boundingBox.getMinLatitude());
System.out.println("Max Latitude: "
+ boundingBox.getMaxLatitude());
System.out.println("Min Longitude: "
+ boundingBox.getMinLongitude());
System.out.println("Max Longitude: "
+ boundingBox.getMaxLongitude());
System.out.println();
}
SpatialReferenceSystemDao srsDao = geoPackage
.getSpatialReferenceSystemDao();
long srsId = tileMatrixSet.getSrsId();
SpatialReferenceSystem srs = srsDao.queryForId(srsId);
Projection projection = srs.getProjection();
Projection requestProjection = ProjectionFactory
.getProjection(ProjectionConstants.EPSG_WORLD_GEODETIC_SYSTEM);
ProjectionTransform coverageToRequest = projection
.getTransformation(requestProjection);
projectedBoundingBox = boundingBox.transform(coverageToRequest);
}
if (PRINT) {
System.out.println("Min Latitude: "
+ projectedBoundingBox.getMinLatitude());
System.out.println("Max Latitude: "
+ projectedBoundingBox.getMaxLatitude());
System.out.println("Min Longitude: "
+ projectedBoundingBox.getMinLongitude());
System.out.println("Max Longitude: "
+ projectedBoundingBox.getMaxLongitude());
System.out.println();
}
double latDistance = projectedBoundingBox.getMaxLatitude()
- projectedBoundingBox.getMinLatitude();
double lonDistance = projectedBoundingBox.getMaxLongitude()
- projectedBoundingBox.getMinLongitude();
for (int i = 0; i < 10; i++) {
// Get a random coordinate
double latitude = latDistance * .9 * Math.random()
+ projectedBoundingBox.getMinLatitude()
+ (.05 * latDistance);
double longitude = lonDistance * .9 * Math.random()
+ projectedBoundingBox.getMinLongitude()
+ (.05 * lonDistance);
testLocation(latitude, longitude);
if (PRINT) {
System.out.println();
}
}
}
Example 12
| Source File: TileMatrixSetUtils.java From geopackage-java with MIT License | 4 votes |
|
/**
* Test create
*
* @param geoPackage
* @throws SQLException
*/
public static void testCreate(GeoPackage geoPackage) throws SQLException {
SpatialReferenceSystemDao srsDao = geoPackage
.getSpatialReferenceSystemDao();
ContentsDao contentsDao = geoPackage.getContentsDao();
TileMatrixSetDao dao = geoPackage.getTileMatrixSetDao();
if (dao.isTableExists()) {
// Get current count
long count = dao.countOf();
TestCase.assertEquals(count, dao.getTileTables().size());
// Retrieve a random srs
List<SpatialReferenceSystem> results = srsDao.queryForAll();
SpatialReferenceSystem srs = null;
if (!results.isEmpty()) {
int random = (int) (Math.random() * results.size());
srs = results.get(random);
}
// Create a new contents
Contents contents = new Contents();
contents.setTableName("test_contents");
contents.setDataType(ContentsDataType.TILES);
contents.setIdentifier("test_contents");
contents.setDescription("");
// contents.setLastChange(new Date());
contents.setMinX(-180.0);
contents.setMinY(-90.0);
contents.setMaxX(180.0);
contents.setMaxY(90.0);
contents.setSrs(srs);
// Create the user tile table
geoPackage.createTileTable(TestUtils.buildTileTable(contents
.getTableName()));
contentsDao.create(contents);
// Create new matrix tile set
TileMatrixSet tileMatrixSet = new TileMatrixSet();
tileMatrixSet.setContents(contents);
tileMatrixSet.setSrs(contents.getSrs());
tileMatrixSet.setMinX(contents.getMinX());
tileMatrixSet.setMinY(contents.getMinY());
tileMatrixSet.setMaxX(contents.getMaxX());
tileMatrixSet.setMaxY(contents.getMaxY());
dao.create(tileMatrixSet);
// Verify count
long newCount = dao.countOf();
TestCase.assertEquals(count + 1, newCount);
TestCase.assertEquals(newCount, dao.getTileTables().size());
TestCase.assertTrue(dao.getTileTables().contains(
contents.getTableName()));
// Verify saved matrix tile set
TileMatrixSet queryTileMatrixSet = dao.queryForId(tileMatrixSet
.getId());
TestCase.assertEquals(contents.getId(),
queryTileMatrixSet.getTableName());
TestCase.assertEquals(contents.getSrsId().longValue(),
queryTileMatrixSet.getSrsId());
TestCase.assertEquals(contents.getMinX(),
queryTileMatrixSet.getMinX());
TestCase.assertEquals(contents.getMinY(),
queryTileMatrixSet.getMinY());
TestCase.assertEquals(contents.getMaxX(),
queryTileMatrixSet.getMaxX());
TestCase.assertEquals(contents.getMaxY(),
queryTileMatrixSet.getMaxY());
TestCase.assertEquals(contents.getId(), queryTileMatrixSet
.getContents().getId());
TestCase.assertEquals(contents.getSrsId().longValue(),
queryTileMatrixSet.getSrs().getId());
}
}
Example 13
| Source File: TileMatrixSetUtils.java From geopackage-java with MIT License | 4 votes |
|
/**
* Test delete
*
* @param geoPackage
* @throws SQLException
*/
public static void testDelete(GeoPackage geoPackage) throws SQLException {
TileMatrixSetDao dao = geoPackage.getTileMatrixSetDao();
if (dao.isTableExists()) {
List<TileMatrixSet> results = dao.queryForAll();
if (!results.isEmpty()) {
// Choose random tile matrix set
int random = (int) (Math.random() * results.size());
TileMatrixSet tileMatrixSet = results.get(random);
// Delete the tile matrix set
geoPackage.foreignKeys(false);
dao.delete(tileMatrixSet);
// Verify deleted
TileMatrixSet queryTileMatrixSet = dao.queryForId(tileMatrixSet
.getId());
TestCase.assertNull(queryTileMatrixSet);
// Prepared deleted
results = dao.queryForAll();
if (!results.isEmpty()) {
// Choose random tile matrix set
random = (int) (Math.random() * results.size());
tileMatrixSet = results.get(random);
// Find which tile matrix set to delete
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();
// Delete
DeleteBuilder<TileMatrixSet, String> db = dao
.deleteBuilder();
db.where().eq(TileMatrixSet.COLUMN_SRS_ID,
tileMatrixSet.getSrsId());
PreparedDelete<TileMatrixSet> deleteQuery = db.prepare();
int deleted = dao.delete(deleteQuery);
TestCase.assertEquals(count, deleted);
}
}
}
}
