org.opengis.cite.gpkg10.core

Class SQLiteContainerTests

java.lang.Object

org.opengis.cite.gpkg10.CommonFixture

org.opengis.cite.gpkg10.core.SQLiteContainerTests

public class SQLiteContainerTests
extends CommonFixture

Defines test methods that apply to an SQLite database file. The GeoPackage standard defines a SQL database schema designed for use with the SQLite software library.

Sources

• GeoPackage Encoding Standard - SQLite Container (OGC 12-128r12)
• SQLite Database File Format

Author:

Richard Martell, Luke Lambert

Field Summary

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

databaseConnection, dataSource, gpkgFile, ROOT_PKG_PATH

Constructor Summary

Constructors

Constructor and Description
SQLiteContainerTests()

Method Summary

Modifier and Type	Method and Description
void	applicationID() A GeoPackage shall contain 0x47503130 ("GP10" in UTF-8/ASCII, [71,80,49,48]) in the "Application ID" field of the database header.
void	fileContents() A GeoPackage shall only contain data elements, SQL constructs and GeoPackage extensions with the "gpkg" author name specified in this encoding standard.
void	fileHeaderString() A GeoPackage shall be a SQLite database file using version 3 of the SQLite file format.
void	filenameExtension() A GeoPackage shall have the file extension name ".gpkg".
void	foreignKeyCheck() The SQLite PRAGMA foreign_key_check SQL with no parameter value SHALL return an empty result set indicating no invalid foreign key values for a GeoPackage file.
void	pragmaIntegrityCheck() The SQLite PRAGMA integrity_check SQL command SHALL return "ok" for a GeoPackage file.
void	sqlCheck() A GeoPackage SQLite Configuration SHALL provide SQL access to GeoPackage contents via software APIs.
void	sqliteOptions() Every GeoPackage SQLite Configuration SHALL have the SQLite library compile and run time options specified in table Every GeoPackage SQLite Configuration.

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

close, initCommonFixture

Methods inherited from class java.lang.Object

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

Constructor Detail

SQLiteContainerTests

public SQLiteContainerTests()

Method Detail

fileHeaderString

public void fileHeaderString()
                      throws IOException

A GeoPackage shall be a SQLite database file using version 3 of the SQLite file format. The first 16 bytes of a GeoPackage must contain the (UTF-8/ASCII) string "SQLite format 3", including the terminating NULL character.

Throws:

IOException - If an I/O error occurs while trying to read the data file.

See Also:

File Format - Requirement 1

applicationID

public void applicationID()
                   throws IOException

A GeoPackage shall contain 0x47503130 ("GP10" in UTF-8/ASCII, [71,80,49,48]) in the "Application ID" field of the database header. The field is located at offset 64 (a 32-bit unsigned big-endian integer).

Throws:

IOException - If an I/O error occurs while trying to read the data file.

See Also:

File Format - Requirement 2, Assigned application IDs

filenameExtension

public void filenameExtension()

A GeoPackage shall have the file extension name ".gpkg".

See Also:

File Extension Name - Requirement 3

fileContents

public void fileContents()

A GeoPackage shall only contain data elements, SQL constructs and GeoPackage extensions with the "gpkg" author name specified in this encoding standard.

See Also:

File Contents - Requirement 4

pragmaIntegrityCheck

public void pragmaIntegrityCheck()
                          throws SQLException

The SQLite PRAGMA integrity_check SQL command SHALL return "ok" for a GeoPackage file.

Throws:

SQLException - If an SQL query causes an error

See Also:

File Integrity - Requirement 6

foreignKeyCheck

public void foreignKeyCheck()
                     throws SQLException

The SQLite PRAGMA foreign_key_check SQL with no parameter value SHALL return an empty result set indicating no invalid foreign key values for a GeoPackage file.

Throws:

SQLException - If an SQL query causes an error

See Also:

File Integrity - Requirement 7

sqlCheck

public void sqlCheck()
              throws SQLException

A GeoPackage SQLite Configuration SHALL provide SQL access to GeoPackage contents via software APIs.

Throws:

SQLException - If an SQL query causes an error

See Also:

Structured Query Language (SQL) - Requirement 8

sqliteOptions

public void sqliteOptions()
                   throws SQLException

Every GeoPackage SQLite Configuration SHALL have the SQLite library compile and run time options specified in table Every GeoPackage SQLite Configuration.

Throws:

SQLException - If an SQL query causes an error

See Also:

Every GPKG SQLite Configuration - Requirement 9