mil.nga.geopackage.features.user.FeatureTable Java Examples

/**
 * Get the RTree Table
 * 
 * @param featureTable
 *            feature table
 * @return RTree table
 */
protected UserCustomTable getRTreeTable(FeatureTable featureTable) {

	List<UserCustomColumn> columns = new ArrayList<>();
	columns.add(UserCustomColumn.createPrimaryKeyColumn(COLUMN_ID));
	columns.add(UserCustomColumn.createColumn(COLUMN_MIN_X,
			GeoPackageDataType.FLOAT));
	columns.add(UserCustomColumn.createColumn(COLUMN_MAX_X,
			GeoPackageDataType.FLOAT));
	columns.add(UserCustomColumn.createColumn(COLUMN_MIN_Y,
			GeoPackageDataType.FLOAT));
	columns.add(UserCustomColumn.createColumn(COLUMN_MAX_Y,
			GeoPackageDataType.FLOAT));

	String rTreeTableName = getRTreeTableName(featureTable.getTableName(),
			featureTable.getGeometryColumnName());

	UserCustomTable userCustomTable = new UserCustomTable(rTreeTableName,
			columns);

	return userCustomTable;
}
 

/**
 * Build an example feature table
 *
 * @param tableName
 * @param geometryColumn
 * @param geometryType
 * @return
 */
public static FeatureTable buildFeatureTable(String tableName,
                                             String geometryColumn, GeometryType geometryType) {

    List<FeatureColumn> columns = new ArrayList<FeatureColumn>();

    columns.add(FeatureColumn.createPrimaryKeyColumn(0, "id"));
    columns.add(FeatureColumn.createColumn(7, "test_text_limited",
            GeoPackageDataType.TEXT, 5L, false, null));
    columns.add(FeatureColumn.createColumn(8, "test_blob_limited",
            GeoPackageDataType.BLOB, 7L, false, null));
    columns.add(FeatureColumn.createGeometryColumn(1, geometryColumn,
            geometryType, false, null));
    columns.add(FeatureColumn.createColumn(2, "test_text",
            GeoPackageDataType.TEXT, false, ""));
    columns.add(FeatureColumn.createColumn(3, "test_real",
            GeoPackageDataType.REAL, false, null));
    columns.add(FeatureColumn.createColumn(4, "test_boolean",
            GeoPackageDataType.BOOLEAN, false, null));
    columns.add(FeatureColumn.createColumn(5, "test_blob",
            GeoPackageDataType.BLOB, false, null));
    columns.add(FeatureColumn.createColumn(6, TEST_INTEGER_COLUMN,
            GeoPackageDataType.INTEGER, false, null));

    FeatureTable table = new FeatureTable(tableName, columns);

    return table;
}
 

/**
 * {@inheritDoc}
 */
@Override
public FeatureDao getFeatureDao(GeometryColumns geometryColumns) {

	if (geometryColumns == null) {
		throw new GeoPackageException(
				"Non null " + GeometryColumns.class.getSimpleName()
						+ " is required to create "
						+ FeatureDao.class.getSimpleName());
	}

	// Read the existing table and create the dao
	FeatureTableReader tableReader = new FeatureTableReader(
			geometryColumns);
	final FeatureTable featureTable = tableReader.readTable(database);
	featureTable.setContents(geometryColumns.getContents());
	FeatureDao dao = new FeatureDao(getName(), database, geometryColumns,
			featureTable);

	// If the GeoPackage is writable and the feature table has a RTree Index
	// extension, create the SQL functions
	if (writable) {
		RTreeIndexExtension rtree = new RTreeIndexExtension(this);
		rtree.createFunctions(featureTable);
	}

	return dao;
}
 

/**
 * Create the feature table with data columns entry
 * 
 * @param geoPackage
 * @param contents
 * @param geometryColumn
 * @param geometryType
 * @return feature table
 * @throws SQLException
 */
public static FeatureTable createFeatureTable(GeoPackage geoPackage,
		Contents contents, String geometryColumn, GeometryType geometryType)
		throws SQLException {

	FeatureTable table = buildFeatureTable(contents.getTableName(),
			geometryColumn, geometryType);
	geoPackage.createFeatureTable(table);

	double random = Math.random();

	DataColumnsDao dataColumnsDao = geoPackage.getDataColumnsDao();
	DataColumns dataColumns = new DataColumns();
	dataColumns.setContents(contents);
	dataColumns.setColumnName(TEST_INTEGER_COLUMN);
	dataColumns.setName(contents.getTableName());
	dataColumns.setTitle("TEST_TITLE");
	dataColumns.setDescription("TEST_DESCRIPTION");
	dataColumns.setMimeType("TEST_MIME_TYPE");

	if (random < (1.0 / 3.0)) {
		dataColumns.setConstraintName(SAMPLE_RANGE_CONSTRAINT);
	} else if (random < (2.0 / 3.0)) {
		dataColumns.setConstraintName(SAMPLE_ENUM_CONSTRAINT);
	} else {
		dataColumns.setConstraintName(SAMPLE_GLOB_CONSTRAINT);
	}

	dataColumnsDao.create(dataColumns);

	return table;
}
 

