Skip navigation links
A B C D E F G H I L M N O P Q R S T U V W Y 

A

acquireConnection(String, int, CancellationSignal) - Method in class org.sqlite.database.sqlite.SQLiteConnectionPool
Acquires a connection from the pool.
acquireReference() - Method in class org.sqlite.database.sqlite.SQLiteClosable
Acquires a reference to the object.
addCustomFunction(String, int, SQLiteDatabase.CustomFunction) - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Registers a CustomFunction callback as a function that can be called from SQLite database triggers.
appendColumns(StringBuilder, String[]) - Static method in class org.sqlite.database.sqlite.SQLiteQueryBuilder
Add the names that are non-null in columns to s, separating them with commas.
appendEscapedSQLString(StringBuilder, String) - Static method in class org.sqlite.database.DatabaseUtils
Appends an SQL string to the given StringBuilder, including the opening and closing single quotes.
appendSelectionArgs(String[], String[]) - Static method in class org.sqlite.database.DatabaseUtils
Appends one set of selection args to another.
appendValueToSql(StringBuilder, Object) - Static method in class org.sqlite.database.DatabaseUtils
Appends an Object to an SQL string with the proper escaping, etc.
appendWhere(CharSequence) - Method in class org.sqlite.database.sqlite.SQLiteQueryBuilder
Append a chunk to the WHERE clause of the query.
appendWhereEscapeString(String) - Method in class org.sqlite.database.sqlite.SQLiteQueryBuilder
Append a chunk to the WHERE clause of the query.

B

beginTransaction() - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Begins a transaction in EXCLUSIVE mode.
beginTransaction(int, SQLiteTransactionListener, int, CancellationSignal) - Method in class org.sqlite.database.sqlite.SQLiteSession
Begins a transaction.
beginTransactionNonExclusive() - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Begins a transaction in IMMEDIATE mode.
beginTransactionWithListener(SQLiteTransactionListener) - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Begins a transaction in EXCLUSIVE mode.
beginTransactionWithListenerNonExclusive(SQLiteTransactionListener) - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Begins a transaction in IMMEDIATE mode.
bind(int, double) - Method in class org.sqlite.database.DatabaseUtils.InsertHelper
Deprecated.
Bind the value to an index.
bind(int, float) - Method in class org.sqlite.database.DatabaseUtils.InsertHelper
Deprecated.
Bind the value to an index.
bind(int, long) - Method in class org.sqlite.database.DatabaseUtils.InsertHelper
Deprecated.
Bind the value to an index.
bind(int, int) - Method in class org.sqlite.database.DatabaseUtils.InsertHelper
Deprecated.
Bind the value to an index.
bind(int, boolean) - Method in class org.sqlite.database.DatabaseUtils.InsertHelper
Deprecated.
Bind the value to an index.
bind(int, byte[]) - Method in class org.sqlite.database.DatabaseUtils.InsertHelper
Deprecated.
Bind the value to an index.
bind(int, String) - Method in class org.sqlite.database.DatabaseUtils.InsertHelper
Deprecated.
Bind the value to an index.
bindAllArgsAsStrings(String[]) - Method in class org.sqlite.database.sqlite.SQLiteProgram
Given an array of String bindArgs, this method binds all of them in one single call.
bindBlob(int, byte[]) - Method in class org.sqlite.database.sqlite.SQLiteProgram
Bind a byte array value to this statement.
bindDouble(int, double) - Method in class org.sqlite.database.sqlite.SQLiteProgram
Bind a double value to this statement.
bindLong(int, long) - Method in class org.sqlite.database.sqlite.SQLiteProgram
Bind a long value to this statement.
bindNull(int) - Method in class org.sqlite.database.DatabaseUtils.InsertHelper
Deprecated.
Bind null to an index.
bindNull(int) - Method in class org.sqlite.database.sqlite.SQLiteProgram
Bind a NULL value to this statement.
bindObjectToProgram(SQLiteProgram, int, Object) - Static method in class org.sqlite.database.DatabaseUtils
Binds the given Object to the given SQLiteProgram using the proper typing.
bindString(int, String) - Method in class org.sqlite.database.sqlite.SQLiteProgram
Bind a String value to this statement.
blobFileDescriptorForQuery(SQLiteDatabase, String, String[]) - Static method in class org.sqlite.database.DatabaseUtils
Utility method to run the query on the db and return the blob value in the first column of the first row.
blobFileDescriptorForQuery(SQLiteStatement, String[]) - Static method in class org.sqlite.database.DatabaseUtils
Utility method to run the pre-compiled query and return the blob value in the first column of the first row.
buildQuery(String[], String, String, String, String, String) - Method in class org.sqlite.database.sqlite.SQLiteQueryBuilder
Construct a SELECT statement suitable for use in a group of SELECT statements that will be joined through UNION operators in buildUnionQuery.
buildQuery(String[], String, String[], String, String, String, String) - Method in class org.sqlite.database.sqlite.SQLiteQueryBuilder
Deprecated.
This method's signature is misleading since no SQL parameter substitution is carried out. The selection arguments parameter does not get used at all. To avoid confusion, call SQLiteQueryBuilder.buildQuery(String[], String, String, String, String, String) instead.
buildQueryString(boolean, String, String[], String, String, String, String, String) - Static method in class org.sqlite.database.sqlite.SQLiteQueryBuilder
Build an SQL query string from the given clauses.
buildUnionQuery(String[], String, String) - Method in class org.sqlite.database.sqlite.SQLiteQueryBuilder
Given a set of subqueries, all of which are SELECT statements, construct a query that returns the union of what those subqueries return.
buildUnionSubQuery(String, String[], Set<String>, int, String, String, String, String) - Method in class org.sqlite.database.sqlite.SQLiteQueryBuilder
Construct a SELECT statement suitable for use in a group of SELECT statements that will be joined through UNION operators in buildUnionQuery.
buildUnionSubQuery(String, String[], Set<String>, int, String, String, String[], String, String) - Method in class org.sqlite.database.sqlite.SQLiteQueryBuilder
Deprecated.
This method's signature is misleading since no SQL parameter substitution is carried out. The selection arguments parameter does not get used at all. To avoid confusion, call SQLiteQueryBuilder.buildUnionSubQuery(java.lang.String, java.lang.String[], java.util.Set<java.lang.String>, int, java.lang.String, java.lang.String, java.lang.String, java.lang.String) instead.

C

cache - Variable in class org.sqlite.database.sqlite.SQLiteDebug.DbStats
statement cache stats: hits/misses/cachesize
callback - Variable in class org.sqlite.database.sqlite.SQLiteCustomFunction
 
callback(String[]) - Method in interface org.sqlite.database.sqlite.SQLiteDatabase.CustomFunction
 
clearBindings() - Method in class org.sqlite.database.sqlite.SQLiteProgram
Clears all existing bindings.
close() - Method in class org.sqlite.database.DatabaseUtils.InsertHelper
Deprecated.
Close this object and release any resources associated with it.
close() - Method in class org.sqlite.database.sqlite.CloseGuard
Marks this CloseGuard instance as closed to avoid warnings on finalization.
close() - Method in class org.sqlite.database.sqlite.SQLiteClosable
Releases a reference to the object, closing the object if the last reference was released.
close() - Method in class org.sqlite.database.sqlite.SQLiteConnectionPool
Closes the connection pool.
close() - Method in class org.sqlite.database.sqlite.SQLiteCursor
 
