34 lines
904 B
Dart
34 lines
904 B
Dart
import 'package:drift/drift.dart';
|
|
|
|
import 'tables.dart';
|
|
|
|
abstract class CategoryTodoCountView extends View {
|
|
TodosTable get todos;
|
|
Categories get categories;
|
|
|
|
Expression<int> get categoryId => categories.id;
|
|
Expression<String> get description => categories.description + const Variable('!');
|
|
Expression<int> get itemCount => todos.id.count();
|
|
|
|
@override
|
|
Query as() =>
|
|
select(
|
|
[categoryId, description, itemCount],
|
|
).from(categories).join([
|
|
innerJoin(todos, todos.category.equalsExp(categories.id)),
|
|
])
|
|
..groupBy([categories.id]);
|
|
}
|
|
|
|
abstract class TodoWithCategoryView extends View {
|
|
TodosTable get todos;
|
|
Categories get categories;
|
|
|
|
@override
|
|
Query as() =>
|
|
select(
|
|
[todos.title, categories.description],
|
|
).from(todos).join([
|
|
innerJoin(categories, categories.id.equalsExp(todos.category)),
|
|
]);
|
|
}
|