ConjunctionBase class abstract
Container of Conjunction Keywords & toList/Single methods below
ConjunctionBase and ConjunctionBase or ConjunctionBase startBlock ConjunctionBase endBlock ConjunctionBase where(String? whereCriteria, {dynamic parameterValue}) ConjunctionBase page(int page, int pagesize) ConjunctionBase top(int count) ConjunctionBase orderBy(dynamic argFields) ConjunctionBase orderByDesc(dynamic argFields) ConjunctionBase groupBy(dynamic argFields) ConjunctionBase having(dynamic argFields)
Methods
Future<List
- Inheritance
-
- Object
- FluentBase
- ConjunctionBase
Constructors
- ConjunctionBase(TableBase obj, bool? getIsDeleted)
Properties
- and → ConjunctionBase
-
put the sql keyword 'AND'
no setter
- endBlock → ConjunctionBase
-
close parentheses
no setter
-
groupByList
↔ List<
String> -
getter/setter pairinherited
- hashCode → int
-
The hash code for this object.
no setterinherited
-
havingList
↔ List<
String> -
getter/setter pairinherited
- openedBlock → bool
-
protected
The member 'openedBlock' can only be used within instance members
no setter
- or → ConjunctionBase
-
put the sql keyword 'OR'
no setter
-
orderByList
↔ List<
String> -
getter/setter pair
-
parameters
↔ List<
DbParameter> -
getter/setter pair
- qparams ↔ QueryParams
-
getter/setter pair
- result ↔ BoolResult?
-
getter/setter pairinherited
- runtimeType → Type
-
A representation of the runtime type of the object.
no setterinherited
- startBlock → ConjunctionBase
-
open parentheses
no setter
- whereArguments ↔ List
-
getter/setter pairinherited
- whereString ↔ String
-
getter/setter pairinherited
Methods
-
buildParameters(
{bool? getIsDeleted, int? pSize}) → void -
delete(
[bool hardDelete = false]) → Future< BoolResult> - METHODS Deletes List
-
groupBy(
dynamic argFields) → ConjunctionBase - argFields might be String or List
-
having(
dynamic argFields) → ConjunctionBase - argFields might be String or List
-
noSuchMethod(
Invocation invocation) → dynamic -
Invoked when a nonexistent method or property is accessed.
inherited
-
orderBy(
dynamic argFields) → ConjunctionBase - argFields might be String or List
-
orderByDesc(
dynamic argFields) → ConjunctionBase - argFields might be String or List
-
page(
int page, int pagesize) → ConjunctionBase - page = page number, pagesize = row(s) per page
-
recover(
) → Future< BoolResult> - Recover List
-
setCriteria(
dynamic pValue, List< DbParameter> ? parameters, DbParameter? param, String? sqlSyntax, AddedBlocks? addedBlocks, [dynamic pValue2]) → AddedBlocks -
inherited
-
toCount(
) → Future< int> -
toJson(
) → Future< String> -
toJsonWithChilds(
) → Future< String> -
toList(
{bool preload = false, List< String> ? preloadFields, bool loadParents = false, List<String> ? loadedFields}) → Future<List< TableBase> > -
toListObject(
) → Future< List> - Returns List
-
toListPrimaryKey(
[bool buildParams = true]) → Future< List> - This method returns Primary Key List
-
toListPrimaryKeySQL(
[bool buildParams = true]) → Map< String, dynamic> -
This method returns Primary Key List SQL and Parameters retVal = Map<String,dynamic>.
retVal
'sql'= SQL statement string, retVal'args'= whereArguments List -
toListString(
) → Future< List< String> > - Returns List
-
toMapList(
) → Future< List> -
top(
int count) → ConjunctionBase - int count = LIMIT
-
toSingle(
) → Future< TableBase?> -
toSingleOrDefault(
) → Future< TableBase> -
toString(
) → String -
A string representation of this object.
inherited
-
update(
Map< String, dynamic> values) → Future<BoolResult> - update({'fieldName': Value}) fieldName must be String. Value is dynamic, it can be any of the (int, bool, String.. )
-
where(
String? whereCriteria, {dynamic parameterValue}) → ConjunctionBase - String whereCriteria, write raw query without 'where' keyword. Like this: 'field1 like 'test%' and field2 = 3'
Operators
-
operator ==(
Object other) → bool -
The equality operator.
inherited