DbQuery class
Runs SQL for a card (WML <dbquery>): SELECTs become registered datasets.
Constructors
- DbQuery({required DataSetRegistry registry, required TSQLConnection connection, String databaseName = 'TestDB'})
-
Creates a query helper for
registryusingconnection.
Properties
- connection → TSQLConnection
-
The connection the SQL is sent through.
final
- databaseName → String
-
Name of the database (informational).
final
- hashCode → int
-
The hash code for this object.
no setterinherited
- registry → DataSetRegistry
-
Where query registers the datasets it opens.
final
- runtimeType → Type
-
A representation of the runtime type of the object.
no setterinherited
Methods
-
exec(
String sql, {Map< String, dynamic> ? params}) → Future<int> - Runs an INSERT / UPDATE / DELETE (an id-less ExecSQL). Returns the number of affected rows.
-
noSuchMethod(
Invocation invocation) → dynamic -
Invoked when a nonexistent method or property is accessed.
inherited
-
query(
String id, String sql, {Map< String, dynamic> ? params, bool readOnly = false}) → Future<TSQLQuery> - Runs a SELECT. With an id: creates and registers it the first time, reuses it thereafter; with an empty id: a one-off query that isn't registered.
-
toString(
) → String -
A string representation of this object.
inherited
Operators
-
operator ==(
Object other) → bool -
The equality operator.
inherited