Java Code Examples for mil.nga.geopackage.features.user.FeatureDao#count()

The following examples show how to use mil.nga.geopackage.features.user.FeatureDao#count() . These examples are extracted from open source projects. 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
/**
 * Index features
 *
 * @param activity
 * @param callback
 * @param database
 * @param tableName
 * @param indexLocation
 */
public static void indexFeatures(Activity activity, IIndexerTask callback,
                                 String database, String tableName,
                                 FeatureIndexType indexLocation) {

    GeoPackageManager manager = GeoPackageFactory.getManager(activity);
    GeoPackage geoPackage = manager.open(database);

    FeatureDao featureDao = geoPackage.getFeatureDao(tableName);

    FeatureIndexManager indexer = new FeatureIndexManager(activity, geoPackage, featureDao);
    indexer.setIndexLocation(indexLocation);

    ProgressDialog progressDialog = new ProgressDialog(activity);
    final IndexerTask indexTask = new IndexerTask(activity,
            callback, progressDialog, geoPackage, indexer);

    int max = featureDao.count();
    indexTask.setMax(max);
    indexer.setProgress(indexTask);

    progressDialog.setMessage(activity
            .getString(R.string.geopackage_table_index_features_index_title)
            + ": "
            + geoPackage.getName() + " - " + tableName);
    progressDialog.setCancelable(false);
    progressDialog.setProgressStyle(ProgressDialog.STYLE_HORIZONTAL);
    progressDialog.setIndeterminate(false);
    progressDialog.setMax(max);
    progressDialog.setButton(ProgressDialog.BUTTON_NEGATIVE,
            activity.getString(R.string.button_cancel_label),
            new DialogInterface.OnClickListener() {
                @Override
                public void onClick(DialogInterface dialog, int which) {
                    indexTask.cancel(true);
                }
            });

    indexTask.execute();
}
 
Example 2
Source Project: geopackage-android   File: TransactionTest.java    License: MIT License 4 votes vote down vote up
/**
 * Test a transaction using shortcut methods
 *
 * @param featureDao feature dao
 * @param rows       rows to insert
 * @param successful true for a successful transaction
 */
private void testUserDaoShortcuts2(FeatureDao featureDao, int rows, boolean successful) {

    int countBefore = featureDao.count();

    featureDao.beginTransaction();

    try {

        insertRows(featureDao, rows);

    } catch (Exception e) {

        featureDao.endTransaction(false);
        TestCase.fail(e.getMessage());

    } finally {

        featureDao.endTransaction(successful);

    }

    TestCase.assertEquals(successful ? countBefore + rows : countBefore, featureDao.count());

}
 
Example 3
Source Project: geopackage-android   File: TransactionTest.java    License: MIT License 4 votes vote down vote up
/**
 * Test a transaction with chunked inserts
 *
 * @param featureDao feature dao
 * @param rows       rows to insert
 * @param chunkSize  chunk size
 * @param successful true for a successful transaction
 */
private void testUserDaoChunks(FeatureDao featureDao, int rows, int chunkSize, boolean successful) {

    int countBefore = featureDao.count();

    featureDao.beginTransaction();

    try {

        for (int count = 1; count <= rows; count++) {

            insertRow(featureDao);

            if (count % chunkSize == 0) {

                if (successful) {
                    featureDao.commit();
                } else {
                    featureDao.failTransaction();
                    featureDao.beginTransaction();
                }

            }
        }

    } catch (Exception e) {

        featureDao.failTransaction();
        TestCase.fail(e.getMessage());

    } finally {
        if (successful) {
            featureDao.endTransaction();
        } else {
            featureDao.failTransaction();
        }
    }

    TestCase.assertEquals(successful ? countBefore + rows : countBefore, featureDao.count());

}
 
Example 4
Source Project: geopackage-android   File: FeaturePreviewUtils.java    License: MIT License 4 votes vote down vote up
/**
 * Test the GeoPackage draw feature preview
 *
 * @param activity   activity
 * @param geoPackage GeoPackage
 * @throws IOException upon error
 */
