StrField class

StrField is a convenience DSL used to construct queries in a concise and understandable way.

Example:

final name = DoubleField('name');
var value = await Find()
        .from('user')
        .where(name.eq('teja'))  // Simplifies query expressions
        .exec(adapter).one();
Inheritance

Constructors

StrField(String name)

Properties

hashCode → int
The hash code for this object.
no setterinherited
isNotNull → Cond<String>
Returns an "IS NOT" condition, i.e. 'where var IS NOT null'
no setterinherited
isNull → Cond<String>
Returns an "IS" condition, i.e. 'where var IS null'
no setterinherited
name → String
Name of the field
finalinherited
runtimeType → Type
A representation of the runtime type of the object.
no setterinherited
tableName → String?
finalinherited

Methods

aliasAs(String tableAlias) → Field<String>
inherited
between(String low, String high) → Between<String>
Returns an "in between" condition
inherited
create(Create statement, {bool isNullable = false, int length = 20, bool primary = false, String? foreignTable, String? foreignCol, String? uniqueGroup}) → void
Adds the field to create statement
eq(String value) → Cond<String>
Returns an "is equal to" condition
inherited
eqF(String name, {String? table}) → CondCol<String>
Returns an "is equal to" condition
inherited
eqField(Field<String> rhs) → CondCol<String>
Returns an "is equal to" condition
inherited
gt(String value) → Cond<String>
Returns a "greater than" condition
inherited
gtEq(String value) → Cond<String>
Returns a "greater than equal to" condition
inherited
gtEqF(String name, {String? table}) → CondCol<String>
Returns a "greater than equal to" condition
inherited
gtEqField(Field<String> rhs) → CondCol<String>
Returns a "greater than equal to" condition
inherited
gtF(String name, {String? table}) → CondCol<String>
Returns a "greater than" condition
inherited
gtField(Field<String> rhs) → CondCol<String>
Returns a "greater than" condition
inherited
inBetweenFields(Field<String> low, Field<String> high) → InBetweenCol<String>
Returns an "in between" condition
inherited
isIn(Set<String> value) → InOperation<String>
Returns an "in" condition
inherited
like(String value) → Cond<String>
Returns a "like" condition
lt(String value) → Cond<String>
Returns a "less than" condition
inherited
ltEq(String value) → Cond<String>
Returns a "less than equal to" condition
inherited
ltEqF(String name, {String? table}) → CondCol<String>
Returns a "less than equal to" condition
inherited
ltEqField(Field<String> rhs) → CondCol<String>
Returns a "less than equal to" condition
inherited
ltF(String name, {String? table}) → CondCol<String>
Returns a "less than" condition
inherited
ltField(Field<String> rhs) → CondCol<String>
Returns a "less than" condition
inherited
ne(String value) → Cond<String>
Returns a "not equal to" condition
inherited
neF(String name, {String? table}) → CondCol<String>
Returns a "not equal to" condition
inherited
neField(Field<String> rhs) → CondCol<String>
Returns a "not equal to" condition
inherited
noSuchMethod(Invocation invocation) → dynamic
Invoked when a nonexistent method or property is accessed.
inherited
set(String? value) → SetColumn<String>
Returns a "set column" clause
inherited
setNullable(String? value) → SetColumn<String?>
inherited
toString() → String
A string representation of this object.
inherited

Operators

operator %(String other) → Cond<String>
This is actually 'like' operator
operator <(String other) → Cond<String>
inherited
operator <=(String other) → Cond<String>
inherited
operator ==(Object other) → bool
The equality operator.
inherited
operator >(String other) → Cond<String>
inherited
operator >=(String other) → Cond<String>
inherited