org.positronicnet.db.DbQuery

Ordering

Alphabetic
By inheritance

Inherited

Hide All
Show all

DbQuery
ContentQuery
AnyRef
Any

Visibility

Public
All

Instance Constructors

new DbQuery (source: DbWrapper, tableName: String, orderString: String, whereString: String, whereValues: Array[String], limitString: String)

Value Members

def != (arg0: AnyRef): Boolean

Attributes
final
Definition Classes
AnyRef
def != (arg0: Any): Boolean

Attributes
final
Definition Classes
Any
def ## (): Int

Attributes
final
Definition Classes
AnyRef → Any
def == (arg0: AnyRef): Boolean

Attributes
final
Definition Classes
AnyRef
def == (arg0: Any): Boolean

Attributes
final
Definition Classes
Any
def asInstanceOf [T0] : T0

Attributes
final
Definition Classes
Any
def buildContentValues (assigns: (String, ContentValue)*): ContentValues

Attributes
protected
Definition Classes
ContentQuery
def clone (): AnyRef

Attributes
protected[lang]
Definition Classes
AnyRef
Annotations
@throws()
def conditionKey : (String, Seq[String])

All conditions on this ContentQuery.
All conditions on this ContentQuery. Useful to determine when two are equivalent.

Definition Classes
ContentQuery
def count : Long

Returns a count of records matching this query's conditions.
Returns a count of records matching this query's conditions. May not be supported by all repositories; in particular, it is not supported by ContentProviders.

Definition Classes
DbQuery → ContentQuery
def delete : Int

Delete all records which match this ContentQuery
Delete all records which match this ContentQuery

Definition Classes
ContentQuery
def eq (arg0: AnyRef): Boolean

Attributes
final
Definition Classes
AnyRef
def equals (arg0: Any): Boolean

Definition Classes
AnyRef → Any
def facility : ThreadlessDatabase

Definition Classes
DbQuery → ContentQuery
def finalize (): Unit

Attributes
protected[lang]
Definition Classes
AnyRef
Annotations
@throws()
def getClass (): java.lang.Class[_]

Attributes
final
Definition Classes
AnyRef
def hashCode (): Int

Definition Classes
AnyRef → Any
def insert (assigns: (String, ContentValue)*): Long

Inserts a new record, with values of the columns named by the Strings to each associated ContentValue.
Inserts a new record, with values of the columns named by the Strings to each associated ContentValue. E.g.,
```
    qry.insert( "description" -> "write documentation",
                "status" -> "in_progress",
                "urgency_level" -> 3 )
```
using the same shorthand for pairs as is commonly used for Map constructors.
Definition Classes
ContentQuery
def isInstanceOf [T0] : Boolean

Attributes
final
Definition Classes
Any
def limit (s: String): DbQuery

Returns a new query whose results will be limited to the given number of rows.
Returns a new query whose results will be limited to the given number of rows. May not be supported by all repositories; in particular, it is not supported by ContentProviders.

Definition Classes
DbQuery → ContentQuery
def limit (l: Int): ContentQuery[String, Long]

Returns a new query whose results will be limited to the given number of rows.
Returns a new query whose results will be limited to the given number of rows. May not be supported by all repositories; in particular, it is not supported by ContentProviders.

Definition Classes
ContentQuery
def log (stmtType: String, contentValues: ContentValues = null, cols: Array[String] = null): AnyVal

Attributes
protected
Definition Classes
ContentQuery
def ne (arg0: AnyRef): Boolean

Attributes
final
Definition Classes
AnyRef
def notify (): Unit

Attributes
final
Definition Classes
AnyRef
def notifyAll (): Unit

Attributes
final
Definition Classes
AnyRef
def oneRow (cols: String*): PositronicCursor
def order (s: String): DbQuery

Returns a new ContentQuery, equivalent to this one, except that results will be ordered as per the given String.
Returns a new ContentQuery, equivalent to this one, except that results will be ordered as per the given String. Interpretation of the Strings is as per the underlying APIs, e.g., as for a SQL order by when querying a database.

Definition Classes
DbQuery → ContentQuery
def select (cols: String*): PositronicCursor

Return a PositronicCursor for the values of the given columns, in records matching this query, respecting its order and limit.
Return a PositronicCursor for the values of the given columns, in records matching this query, respecting its order and limit.
(This is a wrapper around standard Android Cursors, which provides a few extra features; its wrappedCursorAs method can be used to get the underlying raw Cursor, if you want it.)

Definition Classes
ContentQuery
def selectDefaultColumns : PositronicCursor

Return a PositronicCursor for the values of the underlying resource's default set of columns, in records matching this query, respecting its order and limit.
Return a PositronicCursor for the values of the underlying resource's default set of columns, in records matching this query, respecting its order and limit.
(This is a wrapper around standard Android Cursors, which provides a few extra features; its wrappedCursorAs method can be used to get the underlying raw Cursor, if you want it.)