public static void testDraw(Activity activity, GeoPackage geoPackage) throws IOException {

    for (String featureTable : geoPackage.getFeatureTables()) {

        FeatureDao featureDao = geoPackage.getFeatureDao(featureTable);
        int count = featureDao.count(
                CoreSQLUtils.quoteWrap(featureDao.getGeometryColumnName())
                        + " IS NOT NULL");

        BoundingBox contentsBoundingBox = geoPackage
                .getContentsBoundingBox(featureTable);
        BoundingBox indexedBoundingBox = geoPackage
                .getBoundingBox(featureTable);
        boolean expectImage = (contentsBoundingBox != null
                || indexedBoundingBox != null) && count > 0;
        boolean epsg = featureDao.getProjection().getAuthority()
                .equalsIgnoreCase(ProjectionConstants.AUTHORITY_EPSG);

        FeaturePreview preview = new FeaturePreview(activity, geoPackage, featureDao);

        Bitmap image = preview.draw();
        if (epsg) {
            assertEquals(expectImage, image != null);
        }

        preview.setBufferPercentage(0.4);
        preview.setLimit((int) Math.ceil(count / 2.0));
        Bitmap imageLimit = preview.draw();
        if (epsg) {
            assertEquals(expectImage, imageLimit != null);
        }

        preview.setManual(true);
        preview.setBufferPercentage(0.05);
        preview.setLimit(null);
        FeatureTiles featureTiles = preview.getFeatureTiles();
        featureTiles.setTileWidth(TileUtils.TILE_PIXELS_DEFAULT);
        featureTiles.setTileHeight(TileUtils.TILE_PIXELS_DEFAULT);
        featureTiles.setDensity(
                TileUtils.density(TileUtils.TILE_PIXELS_DEFAULT));
        featureTiles.clearIconCache();
        Bitmap imageManual = preview.draw();
        if (epsg) {
            assertNotNull(imageManual);
        }

        preview.setBufferPercentage(0.35);
        preview.setLimit(Math.max(count - 1, 1));
        Bitmap imageManualLimit = preview.draw();
        if (epsg) {
            assertNotNull(imageManualLimit);
        }

        preview.setBufferPercentage(0.15);
        preview.setLimit(null);
        preview.appendWhere(
                CoreSQLUtils.quoteWrap(featureDao.getIdColumnName()) + " > "
                        + ((int) Math.floor(count / 2.0)));
        Bitmap imageManualWhere = preview.draw();
        if (epsg) {
            assertNotNull(imageManualWhere);
        }

        if(image != null) {
            image.recycle();
        }
        if(imageLimit != null) {
            imageLimit.recycle();
        }
        if(imageManual != null) {
            imageManual.recycle();
        }
        if(imageManualLimit != null) {
            imageManualLimit.recycle();
        }
        if(imageManualWhere != null) {
            imageManualWhere.recycle();
        }

        preview.close();
    }

}
 
Example 5
Source Project: geopackage-java   File: TransactionTest.java    License: MIT License 4 votes vote down vote up
/**
 * Test a transaction with chunked inserts
 *
 * @param featureDao
 *            feature dao
 * @param rows
 *            rows to insert
 * @param chunkSize
 *            chunk size
 * @param successful
 *            true for a successful transaction
 */
private void testUserDaoChunks(FeatureDao featureDao, int rows,
		int chunkSize, boolean successful) {

	int countBefore = featureDao.count();

	featureDao.beginTransaction();

	try {

		for (int count = 1; count <= rows; count++) {

			insertRow(featureDao);

			if (count % chunkSize == 0) {

				if (successful) {
					featureDao.commit();
				} else {
					featureDao.failTransaction();
					featureDao.beginTransaction();
				}

			}
		}

	} catch (Exception e) {

		featureDao.failTransaction();
		TestCase.fail(e.getMessage());

	} finally {
		if (successful) {
			featureDao.endTransaction();
		} else {
			featureDao.failTransaction();
		}
	}

	TestCase.assertEquals(successful ? countBefore + rows : countBefore,
			featureDao.count());

}
 
