SQLiteQueryBuilder class

Implemented types

• QueryBuilder

Constructors

SQLiteQueryBuilder(DBDriver driver, [String? table])

Properties

driver ↔ DBDriver

getter/setter pair, override

hashCode → int

The hash code for this object.

no setter, inherited

logger → ConsoleLogger

late, final

runtimeType → Type

A representation of the runtime type of the object.

no setter, inherited

safeQueryBuilderParameterParser → SafeQueryBuilderParameterParser

late, final

table ↔ String?

getter/setter pair, override

Methods

addSelect(String column) → QueryBuilder

override

avg(String column) → num

override

chunk(int size, bool? callback(RecordSet records)) → void

override

chunkById(int size, bool? callback(RecordSet records)) → void

override

count([String columns = '*']) → int

override

delete([Object? id]) → Future<int>

override

distinct() → QueryBuilder

override

doesntExist() → bool

override

exists() → bool

override

find(dynamic id) → Record?

override

first() → Record?

override

firstOrFail() → Record

override

get() → RecordSet

override

groupBy(String column) → QueryBuilder

override

insert(Map<String, dynamic> values) → bool

override

insertGetId(Map<String, dynamic> values) → Future<int>

override

lazy() → LazyRecordSetGenerator

override

lazyById() → LazyRecordSetGenerator

override

limit(int limit, [int? offset]) → QueryBuilder

override

max(String column) → int

override

min(String column) → int

override

noSuchMethod(Invocation invocation) → dynamic

Invoked when a nonexistent method or property is accessed.

inherited

orderBy(String column, [String direction = 'DESC']) → QueryBuilder

override

orWhere(dynamic column, [dynamic operatorOrValue, dynamic value]) → QueryBuilder

override

orWhereRaw(String rawWhere, [List bindings = const []]) → QueryBuilder

override

pluck(String column) → List<Object?>

override

select(dynamic columns) → QueryBuilder

override

selectRaw(String rawSelect, [List bindings = const []]) → QueryBuilder

override

sum(String column) → int

override

toString() → String

A string representation of this object.

inherited

update(Map<String, dynamic> values) → Future<int>

override

value(String column) → Object?

override

where(dynamic column, [dynamic operatorOrValue, dynamic value]) → QueryBuilder

override

whereRaw(String rawWhere, [List bindings = const []]) → QueryBuilder

override

Operators

operator ==(Object other) → bool

The equality operator.

inherited