SQL class

An encoded SQL representation. This is used by a DBSQLAdapter to execute queries.

Implemented types

Constructors

SQL(String sql, List? positionalParameters, Map<String, dynamic>? namedParameters, Map<String, dynamic> parametersByPlaceholder, {String? sqlCondition, String? sqlPositional, List<String>? parametersKeysByPosition, List<Object?>? parametersValuesByPosition, Condition? condition, String? entityName, String? idFieldName, Set<String>? returnColumns, Map<String, String>? returnColumnsAliases, int? limit, int? offset, bool? orderByID, OrderDirection? orderDirection, required String? mainTable, TableRelationshipReference? relationship, Map<String, String>? tablesAliases, RegExp? placeholderRegexp})

Properties

allSQLs → Iterable<SQL>
Returns all wrapped SQLs.
no setteroverride
condition → Condition?
final
entityName → String?
final
hashCode → int
The hash code for this object.
no setterinherited
hasPosSQL → bool
no setter
hasPreOrPosSQL → bool
no setter
hasPreSQL → bool
no setter
idFieldName → String?
final
isDummy → bool
no setter
isFullyDummy → bool
no setter
isSharedDummy → bool
Returns true if this is the dummy instance. See ensureNotSharedDummy.
no setter
limit → int?
final
mainSQL → SQL
Returns the main SQL.
no setteroverride
mainTable → String?
final
namedParameters → Map<String, dynamic>?
final
offset → int?
The return offset of this select (OFFSET), or null for no offset.
final
orderByID → bool?
If this select is ordered by the table ID column. null means unset: the generated SQL orders by ID when there's an OFFSET or a LIMIT (see OrderDirection.resolveOrderByID); DBSQLMemoryAdapter orders only with an OFFSET (its rows are already in insertion order).
final
orderDirection → OrderDirection?
The OrderDirection of the ordering. Only applies while the ordering is active. See orderByID.
final
parametersByPlaceholder → Map<String, dynamic>
final
parametersKeysByPosition → List<String>
no setter
parametersValuesByPosition → List<Object?>
no setter
placeholderRegexp → RegExp
final
positionalParameters → List?
final
posSQL ↔ List<SQL>?
getter/setter pair
posSQLReturnIndex ↔ int?
getter/setter pair
preSQL ↔ List<SQL>?
getter/setter pair
relationship → TableRelationshipReference?
final
returnColumns → Set<String>?
final
returnColumnsAliases → Map<String, String>?
final
runtimeType → Type
A representation of the runtime type of the object.
no setterinherited
sql → String
final
sqlCondition → String?
final
sqlPositional → String
no setter
sqlsLength → int
The amount of SQLs.
no setteroverride
tablesAliases → Map<String, String>?
final

Methods

copy() → SQL
ensureNotSharedDummy() → SQL
Ensures that this is not the dummy instance. Returns a copy if necessary.
noSuchMethod(Invocation invocation) → dynamic
Invoked when a nonexistent method or property is accessed.
inherited
toString() → String
A string representation of this object.
override

Operators

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

Static Properties

dummy → SQL
final