Example 6
Source Project: geopackage-java   File: FeaturePreviewUtils.java    License: MIT License 4 votes vote down vote up
/**
 * Test the GeoPackage draw feature preview
 * 
 * @param geoPackage
 *            GeoPackage
 * @throws IOException
 *             upon error
 */
public static void testDraw(GeoPackage geoPackage) throws IOException {

	for (String featureTable : geoPackage.getFeatureTables()) {

		FeatureDao featureDao = geoPackage.getFeatureDao(featureTable);
		int count = featureDao.count(
				CoreSQLUtils.quoteWrap(featureDao.getGeometryColumnName())
						+ " IS NOT NULL");

		BoundingBox contentsBoundingBox = geoPackage
				.getContentsBoundingBox(featureTable);
		BoundingBox indexedBoundingBox = geoPackage
				.getBoundingBox(featureTable);
		boolean expectImage = (contentsBoundingBox != null
				|| indexedBoundingBox != null) && count > 0;
		boolean epsg = featureDao.getProjection().getAuthority()
				.equalsIgnoreCase(ProjectionConstants.AUTHORITY_EPSG);

		FeaturePreview preview = new FeaturePreview(geoPackage, featureDao);

		BufferedImage image = preview.draw();
		if (epsg) {
			assertEquals(expectImage, image != null);
		}
		if (writeImages) {
			ImageIO.write(image, "png", new File("image.png"));
		}

		preview.setBufferPercentage(0.4);
		preview.setLimit((int) Math.ceil(count / 2.0));
		BufferedImage imageLimit = preview.draw();
		if (epsg) {
			assertEquals(expectImage, imageLimit != null);
		}
		if (writeImages) {
			ImageIO.write(imageLimit, "png", new File("image_limit.png"));
		}

		preview.setManual(true);
		preview.setBufferPercentage(0.05);
		preview.setLimit(null);
		FeatureTiles featureTiles = preview.getFeatureTiles();
		featureTiles.setTileWidth(TileUtils.TILE_PIXELS_DEFAULT);
		featureTiles.setTileHeight(TileUtils.TILE_PIXELS_DEFAULT);
		featureTiles.setScale(
				TileUtils.tileScale(TileUtils.TILE_PIXELS_DEFAULT));
		featureTiles.clearIconCache();
		BufferedImage imageManual = preview.draw();
		if (epsg) {
			assertNotNull(imageManual);
		}
		if (writeImages) {
			ImageIO.write(imageManual, "png", new File("image_manual.png"));
		}

		preview.setBufferPercentage(0.35);
		preview.setLimit(Math.max(count - 1, 1));
		BufferedImage imageManualLimit = preview.draw();
		if (epsg) {
			assertNotNull(imageManualLimit);
		}
		if (writeImages) {
			ImageIO.write(imageManualLimit, "png",
					new File("image_manual_limit.png"));
		}

		preview.setBufferPercentage(0.15);
		preview.setLimit(null);
		preview.appendWhere(
				CoreSQLUtils.quoteWrap(featureDao.getIdColumnName()) + " > "
						+ ((int) Math.floor(count / 2.0)));
		BufferedImage imageManualWhere = preview.draw();
		if (epsg) {
			assertNotNull(imageManualWhere);
		}
		if (writeImages) {
			ImageIO.write(imageManualWhere, "png",
					new File("image_manual_where.png"));
			System.out.println("Breakpoint here");
		}

	}

}
 
Example 7
Source Project: geopackage-android   File: TransactionTest.java    License: MIT License 3 votes vote down vote up
/**
 * Test a transaction
 *
 * @param featureDao feature dao
 * @param rows       rows to insert
 * @param successful true for a successful transaction
 */
