Expr class abstract

Implementers

• AliasedExpr
• BetweenExpression
• BinaryExpression
• DbColumn
• ExistsExpression
• FunctionExpression
• InExpression
• NullCheckExp
• RawSqlExpr
• UnaryExpression
• ValueExpr

Constructors

Expr()

Properties

fieldType ↔ dbType

getter/setter pair

hashCode → int

The hash code for this object.

no setter, inherited

runtimeType → Type

A representation of the runtime type of the object.

no setter, inherited

Methods

And(Expr exp) → Expr

As(String alias) → Expr

Ascending() → SortExp

Between(Expr exp1, Expr exp2) → Expr

BetweenValues(Object val1, Object val2) → Expr

Concat(Object o) → Expr

Descending() → SortExp

Divide(Expr exp) → Expr

DivideValue(double o) → Expr

Equal(Object o) → Expr

GreaterOrEqual(Object o) → Expr

GreaterThan(Object o) → Expr

In(AbsSelect select) → Expr

InTable(DbTable table) → Expr

InValues(List<Object> values) → Expr

IsNull() → Expr

LessOrEqual(Object o) → Expr

LessThan(Object o) → Expr

Like(String pattern) → Expr

matches against a pattern, use % to match any number of chars or digits(or none), and _ to match exactly one char, you can use it with text or numeric columns

Mod(Expr exp) → Expr

ModValue(num value) → Expr

Multiply(Expr exp) → Expr

MultiplyValue(double o) → Expr

noSuchMethod(Invocation invocation) → dynamic

Invoked when a nonexistent method or property is accessed.

inherited

NotBetween(Expr exp1, Expr exp2) → Expr

NotBetweenValues(Object val1, Object val2) → Expr

NotEqual(Object o) → Expr

NotIn(AbsSelect select) → Expr

NotInTable(DbTable table) → Expr

NotInValues(List<Object> values) → Expr

NotLike(String pattern) → Expr

NotNull() → Expr

Or(Expr exp) → Expr

Plus(Expr exp) → Expr

PlusValue(num value) → Expr

Subtract(Expr o) → Expr

SubtractValue(num value) → Expr

toSql(Statement? st) → String

toString() → String

A string representation of this object.

inherited

Operators

operator ==(Object other) → bool

The equality operator.

inherited

Static Properties

NULL → ValueExpr

no setter

Static Methods

Abs(Expr exp) → Expr

Avg(Expr exp) → Expr

Count(Expr exp) → Expr

Date(Expr exp) → Expr

DateFormat(Expr exp, String format) → Expr

formats the given date expr
%d : day of month: 00 %f : fractional seconds: SS.SSS
%H : hour: 00-24
%j : day of year: 001-366
%J : Julian day number
%m : month: 01-12
%M : minute: 00-59
%s : seconds since 1970-01-01
%S : seconds: 00-59
%w : day of week 0-6 with Sunday==0
%W : week of year: 00-53
%Y : year: 0000-9999
%% : %

Exists(AbsSelect select) → Expr

GroupConcat(Expr exp, [String? seperator]) → Expr

Length(Expr exp) → Expr

the length of a String value

Max(List<Expr> exp) → Expr

a simple function if given more than one param, but an aggregation function if given one param

Min(List<Expr> exp) → Expr

a simple function if given more than one param, but an aggregation function if given one param

Minus(Expr exp) → Expr

Not(Expr exp) → Expr

Raw(String rawSqlExpr) → Expr

Sum(Expr exp) → Expr

Time(Expr exp) → Expr

Total(Expr exp) → Expr