/**
 * Build an example feature table
 * 
 * @param tableName
 * @param geometryColumn
 * @param geometryType
 * @return feature table
 */
public static FeatureTable buildFeatureTable(String tableName,
		String geometryColumn, GeometryType geometryType) {

	List<FeatureColumn> columns = new ArrayList<FeatureColumn>();

	columns.add(FeatureColumn.createPrimaryKeyColumn(0, "id"));
	columns.add(FeatureColumn.createColumn(7, "test_text_limited",
			GeoPackageDataType.TEXT, 5L));
	columns.add(FeatureColumn.createColumn(8, "test_blob_limited",
			GeoPackageDataType.BLOB, 7L));
	columns.add(FeatureColumn.createColumn(9, "test_date",
			GeoPackageDataType.DATE));
	columns.add(FeatureColumn.createColumn(10, "test_datetime",
			GeoPackageDataType.DATETIME));
	columns.add(FeatureColumn.createGeometryColumn(1, geometryColumn,
			geometryType));
	columns.add(FeatureColumn.createColumn(2, "test_text",
			GeoPackageDataType.TEXT, false, ""));
	columns.add(FeatureColumn.createColumn(3, "test_real",
			GeoPackageDataType.REAL));
	columns.add(FeatureColumn.createColumn(4, "test_boolean",
			GeoPackageDataType.BOOLEAN));
	columns.add(FeatureColumn.createColumn(5, "test_blob",
			GeoPackageDataType.BLOB));
	columns.add(FeatureColumn.createColumn(6, TEST_INTEGER_COLUMN,
			GeoPackageDataType.INTEGER));

	FeatureTable table = new FeatureTable(tableName, geometryColumn,
			columns);

	return table;
}
 

/**
 * {@inheritDoc}
 */
@Override
public FeatureDao getFeatureDao(GeometryColumns geometryColumns) {

    if (geometryColumns == null) {
        throw new GeoPackageException("Non null "
                + GeometryColumns.class.getSimpleName()
                + " is required to create "
                + FeatureDao.class.getSimpleName());
    }

    // Read the existing table and create the dao
    FeatureTableReader tableReader = new FeatureTableReader(geometryColumns);
    final FeatureTable featureTable = tableReader.readTable(database);
    featureTable.setContents(geometryColumns.getContents());
    FeatureDao dao = new FeatureDao(getName(), database, geometryColumns, featureTable);

    // Register the table name (with and without quotes) to wrap cursors with the feature cursor
    registerCursorWrapper(geometryColumns.getTableName(),
            new GeoPackageCursorWrapper() {

                @Override
                public Cursor wrapCursor(Cursor cursor) {
                    return new FeatureCursor(featureTable, cursor);
                }
            });

    // If the GeoPackage is writable and the feature table has a RTree Index
    // extension, drop the RTree triggers.  User defined functions are currently not supported.
    if (writable) {
        RTreeIndexExtension rtree = new RTreeIndexExtension(this);
        rtree.dropTriggers(featureTable);
    }

    return dao;
}
 

/**
 * Build an example feature table
 *
 * @param tableName
 * @param geometryColumn
 * @param geometryType
 * @return
 */
public static FeatureTable buildFeatureTable(String tableName,
                                             String geometryColumn, GeometryType geometryType) {

    List<FeatureColumn> columns = new ArrayList<FeatureColumn>();

    columns.add(FeatureColumn.createPrimaryKeyColumn(0, "id"));
    columns.add(FeatureColumn.createColumn(7, "test_text_limited",
            GeoPackageDataType.TEXT, 5L));
    columns.add(FeatureColumn.createColumn(8, "test_blob_limited",
            GeoPackageDataType.BLOB, 7L));
    columns.add(FeatureColumn.createColumn(9, "test_date",
            GeoPackageDataType.DATE));
    columns.add(FeatureColumn.createColumn(10, "test_datetime",
            GeoPackageDataType.DATETIME));
    columns.add(FeatureColumn.createGeometryColumn(1, geometryColumn,
            geometryType));
    columns.add(FeatureColumn.createColumn(2, "test_text",
            GeoPackageDataType.TEXT, false, ""));
    columns.add(FeatureColumn.createColumn(3, "test_real",
            GeoPackageDataType.REAL));
    columns.add(FeatureColumn.createColumn(4, "test_boolean",
            GeoPackageDataType.BOOLEAN));
    columns.add(FeatureColumn.createColumn(5, "test_blob",
            GeoPackageDataType.BLOB));
    columns.add(FeatureColumn.createColumn(6, TEST_INTEGER_COLUMN,
            GeoPackageDataType.INTEGER));

    FeatureTable table = new FeatureTable(tableName, geometryColumn, columns);

    return table;
}
 

