SqlSelectBloc class
A ready to use select bloc
Provides a stream with the rows corresponding to the query. This stream, accssible via rows, will send new data if something changes in the database if the reactive parameter is true
Join queries are possible.
Constructors
- SqlSelectBloc({required SqlDb database, required String table, int? offset, int? limit, String? where, String columns = "*", String? joinTable, String? joinOn, String? orderBy, bool reactive = false, bool verbose = false})
- Create a select bloc with the specified options. The select bloc will fire a query on creation
Properties
- columns ↔ String
-
Select sql statement
getter/setter pair
- database → SqlDb
-
The database
final
- hashCode → int
-
The hash code for this object.
no setterinherited
- joinOn ↔ String?
-
The on sql statement
getter/setter pair
- joinTable ↔ String?
-
The join sql statement
getter/setter pair
- limit ↔ int?
-
Limit sql statement
getter/setter pair
- offset ↔ int?
-
Offset sql statement
getter/setter pair
- orderBy ↔ String?
-
Order by sql statement
getter/setter pair
- reactive ↔ bool
-
The reactivity of the bloc. Will send new values in
items
when something changes in the database if set to truegetter/setter pair -
rows
→ Stream<
List< DbRow> > -
A stream of rows returned by the query. Will return new items
if something changes in the database when the reactive parameter
is true
no setter
- runtimeType → Type
-
A representation of the runtime type of the object.
no setterinherited
- table → String
-
The table name
final
- verbose ↔ bool
-
The verbosity
getter/setter pair
- where ↔ String?
-
Where sql statement
getter/setter pair
Methods
-
dispose(
) → void - Cancel the changefeed subscription
-
noSuchMethod(
Invocation invocation) → dynamic -
Invoked when a nonexistent method or property is accessed.
inherited
-
toString(
) → String -
A string representation of this object.
inherited
-
update(
List< DbRow> _rows) → void - A convenience method to update the bloc items if needed by adding to the sink
Operators
-
operator ==(
Object other) → bool -
The equality operator.
inherited