Find class

Select SQL statement builder.

Implemented types

Constructors

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

Properties

asImmutable ImmutableFindStatement
read-only
from TableName
final
hashCode → int
The hash code for this object.
read-only, inherited
runtimeType → Type
A representation of the runtime type of the object.
read-only, 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.
andMap<T>(Iterable<T> iterable, MappedExpression<T> func) Find
between<T>(String column, T low, T high) Find
Adds an 'between' expression to 'where' clause.
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.
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.
gtEq<T>(String column, T val) Find
Adds an '>=' expression to 'where' clause.
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.
limit(int val) Find
lt<T>(String column, T val) Find
Adds an '<' expression to 'where' clause.
ltEq<T>(String column, T val) Find
Adds an '<=' expression to 'where' clause.
ne<T>(String column, T val) Find
Adds an '<>' expression to 'where' clause.
offset(int val) Find
or(Expression expression) Find
Adds an 'or' expression to 'where' clause.
orderBy(String column, [ bool ascending = false ]) Find
orderByMany(List<String> columns, [ bool ascending = false ]) Find
orMap<T>(Iterable<T> iterable, MappedExpression<T> func) Find
rightJoin(String tableName, [ String alias ]) Find
Adds a 'right join' clause to the select statement.
sel(String column, [ String alias ]) Find
Selects a column to be fetched. Use alias to alias the column name.
selAll() Find
Selects a column to be fetched. Use alias to alias the column name.
selAllFromTable(String table) Find
Selects a column to be fetched. Use alias to alias the column name.
selIn(String table, String column, [ String alias ]) Find
Selects a column to be fetched from the table. Use alias to alias the column name.
selMany(Iterable<String> columns, [ String alias ]) Find
Selects many columns to be fetched. Use alias to alias the column name.
selManyIn(String table, List<String> columns) Find
Selects many columns to be fetched in the given table. Use alias to alias the column name.
where(Expression expression) Find
Adds an to 'where' expression clause.
noSuchMethod(Invocation invocation) → dynamic
Invoked when a non-existent method or property is accessed.
inherited
toString() → String
Returns a string representation of this object.
inherited

Operators

operator ==(dynamic other) → bool
The equality operator.
inherited