org.sqlite.database

Class DatabaseUtils

java.lang.Object

org.sqlite.database.DatabaseUtils

public class DatabaseUtils
extends java.lang.Object

Static utility methods for dealing with databases and Cursors.

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	DatabaseUtils.InsertHelper Deprecated. Use SQLiteStatement instead.

Field Summary

Fields

Modifier and Type	Field and Description
static int	STATEMENT_ABORT One of the values returned by getSqlStatementType(String).
static int	STATEMENT_ATTACH One of the values returned by getSqlStatementType(String).
static int	STATEMENT_BEGIN One of the values returned by getSqlStatementType(String).
static int	STATEMENT_COMMIT One of the values returned by getSqlStatementType(String).
static int	STATEMENT_DDL One of the values returned by getSqlStatementType(String).
static int	STATEMENT_OTHER One of the values returned by getSqlStatementType(String).
static int	STATEMENT_PRAGMA One of the values returned by getSqlStatementType(String).
static int	STATEMENT_SELECT One of the values returned by getSqlStatementType(String).
static int	STATEMENT_UNPREPARED One of the values returned by getSqlStatementType(String).
static int	STATEMENT_UPDATE One of the values returned by getSqlStatementType(String).

Constructor Summary

Constructors

Constructor and Description
DatabaseUtils()

Method Summary

