Package org.opengis.cite.gpkg12.extensions.rtreeindex

Class RTreeIndexTests

java.lang.Object

org.opengis.cite.gpkg12.CommonFixture

org.opengis.cite.gpkg12.extensions.rtreeindex.RTreeIndexTests

public class RTreeIndexTests
extends CommonFixture

Defines test methods that apply to descriptive information about a GeoPackage's RTree Index Extension.

Sources

• GeoPackage Encoding Standard - Annex F.3 RTree Spatial Index (OGC 12-128r14)

Author:

Jeff Yutzler

Field Summary

Fields inherited from class org.opengis.cite.gpkg12.CommonFixture

databaseConnection, dataSource, geopackageVersion, gpkgFile, ROOT_PKG_PATH

Constructor Summary

Constructors

Constructor	Description
RTreeIndexTests()

Method Summary

Modifier and Type	Method	Description
void	extensionIndexImplementation()	A GeoPackage SHALL implement spatial indexes on feature table geometry columns using the SQLite Virtual Table RTrees and triggers specified below.
void	extensionsTableRows()	A GeoPackage that implements spatial indexes SHALL have a `gpkg_extensions` table that contains a row for each spatially indexed column with `extension_name` "gpkg_rtree_index", the `table_name` of the table with a spatially indexed column, the `column_name` of the spatially indexed column, and a `scope` of "write-only".
void	setUp()	Sets up variables used across methods
void	validateExtensionPresent(org.testng.ITestContext testContext)	The "gpkg_rtree_index" extension name SHALL be used as a gpkg_extensions table extension_name column value to specify implementation of spatial indexes on a geometry column.

Methods inherited from class org.opengis.cite.gpkg12.CommonFixture

checkPrimaryKey, close, getGeopackageVersion, getPrimaryKeyColumn, getTestName, initCommonFixture, isExtendedType, setTestName, validateClassEnabled

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

RTreeIndexTests

public RTreeIndexTests()

Method Details

validateExtensionPresent

@BeforeClass
public void validateExtensionPresent(org.testng.ITestContext testContext)
                              throws SQLException

The "gpkg_rtree_index" extension name SHALL be used as a gpkg_extensions table extension_name column value to specify implementation of spatial indexes on a geometry column.

Parameters:

testContext - the ITestContext to use

Throws:

SQLException - on any error

See Also:

• Requirement 75

setUp

@BeforeClass
public void setUp()
           throws SQLException

Sets up variables used across methods

Throws:

SQLException - if there is a database error

extensionsTableRows

public void extensionsTableRows()
                         throws SQLException

A GeoPackage that implements spatial indexes SHALL have a `gpkg_extensions` table that contains a row for each spatially indexed column with `extension_name` "gpkg_rtree_index", the `table_name` of the table with a spatially indexed column, the `column_name` of the spatially indexed column, and a `scope` of "write-only".

Throws:

SQLException - on any error

See Also:

• Requirement 76

extensionIndexImplementation

public void extensionIndexImplementation()
                                  throws SQLException

A GeoPackage SHALL implement spatial indexes on feature table geometry columns using the SQLite Virtual Table RTrees and triggers specified below. The tables below contain SQL templates with variables. Replace the following template variables with the specified values to create the required SQL statements: <t>: The name of the feature table containing the geometry column <c>: The name of the geometry column in <t> that is being indexed <i>: The name of the integer primary key column in <t> as specified in [r29]

Throws:

SQLException - on any error

See Also:

• Requirement 77