close() - Method in class org.sqlite.database.sqlite.SQLiteOpenHelper
Close any open database object.
CloseGuard - Class in org.sqlite.database.sqlite
CloseGuard is a mechanism for flagging implicit finalizer cleanup of resources that should have been cleaned up by explicit close methods (aka "explicit termination methods" in Effective Java).
CloseGuard.Reporter - Interface in org.sqlite.database.sqlite
Interface to allow customization of reporting behavior.
collectDbStats(ArrayList<SQLiteDebug.DbStats>) - Method in class org.sqlite.database.sqlite.SQLiteConnectionPool
Collects statistics about database connection memory usage.
columnNames - Variable in class org.sqlite.database.sqlite.SQLiteStatementInfo
The names of all columns in the result set of the statement.
compileStatement(String) - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Compiles an SQL statement into a reusable pre-compiled statement object.
concatenateWhere(String, String) - Static method in class org.sqlite.database.DatabaseUtils
Concatenates two SQL WHERE clauses, handling empty or null values.
CONFLICT_ABORT - Static variable in class org.sqlite.database.sqlite.SQLiteDatabase
When a constraint violation occurs,no ROLLBACK is executed so changes from prior commands within the same transaction are preserved.
CONFLICT_FAIL - Static variable in class org.sqlite.database.sqlite.SQLiteDatabase
When a constraint violation occurs, the command aborts with a return code SQLITE_CONSTRAINT.
CONFLICT_IGNORE - Static variable in class org.sqlite.database.sqlite.SQLiteDatabase
When a constraint violation occurs, the one row that contains the constraint violation is not inserted or changed.
CONFLICT_NONE - Static variable in class org.sqlite.database.sqlite.SQLiteDatabase
Use the following when no conflict action is specified.
CONFLICT_REPLACE - Static variable in class org.sqlite.database.sqlite.SQLiteDatabase
When a UNIQUE constraint violation occurs, the pre-existing rows that are causing the constraint violation are removed prior to inserting or updating the current row.
CONFLICT_ROLLBACK - Static variable in class org.sqlite.database.sqlite.SQLiteDatabase
When a constraint violation occurs, an immediate ROLLBACK occurs, thus ending the current transaction, and the command aborts with a return code of SQLITE_CONSTRAINT.
CONNECTION_FLAG_INTERACTIVE - Static variable in class org.sqlite.database.sqlite.SQLiteConnectionPool
Connection flag: Connection is being used interactively.
CONNECTION_FLAG_PRIMARY_CONNECTION_AFFINITY - Static variable in class org.sqlite.database.sqlite.SQLiteConnectionPool
Connection flag: Primary connection affinity.
CONNECTION_FLAG_READ_ONLY - Static variable in class org.sqlite.database.sqlite.SQLiteConnectionPool
Connection flag: Read-only.
create(SQLiteDatabase.CursorFactory) - Static method in class org.sqlite.database.sqlite.SQLiteDatabase
Create a memory backed SQLite database.
CREATE_IF_NECESSARY - Static variable in class org.sqlite.database.sqlite.SQLiteDatabase
Open flag: Flag for SQLiteDatabase.openDatabase(java.lang.String, org.sqlite.database.sqlite.SQLiteDatabase.CursorFactory, int) to create the database file if it does not already exist.
createDbFromSqlStatements(Context, String, int, String) - Static method in class org.sqlite.database.DatabaseUtils
Creates a db and populates it with the sql statements in sqlStatements.
cursorClosed() - Method in interface org.sqlite.database.sqlite.SQLiteCursorDriver
Called by a SQLiteCursor when it it closed to destroy this object as well.
cursorClosed() - Method in class org.sqlite.database.sqlite.SQLiteDirectCursorDriver
 
cursorDeactivated() - Method in interface org.sqlite.database.sqlite.SQLiteCursorDriver
Called by a SQLiteCursor when it is released.
cursorDeactivated() - Method in class org.sqlite.database.sqlite.SQLiteDirectCursorDriver
 
cursorDoubleToContentValues(Cursor, String, ContentValues, String) - Static method in class org.sqlite.database.DatabaseUtils
Reads a Double out of a field in a Cursor and writes it to a Map.
cursorDoubleToContentValuesIfPresent(Cursor, ContentValues, String) - Static method in class org.sqlite.database.DatabaseUtils
Reads a Double out of a column in a Cursor and writes it to a ContentValues.
cursorDoubleToCursorValues(Cursor, String, ContentValues) - Static method in class org.sqlite.database.DatabaseUtils
Reads a Double out of a field in a Cursor and writes it to a Map.
cursorFillWindow(Cursor, int, CursorWindow) - Static method in class org.sqlite.database.DatabaseUtils
Fills the specified cursor window by iterating over the contents of the cursor.
cursorFloatToContentValuesIfPresent(Cursor, ContentValues, String) - Static method in class org.sqlite.database.DatabaseUtils
Reads a Float out of a column in a Cursor and writes it to a ContentValues.
cursorIntToContentValues(Cursor, String, ContentValues) - Static method in class org.sqlite.database.DatabaseUtils
Reads an Integer out of a field in a Cursor and writes it to a Map.
cursorIntToContentValues(Cursor, String, ContentValues, String) - Static method in class org.sqlite.database.DatabaseUtils
Reads a Integer out of a field in a Cursor and writes it to a Map.
cursorIntToContentValuesIfPresent(Cursor, ContentValues, String) - Static method in class org.sqlite.database.DatabaseUtils
Reads a Integer out of a column in a Cursor and writes it to a ContentValues.
cursorLongToContentValues(Cursor, String, ContentValues) - Static method in class org.sqlite.database.DatabaseUtils
Reads a Long out of a field in a Cursor and writes it to a Map.
cursorLongToContentValues(Cursor, String, ContentValues, String) - Static method in class org.sqlite.database.DatabaseUtils
Reads a Long out of a field in a Cursor and writes it to a Map.
cursorLongToContentValuesIfPresent(Cursor, ContentValues, String) - Static method in class org.sqlite.database.DatabaseUtils
Reads a Long out of a column in a Cursor and writes it to a ContentValues.
cursorPickFillWindowStartPosition(int, int) - Static method in class org.sqlite.database.DatabaseUtils
Picks a start position for Cursor#fillWindow such that the window will contain the requested row and a useful range of rows around it.
cursorRequeried(Cursor) - Method in interface org.sqlite.database.sqlite.SQLiteCursorDriver
Called by a SQLiteCursor when it is requeried.
cursorRequeried(Cursor) - Method in class org.sqlite.database.sqlite.SQLiteDirectCursorDriver
 
cursorRowToContentValues(Cursor, ContentValues) - Static method in class org.sqlite.database.DatabaseUtils
Read the entire contents of a cursor row and store them in a ContentValues.
cursorShortToContentValuesIfPresent(Cursor, ContentValues, String) - Static method in class org.sqlite.database.DatabaseUtils
Reads a Short out of a column in a Cursor and writes it to a ContentValues.
cursorStringToContentValues(Cursor, String, ContentValues) - Static method in class org.sqlite.database.DatabaseUtils
Reads a String out of a field in a Cursor and writes it to a Map.
cursorStringToContentValues(Cursor, String, ContentValues, String) - Static method in class org.sqlite.database.DatabaseUtils
Reads a String out of a field in a Cursor and writes it to a Map.
cursorStringToContentValuesIfPresent(Cursor, ContentValues, String) - Static method in class org.sqlite.database.DatabaseUtils
Reads a String out of a column in a Cursor and writes it to a ContentValues.
cursorStringToInsertHelper(Cursor, String, DatabaseUtils.InsertHelper, int) - Static method in class org.sqlite.database.DatabaseUtils
Reads a String out of a field in a Cursor and writes it to an InsertHelper.
customFunctions - Variable in class org.sqlite.database.sqlite.SQLiteDatabaseConfiguration
The custom functions to register.

D

DatabaseErrorHandler - Interface in org.sqlite.database
An interface to let apps define an action to take when database corruption is detected.
DatabaseObjectNotClosedException - Exception in org.sqlite.database.sqlite
An exception that indicates that garbage-collector is finalizing a database object that is not explicitly closed
DatabaseObjectNotClosedException() - Constructor for exception org.sqlite.database.sqlite.DatabaseObjectNotClosedException
 
DatabaseUtils - Class in org.sqlite.database
Static utility methods for dealing with databases and Cursors.
DatabaseUtils() - Constructor for class org.sqlite.database.DatabaseUtils
 
DatabaseUtils.InsertHelper - Class in org.sqlite.database
Deprecated.
Use SQLiteStatement instead.
dbName - Variable in class org.sqlite.database.sqlite.SQLiteDebug.DbStats
name of the database
dbSize - Variable in class org.sqlite.database.sqlite.SQLiteDebug.DbStats
the database size
DbStats(String, long, long, int, int, int, int) - Constructor for class org.sqlite.database.sqlite.SQLiteDebug.DbStats
 
