Methods
-
all()
→ Future<List<Map<String, Object?>>>
-
Return all rows from table.
-
create(Map<String, Object?> values)
→ Future<int>
-
Create a new row.
-
createIfNotExists({required Map<String, Object?> check, required Map<String, Object?> create})
→ Future<int?>
-
inherited
-
delete()
→ Future<int>
-
Delete rows from table and return number of changes.
override
-
distinct(List<String>? columnNames)
→ Generator
-
Get unique column values.
inherited
-
find(dynamic primaryKeyValue)
→ Future<Map<String, Object?>?>
-
inherited
-
first()
→ Future<Map<String, Object?>?>
-
inherited
-
generateQuery(String prefix, {String? table})
→ String
-
inherited
-
get()
→ Future<List<Map<String, Object?>>>
-
Get the rows.
-
getSelectedColumnAsArray()
→ List<String>?
-
inherited
-
getSelectedColumns({String? table})
→ String?
-
inherited
-
getWhereColumns()
→ List<_Where>
-
inherited
-
groupBy(String? columnName, {Sort? sort})
→ Generator
-
Group rows by column.
inherited
-
groupByDesc(String? columnName)
→ Generator
-
Group rows by column in descending order.
inherited
-
latest({String? columName})
→ Generator
-
Get latest row related to primary key. You can specify the column name.
inherited
-
noSuchMethod(Invocation invocation)
→ dynamic
-
Invoked when a nonexistent method or property is accessed.
inherited
-
orderBy(String? columnName, {Sort? sort})
→ Generator
-
Sort rows in either descending or ascending order.
inherited
-
orderByDesc(String? columnName)
→ Generator
-
Sort rows in descending order.
inherited
-
resetAll()
→ dynamic
-
-
resetDistinct()
→ dynamic
-
inherited
-
resetGroupBy()
→ dynamic
-
inherited
-
resetLimit()
→ dynamic
-
inherited
-
resetOffset()
→ dynamic
-
inherited
-
resetOrderBy()
→ dynamic
-
inherited
-
resetSelectedColunns()
→ dynamic
-
inherited
-
resetSort()
→ dynamic
-
inherited
-
resetWheres()
→ dynamic
-
inherited
-
save()
→ Future<int>
-
Create record in related table if not exists depending on primary value
Otherwise update the values.
inherited
-
search(String keyword, {List<String>? searchableColumns})
→ Future<List<Map<String, Object?>>>
-
Search rows.
-
select(List<String> selectedColumns)
→ Generator
-
Specify columns to be only included in results.
inherited
-
setPrimaryValue(dynamic value)
→ dynamic
-
Update the primary value automatically when
save
method is executed.
inherited
-
skip(int? offset)
→ Generator
-
Skip a given number of results.
inherited
-
take(int? count)
→ Generator
-
Limit the number of rows in result
inherited
-
toString()
→ String
-
A string representation of this object.
inherited
-
update(Map<String, Object?> values)
→ Future<int>
-
Update rows and return number of changes.
override
-
updateOrCreate({required Map<String, Object?> check, required Map<String, Object?> inserts})
→ Future<int>
-
Update data if exists and if not, create new row.
inherited
-
where(String columnName, dynamic value, {Operator operator = Operator.equal, String? conjuncation})
→ Generator
-
Specify 'where' conditions in query.
inherited
-
whereIn(String columnName, List values)
→ Generator
-
Get all records of which
columnName
include any of values
.
inherited
-
whereNotIn(String columnName, List values)
→ Generator
-
Get all records of which
columnName
does not include any of values
.
inherited