DatabaseUtils

STATEMENT_ABORT

static val STATEMENT_ABORT: Int

One of the values returned by getSqlStatementType(java.lang.String).

Value: 6

STATEMENT_ATTACH

static val STATEMENT_ATTACH: Int

One of the values returned by getSqlStatementType(java.lang.String).

Value: 3

STATEMENT_BEGIN

static val STATEMENT_BEGIN: Int

One of the values returned by getSqlStatementType(java.lang.String).

Value: 4

STATEMENT_COMMIT

static val STATEMENT_COMMIT: Int

One of the values returned by getSqlStatementType(java.lang.String).

Value: 5

STATEMENT_DDL

static val STATEMENT_DDL: Int

One of the values returned by getSqlStatementType(java.lang.String).

Value: 8

STATEMENT_OTHER

static val STATEMENT_OTHER: Int

One of the values returned by getSqlStatementType(java.lang.String).

Value: 99

STATEMENT_PRAGMA

static val STATEMENT_PRAGMA: Int

One of the values returned by getSqlStatementType(java.lang.String).

Value: 7

STATEMENT_SELECT

static val STATEMENT_SELECT: Int

One of the values returned by getSqlStatementType(java.lang.String).

Value: 1

STATEMENT_UNPREPARED

static val STATEMENT_UNPREPARED: Int

One of the values returned by getSqlStatementType(java.lang.String).

Value: 9

STATEMENT_UPDATE

static val STATEMENT_UPDATE: Int

One of the values returned by getSqlStatementType(java.lang.String).

Value: 2

appendEscapedSQLString

open static fun appendEscapedSQLString(
    sb: StringBuilder!, 
    sqlString: String!
): Unit

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

open static fun appendSelectionArgs(
    originalValues: Array<String!>!, 
    newValues: Array<String!>!
): Array<String!>!

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

appendValueToSql

static fun appendValueToSql(
    sql: StringBuilder!, 
    value: Any!
): Unit

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

bindObjectToProgram

open static fun bindObjectToProgram(
    prog: SQLiteProgram!, 
    index: Int, 
    value: Any!
): Unit

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

open static fun blobFileDescriptorForQuery(
    db: SQLiteDatabase!, 
    query: String!, 
    selectionArgs: Array<String!>!
): ParcelFileDescriptor!

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

blobFileDescriptorForQuery

open static fun blobFileDescriptorForQuery(
    prog: SQLiteStatement!, 
    selectionArgs: Array<String!>!
): ParcelFileDescriptor!

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

concatenateWhere

open static fun concatenateWhere(
    a: String!, 
    b: String!
): String!

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

createDbFromSqlStatements

open static fun createDbFromSqlStatements(
    context: Context!, 
    dbName: String!, 
    dbVersion: Int, 
    sqlStatements: String!
): Unit

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

cursorDoubleToContentValues

open static fun cursorDoubleToContentValues(
    cursor: Cursor!, 
    field: String!, 
    values: ContentValues!, 
    key: String!
): Unit

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

cursorDoubleToContentValuesIfPresent

open static fun cursorDoubleToContentValuesIfPresent(
    cursor: Cursor!, 
    values: ContentValues!, 
    column: String!
): Unit

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

open static fun cursorDoubleToCursorValues(
    cursor: Cursor!, 
    field: String!, 
    values: ContentValues!
): Unit

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

cursorFloatToContentValuesIfPresent

open static fun cursorFloatToContentValuesIfPresent(
    cursor: Cursor!, 
    values: ContentValues!, 
    column: String!
): Unit

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

open static fun cursorIntToContentValues(
    cursor: Cursor!, 
    field: String!, 
    values: ContentValues!
): Unit

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

cursorIntToContentValues

open static fun cursorIntToContentValues(
    cursor: Cursor!, 
    field: String!, 
    values: ContentValues!, 
    key: String!
): Unit

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

cursorIntToContentValuesIfPresent

open static fun cursorIntToContentValuesIfPresent(
    cursor: Cursor!, 
    values: ContentValues!, 
    column: String!
): Unit

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

open static fun cursorLongToContentValues(
    cursor: Cursor!, 
    field: String!, 
    values: ContentValues!
): Unit

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

cursorLongToContentValues

