Select class
SELECT query builder.
- Inheritance
-
- Object
- QueryBuilder
- Select
Constructors
-
Select(QueryBuilderOptions options, {Future<
List< execFunc()?, Future<List> >Map< firstAsMapFuncWithMeta()?, Future<String, Map< ?>String?, dynamic> >List< getAsMapFuncWithMeta()?, Future<Map< >String, Map< >String?, dynamic> >List?> firstFunc()?, Future<Map< firstAsMapFunc()?, Future<String, dynamic> ?>List< getAsMapFunc()?, Future<Map< >String, dynamic> >List< fetchAllFunc<T> >T>([T (Map< Future<String, dynamic> )?])?,T?> fetchSingleFunc<T>([T (Map< Future<String?, dynamic> )?])?,int> countFunc()?})
Properties
- hashCode → int
-
The hash code for this object.
no setterinherited
-
mBlocks
↔ List<
Block> ? -
getter/setter pairinherited
- mOptions ↔ QueryBuilderOptions
-
getter/setter pairinherited
- runtimeType → Type
-
A representation of the runtime type of the object.
no setterinherited
Methods
-
buildReturningFields(
) → List< String?> -
inherited
-
buildSubstitutionValues(
) → Map< String, dynamic> -
inherited
-
count(
) → Future< int> -
inherited
-
deleteSingle<
T> (T entity, [QueryBuilder? queryBuilder]) → Future -
inherited
-
distinct(
) → QueryBuilder -
override
-
exec(
) → Future< List< List> > -
inherited
-
fetchAll<
T> ([T factory(Map< String, dynamic> )?]) → Future<List< T> > -
inherited
-
fetchSingle<
T> ([T factory(Map< String?, dynamic> )?]) → Future<T?> -
inherited
-
field(
String field, {String? alias}) → QueryBuilder -
override
-
fieldRaw(
String setFieldRawSql) → QueryBuilder -
override
-
fields(
Iterable< String> fields) → QueryBuilder -
override
-
fieldSubQuery(
QueryBuilder field, {String? alias}) → QueryBuilder -
override
-
first(
) → Future< List?> -
inherited
-
firstAsMap(
) → Future< Map< String, dynamic> ?> -
inherited
-
firstAsMapWithMeta(
) → Future< Map< String, Map< ?>String?, dynamic> > -
Return row as maps containing table and column names
inherited
-
from(
String? table, {String? alias}) → QueryBuilder -
override
-
fromQuery(
Iterable< String> fields, QueryBuilder query) → QueryBuilder -
inherited
-
fromRaw(
String fromRawSqlString) → QueryBuilder -
override
-
fromSubQuery(
QueryBuilder table, {String? alias}) → QueryBuilder -
override
-
get(
) → Future< List< List?> ?> -
inherited
-
getAsMap(
) → Future< List< Map< >String, dynamic> > -
inherited
-
getAsMapWithMeta(
) → Future< List< Map< >String, Map< >String?, dynamic> > -
Return rows as maps containing table and column names
inherited
-
group(
String field) → QueryBuilder -
override
-
groupRaw(
String groupRawSql) → QueryBuilder -
override
-
groups(
Iterable< String> fields) → QueryBuilder -
override
-
innerJoin(
String joinTableName, String field1, String operator, String field2, {String? alias}) → QueryBuilder -
inherited
-
into(
String table) → QueryBuilder -
inherited
-
isContainFromBlock(
) → bool -
inherited
-
isQuery(
) → bool -
inherited
-
join(
String joinTableName, String condition, {String? alias, JoinType type = JoinType.INNER}) → QueryBuilder -
override
-
joinRaw(
String sql) → QueryBuilder -
inherited
-
joinWithExpression(
String table, Expression condition, {String? alias, JoinType type = JoinType.INNER}) → QueryBuilder -
override
-
joinWithQueryExpr(
QueryBuilder table, Expression condition, {String? alias, JoinType type = JoinType.INNER}) → QueryBuilder -
override
-
joinWithSubQuery(
QueryBuilder table, String condition, {String? alias, JoinType type = JoinType.INNER}) → QueryBuilder -
override
-
leftJoin(
String joinTableName, String field1, String operator, String field2, {String? alias}) → QueryBuilder -
inherited
-
limit(
int value) → QueryBuilder -
override
-
noSuchMethod(
Invocation invocation) → dynamic -
Invoked when a nonexistent method or property is accessed.
inherited
-
offset(
int value) → QueryBuilder -
override
-
order(
String field, {SortOrder dir = SortOrder.ASC}) → QueryBuilder -
override
-
orWhereGroup(
QueryBuilder function(QueryBuilder)) → QueryBuilder -
override
-
orWhereSafe(
String field, String operator, dynamic value) → QueryBuilder -
OR Where safe way against SQL injection
Example: orWhereSafe('"toAll"', '=', 'true');
override
-
putSingle<
T> (T entity) → Future -
inherited
-
rightJoin(
String joinTableName, String field1, String operator, String field2, {String? alias}) → QueryBuilder -
inherited
-
set(
String field, dynamic value) → QueryBuilder -
inherited
-
setAll(
Map< String, dynamic> fieldsAndValues) → QueryBuilder -
inherited
-
table(
String table, {String? alias}) → QueryBuilder -
inherited
-
toSql(
{bool isFirst = false, bool isCount = false}) → String -
isFirst used to add or replace limit 1 offset 0 in query string
inherited
-
toString(
) → String -
A string representation of this object.
inherited
-
union(
String table, UnionType unionType) → QueryBuilder -
override
-
unionSubQuery(
QueryBuilder table, UnionType unionType) → QueryBuilder -
override
-
updateSingle<
T> (T entity, [QueryBuilder? queryBuilder]) → Future -
inherited
-
where(
String condition, [Object? param, String andOr = 'AND']) → QueryBuilder -
WHERE
Not secure, this one is subject to SQL injection
Example: where('nome ilike ?', '%isaque%')
override
-
whereExpr(
Expression condition, [Object? param, String andOr = 'AND']) → QueryBuilder -
override
-
whereGroup(
QueryBuilder function(QueryBuilder)) → QueryBuilder -
override
-
whereRaw(
String whereRawSql, {String andOr = 'AND', Map< String, dynamic> ? substitutionValues}) → QueryBuilder -
Example PostgreSQL: whereRaw('b.info ilike @info', andOr: 'AND', substitutionValues: {'info': "%Sant'Ana%"})
Example MySQL: whereRaw('b.info ilike ?', andOr: 'AND', substitutionValues: {'info': "%Sant'Ana%"})
Example:
whereRaw(
'LOWER(${db.putInQuotes(sField.field)}::text) like ${db.formatSubititutioValue(sField.field)}',
andOr: 'OR',
substitutionValues: {
'nome': '%${filtros.searchString}%',
});
override
-
whereSafe(
String field, String operator, dynamic value) → QueryBuilder -
AND Where safe way against SQL injection
Example: whereSafe('"toAll"', '=', 'true');
override
Operators
-
operator ==(
Object other) → bool -
The equality operator.
inherited