Tags: Nash0x7E2/moor
Tags
- Support common table expressions - Handle special `rowid`, `oid`, `__rowid__` references - Support references to `sqlite_master` and `sqlite_sequence` tables
- New extension methods to simplify the Dart api!
- Use `&`, `or` and `.not()` to combine boolean expressions.
```dart
// OLD
select(animals)..where((a) => and(not(a.isMammal), a.amountOfLegs.equals(4)))
// NEW:
select(animals)..where((a) => a.isMammal.not() & a.amountOfLegs.equals(4))
```
- Arithmetic: New `+`, `-`, `*` and `/` operators for int and double sql expressions
- New `+` operator for string concatenation
- Fix crash when `customStatement` is the first operation used on a database ([simolus3#199](simolus3#199))
- Allow transactions inside a `beforeOpen` callback
- New `batch` method on generated databases to execute multiple queries in a single batch
- Experimental support to run moor on a background isolate
- Reduce use of parentheses in SQL code generated at runtime
- Query streams now emit errors that happened while running the query
- Upgraded the sql parser which now supports `WITH` clauses in moor files
- Internal refactorings on the runtime query builder
- Accept inheritance in table definitions (e.g. if an abstract class … …declared as `IntColumn get foo => integer()()`, tables inheriting from that class will also have a `foo` column) - New `use_data_class_name_for_companions` option that will make the name of the companion based on the data class name (uses table name by default). - New `use_column_name_as_json_key_when_defined_in_moor_file` option to use the column name instead of the Dart getter name as json key for columns declared in moor files
- Remove the `background` flag from the moor apis provided by this pa… …ckage. Use the moor isolate api instead. - Remove builtin support for background execution from the low-level `Database` api - Support Dart 2.6, drop support for older versions