dbStats - Variable in class org.sqlite.database.sqlite.SQLiteDebug.PagerStats
a list of SQLiteDebug.DbStats - one for each main database opened by the applications running on the android device
deactivate() - Method in class org.sqlite.database.sqlite.SQLiteCursor
 
DEBUG_LOG_SLOW_QUERIES - Static variable in class org.sqlite.database.sqlite.SQLiteDebug
True to enable database performance testing instrumentation.
DEBUG_SQL_LOG - Static variable in class org.sqlite.database.sqlite.SQLiteDebug
Controls the printing of informational SQL log messages.
DEBUG_SQL_STATEMENTS - Static variable in class org.sqlite.database.sqlite.SQLiteDebug
Controls the printing of SQL statements as they are executed.
DEBUG_SQL_TIME - Static variable in class org.sqlite.database.sqlite.SQLiteDebug
Controls the printing of wall-clock time taken to execute SQL statements as they are executed.
DefaultDatabaseErrorHandler - Class in org.sqlite.database
Default class used to define the action to take when database corruption is reported by sqlite.
DefaultDatabaseErrorHandler() - Constructor for class org.sqlite.database.DefaultDatabaseErrorHandler
 
delete(String, String, String[]) - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Convenience method for deleting rows in the database.
deleteDatabase(File) - Static method in class org.sqlite.database.sqlite.SQLiteDatabase
Deletes a database including its journal file and other auxiliary files that may have been created by the database engine.
disableWriteAheadLogging() - Method in class org.sqlite.database.sqlite.SQLiteDatabase
This method disables the features enabled by SQLiteDatabase.enableWriteAheadLogging().
dump(Printer, boolean) - Method in class org.sqlite.database.sqlite.SQLiteConnection
Dumps debugging information about this connection.
dump(Printer, boolean) - Method in class org.sqlite.database.sqlite.SQLiteConnectionPool
Dumps debugging information about this connection pool.
dump(Printer, String[]) - Static method in class org.sqlite.database.sqlite.SQLiteDebug
Dumps detailed information about all databases used by the process.
dumpCurrentRow(Cursor) - Static method in class org.sqlite.database.DatabaseUtils
Prints the contents of a Cursor's current row to System.out.
dumpCurrentRow(Cursor, PrintStream) - Static method in class org.sqlite.database.DatabaseUtils
Prints the contents of a Cursor's current row to a PrintSteam.
dumpCurrentRow(Cursor, StringBuilder) - Static method in class org.sqlite.database.DatabaseUtils
Prints the contents of a Cursor's current row to a StringBuilder.
dumpCurrentRowToString(Cursor) - Static method in class org.sqlite.database.DatabaseUtils
Dump the contents of a Cursor's current row to a String.
dumpCursor(Cursor) - Static method in class org.sqlite.database.DatabaseUtils
Prints the contents of a Cursor to System.out.
dumpCursor(Cursor, PrintStream) - Static method in class org.sqlite.database.DatabaseUtils
Prints the contents of a Cursor to a PrintSteam.
dumpCursor(Cursor, StringBuilder) - Static method in class org.sqlite.database.DatabaseUtils
Prints the contents of a Cursor to a StringBuilder.
dumpCursorToString(Cursor) - Static method in class org.sqlite.database.DatabaseUtils
Prints the contents of a Cursor to a String.

E

ENABLE_WRITE_AHEAD_LOGGING - Static variable in class org.sqlite.database.sqlite.SQLiteDatabase
Open flag: Flag for SQLiteDatabase.openDatabase(java.lang.String, org.sqlite.database.sqlite.SQLiteDatabase.CursorFactory, int) to open the database file with write-ahead logging enabled by default.
enableLocalizedCollators() - Method in class org.sqlite.database.sqlite.SQLiteConnection
 
enableLocalizedCollators() - Method in class org.sqlite.database.sqlite.SQLiteConnectionPool
 
enableLocalizedCollators() - Method in class org.sqlite.database.sqlite.SQLiteDatabase
 
enableWriteAheadLogging() - Method in class org.sqlite.database.sqlite.SQLiteDatabase
This method enables parallel execution of queries from multiple threads on the same database.
endTransaction() - Method in class org.sqlite.database.sqlite.SQLiteDatabase
End a transaction.
endTransaction(CancellationSignal) - Method in class org.sqlite.database.sqlite.SQLiteSession
Ends the current transaction and commits or rolls back changes.
execSQL(String) - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Execute a single SQL statement that is NOT a SELECT or any other SQL statement that returns data.
execSQL(String, Object[]) - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Execute a single SQL statement that is NOT a SELECT/INSERT/UPDATE/DELETE.
execute() - Method in class org.sqlite.database.DatabaseUtils.InsertHelper
Deprecated.
Execute the previously prepared insert or replace using the bound values since the last call to prepareForInsert or prepareForReplace.
execute(String, Object[], CancellationSignal) - Method in class org.sqlite.database.sqlite.SQLiteConnection
Executes a statement that does not return a result.
execute(String, Object[], int, CancellationSignal) - Method in class org.sqlite.database.sqlite.SQLiteSession
Executes a statement that does not return a result.
execute() - Method in class org.sqlite.database.sqlite.SQLiteStatement
Execute this SQL statement, if it is not a SELECT / INSERT / DELETE / UPDATE, for example CREATE / DROP table, view, trigger, index etc.
executeForBlobFileDescriptor(String, Object[], CancellationSignal) - Method in class org.sqlite.database.sqlite.SQLiteConnection
Executes a statement that returns a single BLOB result as a file descriptor to a shared memory region.
executeForBlobFileDescriptor(String, Object[], int, CancellationSignal) - Method in class org.sqlite.database.sqlite.SQLiteSession
Executes a statement that returns a single BLOB result as a file descriptor to a shared memory region.
executeForChangedRowCount(String, Object[], CancellationSignal) - Method in class org.sqlite.database.sqlite.SQLiteConnection
Executes a statement that returns a count of the number of rows that were changed.
executeForChangedRowCount(String, Object[], int, CancellationSignal) - Method in class org.sqlite.database.sqlite.SQLiteSession
Executes a statement that returns a count of the number of rows that were changed.
executeForCursorWindow(String, Object[], CursorWindow, int, int, boolean, CancellationSignal) - Method in class org.sqlite.database.sqlite.SQLiteConnection
Executes a statement and populates the specified CursorWindow with a range of results.
executeForCursorWindow(String, Object[], CursorWindow, int, int, boolean, int, CancellationSignal) - Method in class org.sqlite.database.sqlite.SQLiteSession
Executes a statement and populates the specified CursorWindow with a range of results.
executeForLastInsertedRowId(String, Object[], CancellationSignal) - Method in class org.sqlite.database.sqlite.SQLiteConnection
Executes a statement that returns the row id of the last row inserted by the statement.
executeForLastInsertedRowId(String, Object[], int, CancellationSignal) - Method in class org.sqlite.database.sqlite.SQLiteSession
Executes a statement that returns the row id of the last row inserted by the statement.
executeForLong(String, Object[], CancellationSignal) - Method in class org.sqlite.database.sqlite.SQLiteConnection
Executes a statement that returns a single long result.
executeForLong(String, Object[], int, CancellationSignal) - Method in class org.sqlite.database.sqlite.SQLiteSession
Executes a statement that returns a single long result.
executeForString(String, Object[], CancellationSignal) - Method in class org.sqlite.database.sqlite.SQLiteConnection
Executes a statement that returns a single String result.
executeForString(String, Object[], int, CancellationSignal) - Method in class org.sqlite.database.sqlite.SQLiteSession
Executes a statement that returns a single String result.
executeInsert() - Method in class org.sqlite.database.sqlite.SQLiteStatement
Execute this SQL statement and return the ID of the row inserted due to this call.
executeUpdateDelete() - Method in class org.sqlite.database.sqlite.SQLiteStatement
Execute this SQL statement, if the the number of rows affected by execution of this SQL statement is of any importance to the caller - for example, UPDATE / DELETE SQL statements.

F

finalize() - Method in class org.sqlite.database.sqlite.SQLiteConnection
 
