QueryBuilder class

A simple SQL query builder for MySQL/PostgreSQL in Flint Dart.

Constructors

QueryBuilder({required String table})

Properties

hashCode → int
The hash code for this object.
no setterinherited
runtimeType → Type
A representation of the runtime type of the object.
no setterinherited
table → String
final

Methods

avg(String column) → Future<double?>
AVG aggregate
count([String column = '*']) → Future<int>
COUNT aggregate
delete() → Future<void>
DELETE
first() → Future<Map<String, dynamic>?>
Fetch first row
get() → Future<List<Map<String, dynamic>>>
Fetch all rows
groupBy(String field) → QueryBuilder
GROUP BY clause
insert(Map<String, dynamic> data, {String idColumn = 'id'}) → Future<void>
INSERT
join(String table, String first, String operator, String second) → QueryBuilder
JOIN clause
limit(int value) → QueryBuilder
LIMIT clause
max(String column) → Future
MAX aggregate
min(String column) → Future
MIN aggregate
noSuchMethod(Invocation invocation) → dynamic
Invoked when a nonexistent method or property is accessed.
inherited
offset(int value) → QueryBuilder
OFFSET clause
orderBy(String field, [String direction = 'ASC']) → QueryBuilder
ORDER BY clause
orWhere(String field, String operator, dynamic value) → QueryBuilder
OR WHERE clause
paginate(int page, [int perPage = 15]) → Future<Map<String, dynamic>>
Paginate results
select([List<String>? fields]) → QueryBuilder
SELECT fields
sum(String column) → Future<double?>
SUM aggregate
toString() → String
A string representation of this object.
inherited
update(Map<String, dynamic> data) → Future<void>
UPDATE
where(String field, String operator, dynamic value) → QueryBuilder
WHERE clause
whereIn(String field, List values) → QueryBuilder
WHERE IN clause
whereNotIn(String field, List values) → QueryBuilder
WHERE NOT IN clause
whereNotNull(String field) → QueryBuilder
WHERE NOT NULL clause
whereNull(String field) → QueryBuilder
WHERE NULL clause

Operators

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