open static fun cursorLongToContentValues(
    cursor: Cursor!, 
    field: String!, 
    values: ContentValues!, 
    key: String!
): Unit

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

cursorLongToContentValuesIfPresent

open static fun cursorLongToContentValuesIfPresent(
    cursor: Cursor!, 
    values: ContentValues!, 
    column: String!
): Unit

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

open static fun cursorRowToContentValues(
    cursor: Cursor!, 
    values: ContentValues!
): Unit

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

cursorShortToContentValuesIfPresent

open static fun cursorShortToContentValuesIfPresent(
    cursor: Cursor!, 
    values: ContentValues!, 
    column: String!
): Unit

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

open static fun cursorStringToContentValues(
    cursor: Cursor!, 
    field: String!, 
    values: ContentValues!
): Unit

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

cursorStringToContentValues

open static fun cursorStringToContentValues(
    cursor: Cursor!, 
    field: String!, 
    values: ContentValues!, 
    key: String!
): Unit

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

cursorStringToContentValuesIfPresent

open static fun cursorStringToContentValuesIfPresent(
    cursor: Cursor!, 
    values: ContentValues!, 
    column: String!
): Unit

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

open static fun cursorStringToInsertHelper(
    cursor: Cursor!, 
    field: String!, 
    inserter: DatabaseUtils.InsertHelper!, 
    index: Int
): Unit

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

dumpCurrentRow

open static fun dumpCurrentRow(cursor: Cursor!): Unit

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

dumpCurrentRow

open static fun dumpCurrentRow(
    cursor: Cursor!, 
    stream: PrintStream!
): Unit

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

dumpCurrentRow

open static fun dumpCurrentRow(
    cursor: Cursor!, 
    sb: StringBuilder!
): Unit

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

dumpCurrentRowToString

open static fun dumpCurrentRowToString(cursor: Cursor!): String!

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

dumpCursor

open static fun dumpCursor(cursor: Cursor!): Unit

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

dumpCursor

open static fun dumpCursor(
    cursor: Cursor!, 
    stream: PrintStream!
): Unit

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

dumpCursor

open static fun dumpCursor(
    cursor: Cursor!, 
    sb: StringBuilder!
): Unit

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

dumpCursorToString

open static fun dumpCursorToString(cursor: Cursor!): String!

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

getCollationKey

open static fun getCollationKey(name: String!): String!

return the collation key

getHexCollationKey

open static fun getHexCollationKey(name: String!): String!

return the collation key in hex format

getSqlStatementType

open static fun getSqlStatementType(sql: String!): Int

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_PRAGMA
8. STATEMENT_DDL
9. STATEMENT_UNPREPARED
10. STATEMENT_OTHER

longForQuery

open static fun longForQuery(
    db: SQLiteDatabase!, 
    query: String!, 
    selectionArgs: Array<String!>!
): Long

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

longForQuery

open static fun longForQuery(
    prog: SQLiteStatement!, 
    selectionArgs: Array<String!>!
): Long

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

queryNumEntries

open static fun queryNumEntries(
    db: SQLiteDatabase!, 
    table: String!
): Long

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

queryNumEntries

open static fun queryNumEntries(
    db: SQLiteDatabase!, 
    table: String!, 
    selection: String!
): Long

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

queryNumEntries

open static fun queryNumEntries(
    db: SQLiteDatabase!, 
    table: String!, 
    selection: String!, 
    selectionArgs: Array<String!>!
): Long

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

readExceptionFromParcel

static fun readExceptionFromParcel(reply: Parcel!): Unit

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

open static fun readExceptionWithFileNotFoundExceptionFromParcel(reply: Parcel!): Unit

readExceptionWithOperationApplicationExceptionFromParcel

open static fun readExceptionWithOperationApplicationExceptionFromParcel(reply: Parcel!): Unit

sqlEscapeString

open static fun sqlEscapeString(value: String!): String!

SQL-escape a string.

stringForQuery

open static fun stringForQuery(
    db: SQLiteDatabase!, 
    query: String!, 
    selectionArgs: Array<String!>!
): String!

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

stringForQuery

open static fun stringForQuery(
    prog: SQLiteStatement!, 
    selectionArgs: Array<String!>!
): String!

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

writeExceptionToParcel

static fun writeExceptionToParcel(
    reply: Parcel!, 
    e: Exception!
): Unit

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