finalize() - Method in class org.sqlite.database.sqlite.SQLiteConnectionPool
 
finalize() - Method in class org.sqlite.database.sqlite.SQLiteCursor
Release the native resources, if they haven't been released yet.
finalize() - Method in class org.sqlite.database.sqlite.SQLiteDatabase
 
findEditTable(String) - Static method in class org.sqlite.database.sqlite.SQLiteDatabase
Finds the name of the first table, which is editable.
findRowIdColumnIndex(String[]) - Static method in class org.sqlite.database.DatabaseUtils
Returns column index of "_id" column, or -1 if not found.
foreignKeyConstraintsEnabled - Variable in class org.sqlite.database.sqlite.SQLiteDatabaseConfiguration
True if foreign key constraints are enabled.

G

get() - Static method in class org.sqlite.database.sqlite.CloseGuard
Returns a CloseGuard instance.
getAttachedDbs() - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Returns list of full pathnames of all attached databases including the main database by executing 'pragma database_list' on the database.
getCollationKey(String) - Static method in class org.sqlite.database.DatabaseUtils
return the collation key
getColumnIndex(String) - Method in class org.sqlite.database.DatabaseUtils.InsertHelper
Deprecated.
Returns the index of the specified column.
getColumnIndex(String) - Method in class org.sqlite.database.sqlite.SQLiteCursor
 
getColumnNames() - Method in class org.sqlite.database.sqlite.SQLiteCursor
 
getConnectionFlags() - Method in class org.sqlite.database.sqlite.SQLiteProgram
 
getConnectionId() - Method in class org.sqlite.database.sqlite.SQLiteConnection
Gets the unique id of this connection.
getCount() - Method in class org.sqlite.database.sqlite.SQLiteCursor
 
getDatabase() - Method in class org.sqlite.database.sqlite.SQLiteCursor
Get the database that this cursor is associated with.
getDatabaseInfo() - Static method in class org.sqlite.database.sqlite.SQLiteDebug
return all pager and database stats for the current process.
getDatabaseName() - Method in class org.sqlite.database.sqlite.SQLiteOpenHelper
Return the name of the SQLite database being opened, as given to the constructor.
getDefaultJournalMode() - Static method in class org.sqlite.database.sqlite.SQLiteGlobal
Gets the default journal mode when WAL is not in use.
getDefaultPageSize() - Static method in class org.sqlite.database.sqlite.SQLiteGlobal
Gets the default page size to use when creating a database.
getDefaultSyncMode() - Static method in class org.sqlite.database.sqlite.SQLiteGlobal
Gets the default database synchronization mode when WAL is not in use.
getHexCollationKey(String) - Static method in class org.sqlite.database.DatabaseUtils
return the collation key in hex format
getJournalSizeLimit() - Static method in class org.sqlite.database.sqlite.SQLiteGlobal
Gets the journal size limit in bytes.
getMaximumSize() - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Returns the maximum size the database may grow to.
getPageSize() - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Returns the current database page size, in bytes.
getPath() - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Gets the path to the database file.
getReadableDatabase() - Method in class org.sqlite.database.sqlite.SQLiteOpenHelper
Create and/or open a database.
getReporter() - Static method in class org.sqlite.database.sqlite.CloseGuard
Returns non-null CloseGuard.Reporter.
getSession() - Method in class org.sqlite.database.sqlite.SQLiteProgram
 
getSqlStatementType(String) - Static method in class org.sqlite.database.DatabaseUtils
Returns one of the following which represent the type of the given SQL statement.
getSyncedTables() - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Deprecated.
This method no longer serves any useful purpose and has been deprecated.
getTables() - Method in class org.sqlite.database.sqlite.SQLiteQueryBuilder
Returns the list of tables being queried
getTypeOfObject(Object) - Static method in class org.sqlite.database.DatabaseUtils
Returns data type of the given object's value.
getUniqueId() - Method in class org.sqlite.database.sqlite.SQLiteProgram
Deprecated.
This method is deprecated and must not be used.
getVersion() - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Gets the database version.
getWALAutoCheckpoint() - Static method in class org.sqlite.database.sqlite.SQLiteGlobal
Gets the WAL auto-checkpoint integer in database pages.
getWALConnectionPoolSize() - Static method in class org.sqlite.database.sqlite.SQLiteGlobal
Gets the connection pool size when in WAL mode.
getWALSyncMode() - Static method in class org.sqlite.database.sqlite.SQLiteGlobal
Gets the database synchronization mode when in WAL mode.
getWritableDatabase() - Method in class org.sqlite.database.sqlite.SQLiteOpenHelper
Create and/or open a database that will be used for reading and writing.

H

hasCodec() - Static method in class org.sqlite.database.sqlite.SQLiteConnection
 
hasCodec() - Static method in class org.sqlite.database.sqlite.SQLiteDatabase
 
hasConnection() - Method in class org.sqlite.database.sqlite.SQLiteSession
Returns true if the session has an active database connection.
hasNestedTransaction() - Method in class org.sqlite.database.sqlite.SQLiteSession
Returns true if the session has a nested transaction in progress.
hasTransaction() - Method in class org.sqlite.database.sqlite.SQLiteSession
Returns true if the session has a transaction in progress.

I

insert(ContentValues) - Method in class org.sqlite.database.DatabaseUtils.InsertHelper
Deprecated.
Performs an insert, adding a new row with the given values.
insert(String, String, ContentValues) - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Convenience method for inserting a row into the database.
InsertHelper(SQLiteDatabase, String) - Constructor for class org.sqlite.database.DatabaseUtils.InsertHelper
Deprecated.
 
insertOrThrow(String, String, ContentValues) - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Convenience method for inserting a row into the database.
insertWithOnConflict(String, String, ContentValues, int) - Method in class org.sqlite.database.sqlite.SQLiteDatabase
General method for inserting a row into the database.
inTransaction() - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Returns true if the current thread has a transaction pending.
isDatabaseIntegrityOk() - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Runs 'pragma integrity_check' on the given database (and all the attached databases) and returns true if the given database (and all its attached databases) pass integrity_check, false otherwise.
isDbLockedByCurrentThread() - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Returns true if the current thread is holding an active connection to the database.
isDbLockedByOtherThreads() - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Deprecated.
Always returns false. Do not use this method.
isInMemoryDatabase() - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Returns true if the database is in-memory db.
isInMemoryDb() - Method in class org.sqlite.database.sqlite.SQLiteDatabaseConfiguration
Returns true if the database is in-memory.
isOpen() - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Returns true if the database is currently open.
isPrimaryConnection() - Method in class org.sqlite.database.sqlite.SQLiteConnection
Returns true if this is the primary database connection.
isReadOnly() - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Returns true if the database is opened as read only.
isWriteAheadLoggingEnabled() - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Returns true if write-ahead logging has been enabled for this database.

L

label - Variable in class org.sqlite.database.sqlite.SQLiteDatabaseConfiguration
The label to use to describe the database when it appears in logs.
largestMemAlloc - Variable in class org.sqlite.database.sqlite.SQLiteDebug.PagerStats
records the largest memory allocation request handed to sqlite3.
locale - Variable in class org.sqlite.database.sqlite.SQLiteDatabaseConfiguration
The database locale.
longForQuery(SQLiteDatabase, String, String[]) - Static method in class org.sqlite.database.DatabaseUtils
Utility method to run the query on the db and return the value in the first column of the first row.
longForQuery(SQLiteStatement, String[]) - Static method in class org.sqlite.database.DatabaseUtils
Utility method to run the pre-compiled query and return the value in the first column of the first row.
lookaside - Variable in class org.sqlite.database.sqlite.SQLiteDebug.DbStats
documented here http://www.sqlite.org/c3ref/c_dbstatus_lookaside_used.html

M