/**
 * Create a table view
 * 
 * @param db
 *            connection
 * @param featureTable
 *            feature column
 * @param viewName
 *            view name
 * @param quoteWrap
 */
private static void createViewWithName(GeoPackageConnection db,
		FeatureTable featureTable, String viewName, boolean quoteWrap) {

	StringBuilder view = new StringBuilder("CREATE VIEW ");
	if (quoteWrap) {
		viewName = CoreSQLUtils.quoteWrap(viewName);
	}
	view.append(viewName);
	view.append(" AS SELECT ");
	for (int i = 0; i < featureTable.columnCount(); i++) {
		if (i > 0) {
			view.append(", ");
		}
		view.append(CoreSQLUtils.quoteWrap(featureTable.getColumnName(i)));
		view.append(" AS ");
		String columnName = "column" + (i + 1);
		if (quoteWrap) {
			columnName = CoreSQLUtils.quoteWrap(columnName);
		}
		view.append(columnName);
	}
	view.append(" FROM ");
	String tableName = featureTable.getTableName();
	if (quoteWrap) {
		tableName = CoreSQLUtils.quoteWrap(tableName);
	}
	view.append(tableName);

	db.execSQL(view.toString());
}
 

/**
 * Create a table view
 *
 * @param db           connection
 * @param featureTable feature column
 * @param viewName     view name
 * @param quoteWrap
 */
private static void createViewWithName(GeoPackageConnection db,
                                       FeatureTable featureTable, String viewName, boolean quoteWrap) {

    StringBuilder view = new StringBuilder("CREATE VIEW ");
    if (quoteWrap) {
        viewName = CoreSQLUtils.quoteWrap(viewName);
    }
    view.append(viewName);
    view.append(" AS SELECT ");
    for (int i = 0; i < featureTable.columnCount(); i++) {
        if (i > 0) {
            view.append(", ");
        }
        view.append(CoreSQLUtils.quoteWrap(featureTable.getColumnName(i)));
        view.append(" AS ");
        String columnName = "column" + (i + 1);
        if (quoteWrap) {
            columnName = CoreSQLUtils.quoteWrap(columnName);
        }
        view.append(columnName);
    }
    view.append(" FROM ");
    String tableName = featureTable.getTableName();
    if (quoteWrap) {
        tableName = CoreSQLUtils.quoteWrap(tableName);
    }
    view.append(tableName);

    db.execSQL(view.toString());
}
 

/**
 * Create the feature table with data columns entry
 *
 * @param geoPackage
 * @param contents
 * @param geometryColumn
 * @param geometryType
 * @return
 * @throws SQLException
 */
public static FeatureTable createFeatureTable(GeoPackage geoPackage,
                                              Contents contents, String geometryColumn, GeometryType geometryType)
        throws SQLException {

    FeatureTable table = buildFeatureTable(contents.getTableName(),
            geometryColumn, geometryType);
    geoPackage.createFeatureTable(table);

    double random = Math.random();

    DataColumnsDao dataColumnsDao = geoPackage.getDataColumnsDao();
    DataColumns dataColumns = new DataColumns();
    dataColumns.setContents(contents);
    dataColumns.setColumnName(TEST_INTEGER_COLUMN);
    dataColumns.setName(contents.getTableName());
    dataColumns.setTitle("TEST_TITLE");
    dataColumns.setDescription("TEST_DESCRIPTION");
    dataColumns.setMimeType("TEST_MIME_TYPE");

    if (random < (1.0 / 3.0)) {
        dataColumns.setConstraintName(SAMPLE_RANGE_CONSTRAINT);
    } else if (random < (2.0 / 3.0)) {
        dataColumns.setConstraintName(SAMPLE_ENUM_CONSTRAINT);
    } else {
        dataColumns.setConstraintName(SAMPLE_GLOB_CONSTRAINT);
    }

    dataColumnsDao.create(dataColumns);

    return table;
}
 

/**
 * {@inheritDoc}
 */
@Override
public void createFeatureTable(FeatureTable table) {
	createUserTable(table);
}
 

private static void createRTreeSpatialIndexExtension(GeoPackage geoPackage) {

        RTreeIndexExtension extension = new RTreeIndexExtension(geoPackage);

        List<String> featureTables = geoPackage.getFeatureTables();
        for (String tableName : featureTables) {

            FeatureDao featureDao = geoPackage.getFeatureDao(tableName);
            FeatureTable featureTable = featureDao.getTable();

            extension.create(featureTable);
        }

    }
 

