favorite method

Implementation

Future<List<DtoChat>> favorite({int? limit}) async {
  final result = await safe(
    (db) async {
      final stmt = db.select(db.chats);

      stmt.where(
        (u) =>
            u.isHidden.equals(false) &
            u.favoritePosition.isNotNull() &
            u.id.like('local_%').not() &
            u.id.like('d_%').not(),
      );
      stmt.orderBy([(u) => OrderingTerm.desc(u.favoritePosition)]);

      if (limit != null) {
        stmt.limit(limit);
      }

      return (await stmt.get()).map(_ChatDb.fromDb).toList();
    },
    tag: 'chat.favorite(limit: $limit)',
    exclusive: false,
  );

  return result ?? [];
}