private void testUserDao(FeatureDao featureDao, int rows, boolean successful) {

    int countBefore = featureDao.count();

    SQLiteDatabase db = featureDao.getDatabaseConnection().getDb();
    db.beginTransaction();

    try {

        insertRows(featureDao, rows);

        if (successful) {
            db.setTransactionSuccessful();
        }

    } catch (Exception e) {

        db.endTransaction();
        TestCase.fail(e.getMessage());

    } finally {

        db.endTransaction();

    }

    TestCase.assertEquals(successful ? countBefore + rows : countBefore, featureDao.count());

}
 
Example 8
Source Project: geopackage-android   File: TransactionTest.java    License: MIT License 3 votes vote down vote up
/**
 * Test a transaction using shortcut methods
 *
 * @param featureDao feature dao
 * @param rows       rows to insert
 * @param successful true for a successful transaction
 */
private void testUserDaoShortcuts(FeatureDao featureDao, int rows, boolean successful) {

    int countBefore = featureDao.count();

    featureDao.beginTransaction();

    try {

        insertRows(featureDao, rows);

    } catch (Exception e) {

        featureDao.failTransaction();
        TestCase.fail(e.getMessage());

    } finally {

        if (successful) {
            featureDao.endTransaction();
        } else {
            featureDao.failTransaction();
        }

    }

    TestCase.assertEquals(successful ? countBefore + rows : countBefore, featureDao.count());

}
 
Example 9
Source Project: geopackage-java   File: TransactionTest.java    License: MIT License 3 votes vote down vote up
/**
 * Test a transaction
 *
 * @param featureDao
 *            feature dao
 * @param rows
 *            rows to insert
 * @param successful
 *            true for a successful transaction
 * @throws SQLException
 *             upon error
 */
private void testUserDao(FeatureDao featureDao, int rows, boolean successful)
		throws SQLException {

	int countBefore = featureDao.count();

	Connection connection = featureDao.getConnection();
	connection.setAutoCommit(false);

	try {

		insertRows(featureDao, rows);

		if (successful) {
			connection.commit();
		} else {
			connection.rollback();
		}

	} catch (Exception e) {

		connection.rollback();
		TestCase.fail(e.getMessage());

	} finally {

		connection.setAutoCommit(true);

	}

	TestCase.assertEquals(successful ? countBefore + rows : countBefore,
			featureDao.count());

}
 
Example 10
Source Project: geopackage-java   File: TransactionTest.java    License: MIT License 3 votes vote down vote up
/**
 * Test a transaction using shortcut methods
 *
 * @param featureDao
 *            feature dao
 * @param rows
 *            rows to insert
 * @param successful
 *            true for a successful transaction
 */
private void testUserDaoShortcuts(FeatureDao featureDao, int rows,
		boolean successful) {

	int countBefore = featureDao.count();

	featureDao.beginTransaction();

	try {

		insertRows(featureDao, rows);

	} catch (Exception e) {

		featureDao.failTransaction();
		TestCase.fail(e.getMessage());

	} finally {

		if (successful) {
			featureDao.endTransaction();
		} else {
			featureDao.failTransaction();
		}

	}

	TestCase.assertEquals(successful ? countBefore + rows : countBefore,
			featureDao.count());

}
 
Example 11
Source Project: geopackage-java   File: TransactionTest.java    License: MIT License 3 votes vote down vote up
/**
 * Test a transaction using shortcut methods
 *
 * @param featureDao
 *            feature dao
 * @param rows
 *            rows to insert
 * @param successful
 *            true for a successful transaction
 */
private void testUserDaoShortcuts2(FeatureDao featureDao, int rows,
		boolean successful) {

	int countBefore = featureDao.count();

	featureDao.beginTransaction();

	try {

		insertRows(featureDao, rows);

	} catch (Exception e) {

		featureDao.endTransaction(false);
		TestCase.fail(e.getMessage());

	} finally {

		featureDao.endTransaction(successful);

	}

	TestCase.assertEquals(successful ? countBefore + rows : countBefore,
			featureDao.count());

}