Package mil.nga.geopackage.db

Interface GeoPackageSQLiteDatabase

All Known Implementing Classes:
AndroidBindingsSQLiteDatabase, AndroidSQLiteDatabase, GeoPackageDatabase
public interface GeoPackageSQLiteDatabase
GeoPackage SQLiteDatabase interface
Since:
3.4.0

  • Method Details

    • execSQL

      void execSQL(String sql) throws android.database.SQLException
      Execute SQL
      Parameters:
      sql - sql command
      Throws:
      android.database.SQLException
      See Also:
      • SQLiteDatabase.execSQL(String)

    • beginTransaction

      void beginTransaction()
      Begin a transaction

    • endTransaction

      void endTransaction()
      End a transaction as successful

    • endTransaction

      void endTransaction(boolean successful)
      End a transaction
      Parameters:
      successful - true to commit, false to rollback

    • endAndBeginTransaction

      void endAndBeginTransaction()
      End a transaction as successful and begin a new transaction

    • inTransaction

      boolean inTransaction()
      Determine if currently within a transaction
      Returns:
      true if in transaction

    • delete

      int delete(String table, String whereClause, String[] whereArgs)
      Delete from table
      Parameters:
      table - table name
      whereClause - where clause
      whereArgs - where arguments
      Returns:
      deleted rows
      See Also:
      • SQLiteDatabase.delete(String, String, String[])

    • rawQuery

      android.database.Cursor rawQuery(String sql, String[] selectionArgs)
      Raw query
      Parameters:
      sql - sql command
      selectionArgs - selection arguments
      Returns:
      cursor
      See Also:
      • SQLiteDatabase.rawQuery(String, String[])

    • rawQueryWithFactory

      android.database.Cursor rawQueryWithFactory(GeoPackageCursorFactory cursorFactory, String sql, String[] selectionArgs, String editTable)
      Raw query with factory
      Parameters:
      cursorFactory - cursor factory
      sql - sql command
      selectionArgs - selection arguments
      editTable - edit table name
      Returns:
      cursor
      Since:
      4.0.0
      See Also:
      • SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.CursorFactory, String, String[], String)

    • close

      void close()
      Close the connection
      See Also:
      • SQLiteClosable.close()

    • query

      android.database.Cursor query(String table, String[] columns, String selection, String[] selectionArgs, String groupBy, String having, String orderBy)
      Query the table
      Parameters:
      table - table name
      columns - columns
      selection - selection
      selectionArgs - selection arguments
      groupBy - group by
      having - having
      orderBy - order by
      Returns:
      cursor
      See Also:
      • SQLiteDatabase.query(String, String[], String, String[], String, String, String)

    • query

      android.database.Cursor query(String table, String[] columns, String[] columnsAs, String selection, String[] selectionArgs, String groupBy, String having, String orderBy)
      Query the table
      Parameters:
      table - table name
      columns - columns
      columnsAs - columns as
      selection - selection
      selectionArgs - selection arguments
      groupBy - group by
      having - having
      orderBy - order by
      Returns:
      cursor
      See Also:
      • SQLiteDatabase.query(String, String[], String, String[], String, String, String)

    • query

      android.database.Cursor query(String table, String[] columns, String selection, String[] selectionArgs, String groupBy, String having, String orderBy, String limit)
      Query the table
      Parameters:
      table - table name
      columns - columns
      selection - selection
      selectionArgs - selection arguments
      groupBy - group by
      having - having
      orderBy - order by
      limit - limit
      Returns:
      cursor
      See Also:
      • SQLiteDatabase.query(String, String[], String, String[], String, String, String, String)

    • query

      android.database.Cursor query(String table, String[] columns, String[] columnsAs, String selection, String[] selectionArgs, String groupBy, String having, String orderBy, String limit)
      Query the table
      Parameters:
      table - table name
      columns - columns
      columnsAs - columns as
      selection - selection
      selectionArgs - selection arguments
      groupBy - group by
      having - having
      orderBy - order by
      limit - limit
      Returns:
      cursor
      See Also:
      • SQLiteDatabase.query(String, String[], String, String[], String, String, String, String)

    • query

      android.database.Cursor query(boolean distinct, String table, String[] columns, String selection, String[] selectionArgs, String groupBy, String having, String orderBy, String limit)
      Query the table
      Parameters:
      distinct - distinct flag
      table - table name
      columns - columns
      selection - selection
      selectionArgs - selection arguments
      groupBy - group by
      having - having
      orderBy - order by
      limit - limit
      Returns:
      cursor
      Since:
      4.0.0
      See Also:
      • SQLiteDatabase.query(boolean, String, String[], String, String[], String, String, String, String)

    • update

      int update(String table, android.content.ContentValues values, String whereClause, String[] whereArgs)
      Update the table
      Parameters:
      table - table name
      values - content values
      whereClause - where clause
      whereArgs - where arguments
      Returns:
      updated rows
      See Also:
      • SQLiteDatabase.update(String, ContentValues, String, String[])

    • insertOrThrow

      long insertOrThrow(String table, String nullColumnHack, android.content.ContentValues values) throws android.database.SQLException
      Insert into a table
      Parameters:
      table - table name
      nullColumnHack - null column hack
      values - content values
      Returns:
      row id
      Throws:
      android.database.SQLException
      See Also:
      • SQLiteDatabase.insertOrThrow(String, String, ContentValues)

    • insert

      long insert(String table, String nullColumnHack, android.content.ContentValues values)
      Insert into a table
      Parameters:
      table - table name
      nullColumnHack - null column hack
      values - content values
      Returns:
      row id
      See Also:
      • SQLiteDatabase.insert(String, String, ContentValues)