markTableSyncable(String, String) - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Deprecated.
This method no longer serves any useful purpose and has been deprecated.
markTableSyncable(String, String, String) - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Deprecated.
This method no longer serves any useful purpose and has been deprecated.
MAX_SQL_CACHE_SIZE - Static variable in class org.sqlite.database.sqlite.SQLiteDatabase
Absolute max value that can be set by SQLiteDatabase.setMaxSqlCacheSize(int).
maxSqlCacheSize - Variable in class org.sqlite.database.sqlite.SQLiteDatabaseConfiguration
The maximum size of the prepared statement cache for each database connection.
MEMORY_DB_PATH - Static variable in class org.sqlite.database.sqlite.SQLiteDatabaseConfiguration
Special path used by in-memory databases.
memoryUsed - Variable in class org.sqlite.database.sqlite.SQLiteDebug.PagerStats
the current amount of memory checked out by sqlite using sqlite3_malloc().

N

name - Variable in class org.sqlite.database.sqlite.SQLiteCustomFunction
 
needUpgrade(int) - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Returns true if the new version code is greater than the current database version.
newCursor(SQLiteDatabase, SQLiteCursorDriver, String, SQLiteQuery) - Method in interface org.sqlite.database.sqlite.SQLiteDatabase.CursorFactory
NO_LOCALIZED_COLLATORS - Static variable in class org.sqlite.database.sqlite.SQLiteDatabase
Open flag: Flag for SQLiteDatabase.openDatabase(java.lang.String, org.sqlite.database.sqlite.SQLiteDatabase.CursorFactory, int) to open the database without support for localized collators.
numArgs - Variable in class org.sqlite.database.sqlite.SQLiteCustomFunction
 
numParameters - Variable in class org.sqlite.database.sqlite.SQLiteStatementInfo
The number of parameters that the statement has.

O

onAllReferencesReleased() - Method in class org.sqlite.database.sqlite.SQLiteClosable
Called when the last reference to the object was released by a call to SQLiteClosable.releaseReference() or SQLiteClosable.close().
onAllReferencesReleased() - Method in class org.sqlite.database.sqlite.SQLiteDatabase
 
onAllReferencesReleased() - Method in class org.sqlite.database.sqlite.SQLiteProgram
 
onAllReferencesReleasedFromContainer() - Method in class org.sqlite.database.sqlite.SQLiteClosable
Deprecated.
Do not use.
onBeforeDelete(SQLiteDatabase) - Method in class org.sqlite.database.sqlite.SQLiteOpenHelper
Called before the database is deleted when the version returned by SQLiteDatabase.getVersion() is lower than the minimum supported version passed (if at all) while creating this helper.
onBegin() - Method in interface org.sqlite.database.sqlite.SQLiteTransactionListener
Called immediately after the transaction begins.
onCancel() - Method in class org.sqlite.database.sqlite.SQLiteConnection
 
onCommit() - Method in interface org.sqlite.database.sqlite.SQLiteTransactionListener
Called immediately before commiting the transaction.
onConfigure(SQLiteDatabase) - Method in class org.sqlite.database.sqlite.SQLiteOpenHelper
Called when the database connection is being configured, to enable features such as write-ahead logging or foreign key support.
onCorruption(SQLiteDatabase) - Method in interface org.sqlite.database.DatabaseErrorHandler
The method invoked when database corruption is detected.
onCorruption(SQLiteDatabase) - Method in class org.sqlite.database.DefaultDatabaseErrorHandler
defines the default method to be invoked when database corruption is detected.
onCorruption() - Method in class org.sqlite.database.sqlite.SQLiteProgram
 
onCreate(SQLiteDatabase) - Method in class org.sqlite.database.sqlite.SQLiteOpenHelper
Called when the database is created for the first time.
onDowngrade(SQLiteDatabase, int, int) - Method in class org.sqlite.database.sqlite.SQLiteOpenHelper
Called when the database needs to be downgraded.
onMove(int, int) - Method in class org.sqlite.database.sqlite.SQLiteCursor
 
onOpen(SQLiteDatabase) - Method in class org.sqlite.database.sqlite.SQLiteOpenHelper
Called when the database has been opened.
onRollback() - Method in interface org.sqlite.database.sqlite.SQLiteTransactionListener
Called if the transaction is about to be rolled back.
onUpgrade(SQLiteDatabase, int, int) - Method in class org.sqlite.database.sqlite.SQLiteOpenHelper
Called when the database needs to be upgraded.
open(String) - Method in class org.sqlite.database.sqlite.CloseGuard
If CloseGuard is enabled, open initializes the instance with a warning that the caller should have explicitly called the closer method instead of relying on finalization.
open(SQLiteDatabaseConfiguration) - Static method in class org.sqlite.database.sqlite.SQLiteConnectionPool
Opens a connection pool for the specified database.
OPEN_READONLY - Static variable in class org.sqlite.database.sqlite.SQLiteDatabase
OPEN_READWRITE - Static variable in class org.sqlite.database.sqlite.SQLiteDatabase
openDatabase(String, SQLiteDatabase.CursorFactory, int) - Static method in class org.sqlite.database.sqlite.SQLiteDatabase
openDatabase(String, SQLiteDatabase.CursorFactory, int, DatabaseErrorHandler) - Static method in class org.sqlite.database.sqlite.SQLiteDatabase
openFlags - Variable in class org.sqlite.database.sqlite.SQLiteDatabaseConfiguration
The flags used to open the database.
openOrCreateDatabase(File, SQLiteDatabase.CursorFactory) - Static method in class org.sqlite.database.sqlite.SQLiteDatabase
Equivalent to openDatabase(file.getPath(), factory, CREATE_IF_NECESSARY).
openOrCreateDatabase(String, SQLiteDatabase.CursorFactory) - Static method in class org.sqlite.database.sqlite.SQLiteDatabase
Equivalent to openDatabase(path, factory, CREATE_IF_NECESSARY).
openOrCreateDatabase(String, SQLiteDatabase.CursorFactory, DatabaseErrorHandler) - Static method in class org.sqlite.database.sqlite.SQLiteDatabase
Equivalent to openDatabase(path, factory, CREATE_IF_NECESSARY, errorHandler).
org.sqlite.database - package org.sqlite.database
 
org.sqlite.database.sqlite - package org.sqlite.database.sqlite
 

P

pageCacheOverflow - Variable in class org.sqlite.database.sqlite.SQLiteDebug.PagerStats
the number of bytes of page cache allocation which could not be sattisfied by the SQLITE_CONFIG_PAGECACHE buffer and where forced to overflow to sqlite3_malloc().
PagerStats() - Constructor for class org.sqlite.database.sqlite.SQLiteDebug.PagerStats
 
pageSize - Variable in class org.sqlite.database.sqlite.SQLiteDebug.DbStats
the page size for the database
path - Variable in class org.sqlite.database.sqlite.SQLiteDatabaseConfiguration
The database path.
prepare(String, SQLiteStatementInfo) - Method in class org.sqlite.database.sqlite.SQLiteConnection
Prepares a statement for execution but does not bind its parameters or execute it.
prepare(String, int, CancellationSignal, SQLiteStatementInfo) - Method in class org.sqlite.database.sqlite.SQLiteSession
Prepares a statement for execution but does not bind its parameters or execute it.
prepareForInsert() - Method in class org.sqlite.database.DatabaseUtils.InsertHelper
Deprecated.
Prepare the InsertHelper for an insert.
prepareForReplace() - Method in class org.sqlite.database.DatabaseUtils.InsertHelper
Deprecated.
Prepare the InsertHelper for a replace.

Q

query(SQLiteDatabase.CursorFactory, String[]) - Method in interface org.sqlite.database.sqlite.SQLiteCursorDriver
Executes the query returning a Cursor over the result set.
query(boolean, String, String[], String, String[], String, String, String, String) - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Query the given URL, returning a Cursor over the result set.
query(boolean, String, String[], String, String[], String, String, String, String, CancellationSignal) - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Query the given URL, returning a Cursor over the result set.
query(String, String[], String, String[], String, String, String) - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Query the given table, returning a Cursor over the result set.
query(String, String[], String, String[], String, String, String, String) - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Query the given table, returning a Cursor over the result set.
query(SQLiteDatabase.CursorFactory, String[]) - Method in class org.sqlite.database.sqlite.SQLiteDirectCursorDriver
 
query(SQLiteDatabase, String[], String, String[], String, String, String) - Method in class org.sqlite.database.sqlite.SQLiteQueryBuilder
Perform a query by combining all current settings and the information passed into this method.
query(SQLiteDatabase, String[], String, String[], String, String, String, String) - Method in class org.sqlite.database.sqlite.SQLiteQueryBuilder
Perform a query by combining all current settings and the information passed into this method.
query(SQLiteDatabase, String[], String, String[], String, String, String, String, CancellationSignal) - Method in class org.sqlite.database.sqlite.SQLiteQueryBuilder
Perform a query by combining all current settings and the information passed into this method.
queryIsEmpty(SQLiteDatabase, String) - Static method in class org.sqlite.database.DatabaseUtils
Query the table to check whether a table is empty or not
queryNumEntries(SQLiteDatabase, String) - Static method in class org.sqlite.database.DatabaseUtils
Query the table for the number of rows in the table.
queryNumEntries(SQLiteDatabase, String, String) - Static method in class org.sqlite.database.DatabaseUtils
Query the table for the number of rows in the table.
queryNumEntries(SQLiteDatabase, String, String, String[]) - Static method in class org.sqlite.database.DatabaseUtils
Query the table for the number of rows in the table.
queryWithFactory(SQLiteDatabase.CursorFactory, boolean, String, String[], String, String[], String, String, String, String) - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Query the given URL, returning a Cursor over the result set.
queryWithFactory(SQLiteDatabase.CursorFactory, boolean, String, String[], String, String[], String, String, String, String, CancellationSignal) - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Query the given URL, returning a Cursor over the result set.

R

rawQuery(String, String[]) - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Runs the provided SQL and returns a Cursor over the result set.
rawQuery(String, String[], CancellationSignal) - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Runs the provided SQL and returns a Cursor over the result set.
rawQueryWithFactory(SQLiteDatabase.CursorFactory, String, String[], String) - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Runs the provided SQL and returns a cursor over the result set.
rawQueryWithFactory(SQLiteDatabase.CursorFactory, String, String[], String, CancellationSignal) - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Runs the provided SQL and returns a cursor over the result set.
readOnly - Variable in class org.sqlite.database.sqlite.SQLiteStatementInfo
True if the statement is read-only.
reconfigure(SQLiteDatabaseConfiguration) - Method in class org.sqlite.database.sqlite.SQLiteConnectionPool
Reconfigures the database configuration of the connection pool and all of its connections.
releaseConnection(SQLiteConnection) - Method in class org.sqlite.database.sqlite.SQLiteConnectionPool
Releases a connection back to the pool.
releaseMemory() - Static method in class org.sqlite.database.sqlite.SQLiteDatabase
Attempts to release memory that SQLite holds but does not require to operate properly.
releaseMemory() - Static method in class org.sqlite.database.sqlite.SQLiteGlobal
Attempts to release memory by pruning the SQLite page cache and other internal data structures.
releaseReference() - Method in class org.sqlite.database.sqlite.SQLiteClosable
Releases a reference to the object, closing the object if the last reference was released.
releaseReferenceFromContainer() - Method in class org.sqlite.database.sqlite.SQLiteClosable
Deprecated.
Do not use.
reopenReadWrite() - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Reopens the database in read-write mode.
replace(ContentValues) - Method in class org.sqlite.database.DatabaseUtils.InsertHelper
Deprecated.
Performs an insert, adding a new row with the given values.
replace(String, String, ContentValues) - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Convenience method for replacing a row in the database.
replaceOrThrow(String, String, ContentValues) - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Convenience method for replacing a row in the database.
report(String, Throwable) - Method in interface org.sqlite.database.sqlite.CloseGuard.Reporter
 
requery() - Method in class org.sqlite.database.sqlite.SQLiteCursor
 

S

setBindArguments(String[]) - Method in interface org.sqlite.database.sqlite.SQLiteCursorDriver
Set new bind arguments.
setBindArguments(String[]) - Method in class org.sqlite.database.sqlite.SQLiteDirectCursorDriver
 
setCursorFactory(SQLiteDatabase.CursorFactory) - Method in class org.sqlite.database.sqlite.SQLiteQueryBuilder
Sets the cursor factory to be used for the query.
setDistinct(boolean) - Method in class org.sqlite.database.sqlite.SQLiteQueryBuilder
Mark the query as DISTINCT.
setEnabled(boolean) - Static method in class org.sqlite.database.sqlite.CloseGuard
Used to enable or disable CloseGuard.
setForeignKeyConstraintsEnabled(boolean) - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Sets whether foreign key constraints are enabled for the database.
setLocale(Locale) - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Sets the locale for this database.
setLockingEnabled(boolean) - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Deprecated.
This method now does nothing. Do not use.
setMaximumSize(long) - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Sets the maximum size the database will grow to.
setMaxSqlCacheSize(int) - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Sets the maximum size of the prepared-statement cache for this database.
setPageSize(long) - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Sets the database page size.
setProjectionMap(Map<String, String>) - Method in class org.sqlite.database.sqlite.SQLiteQueryBuilder
Sets the projection map for the query.
setReporter(CloseGuard.Reporter) - Static method in class org.sqlite.database.sqlite.CloseGuard
Used to replace default Reporter used to warn of CloseGuard violations.
setSelectionArguments(String[]) - Method in class org.sqlite.database.sqlite.SQLiteCursor
Changes the selection arguments.
setStrict(boolean) - Method in class org.sqlite.database.sqlite.SQLiteQueryBuilder
When set, the selection is verified against malicious arguments.
setTables(String) - Method in class org.sqlite.database.sqlite.SQLiteQueryBuilder
Sets the list of tables to query.
setTransactionSuccessful() - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Marks the current transaction as successful.
setTransactionSuccessful() - Method in class org.sqlite.database.sqlite.SQLiteSession
Marks the current transaction as having completed successfully.
setVersion(int) - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Sets the database version.
setWindow(CursorWindow) - Method in class org.sqlite.database.sqlite.SQLiteCursor
 
setWriteAheadLoggingEnabled(boolean) - Method in class org.sqlite.database.sqlite.SQLiteOpenHelper
Enables or disables the use of write-ahead logging for the database.
shouldLogSlowQuery(long) - Static method in class org.sqlite.database.sqlite.SQLiteDebug
Determines whether a query should be logged.
shouldYieldConnection(SQLiteConnection, int) - Method in class org.sqlite.database.sqlite.SQLiteConnectionPool
Returns true if the session should yield the connection due to contention over available database connections.
simpleQueryForBlobFileDescriptor() - Method in class org.sqlite.database.sqlite.SQLiteStatement
Executes a statement that returns a 1 by 1 table with a blob value.
simpleQueryForLong() - Method in class org.sqlite.database.sqlite.SQLiteStatement
Execute a statement that returns a 1 by 1 table with a numeric value.
simpleQueryForString() - Method in class org.sqlite.database.sqlite.SQLiteStatement
Execute a statement that returns a 1 by 1 table with a text value.
sqlEscapeString(String) - Static method in class org.sqlite.database.DatabaseUtils
SQL-escape a string.
SQLException - Exception in org.sqlite.database
An exception that indicates there was an error with SQL parsing or execution.
SQLException() - Constructor for exception org.sqlite.database.SQLException
 
SQLException(String) - Constructor for exception org.sqlite.database.SQLException
 
SQLException(String, Throwable) - Constructor for exception org.sqlite.database.SQLException
 
SQLITE_MAX_LIKE_PATTERN_LENGTH - Static variable in class org.sqlite.database.sqlite.SQLiteDatabase
Maximum Length Of A LIKE Or GLOB Pattern The pattern matching algorithm used in the default LIKE and GLOB implementation of SQLite can exhibit O(N^2) performance (where N is the number of characters in the pattern) for certain pathological cases.
SQLiteAbortException - Exception in org.sqlite.database.sqlite
An exception that indicates that the SQLite program was aborted.
SQLiteAbortException() - Constructor for exception org.sqlite.database.sqlite.SQLiteAbortException
 
SQLiteAbortException(String) - Constructor for exception org.sqlite.database.sqlite.SQLiteAbortException
 
SQLiteAccessPermException - Exception in org.sqlite.database.sqlite
This exception class is used when sqlite can't access the database file due to lack of permissions on the file.
SQLiteAccessPermException() - Constructor for exception org.sqlite.database.sqlite.SQLiteAccessPermException
 
