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 Summary

Modifier and Type	Method	Description
void	beginTransaction()	Begin a transaction
void	close()	Close the connection
int	delete(String table, String whereClause, String[] whereArgs)	Delete from table
void	endAndBeginTransaction()	End a transaction as successful and begin a new transaction
void	endTransaction()	End a transaction as successful
void	endTransaction(boolean successful)	End a transaction
void	execSQL(String sql)	Execute SQL
long	insert(String table, String nullColumnHack, ContentValues values)	Insert into a table
long	insertOrThrow(String table, String nullColumnHack, ContentValues values)	Insert into a table
boolean	inTransaction()	Determine if currently within a transaction
Cursor	query(boolean distinct, String table, String[] columns, String selection, String[] selectionArgs, String groupBy, String having, String orderBy, String limit)	Query the table
Cursor	query(String table, String[] columns, String[] columnsAs, String selection, String[] selectionArgs, String groupBy, String having, String orderBy)	Query the table
Cursor	query(String table, String[] columns, String[] columnsAs, String selection, String[] selectionArgs, String groupBy, String having, String orderBy, String limit)	Query the table
Cursor	query(String table, String[] columns, String selection, String[] selectionArgs, String groupBy, String having, String orderBy)	Query the table
Cursor	query(String table, String[] columns, String selection, String[] selectionArgs, String groupBy, String having, String orderBy, String limit)	Query the table
Cursor	rawQuery(String sql, String[] selectionArgs)	Raw query
Cursor	rawQueryWithFactory(GeoPackageCursorFactory cursorFactory, String sql, String[] selectionArgs, String editTable)	Raw query with factory
int	update(String table, ContentValues values, String whereClause, String[] whereArgs)	Update the table

Method Details

execSQL

void execSQL(String sql)
      throws SQLException

Execute SQL

Parameters:

sql - sql command

Throws:

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

Cursor rawQuery(String sql,
 String[] selectionArgs)

Raw query

Parameters:

sql - sql command

selectionArgs - selection arguments

Returns:

cursor

See Also:

• SQLiteDatabase.rawQuery(String, String[])

rawQueryWithFactory

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

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

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

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

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

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,
 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,
 ContentValues values)
            throws SQLException

Insert into a table

Parameters:

table - table name

nullColumnHack - null column hack

values - content values

Returns:

row id

Throws:

SQLException

See Also:

• SQLiteDatabase.insertOrThrow(String, String, ContentValues)

insert

long insert(String table,
 String nullColumnHack,
 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)