QueryBuilder class

QueryBuilder is SQL Query Builder class

Properties

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

Methods

add(dynamic value) → QueryBuilder

Add something to Query

and() → QueryBuilder

AND operator

between() → QueryBuilder

BETWEEN operator

build() → String

Returns completed SQL Query

delete(String tableName) → QueryBuilder

DELETE statement

equal(dynamic value) → QueryBuilder

Equal operator '='

from(String tableName) → QueryBuilder

FROM statement

greaterThan(dynamic value) → QueryBuilder

Greater Than operator '>'

greaterThanOrEqual(dynamic value) → QueryBuilder

Greater Than Or Equal operator '>='

iN(List values) → QueryBuilder

IN Operator

insertInto({required String tableName, List<String> columns = const [], required List values}) → QueryBuilder

INSERT INTO statement

isNotNull(String column) → QueryBuilder

Check column value is not null

isNull(String column) → QueryBuilder

Check column value is null

lessThan(dynamic value) → QueryBuilder

Less Than operator '<'

lessThanOrEqual(dynamic value) → QueryBuilder

Less Than Or Equal operator '<='

like(String pattern) → QueryBuilder

LIKE operator

noSuchMethod(Invocation invocation) → dynamic

Invoked when a nonexistent method or property is accessed.

inherited

not() → QueryBuilder

NOT operator

notEqual(dynamic value) → QueryBuilder

Not Equal operator '!='

or() → QueryBuilder

OR operator

orderBy({required List<String> columns, String sort = OrderBy.asc}) → QueryBuilder

ORDER BY for ordering

select(List<String> columns) → QueryBuilder

Select columns

selectAll() → QueryBuilder

Select All Columns

selectAllDistinct() → QueryBuilder

Select All Distinct values

selectDistinct(List<String> columns) → QueryBuilder

Select Distinct values

toString() → String

A string representation of this object.

inherited

update({required String tableName, required List<String> columns, required List values}) → QueryBuilder

Update given table columns

where() → QueryBuilder

The WHERE clause is used to filter records.

Operators

operator ==(Object other) → bool

The equality operator.

inherited

Static Properties

i → QueryBuilder

i short form of instance

no setter

instance → QueryBuilder

instance return QueryBuilder instance

no setter