SelectStatement class
- Inheritance
- Implemented types
- Available extensions
Constructors
- SelectStatement.new({bool distinct = false})
Properties
-
fieldsInfo
↔ List<
FieldInfo> -
getter/setter pairinherited-setteroverride-getter
- hashCode → int
-
The hash code for this object.
no setterinherited
- runtimeType → Type
-
A representation of the runtime type of the object.
no setterinherited
Methods
-
CrossJoin(
Queryable t, Expr on) → JoinTable -
inherited
-
Except(
AbsSelect select) → CompoundSelect -
execute(
DbContext dbc) → Future< List< Map< >String, dynamic> > -
inherited
-
executeEntity<
E extends BaseEntity> (E entity, DbContext dbc) → Future< E?> -
Available on SelectStatement, provided by the entityExtensions1 extension
-
executeEntityList<
E extends BaseEntity> (E entityCreator(), DbContext dbc) → Future< List< E> > -
Available on AbsSelect, provided by the entityExtensions extension
-
executeRow(
DbContext dbc) → Future< Map< String, dynamic> ?> - returns the first row of the result set, or null if no data found
-
executeScalar(
DbContext dbc) → Future< Object?> -
Fields(
List< Expr> exprs) → SelectStatement - if used multiple times the last one will override
-
FieldsFromTable(
List< DbTable> tablesAndViews) → SelectStatement - if used multiple times the last one will override
-
From(
Queryable table) → SelectStatement - use it once, if used multiple times, the last one will override
-
GroupBy(
List< Expr> exps) → SelectStatement -
Having(
Expr exp) → SelectStatement - only use with gruopBy() otherwise it's useless
-
InnerJoin(
Queryable t, Expr on) → JoinTable -
inherited
-
Intersect(
AbsSelect select) → CompoundSelect -
LeftJoin(
Queryable t, Expr on) → JoinTable -
inherited
-
noSuchMethod(
Invocation invocation) → dynamic -
Invoked when a nonexistent method or property is accessed.
inherited
-
OrderBy(
List< SortExp> sortExps) → AbsSelect -
inherited
-
OuterJoin(
Queryable t, Expr on) → JoinTable -
inherited
-
Page(
int index, int pageSize) → AbsSelect -
inherited
-
RightJoin(
Queryable t, Expr on) → JoinTable -
inherited
-
toSql(
) → String -
inherited
-
toString(
) → String -
A string representation of this object.
inherited
-
Union(
AbsSelect select) → CompoundSelect -
UnionAll(
AbsSelect select) → CompoundSelect -
Where(
Expr cond) → SelectStatement - use only once
Operators
-
operator ==(
Object other) → bool -
The equality operator.
inherited