Query class

Constructors

Query({required String table, DBMerge? database})

Properties

database ↔ DBMerge?

getter/setter pair

hashCode → int

The hash code for this object.

no setter, inherited

runtimeType → Type

A representation of the runtime type of the object.

no setter, inherited

table ↔ String

getter/setter pair

Methods

crossJoin(dynamic tableName, {dynamic tableColumn, dynamic baseColumn, dynamic baseTableCustom, Query function(Query)?}) → Query

data(Map<String, String> data) → Query

delete() → Future<List<Map<String, dynamic>>>

distinct(List<String> column) → Query

get() → Future<List<Map<String, dynamic>>>

getQuery() → String

groupBy(List<String> columnName) → Query

insert() → Future<List<Map<String, dynamic>>>

join(dynamic tableName, {dynamic tableColumn, dynamic baseColumn, dynamic baseTableCustom, Query function(Query)?}) → Query

leftJoin(dynamic tableName, {dynamic tableColumn, dynamic baseColumn, dynamic baseTableCustom, Query function(Query)?}) → Query

limit(int limit) → Query

listData(List<Map<String, String>> listData) → Query

noSuchMethod(Invocation invocation) → dynamic

Invoked when a nonexistent method or property is accessed.

inherited

on(dynamic tableColumn, dynamic baseColumn) → Query

orderBy(List<String> columnName) → Query

[ table1.id DESC , table2.id ASC ]

orWhere(dynamic column, dynamic operator, dynamic value) → Query

orWhereBetween(dynamic columnName, dynamic startValue, dynamic endValue) → Query

orWhereDateBetween(dynamic columnName, dynamic startValue, dynamic endValue) → Query

orWhereDateNotBetween(dynamic columnName, dynamic startValue, dynamic endValue) → Query

orWhereHas(dynamic tableName, Query function(Query)?) → Query

orWhereIn(dynamic column, List<String> value) → Query

orWhereNotBetween(dynamic columnName, dynamic startValue, dynamic endValue) → Query

orWhereNotHas(dynamic tableName, Query function(Query)?) → Query

orWhereNotIn(dynamic column, List<String> value) → Query

orWhereTableIn(dynamic column, String getQueryTable) → Query

orWhereTableNotIn(dynamic column, String getQueryTable) → Query

select(List<String> column) → Query

selfCrossJoin(dynamic tableName, {dynamic baseColumnName, dynamic columnName, Query function(Query q, String tableName, String baseTableName)?}) → Query

selfJoin(dynamic tableName, {dynamic columnName, dynamic baseColumnName, Query function(Query q, String tableName, String baseTableName)?}) → Query

selfLeftJoin(dynamic tableName, {dynamic baseColumnName, dynamic columnName, Query function(Query q, String tableName, String baseTableName)?}) → Query

toString() → String

A string representation of this object.

inherited

update() → Future<List<Map<String, dynamic>>>

where(dynamic column, dynamic operator, dynamic value) → Query

whereBetween(dynamic columnName, dynamic startValue, dynamic endValue) → Query

whereDateBetween(dynamic columnName, dynamic startValue, dynamic endValue) → Query

whereDateNotBetween(dynamic columnName, dynamic startValue, dynamic endValue) → Query

whereHas(dynamic tableName, Query function(Query)?) → Query

whereIn(dynamic column, List<String> value) → Query

whereNotBetween(dynamic columnName, dynamic startValue, dynamic endValue) → Query

whereNotHas(dynamic tableName, Query function(Query)?) → Query

whereNotIn(dynamic column, List<String> value) → Query

whereTableIn(dynamic column, String getQueryTable) → Query

whereTableNotIn(dynamic column, String getQueryTable) → Query

Operators

operator ==(Object other) → bool

The equality operator.

inherited