Package 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

Author:
Richard Martell, Luke Lambert

  • Constructor Details

    • SQLiteContainerTests

      public SQLiteContainerTests()

  • Method Details

    • 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:

    • 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:

    • filenameExtension

      public void filenameExtension()
      A GeoPackage shall have the file extension name ".gpkg".
      See Also:

    • 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:

    • 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:

    • 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:

    • 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:

    • 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: