DatabaseUtils

STATEMENT_ABORT

int STATEMENT_ABORT

One of the values returned by getSqlStatementType(String).

Constant Value: 6 (0x00000006)

STATEMENT_ATTACH

int STATEMENT_ATTACH

One of the values returned by getSqlStatementType(String).

Constant Value: 3 (0x00000003)

STATEMENT_BEGIN

int STATEMENT_BEGIN

One of the values returned by getSqlStatementType(String).

Constant Value: 4 (0x00000004)

STATEMENT_COMMIT

int STATEMENT_COMMIT

One of the values returned by getSqlStatementType(String).

Constant Value: 5 (0x00000005)

STATEMENT_DDL

int STATEMENT_DDL

One of the values returned by getSqlStatementType(String).

Constant Value: 8 (0x00000008)

STATEMENT_OTHER

int STATEMENT_OTHER

One of the values returned by getSqlStatementType(String).

Constant Value: 99 (0x00000063)

STATEMENT_PRAGMA

int STATEMENT_PRAGMA

One of the values returned by getSqlStatementType(String).

Constant Value: 7 (0x00000007)

STATEMENT_SELECT

int STATEMENT_SELECT

One of the values returned by getSqlStatementType(String).

Constant Value: 1 (0x00000001)

STATEMENT_UNPREPARED

int STATEMENT_UNPREPARED

One of the values returned by getSqlStatementType(String).

Constant Value: 9 (0x00000009)

STATEMENT_UPDATE

int STATEMENT_UPDATE

One of the values returned by getSqlStatementType(String).

Constant Value: 2 (0x00000002)

DatabaseUtils

DatabaseUtils ()

appendEscapedSQLString

void appendEscapedSQLString (StringBuilder sb, 
                String sqlString)

Appends an SQL string to the given StringBuilder, including the opening and closing single quotes. Any single quotes internal to sqlString will be escaped. This method is deprecated because we want to encourage everyone to use the "?" binding form. However, when implementing a ContentProvider, one may want to add WHERE clauses that were not provided by the caller. Since "?" is a positional form, using it in this case could break the caller because the indexes would be shifted to accomodate the ContentProvider's internal bindings. In that case, it may be necessary to construct a WHERE clause manually. This method is useful for those cases.

appendSelectionArgs

String[] appendSelectionArgs (String[] originalValues, 
                String[] newValues)

Appends one set of selection args to another. This is useful when adding a selection argument to a user provided set.

appendValueToSql

void appendValueToSql (StringBuilder sql, 
                Object value)

Appends an Object to an SQL string with the proper escaping, etc.

bindObjectToProgram

void bindObjectToProgram (SQLiteProgram prog, 
                int index, 
                Object value)

Binds the given Object to the given SQLiteProgram using the proper typing. For example, bind numbers as longs/doubles, and everything else as a string by call toString() on it.

blobFileDescriptorForQuery

ParcelFileDescriptor blobFileDescriptorForQuery (SQLiteStatement prog, 
                String[] selectionArgs)

Utility method to run the pre-compiled query and return the blob value in the first column of the first row.

blobFileDescriptorForQuery

ParcelFileDescriptor blobFileDescriptorForQuery (SQLiteDatabase db, 
                String query, 
                String[] selectionArgs)

Utility method to run the query on the db and return the blob value in the first column of the first row.

concatenateWhere

String concatenateWhere (String a, 
                String b)

Concatenates two SQL WHERE clauses, handling empty or null values.

createDbFromSqlStatements

void createDbFromSqlStatements (Context context, 
                String dbName, 
                int dbVersion, 
                String sqlStatements)

Creates a db and populates it with the sql statements in sqlStatements.

cursorDoubleToContentValues

void cursorDoubleToContentValues (Cursor cursor, 
                String field, 
                ContentValues values, 
                String key)

Reads a Double out of a field in a Cursor and writes it to a Map.

cursorDoubleToContentValuesIfPresent

void cursorDoubleToContentValuesIfPresent (Cursor cursor, 
                ContentValues values, 
                String column)

Reads a Double out of a column in a Cursor and writes it to a ContentValues. Adds nothing to the ContentValues if the column isn't present or if its value is null.

cursorDoubleToCursorValues

void cursorDoubleToCursorValues (Cursor cursor, 
                String field, 
                ContentValues values)

Reads a Double out of a field in a Cursor and writes it to a Map.

cursorFloatToContentValuesIfPresent

void cursorFloatToContentValuesIfPresent (Cursor cursor, 
                ContentValues values, 
                String column)

Reads a Float out of a column in a Cursor and writes it to a ContentValues. Adds nothing to the ContentValues if the column isn't present or if its value is null.

cursorIntToContentValues

void cursorIntToContentValues (Cursor cursor, 
                String field, 
                ContentValues values, 
                String key)

Reads a Integer out of a field in a Cursor and writes it to a Map.

cursorIntToContentValues

void cursorIntToContentValues (Cursor cursor, 
                String field, 
                ContentValues values)

Reads an Integer out of a field in a Cursor and writes it to a Map.

cursorIntToContentValuesIfPresent

void cursorIntToContentValuesIfPresent (Cursor cursor, 
                ContentValues values, 
                String column)

Reads a Integer out of a column in a Cursor and writes it to a ContentValues. Adds nothing to the ContentValues if the column isn't present or if its value is null.

cursorLongToContentValues

void cursorLongToContentValues (Cursor cursor, 
                String field, 
                ContentValues values, 
                String key)

Reads a Long out of a field in a Cursor and writes it to a Map.

cursorLongToContentValues

void cursorLongToContentValues (Cursor cursor, 
                String field, 
                ContentValues values)

Reads a Long out of a field in a Cursor and writes it to a Map.

cursorLongToContentValuesIfPresent

void cursorLongToContentValuesIfPresent (Cursor cursor, 
                ContentValues values, 
                String column)

Reads a Long out of a column in a Cursor and writes it to a ContentValues. Adds nothing to the ContentValues if the column isn't present or if its value is null.

cursorRowToContentValues

void cursorRowToContentValues (Cursor cursor, 
                ContentValues values)

Read the entire contents of a cursor row and store them in a ContentValues.

cursorShortToContentValuesIfPresent

void cursorShortToContentValuesIfPresent (Cursor cursor, 
                ContentValues values, 
                String column)

Reads a Short out of a column in a Cursor and writes it to a ContentValues. Adds nothing to the ContentValues if the column isn't present or if its value is null.

cursorStringToContentValues

void cursorStringToContentValues (Cursor cursor, 
                String field, 
                ContentValues values, 
                String key)

Reads a String out of a field in a Cursor and writes it to a Map.

cursorStringToContentValues

void cursorStringToContentValues (Cursor cursor, 
                String field, 
                ContentValues values)

Reads a String out of a field in a Cursor and writes it to a Map.

cursorStringToContentValuesIfPresent

void cursorStringToContentValuesIfPresent (Cursor cursor, 
                ContentValues values, 
                String column)

Reads a String out of a column in a Cursor and writes it to a ContentValues. Adds nothing to the ContentValues if the column isn't present or if its value is null.

cursorStringToInsertHelper

void cursorStringToInsertHelper (Cursor cursor, 
                String field, 
                DatabaseUtils.InsertHelper inserter, 
                int index)

Reads a String out of a field in a Cursor and writes it to an InsertHelper.

dumpCurrentRow

void dumpCurrentRow (Cursor cursor, 
                StringBuilder sb)

Prints the contents of a Cursor's current row to a StringBuilder.

dumpCurrentRow

void dumpCurrentRow (Cursor cursor, 
                PrintStream stream)

Prints the contents of a Cursor's current row to a PrintSteam.

dumpCurrentRow

void dumpCurrentRow (Cursor cursor)

Prints the contents of a Cursor's current row to System.out.

dumpCurrentRowToString

String dumpCurrentRowToString (Cursor cursor)

Dump the contents of a Cursor's current row to a String.

dumpCursor

void dumpCursor (Cursor cursor, 
                PrintStream stream)

Prints the contents of a Cursor to a PrintSteam. The position is restored after printing.

dumpCursor

void dumpCursor (Cursor cursor)

Prints the contents of a Cursor to System.out. The position is restored after printing.

dumpCursor

void dumpCursor (Cursor cursor, 
                StringBuilder sb)

Prints the contents of a Cursor to a StringBuilder. The position is restored after printing.

dumpCursorToString

String dumpCursorToString (Cursor cursor)

Prints the contents of a Cursor to a String. The position is restored after printing.

getCollationKey

String getCollationKey (String name)

return the collation key

getHexCollationKey

String getHexCollationKey (String name)

return the collation key in hex format

getSqlStatementType

int getSqlStatementType (String sql)

Returns one of the following which represent the type of the given SQL statement.

1. STATEMENT_SELECT
2. STATEMENT_UPDATE
3. STATEMENT_ATTACH
4. STATEMENT_BEGIN
5. STATEMENT_COMMIT
6. STATEMENT_ABORT
7. STATEMENT_OTHER

longForQuery

long longForQuery (SQLiteDatabase db, 
                String query, 
                String[] selectionArgs)

Utility method to run the query on the db and return the value in the first column of the first row.

longForQuery

long longForQuery (SQLiteStatement prog, 
                String[] selectionArgs)

Utility method to run the pre-compiled query and return the value in the first column of the first row.

queryNumEntries

long queryNumEntries (SQLiteDatabase db, 
                String table, 
                String selection)

Query the table for the number of rows in the table.

queryNumEntries

long queryNumEntries (SQLiteDatabase db, 
                String table, 
                String selection, 
                String[] selectionArgs)

Query the table for the number of rows in the table.

queryNumEntries

long queryNumEntries (SQLiteDatabase db, 
                String table)

Query the table for the number of rows in the table.

readExceptionFromParcel

void readExceptionFromParcel (Parcel reply)

Special function for reading an exception result from the header of a parcel, to be used after receiving the result of a transaction. This will throw the exception for you if it had been written to the Parcel, otherwise return and let you read the normal result data from the Parcel.

readExceptionWithFileNotFoundExceptionFromParcel

void readExceptionWithFileNotFoundExceptionFromParcel (Parcel reply)

readExceptionWithOperationApplicationExceptionFromParcel

void readExceptionWithOperationApplicationExceptionFromParcel (Parcel reply)

sqlEscapeString

String sqlEscapeString (String value)

SQL-escape a string.

stringForQuery

String stringForQuery (SQLiteDatabase db, 
                String query, 
                String[] selectionArgs)

Utility method to run the query on the db and return the value in the first column of the first row.

stringForQuery

String stringForQuery (SQLiteStatement prog, 
                String[] selectionArgs)

Utility method to run the pre-compiled query and return the value in the first column of the first row.

writeExceptionToParcel

void writeExceptionToParcel (Parcel reply, 
                Exception e)

Special function for writing an exception result at the header of a parcel, to be used when returning an exception from a transaction. exception will be re-thrown by the function in another process