Definition Classes
ContentQuery
def synchronized [T0] (arg0: ⇒ T0): T0

Attributes
final
Definition Classes
AnyRef
def toString (): String

Definition Classes
ContentQuery → AnyRef → Any
def update (assigns: (String, ContentValue)*): Int

Updates each record matched by the query, setting values of the columns named by the Strings to each associated ContentValue.
Updates each record matched by the query, setting values of the columns named by the Strings to each associated ContentValue. E.g.,
```
    qry.update( "status" -> "in_progress",
                "urgency_level" -> 3 )
```
using the same shorthand for pairs as is commonly used for Map constructors.
Definition Classes
ContentQuery
def wait (): Unit

Attributes
final
Definition Classes
AnyRef
Annotations
@throws()
def wait (arg0: Long, arg1: Int): Unit

Attributes
final
Definition Classes
AnyRef
Annotations
@throws()
def wait (arg0: Long): Unit

Attributes
final
Definition Classes
AnyRef
Annotations
@throws()
def where (s: String, vals: ContentValue*): DbQuery

Returns a new ContentQuery with the same semantics as this one, except that it adds extra conditions.
Returns a new ContentQuery with the same semantics as this one, except that it adds extra conditions. If the condition contains '?' placeholders, they will be replaced with ContentValue arguments, e.g.
```
    qry = otherQuery.where( "created_at > ? and status = ?",
                            myDate.getTime, "in_progress" )
```
Definition Classes
DbQuery → ContentQuery
def whereEq (pairs: (String, ContentValue)*): DbQuery

Returns a new ContentQuery with the same semantics as this one, except that it adds the condition that each of the fields named by the Strings in the arguments should be equal to the associated ContentValue.
Returns a new ContentQuery with the same semantics as this one, except that it adds the condition that each of the fields named by the Strings in the arguments should be equal to the associated ContentValue. E.g.,
```
    qry = otherQuery.where( "status" -> "in_progress",
                            "urgency_level" -> 3 )
```
using the same shorthand for pairs as is commonly used for Map constructors.
Definition Classes
DbQuery → ContentQuery
def withUpdatedWhere [T] (pairs: Seq[(String, ContentValue)])(handler: (String, Array[String]) ⇒ T): T

Attributes
protected
Definition Classes
ContentQuery
def withUpdatedWhere [T] (s: String, arr: Array[ContentValue])(handler: (String, Array[String]) ⇒ T): T

Attributes
protected
Definition Classes
ContentQuery

DbQuery

class DbQuery extends ContentQuery[String, Long]

Instance Constructors

new DbQuery (source: DbWrapper, tableName: String, orderString: String, whereString: String, whereValues: Array[String], limitString: String)

Value Members

def != (arg0: AnyRef): Boolean

def != (arg0: Any): Boolean

def ## (): Int

def == (arg0: AnyRef): Boolean

def == (arg0: Any): Boolean

def asInstanceOf [T0] : T0

def buildContentValues (assigns: (String, ContentValue)*): ContentValues

def clone (): AnyRef

def conditionKey : (String, Seq[String])

def count : Long

def delete : Int

def eq (arg0: AnyRef): Boolean

def equals (arg0: Any): Boolean

def facility : ThreadlessDatabase

def finalize (): Unit

def getClass (): java.lang.Class[_]

def hashCode (): Int

def insert (assigns: (String, ContentValue)*): Long

def isInstanceOf [T0] : Boolean

def limit (s: String): DbQuery

def limit (l: Int): ContentQuery[String, Long]

def log (stmtType: String, contentValues: ContentValues = null, cols: Array[String] = null): AnyVal

def ne (arg0: AnyRef): Boolean

def notify (): Unit

def notifyAll (): Unit

def oneRow (cols: String*): PositronicCursor

def order (s: String): DbQuery

def select (cols: String*): PositronicCursor

def selectDefaultColumns : PositronicCursor

def synchronized [T0] (arg0: ⇒ T0): T0

def toString (): String

def update (assigns: (String, ContentValue)*): Int

def wait (): Unit

def wait (arg0: Long, arg1: Int): Unit

def wait (arg0: Long): Unit

def where (s: String, vals: ContentValue*): DbQuery

def whereEq (pairs: (String, ContentValue)*): DbQuery

def withUpdatedWhere [T] (pairs: Seq[(String, ContentValue)])(handler: (String, Array[String]) ⇒ T): T

def withUpdatedWhere [T] (s: String, arr: Array[ContentValue])(handler: (String, Array[String]) ⇒ T): T

Inherited from ContentQuery[String, Long]

Inherited from AnyRef

Inherited from Any