/**
 * Delete all feature styles
 * 
 * @param featureTable
 *            feature table
 */
public void deleteFeatureStyles(FeatureTable featureTable) {
	deleteFeatureStyles(featureTable.getTableName());
}
 

/**
 * Delete the feature table icon for the geometry type
 * 
 * @param featureTable
 *            feature table
 * @param geometryType
 *            geometry type
 */
public void deleteTableIcon(FeatureTable featureTable,
		GeometryType geometryType) {
	deleteTableIcon(featureTable.getTableName(), geometryType);
}
 

/**
 * Delete all styles
 * 
 * @param featureTable
 *            feature table
 */
public void deleteStyles(FeatureTable featureTable) {
	deleteStyles(featureTable.getTableName());
}
 

/**
 * Delete the feature table default icon
 * 
 * @param featureTable
 *            feature table
 */
public void deleteTableIconDefault(FeatureTable featureTable) {
	deleteTableIconDefault(featureTable.getTableName());
}
 

/**
 * Set the feature table default styles
 * 
 * @param featureTable
 *            feature table
 * @param styles
 *            default styles
 */
public void setTableStyles(FeatureTable featureTable, Styles styles) {
	setTableStyles(featureTable.getTableName(), styles);
}
 

/**
 * Set the feature table default feature styles
 * 
 * @param featureTable
 *            feature table
 * @param featureStyles
 *            default feature styles
 */
public void setTableFeatureStyles(FeatureTable featureTable,
		FeatureStyles featureStyles) {
	setTableFeatureStyles(featureTable.getTableName(), featureStyles);
}
 

/**
 * Delete the feature table icons
 * 
 * @param featureTable
 *            feature table
 */
public void deleteTableIcons(FeatureTable featureTable) {
	deleteTableIcons(featureTable.getTableName());
}
 

/**
 * Delete the RTree Index extension for the feature table. Drops the
 * triggers, RTree table, and deletes the extension.
 * 
 * @param featureTable
 *            feature table
 */
public void delete(FeatureTable featureTable) {
	delete(featureTable.getTableName(),
			featureTable.getGeometryColumnName());
}
 

/**
 * Delete the feature table style for the geometry type
 * 
 * @param featureTable
 *            feature table
 * @param geometryType
 *            geometry type
 */
public void deleteTableStyle(FeatureTable featureTable,
		GeometryType geometryType) {
	deleteTableStyle(featureTable.getTableName(), geometryType);
}
 

/**
 * Get the feature table default icons
 * 
 * @param featureTable
 *            feature table
 * @return table icons or null
 */
public Icons getTableIcons(FeatureTable featureTable) {
	return getTableIcons(featureTable.getTableName());
}
 

/**
 * Get the feature table default styles
 * 
 * @param featureTable
 *            feature table
 * @return table styles or null
 */
public Styles getTableStyles(FeatureTable featureTable) {
	return getTableStyles(featureTable.getTableName());
}
 

/**
 * Get the feature table default feature styles
 * 
 * @param featureTable
 *            feature table
 * @return table feature styles or null
 */
public FeatureStyles getTableFeatureStyles(FeatureTable featureTable) {
	return getTableFeatureStyles(featureTable.getTableName());
}
 

/**
 * Create a new feature table
 * 
 * @param table
 *            feature table
 */
public void createFeatureTable(FeatureTable table);
 

/**
 * Drop Triggers that Maintain Spatial Index Values
 * 
 * @param featureTable
 *            feature table
 */
public void dropAllTriggers(FeatureTable featureTable) {
	dropAllTriggers(featureTable.getTableName(),
			featureTable.getGeometryColumnName());
}
 

/**
 * Check if the feature table has the RTree extension and if found, drop the
 * triggers
 * 
 * @param featureTable
 *            feature table
 */
public void dropTriggers(FeatureTable featureTable) {
	dropTriggers(featureTable.getTableName(),
			featureTable.getGeometryColumnName());
}
 

/**
 * Drop the RTree Index Virtual Table
 * 
 * @param featureTable
 *            feature table
 */
public void dropRTreeIndex(FeatureTable featureTable) {
	dropRTreeIndex(featureTable.getTableName(),
			featureTable.getGeometryColumnName());
}
 

/**
 * Drop the the triggers and RTree table for the feature table
 * 
 * @param featureTable
 *            feature table
 */
public void drop(FeatureTable featureTable) {
	drop(featureTable.getTableName(), featureTable.getGeometryColumnName());
}
 

/**
 * Get all the unique icon row ids the features map to
 *
 * @param featureTable
 *            feature table
 * @return icon row ids
 */
public List<Long> getAllIconIds(FeatureTable featureTable) {
	return getAllIconIds(featureTable.getTableName());
}