SQLiteAccessPermException(String) - Constructor for exception org.sqlite.database.sqlite.SQLiteAccessPermException
 
SQLiteBindOrColumnIndexOutOfRangeException - Exception in org.sqlite.database.sqlite
Thrown if the the bind or column parameter index is out of range
SQLiteBindOrColumnIndexOutOfRangeException() - Constructor for exception org.sqlite.database.sqlite.SQLiteBindOrColumnIndexOutOfRangeException
 
SQLiteBindOrColumnIndexOutOfRangeException(String) - Constructor for exception org.sqlite.database.sqlite.SQLiteBindOrColumnIndexOutOfRangeException
 
SQLiteBlobTooBigException - Exception in org.sqlite.database.sqlite
 
SQLiteBlobTooBigException() - Constructor for exception org.sqlite.database.sqlite.SQLiteBlobTooBigException
 
SQLiteBlobTooBigException(String) - Constructor for exception org.sqlite.database.sqlite.SQLiteBlobTooBigException
 
SQLiteCantOpenDatabaseException - Exception in org.sqlite.database.sqlite
 
SQLiteCantOpenDatabaseException() - Constructor for exception org.sqlite.database.sqlite.SQLiteCantOpenDatabaseException
 
SQLiteCantOpenDatabaseException(String) - Constructor for exception org.sqlite.database.sqlite.SQLiteCantOpenDatabaseException
 
SQLiteClosable - Class in org.sqlite.database.sqlite
An object created from a SQLiteDatabase that can be closed.
SQLiteClosable() - Constructor for class org.sqlite.database.sqlite.SQLiteClosable
 
SQLiteConnection - Class in org.sqlite.database.sqlite
Represents a SQLite database connection.
SQLiteConnectionPool - Class in org.sqlite.database.sqlite
Maintains a pool of active SQLite database connections.
SQLiteConstraintException - Exception in org.sqlite.database.sqlite
An exception that indicates that an integrity constraint was violated.
SQLiteConstraintException() - Constructor for exception org.sqlite.database.sqlite.SQLiteConstraintException
 
SQLiteConstraintException(String) - Constructor for exception org.sqlite.database.sqlite.SQLiteConstraintException
 
SQLiteCursor - Class in org.sqlite.database.sqlite
A Cursor implementation that exposes results from a query on a SQLiteDatabase.
SQLiteCursor(SQLiteDatabase, SQLiteCursorDriver, String, SQLiteQuery) - Constructor for class org.sqlite.database.sqlite.SQLiteCursor
SQLiteCursor(SQLiteCursorDriver, String, SQLiteQuery) - Constructor for class org.sqlite.database.sqlite.SQLiteCursor
Execute a query and provide access to its result set through a Cursor interface.
SQLiteCursorDriver - Interface in org.sqlite.database.sqlite
A driver for SQLiteCursors that is used to create them and gets notified by the cursors it creates on significant events in their lifetimes.
SQLiteCustomFunction - Class in org.sqlite.database.sqlite
Describes a custom SQL function.
SQLiteCustomFunction(String, int, SQLiteDatabase.CustomFunction) - Constructor for class org.sqlite.database.sqlite.SQLiteCustomFunction
Create custom function.
SQLiteDatabase - Class in org.sqlite.database.sqlite
Exposes methods to manage a SQLite database.
SQLiteDatabase.CursorFactory - Interface in org.sqlite.database.sqlite
Used to allow returning sub-classes of Cursor when calling query.
SQLiteDatabase.CustomFunction - Interface in org.sqlite.database.sqlite
A callback interface for a custom sqlite3 function.
SQLiteDatabaseConfiguration - Class in org.sqlite.database.sqlite
Describes how to configure a database.
SQLiteDatabaseConfiguration(String, int) - Constructor for class org.sqlite.database.sqlite.SQLiteDatabaseConfiguration
Creates a database configuration with the required parameters for opening a database and default values for all other parameters.
SQLiteDatabaseConfiguration(SQLiteDatabaseConfiguration) - Constructor for class org.sqlite.database.sqlite.SQLiteDatabaseConfiguration
Creates a database configuration as a copy of another configuration.
SQLiteDatabaseCorruptException - Exception in org.sqlite.database.sqlite
An exception that indicates that the SQLite database file is corrupt.
SQLiteDatabaseCorruptException() - Constructor for exception org.sqlite.database.sqlite.SQLiteDatabaseCorruptException
 
SQLiteDatabaseCorruptException(String) - Constructor for exception org.sqlite.database.sqlite.SQLiteDatabaseCorruptException
 
SQLiteDatabaseLockedException - Exception in org.sqlite.database.sqlite
Thrown if the database engine was unable to acquire the database locks it needs to do its job.
SQLiteDatabaseLockedException() - Constructor for exception org.sqlite.database.sqlite.SQLiteDatabaseLockedException
 
SQLiteDatabaseLockedException(String) - Constructor for exception org.sqlite.database.sqlite.SQLiteDatabaseLockedException
 
SQLiteDatatypeMismatchException - Exception in org.sqlite.database.sqlite
 
SQLiteDatatypeMismatchException() - Constructor for exception org.sqlite.database.sqlite.SQLiteDatatypeMismatchException
 
SQLiteDatatypeMismatchException(String) - Constructor for exception org.sqlite.database.sqlite.SQLiteDatatypeMismatchException
 
SQLiteDebug - Class in org.sqlite.database.sqlite
Provides debugging info about all SQLite databases running in the current process.
SQLiteDebug.DbStats - Class in org.sqlite.database.sqlite
contains statistics about a database
SQLiteDebug.PagerStats - Class in org.sqlite.database.sqlite
Contains statistics about the active pagers in the current process.
SQLiteDirectCursorDriver - Class in org.sqlite.database.sqlite
A cursor driver that uses the given query directly.
SQLiteDirectCursorDriver(SQLiteDatabase, String, String, CancellationSignal) - Constructor for class org.sqlite.database.sqlite.SQLiteDirectCursorDriver
 
SQLiteDiskIOException - Exception in org.sqlite.database.sqlite
An exception that indicates that an IO error occured while accessing the SQLite database file.
SQLiteDiskIOException() - Constructor for exception org.sqlite.database.sqlite.SQLiteDiskIOException
 
SQLiteDiskIOException(String) - Constructor for exception org.sqlite.database.sqlite.SQLiteDiskIOException
 
SQLiteDoneException - Exception in org.sqlite.database.sqlite
An exception that indicates that the SQLite program is done.
SQLiteDoneException() - Constructor for exception org.sqlite.database.sqlite.SQLiteDoneException
 
SQLiteDoneException(String) - Constructor for exception org.sqlite.database.sqlite.SQLiteDoneException
 
SQLiteException - Exception in org.sqlite.database.sqlite
A SQLite exception that indicates there was an error with SQL parsing or execution.
SQLiteException() - Constructor for exception org.sqlite.database.sqlite.SQLiteException
 
SQLiteException(String) - Constructor for exception org.sqlite.database.sqlite.SQLiteException
 
SQLiteException(String, Throwable) - Constructor for exception org.sqlite.database.sqlite.SQLiteException
 
SQLiteFullException - Exception in org.sqlite.database.sqlite
An exception that indicates that the SQLite database is full.
SQLiteFullException() - Constructor for exception org.sqlite.database.sqlite.SQLiteFullException
 
SQLiteFullException(String) - Constructor for exception org.sqlite.database.sqlite.SQLiteFullException
 
SQLiteGlobal - Class in org.sqlite.database.sqlite
Provides access to SQLite functions that affect all database connection, such as memory management.
SQLiteMisuseException - Exception in org.sqlite.database.sqlite
This error can occur if the application creates a SQLiteStatement object and allows multiple threads in the application use it at the same time.
SQLiteMisuseException() - Constructor for exception org.sqlite.database.sqlite.SQLiteMisuseException
 
SQLiteMisuseException(String) - Constructor for exception org.sqlite.database.sqlite.SQLiteMisuseException
 
