library / org.akop.kotx.ext.database / android.database.sqlite.SQLiteDatabase

Extensions for android.database.sqlite.SQLiteDatabase

optQuery

fun SQLiteDatabase.optQuery(table: String, columns: Array<String>? = null, selection: String? = null, selArgs: Array<String>? = null, groupBy: String? = null, having: String? = null, orderBy: String? = null, limit: String? = null): Cursor

Slightly more concise version of SQLiteDatabase.query that allows omission of most fields by use of named parameters.

queryValue

fun <T> SQLiteDatabase.queryValue(table: String, column: String, selection: String? = null, selArgs: Array<String>? = null, groupBy: String? = null, having: String? = null, orderBy: String? = null, defaultValue: T? = null): T?

Queries for a single column value in a single row. Automatically sets a LIMIT of 1 for any query submitted