Find class

Select SQL statement builder.

Implemented types

• Statement
• Whereable

Constructors

Find(String tableName, {String? alias, Expression? where})

Properties

asImmutable → ImmutableFindStatement

no setter

from → TableName

final

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

addJoin(JoinedTable join) → Find

Adds a 'join' clause to the select statement

and(Expression exp) → Find

Adds an 'and' expression to 'where' clause.

override

andMap<T>(Iterable<T> iterable, MappedExpression<T> func) → Find

override

between<T>(String column, T low, T high) → Find

Adds an 'between' expression to 'where' clause.

override

count(String column, {String? alias, bool isDistinct = false}) → Find

crossJoin(String tableName, [String? alias]) → Find

Adds 'cross join' clause to the select statement.

eq<T>(String column, T val) → Find

Adds an '=' expression to 'where' clause.

override

exec<ConnType>(Adapter<ConnType> adapter) → FindExecutor<ConnType>

fullJoin(String tableName, [String? alias]) → Find

Adds a 'full join' clause to the select statement.

groupBy(String val) → Find

groupByMany(List<String> columns) → Find

gt<T>(String column, T val) → Find

Adds an '>' expression to 'where' clause.

override

gtEq<T>(String column, T val) → Find

Adds an '>=' expression to 'where' clause.

override

innerJoin(String tableName, [String? alias]) → Find

Adds a 'inner join' clause to the select statement.

joinOn(Expression exp) → Find

Adds the condition with which to perform joins.

leftJoin(String tableName, [String? alias]) → Find

Adds a 'left join' clause to the select statement.

like(String column, String val) → Find

Adds an '%' expression to 'where' clause.

override

limit(int val) → Find

lt<T>(String column, T val) → Find

Adds an '<' expression to 'where' clause.

override

ltEq<T>(String column, T val) → Find

Adds an '<=' expression to 'where' clause.

override

ne<T>(String column, T val) → Find

Adds an '<>' expression to 'where' clause.

override

noSuchMethod(Invocation invocation) → dynamic

Invoked when a nonexistent method or property is accessed.

inherited

offset(int val) → Find

or(Expression expression) → Find

Adds an 'or' expression to 'where' clause.

override

orderBy(String column, [bool ascending = false]) → Find

orderByMany(List<String> columns, [bool ascending = false]) → Find

orMap<T>(Iterable<T> iterable, MappedExpression<T> func) → Find

override

rightJoin(String tableName, [String? alias]) → Find

Adds a 'right join' clause to the select statement.

sel(String column, {String? alias, String? table}) → Find

Selects a column to be fetched from the table. Use alias to alias the column name.

selAll([String? table]) → Find

Selects a column to be fetched. Use alias to alias the column name.

selMany(Iterable<String> columns, {String? table}) → Find

Selects many columns to be fetched in the given table. Use alias to alias the column name.

toString() → String

A string representation of this object.

inherited

where(Expression expression) → Find

Adds an to 'where' expression clause.

override

Operators

operator ==(Object other) → bool

The equality operator.

inherited