SQLiteOpenHelper - Class in org.sqlite.database.sqlite
A helper class to manage database creation and version management.
SQLiteOpenHelper(Context, String, SQLiteDatabase.CursorFactory, int) - Constructor for class org.sqlite.database.sqlite.SQLiteOpenHelper
Create a helper object to create, open, and/or manage a database.
SQLiteOpenHelper(Context, String, SQLiteDatabase.CursorFactory, int, DatabaseErrorHandler) - Constructor for class org.sqlite.database.sqlite.SQLiteOpenHelper
Create a helper object to create, open, and/or manage a database.
SQLiteOpenHelper(Context, String, SQLiteDatabase.CursorFactory, int, int, DatabaseErrorHandler) - Constructor for class org.sqlite.database.sqlite.SQLiteOpenHelper
Same as #SQLiteOpenHelper(Context, String, CursorFactory, int, DatabaseErrorHandler) but also accepts an integer minimumSupportedVersion as a convenience for upgrading very old versions of this database that are no longer supported.
SQLiteOutOfMemoryException - Exception in org.sqlite.database.sqlite
 
SQLiteOutOfMemoryException() - Constructor for exception org.sqlite.database.sqlite.SQLiteOutOfMemoryException
 
SQLiteOutOfMemoryException(String) - Constructor for exception org.sqlite.database.sqlite.SQLiteOutOfMemoryException
 
SQLiteProgram - Class in org.sqlite.database.sqlite
A base class for compiled SQLite programs.
SQLiteQuery - Class in org.sqlite.database.sqlite
Represents a query that reads the resulting rows into a SQLiteQuery.
SQLiteQueryBuilder - Class in org.sqlite.database.sqlite
This is a convience class that helps build SQL queries to be sent to SQLiteDatabase objects.
SQLiteQueryBuilder() - Constructor for class org.sqlite.database.sqlite.SQLiteQueryBuilder
 
SQLiteReadOnlyDatabaseException - Exception in org.sqlite.database.sqlite
 
SQLiteReadOnlyDatabaseException() - Constructor for exception org.sqlite.database.sqlite.SQLiteReadOnlyDatabaseException
 
SQLiteReadOnlyDatabaseException(String) - Constructor for exception org.sqlite.database.sqlite.SQLiteReadOnlyDatabaseException
 
SQLiteSession - Class in org.sqlite.database.sqlite
Provides a single client the ability to use a database.
SQLiteSession(SQLiteConnectionPool) - Constructor for class org.sqlite.database.sqlite.SQLiteSession
Creates a session bound to the specified connection pool.
SQLiteStatement - Class in org.sqlite.database.sqlite
Represents a statement that can be executed against a database.
SQLiteStatementInfo - Class in org.sqlite.database.sqlite
Describes a SQLite statement.
SQLiteStatementInfo() - Constructor for class org.sqlite.database.sqlite.SQLiteStatementInfo
 
SQLiteTableLockedException - Exception in org.sqlite.database.sqlite
 
SQLiteTableLockedException() - Constructor for exception org.sqlite.database.sqlite.SQLiteTableLockedException
 
SQLiteTableLockedException(String) - Constructor for exception org.sqlite.database.sqlite.SQLiteTableLockedException
 
SQLiteTransactionListener - Interface in org.sqlite.database.sqlite
A listener for transaction events.
STATEMENT_ABORT - Static variable in class org.sqlite.database.DatabaseUtils
One of the values returned by DatabaseUtils.getSqlStatementType(String).
STATEMENT_ATTACH - Static variable in class org.sqlite.database.DatabaseUtils
One of the values returned by DatabaseUtils.getSqlStatementType(String).
STATEMENT_BEGIN - Static variable in class org.sqlite.database.DatabaseUtils
One of the values returned by DatabaseUtils.getSqlStatementType(String).
STATEMENT_COMMIT - Static variable in class org.sqlite.database.DatabaseUtils
One of the values returned by DatabaseUtils.getSqlStatementType(String).
STATEMENT_DDL - Static variable in class org.sqlite.database.DatabaseUtils
One of the values returned by DatabaseUtils.getSqlStatementType(String).
STATEMENT_OTHER - Static variable in class org.sqlite.database.DatabaseUtils
One of the values returned by DatabaseUtils.getSqlStatementType(String).
STATEMENT_PRAGMA - Static variable in class org.sqlite.database.DatabaseUtils
One of the values returned by DatabaseUtils.getSqlStatementType(String).
STATEMENT_SELECT - Static variable in class org.sqlite.database.DatabaseUtils
One of the values returned by DatabaseUtils.getSqlStatementType(String).
STATEMENT_UNPREPARED - Static variable in class org.sqlite.database.DatabaseUtils
One of the values returned by DatabaseUtils.getSqlStatementType(String).
STATEMENT_UPDATE - Static variable in class org.sqlite.database.DatabaseUtils
One of the values returned by DatabaseUtils.getSqlStatementType(String).
stringForQuery(SQLiteDatabase, String, String[]) - Static method in class org.sqlite.database.DatabaseUtils
Utility method to run the query on the db and return the value in the first column of the first row.
stringForQuery(SQLiteStatement, String[]) - Static method in class org.sqlite.database.DatabaseUtils
Utility method to run the pre-compiled query and return the value in the first column of the first row.

T

TABLE_INFO_PRAGMA_COLUMNNAME_INDEX - Static variable in class org.sqlite.database.DatabaseUtils.InsertHelper
Deprecated.
These are the columns returned by sqlite's "PRAGMA table_info(...)" command that we depend on.
TABLE_INFO_PRAGMA_DEFAULT_INDEX - Static variable in class org.sqlite.database.DatabaseUtils.InsertHelper
Deprecated.
This field was accidentally exposed in earlier versions of the platform so we can hide it but we can't remove it.
toString() - Method in class org.sqlite.database.sqlite.SQLiteConnection
 
toString() - Method in class org.sqlite.database.sqlite.SQLiteConnectionPool
 
toString() - Method in class org.sqlite.database.sqlite.SQLiteDatabase
 
toString() - Method in class org.sqlite.database.sqlite.SQLiteDirectCursorDriver
 
toString() - Method in class org.sqlite.database.sqlite.SQLiteQuery
 
toString() - Method in class org.sqlite.database.sqlite.SQLiteStatement
 
TRANSACTION_MODE_DEFERRED - Static variable in class org.sqlite.database.sqlite.SQLiteSession
Transaction mode: Deferred.
TRANSACTION_MODE_EXCLUSIVE - Static variable in class org.sqlite.database.sqlite.SQLiteSession
Transaction mode: Exclusive.
TRANSACTION_MODE_IMMEDIATE - Static variable in class org.sqlite.database.sqlite.SQLiteSession
Transaction mode: Immediate.

U

update(String, ContentValues, String, String[]) - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Convenience method for updating rows in the database.
updateParametersFrom(SQLiteDatabaseConfiguration) - Method in class org.sqlite.database.sqlite.SQLiteDatabaseConfiguration
Updates the non-immutable parameters of this configuration object from the other configuration object.
updateWithOnConflict(String, ContentValues, String, String[], int) - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Convenience method for updating rows in the database.

V

validateSql(String, CancellationSignal) - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Verifies that a SQL SELECT statement is valid by compiling it.

W

warnIfOpen() - Method in class org.sqlite.database.sqlite.CloseGuard
If CloseGuard is enabled, logs a warning if the caller did not properly cleanup by calling an explicit close method before finalization.
writeExceptionToParcel(Parcel, Exception) - Static method in class org.sqlite.database.DatabaseUtils
Special function for writing an exception result at the header of a parcel, to be used when returning an exception from a transaction.

Y

yieldIfContended() - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Deprecated.
if the db is locked more than once (becuase of nested transactions) then the lock will not be yielded. Use yieldIfContendedSafely instead.
yieldIfContendedSafely() - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Temporarily end the transaction to let other threads run.
yieldIfContendedSafely(long) - Method in class org.sqlite.database.sqlite.SQLiteDatabase
Temporarily end the transaction to let other threads run.
yieldTransaction(long, boolean, CancellationSignal) - Method in class org.sqlite.database.sqlite.SQLiteSession
Temporarily ends a transaction to let other threads have use of the database.
A B C D E F G H I L M N O P Q R S T U V W Y 
Skip navigation links