Package mil.nga.geopackage.db

Class SQLiteDatabaseUtils

java.lang.Object
mil.nga.geopackage.db.SQLiteDatabaseUtils
public class SQLiteDatabaseUtils extends Object
SQLite Database utilities
Since:
5.1.0

  • Constructor Summary

    Constructors
    Constructor
    Description
    SQLiteDatabaseUtils()
     

  • Method Summary

    Modifier and Type
    Method
    Description
    static boolean
    isDatabaseHeaderValid(android.database.sqlite.SQLiteDatabase sqliteDatabase)
    Determine if the header of the database file is valid
    static android.database.sqlite.SQLiteDatabase
    openDatabase(String path, boolean writable)
    Open a database
    static android.database.sqlite.SQLiteDatabase
    openDatabase(String path, boolean writable, android.database.sqlite.SQLiteDatabase.CursorFactory cursorFactory)
    Open a database
    static android.database.sqlite.SQLiteDatabase
    openReadOnlyDatabase(String path)
    Open a readable database
    static android.database.sqlite.SQLiteDatabase
    openReadOnlyDatabase(String path, android.database.sqlite.SQLiteDatabase.CursorFactory cursorFactory)
    Open a readable database
    static android.database.sqlite.SQLiteDatabase
    openReadWriteDatabase(String path)
    Open a writable database
    static android.database.sqlite.SQLiteDatabase
    openReadWriteDatabase(String path, android.database.sqlite.SQLiteDatabase.CursorFactory cursorFactory)
    Open a writable database
    static android.database.sqlite.SQLiteDatabase
    openReadWriteDatabaseAttempt(String path)
    Attempt to open a writable database, logging any errors
    static android.database.sqlite.SQLiteDatabase
    openReadWriteDatabaseAttempt(String path, android.database.sqlite.SQLiteDatabase.CursorFactory cursorFactory)
    Attempt to open a writable database, logging any errors
    static void
    validateDatabase(android.database.sqlite.SQLiteDatabase sqliteDatabase, boolean validateHeader, boolean validateIntegrity, boolean close, boolean closeOnError)
    Validate the database header and integrity.
    static void
    validateDatabaseAndClose(android.database.sqlite.SQLiteDatabase sqliteDatabase, boolean validateHeader, boolean validateIntegrity)
    Validate the database and close it.
    static void
    validateDatabaseAndCloseOnError(android.database.sqlite.SQLiteDatabase sqliteDatabase, boolean validateHeader, boolean validateIntegrity)
    Validate the database and close when validation fails.
    static void
    validateDatabaseHeader(android.database.sqlite.SQLiteDatabase sqliteDatabase)
    Validate the header of the database file to verify it is a sqlite database
    static void
    validateDatabaseIntegrity(android.database.sqlite.SQLiteDatabase sqliteDatabase)
    Validate the integrity of the database

    Methods inherited from class java.lang.Object

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

  • Constructor Details

    • SQLiteDatabaseUtils

      public SQLiteDatabaseUtils()

  • Method Details

    • openReadWriteDatabaseAttempt

      public static android.database.sqlite.SQLiteDatabase openReadWriteDatabaseAttempt(String path)
      Attempt to open a writable database, logging any errors
      Parameters:
      path - full file path
      Returns:
      database or null if unable to open as writable

    • openReadWriteDatabaseAttempt

      public static android.database.sqlite.SQLiteDatabase openReadWriteDatabaseAttempt(String path, android.database.sqlite.SQLiteDatabase.CursorFactory cursorFactory)
      Attempt to open a writable database, logging any errors
      Parameters:
      path - full file path
      cursorFactory - cursor factory
      Returns:
      database or null if unable to open as writable

    • openReadWriteDatabase

      public static android.database.sqlite.SQLiteDatabase openReadWriteDatabase(String path)
      Open a writable database
      Parameters:
      path - full file path
      Returns:
      database

    • openReadWriteDatabase

      public static android.database.sqlite.SQLiteDatabase openReadWriteDatabase(String path, android.database.sqlite.SQLiteDatabase.CursorFactory cursorFactory)
      Open a writable database
      Parameters:
      path - full file path
      cursorFactory - cursor factory
      Returns:
      database

    • openReadOnlyDatabase

      public static android.database.sqlite.SQLiteDatabase openReadOnlyDatabase(String path)
      Open a readable database
      Parameters:
      path - full file path
      Returns:
      database

    • openReadOnlyDatabase

      public static android.database.sqlite.SQLiteDatabase openReadOnlyDatabase(String path, android.database.sqlite.SQLiteDatabase.CursorFactory cursorFactory)
      Open a readable database
      Parameters:
      path - full file path
      cursorFactory - cursor factory
      Returns:
      database

    • openDatabase

      public static android.database.sqlite.SQLiteDatabase openDatabase(String path, boolean writable)
      Open a database
      Parameters:
      path - full file path
      writable - open as writable or read only
      Returns:
      database

    • openDatabase

      public static android.database.sqlite.SQLiteDatabase openDatabase(String path, boolean writable, android.database.sqlite.SQLiteDatabase.CursorFactory cursorFactory)
      Open a database
      Parameters:
      path - full file path
      writable - open as writable or read only
      cursorFactory - cursor factory
      Returns:
      database

    • validateDatabaseAndCloseOnError

      public static void validateDatabaseAndCloseOnError(android.database.sqlite.SQLiteDatabase sqliteDatabase, boolean validateHeader, boolean validateIntegrity)
      Validate the database and close when validation fails. Throw an error when not valid.
      Parameters:
      sqliteDatabase - database
      validateHeader - validate the header
      validateIntegrity - validate the integrity

    • validateDatabaseAndClose

      public static void validateDatabaseAndClose(android.database.sqlite.SQLiteDatabase sqliteDatabase, boolean validateHeader, boolean validateIntegrity)
      Validate the database and close it. Throw an error when not valid.
      Parameters:
      sqliteDatabase - database
      validateHeader - validate the header
      validateIntegrity - validate the integrity

    • validateDatabase

      public static void validateDatabase(android.database.sqlite.SQLiteDatabase sqliteDatabase, boolean validateHeader, boolean validateIntegrity, boolean close, boolean closeOnError)
      Validate the database header and integrity. Throw an error when not valid.
      Parameters:
      sqliteDatabase - database
      validateHeader - validate the header
      validateIntegrity - validate the integrity
      close - close the database after validation
      closeOnError - close the database if validation fails

    • validateDatabaseHeader

      public static void validateDatabaseHeader(android.database.sqlite.SQLiteDatabase sqliteDatabase)
      Validate the header of the database file to verify it is a sqlite database
      Parameters:
      sqliteDatabase - database

    • isDatabaseHeaderValid

      public static boolean isDatabaseHeaderValid(android.database.sqlite.SQLiteDatabase sqliteDatabase)
      Determine if the header of the database file is valid
      Parameters:
      sqliteDatabase - database
      Returns:
      true if valid

    • validateDatabaseIntegrity

      public static void validateDatabaseIntegrity(android.database.sqlite.SQLiteDatabase sqliteDatabase)
      Validate the integrity of the database
      Parameters:
      sqliteDatabase - database