DbFunctions class
Provides some db functions like MAX - MIN - IFNULL ... etc.
Properties
- hashCode → int
-
The hash code for this object.
no setterinherited
- runtimeType → Type
-
A representation of the runtime type of the object.
no setterinherited
Methods
-
noSuchMethod(
Invocation invocation) → dynamic -
Invoked when a nonexistent method or property is accessed.
inherited
-
toString(
) → String -
A string representation of this object.
inherited
Operators
-
operator ==(
Object other) → bool -
The equality operator.
inherited
Static Properties
- pi → DoubleField
-
Get DoubleField object with the sqlite version.
no setter
- sqliteSourceId → StringField
-
Get StringField object with the sqlite source id.
no setter
- sqliteVersion → IntField
-
Get IntField object with the sqlite version.
no setter
Static Methods
-
assertDateTimeStringsValues(
List values) → void -
Assert each entry of
valuesis a DateTime or DateTimeStringField. -
assertDateTimesValues(
List values) → void -
Assert each entry of
valuesis a DateTime or DateTimeField. -
assertNotNullValues(
List values) → void -
Assert each entry of
valuesis not null. -
assertNumValues(
List values) → void -
Assert each entry of
valuesis num or NumField. -
assertStringValues(
List values) → void -
Assert each entry of
valuesis String or StringField. -
coalesceDateTimes(
List values) → DateTimeField -
Create sql statement with function
COALESCE()function applied for several values, values may be DateTime - DateTimeField. -
coalesceNums(
List values) → DoubleField -
Create sql statement with function
COALESCE()function applied for several values, values may be int - double - NumField - IntField - DoubleField. -
coalesceStrings(
List values) → StringField -
Create sql statement with function
COALESCE()function applied for several values, values may be String or StringField -
concatGroup(
List values) → StringField -
Create sql statement with function
GROUP_CONCAT()function applied for several values, values may be String or StringField -
count(
List values) → DoubleField -
Create sql statement with function
COUNT()function applied. -
distinct(
List< FieldWithValue> fields) → QueryPart -
Create sql statement with function
DISTINCT()function applied.DISTINCT()is used to get rows without duplicates offieldsvalues. -
ifNull(
QueryPart x, QueryPart y) → QueryPart -
Create sql statement with function
IFNULL()function applied for two QueryParts, -
max(
NumField f) → DoubleField -
Create sql statement with function
MAX()function applied. -
maxDatetimes(
DateTimeField a, DateTimeField b) → DateTimeField -
Apply
MAX()function for two db dates. -
min(
NumField f) → DoubleField -
Create sql statement with function
MIN()function applied. -
sum(
List values) → DoubleField -
Create sql statement with function
SUM()function applied.