Modifier and Type	Method and Description
static void	appendEscapedSQLString(java.lang.StringBuilder sb, java.lang.String sqlString) Appends an SQL string to the given StringBuilder, including the opening and closing single quotes.
static java.lang.String[]	appendSelectionArgs(java.lang.String[] originalValues, java.lang.String[] newValues) Appends one set of selection args to another.
static void	appendValueToSql(java.lang.StringBuilder sql, java.lang.Object value) Appends an Object to an SQL string with the proper escaping, etc.
static void	bindObjectToProgram(SQLiteProgram prog, int index, java.lang.Object value) Binds the given Object to the given SQLiteProgram using the proper typing.
static android.os.ParcelFileDescriptor	blobFileDescriptorForQuery(SQLiteDatabase db, java.lang.String query, java.lang.String[] selectionArgs) Utility method to run the query on the db and return the blob value in the first column of the first row.
static android.os.ParcelFileDescriptor	blobFileDescriptorForQuery(SQLiteStatement prog, java.lang.String[] selectionArgs) Utility method to run the pre-compiled query and return the blob value in the first column of the first row.
static java.lang.String	concatenateWhere(java.lang.String a, java.lang.String b) Concatenates two SQL WHERE clauses, handling empty or null values.
static void	createDbFromSqlStatements(android.content.Context context, java.lang.String dbName, int dbVersion, java.lang.String sqlStatements) Creates a db and populates it with the sql statements in sqlStatements.
static void	cursorDoubleToContentValues(android.database.Cursor cursor, java.lang.String field, android.content.ContentValues values, java.lang.String key) Reads a Double out of a field in a Cursor and writes it to a Map.
static void	cursorDoubleToContentValuesIfPresent(android.database.Cursor cursor, android.content.ContentValues values, java.lang.String column) Reads a Double out of a column in a Cursor and writes it to a ContentValues.
static void	cursorDoubleToCursorValues(android.database.Cursor cursor, java.lang.String field, android.content.ContentValues values) Reads a Double out of a field in a Cursor and writes it to a Map.
static void	cursorFillWindow(android.database.Cursor cursor, int position, android.database.CursorWindow window) Fills the specified cursor window by iterating over the contents of the cursor.
static void	cursorFloatToContentValuesIfPresent(android.database.Cursor cursor, android.content.ContentValues values, java.lang.String column) Reads a Float out of a column in a Cursor and writes it to a ContentValues.
static void	cursorIntToContentValues(android.database.Cursor cursor, java.lang.String field, android.content.ContentValues values) Reads an Integer out of a field in a Cursor and writes it to a Map.
static void	cursorIntToContentValues(android.database.Cursor cursor, java.lang.String field, android.content.ContentValues values, java.lang.String key) Reads a Integer out of a field in a Cursor and writes it to a Map.
static void	cursorIntToContentValuesIfPresent(android.database.Cursor cursor, android.content.ContentValues values, java.lang.String column) Reads a Integer out of a column in a Cursor and writes it to a ContentValues.
static void	cursorLongToContentValues(android.database.Cursor cursor, java.lang.String field, android.content.ContentValues values) Reads a Long out of a field in a Cursor and writes it to a Map.
static void	cursorLongToContentValues(android.database.Cursor cursor, java.lang.String field, android.content.ContentValues values, java.lang.String key) Reads a Long out of a field in a Cursor and writes it to a Map.
static void	cursorLongToContentValuesIfPresent(android.database.Cursor cursor, android.content.ContentValues values, java.lang.String column) Reads a Long out of a column in a Cursor and writes it to a ContentValues.
static int	cursorPickFillWindowStartPosition(int cursorPosition, int cursorWindowCapacity) Picks a start position for Cursor#fillWindow such that the window will contain the requested row and a useful range of rows around it.
static void	cursorRowToContentValues(android.database.Cursor cursor, android.content.ContentValues values) Read the entire contents of a cursor row and store them in a ContentValues.
static void	cursorShortToContentValuesIfPresent(android.database.Cursor cursor, android.content.ContentValues values, java.lang.String column) Reads a Short out of a column in a Cursor and writes it to a ContentValues.
static void	cursorStringToContentValues(android.database.Cursor cursor, java.lang.String field, android.content.ContentValues values) Reads a String out of a field in a Cursor and writes it to a Map.
static void	cursorStringToContentValues(android.database.Cursor cursor, java.lang.String field, android.content.ContentValues values, java.lang.String key) Reads a String out of a field in a Cursor and writes it to a Map.
static void	cursorStringToContentValuesIfPresent(android.database.Cursor cursor, android.content.ContentValues values, java.lang.String column) Reads a String out of a column in a Cursor and writes it to a ContentValues.
static void	cursorStringToInsertHelper(android.database.Cursor cursor, java.lang.String field, DatabaseUtils.InsertHelper inserter, int index) Reads a String out of a field in a Cursor and writes it to an InsertHelper.
static void	dumpCurrentRow(android.database.Cursor cursor) Prints the contents of a Cursor's current row to System.out.
static void	dumpCurrentRow(android.database.Cursor cursor, java.io.PrintStream stream) Prints the contents of a Cursor's current row to a PrintSteam.
static void	dumpCurrentRow(android.database.Cursor cursor, java.lang.StringBuilder sb) Prints the contents of a Cursor's current row to a StringBuilder.
static java.lang.String	dumpCurrentRowToString(android.database.Cursor cursor) Dump the contents of a Cursor's current row to a String.
static void	dumpCursor(android.database.Cursor cursor) Prints the contents of a Cursor to System.out.
static void	dumpCursor(android.database.Cursor cursor, java.io.PrintStream stream) Prints the contents of a Cursor to a PrintSteam.
static void	dumpCursor(android.database.Cursor cursor, java.lang.StringBuilder sb) Prints the contents of a Cursor to a StringBuilder.
static java.lang.String	dumpCursorToString(android.database.Cursor cursor) Prints the contents of a Cursor to a String.
static int	findRowIdColumnIndex(java.lang.String[] columnNames) Returns column index of "_id" column, or -1 if not found.
static java.lang.String	getCollationKey(java.lang.String name) return the collation key
static java.lang.String	getHexCollationKey(java.lang.String name) return the collation key in hex format
static int	getSqlStatementType(java.lang.String sql) Returns one of the following which represent the type of the given SQL statement.
static int	getTypeOfObject(java.lang.Object obj) Returns data type of the given object's value.
static long	longForQuery(SQLiteDatabase db, java.lang.String query, java.lang.String[] selectionArgs) Utility method to run the query on the db and return the value in the first column of the first row.
static long	longForQuery(SQLiteStatement prog, java.lang.String[] selectionArgs) Utility method to run the pre-compiled query and return the value in the first column of the first row.
static boolean	queryIsEmpty(SQLiteDatabase db, java.lang.String table) Query the table to check whether a table is empty or not
static long	queryNumEntries(SQLiteDatabase db, java.lang.String table) Query the table for the number of rows in the table.
static long	queryNumEntries(SQLiteDatabase db, java.lang.String table, java.lang.String selection) Query the table for the number of rows in the table.
static long	queryNumEntries(SQLiteDatabase db, java.lang.String table, java.lang.String selection, java.lang.String[] selectionArgs) Query the table for the number of rows in the table.
static java.lang.String	sqlEscapeString(java.lang.String value) SQL-escape a string.
static java.lang.String	stringForQuery(SQLiteDatabase db, java.lang.String query, java.lang.String[] selectionArgs) Utility method to run the query on the db and return the value in the first column of the first row.
static java.lang.String	stringForQuery(SQLiteStatement prog, java.lang.String[] selectionArgs) Utility method to run the pre-compiled query and return the value in the first column of the first row.
static void	writeExceptionToParcel(android.os.Parcel reply, java.lang.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.

Methods inherited from class java.lang.Object

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

Field Detail

STATEMENT_SELECT

public static final int STATEMENT_SELECT

One of the values returned by getSqlStatementType(String).

See Also:

Constant Field Values

STATEMENT_UPDATE

public static final int STATEMENT_UPDATE

One of the values returned by getSqlStatementType(String).

See Also:

Constant Field Values

STATEMENT_ATTACH

public static final int STATEMENT_ATTACH

One of the values returned by getSqlStatementType(String).

See Also:

Constant Field Values

STATEMENT_BEGIN

public static final int STATEMENT_BEGIN

One of the values returned by getSqlStatementType(String).

See Also:

Constant Field Values

STATEMENT_COMMIT

public static final int STATEMENT_COMMIT

One of the values returned by getSqlStatementType(String).

See Also:

Constant Field Values

STATEMENT_ABORT

public static final int STATEMENT_ABORT

One of the values returned by getSqlStatementType(String).

See Also:

Constant Field Values

STATEMENT_PRAGMA

public static final int STATEMENT_PRAGMA

One of the values returned by getSqlStatementType(String).

See Also:

Constant Field Values

STATEMENT_DDL

public static final int STATEMENT_DDL

One of the values returned by getSqlStatementType(String).

See Also:

Constant Field Values

STATEMENT_UNPREPARED

public static final int STATEMENT_UNPREPARED

One of the values returned by getSqlStatementType(String).

See Also:

Constant Field Values

STATEMENT_OTHER

public static final int STATEMENT_OTHER

One of the values returned by getSqlStatementType(String).

See Also:

Constant Field Values

Constructor Detail

DatabaseUtils

public DatabaseUtils()

Method Detail

writeExceptionToParcel

public static final void writeExceptionToParcel(android.os.Parcel reply,
                                                java.lang.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

Parameters:

reply - Parcel to write to

e - The Exception to be written.

See Also:

Parcel.writeNoException(), Parcel.writeException(java.lang.Exception)

bindObjectToProgram

public static void bindObjectToProgram(SQLiteProgram prog,
                                       int index,
                                       java.lang.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.

Parameters:

prog - the program to bind the object to

index - the 1-based index to bind at

value - the value to bind

getTypeOfObject

public static int getTypeOfObject(java.lang.Object obj)

Returns data type of the given object's value.

Returned values are

• Cursor.FIELD_TYPE_NULL
• Cursor.FIELD_TYPE_INTEGER
• Cursor.FIELD_TYPE_FLOAT
• Cursor.FIELD_TYPE_STRING
• Cursor.FIELD_TYPE_BLOB

Parameters:

obj - the object whose value type is to be returned

Returns:

object value type

cursorFillWindow

public static void cursorFillWindow(android.database.Cursor cursor,
                                    int position,
                                    android.database.CursorWindow window)

Fills the specified cursor window by iterating over the contents of the cursor. The window is filled until the cursor is exhausted or the window runs out of space. The original position of the cursor is left unchanged by this operation.

Parameters:

cursor - The cursor that contains the data to put in the window.

position - The start position for filling the window.

window - The window to fill.

appendEscapedSQLString

public static void appendEscapedSQLString(java.lang.StringBuilder sb,
                                          java.lang.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.

Parameters:

sb - the StringBuilder that the SQL string will be appended to

sqlString - the raw string to be appended, which may contain single quotes

sqlEscapeString

public static java.lang.String sqlEscapeString(java.lang.String value)

SQL-escape a string.

appendValueToSql

public static final void appendValueToSql(java.lang.StringBuilder sql,
                                          java.lang.Object value)

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

concatenateWhere

public static java.lang.String concatenateWhere(java.lang.String a,
                                                java.lang.String b)

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

getCollationKey

public static java.lang.String getCollationKey(java.lang.String name)

return the collation key

Parameters:

name -

Returns:

the collation key

getHexCollationKey

public static java.lang.String getHexCollationKey(java.lang.String name)

return the collation key in hex format

Parameters:

name -

Returns:

the collation key in hex format

dumpCursor

public static void dumpCursor(android.database.Cursor cursor)

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

Parameters:

cursor - the cursor to print

dumpCursor

public static void dumpCursor(android.database.Cursor cursor,
                              java.io.PrintStream stream)

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

Parameters:

cursor - the cursor to print

stream - the stream to print to

dumpCursor

public static void dumpCursor(android.database.Cursor cursor,
                              java.lang.StringBuilder sb)

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

Parameters:

cursor - the cursor to print

sb - the StringBuilder to print to

dumpCursorToString

public static java.lang.String dumpCursorToString(android.database.Cursor cursor)

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

Parameters:

cursor - the cursor to print

Returns:

a String that contains the dumped cursor

dumpCurrentRow

public static void dumpCurrentRow(android.database.Cursor cursor)

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

Parameters:

cursor - the cursor to print from

dumpCurrentRow

public static void dumpCurrentRow(android.database.Cursor cursor,
                                  java.io.PrintStream stream)

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

Parameters:

cursor - the cursor to print

stream - the stream to print to

dumpCurrentRow

public static void dumpCurrentRow(android.database.Cursor cursor,
                                  java.lang.StringBuilder sb)

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

Parameters:

cursor - the cursor to print

sb - the StringBuilder to print to

dumpCurrentRowToString

public static java.lang.String dumpCurrentRowToString(android.database.Cursor cursor)

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

Parameters:

cursor - the cursor to print

Returns:

a String that contains the dumped cursor row

cursorStringToContentValues

public static void cursorStringToContentValues(android.database.Cursor cursor,
                                               java.lang.String field,
                                               android.content.ContentValues values)

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

Parameters:

cursor - The cursor to read from

field - The TEXT field to read

values - The ContentValues to put the value into, with the field as the key

cursorStringToInsertHelper

public static void cursorStringToInsertHelper(android.database.Cursor cursor,
                                              java.lang.String field,
                                              DatabaseUtils.InsertHelper inserter,
                                              int index)

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

Parameters:

cursor - The cursor to read from

field - The TEXT field to read

inserter - The InsertHelper to bind into

index - the index of the bind entry in the InsertHelper

cursorStringToContentValues

public static void cursorStringToContentValues(android.database.Cursor cursor,
                                               java.lang.String field,
                                               android.content.ContentValues values,
                                               java.lang.String key)

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

Parameters:

cursor - The cursor to read from

field - The TEXT field to read

values - The ContentValues to put the value into, with the field as the key

key - The key to store the value with in the map

cursorIntToContentValues

public static void cursorIntToContentValues(android.database.Cursor cursor,
                                            java.lang.String field,
                                            android.content.ContentValues values)

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

Parameters:

cursor - The cursor to read from

field - The INTEGER field to read

values - The ContentValues to put the value into, with the field as the key

cursorIntToContentValues

public static void cursorIntToContentValues(android.database.Cursor cursor,
                                            java.lang.String field,
                                            android.content.ContentValues values,
                                            java.lang.String key)

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

Parameters:

cursor - The cursor to read from

field - The INTEGER field to read

values - The ContentValues to put the value into, with the field as the key

key - The key to store the value with in the map

cursorLongToContentValues

public static void cursorLongToContentValues(android.database.Cursor cursor,
                                             java.lang.String field,
                                             android.content.ContentValues values)

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

Parameters:

cursor - The cursor to read from

field - The INTEGER field to read

values - The ContentValues to put the value into, with the field as the key

cursorLongToContentValues

public static void cursorLongToContentValues(android.database.Cursor cursor,
                                             java.lang.String field,
                                             android.content.ContentValues values,
                                             java.lang.String key)

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

Parameters:

cursor - The cursor to read from

field - The INTEGER field to read

values - The ContentValues to put the value into

key - The key to store the value with in the map

cursorDoubleToCursorValues

public static void cursorDoubleToCursorValues(android.database.Cursor cursor,
                                              java.lang.String field,
                                              android.content.ContentValues values)

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

Parameters:

cursor - The cursor to read from

field - The REAL field to read

values - The ContentValues to put the value into

cursorDoubleToContentValues

public static void cursorDoubleToContentValues(android.database.Cursor cursor,
                                               java.lang.String field,
                                               android.content.ContentValues values,
                                               java.lang.String key)

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

Parameters:

cursor - The cursor to read from

field - The REAL field to read

values - The ContentValues to put the value into

key - The key to store the value with in the map

cursorRowToContentValues

public static void cursorRowToContentValues(android.database.Cursor cursor,
                                            android.content.ContentValues values)

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

Parameters:

cursor - the cursor to read from.

values - the ContentValues to put the row into.

cursorPickFillWindowStartPosition

public static int cursorPickFillWindowStartPosition(int cursorPosition,
                                                    int cursorWindowCapacity)

Picks a start position for Cursor#fillWindow such that the window will contain the requested row and a useful range of rows around it. When the data set is too large to fit in a cursor window, seeking the cursor can become a very expensive operation since we have to run the query again when we move outside the bounds of the current window. We try to choose a start position for the cursor window such that 1/3 of the window's capacity is used to hold rows before the requested position and 2/3 of the window's capacity is used to hold rows after the requested position.

Parameters:

cursorPosition - The row index of the row we want to get.

cursorWindowCapacity - The estimated number of rows that can fit in a cursor window, or 0 if unknown.

Returns:

The recommended start position, always less than or equal to the requested row.

queryNumEntries

public static long queryNumEntries(SQLiteDatabase db,
                                   java.lang.String table)

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

Parameters:

db - the database the table is in

table - the name of the table to query

Returns:

the number of rows in the table

queryNumEntries

public static long queryNumEntries(SQLiteDatabase db,
                                   java.lang.String table,
                                   java.lang.String selection)

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

Parameters:

db - the database the table is in

table - the name of the table to query

selection - A filter declaring which rows to return, formatted as an SQL WHERE clause (excluding the WHERE itself). Passing null will count all rows for the given table

Returns:

the number of rows in the table filtered by the selection

queryNumEntries

public static long queryNumEntries(SQLiteDatabase db,
                                   java.lang.String table,
                                   java.lang.String selection,
                                   java.lang.String[] selectionArgs)

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

Parameters:

db - the database the table is in

table - the name of the table to query

selection - A filter declaring which rows to return, formatted as an SQL WHERE clause (excluding the WHERE itself). Passing null will count all rows for the given table

selectionArgs - You may include ?s in selection, which will be replaced by the values from selectionArgs, in order that they appear in the selection. The values will be bound as Strings.

Returns:

the number of rows in the table filtered by the selection

queryIsEmpty

public static boolean queryIsEmpty(SQLiteDatabase db,
                                   java.lang.String table)

Query the table to check whether a table is empty or not

Parameters:

db - the database the table is in

table - the name of the table to query

Returns:

True if the table is empty

longForQuery

public static long longForQuery(SQLiteDatabase db,
                                java.lang.String query,
                                java.lang.String[] selectionArgs)

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

longForQuery

public static long longForQuery(SQLiteStatement prog,
                                java.lang.String[] selectionArgs)

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

stringForQuery

public static java.lang.String stringForQuery(SQLiteDatabase db,
                                              java.lang.String query,
                                              java.lang.String[] selectionArgs)

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

stringForQuery

public static java.lang.String stringForQuery(SQLiteStatement prog,
                                              java.lang.String[] selectionArgs)

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

blobFileDescriptorForQuery

public static android.os.ParcelFileDescriptor blobFileDescriptorForQuery(SQLiteDatabase db,
                                                                         java.lang.String query,
                                                                         java.lang.String[] selectionArgs)

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

Returns:

A read-only file descriptor for a copy of the blob value.

blobFileDescriptorForQuery

public static android.os.ParcelFileDescriptor blobFileDescriptorForQuery(SQLiteStatement prog,
                                                                         java.lang.String[] selectionArgs)

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

Returns:

A read-only file descriptor for a copy of the blob value.

cursorStringToContentValuesIfPresent

public static void cursorStringToContentValuesIfPresent(android.database.Cursor cursor,
                                                        android.content.ContentValues values,
                                                        java.lang.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.

Parameters:

cursor - The cursor to read from

column - The column to read

values - The ContentValues to put the value into

cursorLongToContentValuesIfPresent

public static void cursorLongToContentValuesIfPresent(android.database.Cursor cursor,
                                                      android.content.ContentValues values,
                                                      java.lang.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.

Parameters:

cursor - The cursor to read from

column - The column to read

values - The ContentValues to put the value into

cursorShortToContentValuesIfPresent

public static void cursorShortToContentValuesIfPresent(android.database.Cursor cursor,
                                                       android.content.ContentValues values,
                                                       java.lang.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.

Parameters:

cursor - The cursor to read from

column - The column to read

values - The ContentValues to put the value into

cursorIntToContentValuesIfPresent

public static void cursorIntToContentValuesIfPresent(android.database.Cursor cursor,
                                                     android.content.ContentValues values,
                                                     java.lang.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.

Parameters:

cursor - The cursor to read from

column - The column to read

values - The ContentValues to put the value into

cursorFloatToContentValuesIfPresent

public static void cursorFloatToContentValuesIfPresent(android.database.Cursor cursor,
                                                       android.content.ContentValues values,
                                                       java.lang.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.

Parameters:

cursor - The cursor to read from

column - The column to read

values - The ContentValues to put the value into

cursorDoubleToContentValuesIfPresent

public static void cursorDoubleToContentValuesIfPresent(android.database.Cursor cursor,
                                                        android.content.ContentValues values,
                                                        java.lang.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.

Parameters:

cursor - The cursor to read from

column - The column to read

values - The ContentValues to put the value into

createDbFromSqlStatements

public static void createDbFromSqlStatements(android.content.Context context,
                                             java.lang.String dbName,
                                             int dbVersion,
                                             java.lang.String sqlStatements)

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

Parameters:

context - the context to use to create the db

dbName - the name of the db to create

dbVersion - the version to set on the db

sqlStatements - the statements to use to populate the db. This should be a single string of the form returned by sqlite3's .dump command (statements separated by semicolons)

getSqlStatementType

public static int getSqlStatementType(java.lang.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

Parameters:

sql - the SQL statement whose type is returned by this method

Returns:

one of the values listed above

appendSelectionArgs

public static java.lang.String[] appendSelectionArgs(java.lang.String[] originalValues,
                                                     java.lang.String[] newValues)

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

findRowIdColumnIndex

public static int findRowIdColumnIndex(java.lang.String[] columnNames)

Returns column index of "_id" column, or -1 if not found.