SQLiteQueryBuilder Class

Definition

This is a convenience class that helps build SQL queries to be sent to SQLiteDatabase objects.

[Android.Runtime.Register("android/database/sqlite/SQLiteQueryBuilder", DoNotGenerateAcw=true)]
public class SQLiteQueryBuilder : Java.Lang.Object
[<Android.Runtime.Register("android/database/sqlite/SQLiteQueryBuilder", DoNotGenerateAcw=true)>]
type SQLiteQueryBuilder = class
    inherit Object
Inheritance
SQLiteQueryBuilder
Attributes

Remarks

This is a convenience class that helps build SQL queries to be sent to SQLiteDatabase objects.

Java documentation for android.database.sqlite.SQLiteQueryBuilder.

Portions of this page are modifications based on work created and shared by the Android Open Source Project and used according to terms described in the Creative Commons 2.5 Attribution License.

Constructors

SQLiteQueryBuilder()
SQLiteQueryBuilder(IntPtr, JniHandleOwnership)

A constructor used when creating managed representations of JNI objects; called by the runtime.

Properties

Class

Returns the runtime class of this Object.

(Inherited from Object)
CursorFactory

Gets the cursor factory to be used for the query, as last configured by #setCursorFactory(android.database.sqlite.SQLiteDatabase.CursorFactory).

Handle

The handle to the underlying Android instance.

(Inherited from Object)
IsDistinct

Get if the query is marked as DISTINCT, as last configured by #setDistinct(boolean).

IsStrict

Get if the query is marked as strict, as last configured by #setStrict(boolean).

JniIdentityHashCode (Inherited from Object)
JniPeerMembers
PeerReference (Inherited from Object)
ProjectionGreylist

Gets the projection greylist for the query, as last configured by #setProjectionGreylist. -or- Sets a projection greylist of columns that will be allowed through, even when #setStrict(boolean) is enabled.

ProjectionMap

Gets the projection map for the query, as last configured by #setProjectionMap(Map).

StrictColumns

Get if the query is marked as strict, as last configured by #setStrictColumns(boolean). -or- When enabled, verify that all projections and ContentValues only contain valid columns as defined by #setProjectionMap(Map).

StrictGrammar

Get if the query is marked as strict, as last configured by #setStrictGrammar(boolean). -or- When enabled, verify that all untrusted SQL conforms to a restricted SQL grammar.

Tables

Returns the list of tables being queried -or- Sets the list of tables to query.

ThresholdClass

This API supports the Mono for Android infrastructure and is not intended to be used directly from your code.

ThresholdType

This API supports the Mono for Android infrastructure and is not intended to be used directly from your code.

Methods

AppendColumns(StringBuilder, String[])

Add the names that are non-null in columns to s, separating them with commas.

AppendWhere(ICharSequence)

Append a chunk to the WHERE clause of the query.

AppendWhere(String)

Append a chunk to the WHERE clause of the query.

AppendWhereEscapeString(String)

Append a chunk to the WHERE clause of the query.

AppendWhereStandalone(ICharSequence)

Add a standalone chunk to the WHERE clause of this query.

AppendWhereStandalone(String)

Add a standalone chunk to the WHERE clause of this query.

BuildQuery(String[], String, String, String, String, String)

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)
Obsolete.

This member is deprecated.

BuildQueryString(Boolean, String, String[], String, String, String, String, String)

Build an SQL query string from the given clauses.

BuildUnionQuery(String[], String, String)

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[], ICollection<String>, Int32, String, String, String, String)

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[], ICollection<String>, Int32, String, String, String[], String, String)
Obsolete.

This member is deprecated.

Clone()

Creates and returns a copy of this object.

(Inherited from Object)
Delete(SQLiteDatabase, String, String[])

Perform a delete by combining all current settings and the information passed into this method.

Dispose() (Inherited from Object)
Dispose(Boolean) (Inherited from Object)
Equals(Object)

Indicates whether some other object is "equal to" this one.

(Inherited from Object)
GetHashCode()

Returns a hash code value for the object.

(Inherited from Object)
Insert(SQLiteDatabase, ContentValues)

Perform an insert by combining all current settings and the information passed into this method.

JavaFinalize()

Called by the garbage collector on an object when garbage collection determines that there are no more references to the object.

(Inherited from Object)
Notify()

Wakes up a single thread that is waiting on this object's monitor.

(Inherited from Object)
NotifyAll()

Wakes up all threads that are waiting on this object's monitor.

(Inherited from Object)
Query(SQLiteDatabase, String[], String, String[], String, String, String, String, CancellationSignal)

Perform a query by combining all current settings and the information passed into this method.

Query(SQLiteDatabase, String[], String, String[], String, String, String, String)

Perform a query by combining all current settings and the information passed into this method.

Query(SQLiteDatabase, String[], String, String[], String, String, String)

Perform a query by combining all current settings and the information passed into this method.

SetCursorFactory(SQLiteDatabase+ICursorFactory)

Sets the cursor factory to be used for the query.

SetDistinct(Boolean)

Mark the query as DISTINCT.

SetHandle(IntPtr, JniHandleOwnership)

Sets the Handle property.

(Inherited from Object)
SetProjectionMap(IDictionary<String,String>)

Sets the projection map for the query.

SetStrict(Boolean)

When set, the selection is verified against malicious arguments.

ToArray<T>() (Inherited from Object)
ToString()

Returns a string representation of the object.

(Inherited from Object)
UnregisterFromRuntime() (Inherited from Object)
Update(SQLiteDatabase, ContentValues, String, String[])

Perform an update by combining all current settings and the information passed into this method.

Wait()

Causes the current thread to wait until it is awakened, typically by being <em>notified</em> or <em>interrupted</em>.

(Inherited from Object)
Wait(Int64, Int32)

Causes the current thread to wait until it is awakened, typically by being <em>notified</em> or <em>interrupted</em>, or until a certain amount of real time has elapsed.

(Inherited from Object)
Wait(Int64)

Causes the current thread to wait until it is awakened, typically by being <em>notified</em> or <em>interrupted</em>, or until a certain amount of real time has elapsed.

(Inherited from Object)

Explicit Interface Implementations

Extension Methods

Applies to