Query class base

Implements the capability of database querying.

This class encapsulates SQLite SELECT statements and is used internally by the library to implement the functionality of the methods SQLite.prepare, SQLite.free, and SQLite.query.

See also: QueryId.

Constructors

Query(SQLite sqlite, List<Sql> columns, Sql? search, Sql? where, List<QueryOrdering> order, QueryDistinction distinction, int limit)

Creates a Query using the given query configuration parameters.

Properties

columns → List<Sql>

The additional columns to be retrieved.

final

distinction → QueryDistinction

The last sorting column.

final

hashCode → int

The hash code for this object.

no setter, inherited

limit → int

The value for the LIMIT clause.

final

order → List<QueryOrdering>

The ordering of this query.

final

runtimeType → Type

A representation of the runtime type of the object.

no setter, inherited

search → Sql?

The FROM clause for full-text search queries.

final

sqlite → SQLite

A reference to the SQLite instance for this query.

final

where → Sql?

The WHERE clause condition.

final

Methods

checkActive() → void

Throws an Error if the state is not set to Active.

inherited

checkDeactivated() → void

Throws an Error if the state is not set to Deactivated.

inherited

checkInitialized() → void

Throws an Error if the state is not set to either Active or Deactivated.

inherited

checkUndeactivated() → void

Throws an Error if the state is not set to either Uninitialized or Active.

inherited

checkUninitialized() → void

Throws an Error if the state is not set to Uninitialized.

inherited

deactivate() → void

A public interface for object deactivation.

inherited

dispose() → void

Called by deactivate; should contain the actual object deactivation code.

getStrOrder(QueryDirection direction) → String

Returns ORDER BY clause expressions.

getStrSeek(QueryDirection direction, {required bool first}) → String

Returns a WHERE clause condition for query seek-based pagination.

initialize() → void

A public interface for object initialization.

inherited

isActive() → bool

Whether the state is set to Active.

inherited

isDeactivated() → bool

Whether the state is set to Deactivated.

inherited

isInitialized() → bool

Whether the state is set to either Active or Deactivated.

inherited

isUndeactivated() → bool

Whether the state is set to either Uninitialized or Active.

inherited

isUninitialized() → bool

Whether the state is set to Uninitialized.

inherited

noSuchMethod(Invocation invocation) → dynamic

Invoked when a nonexistent method or property is accessed.

inherited

propose() → void

Called by initialize; should contain the actual object initialization code.

inherited

raiseInactive() → void

Throws an InactiveActorException if the state is no longer set to Active.

inherited

run(QueryParameters parameters, QueryDirection direction, QueryRowPosition? start) → ResultSet

Executes a query using the given query execution parameters.

setActive() → void

Sets the state to Active.

inherited

setDeactivated() → void

Sets the state to Deactivated.

inherited

statement(QueryDirection direction, {required bool first}) → CommonPreparedStatement

Caches (if not cached) and returns a prepared SELECT statement.

toString() → String

A string representation of this object.

inherited

Operators

operator ==(Object other) → bool

The equality operator.

inherited