search-notes.dart

Future<List<NoteSearchResult>> searchNotes(Query queryString) async {
  // Creating a query has some overhead and if a query is executed
  // many times, it should be created once and reused. For simplicity
  // we don't do that here.
  final query = await Query.fromN1ql(
    database,
    r'''
    SELECT META().id AS id, title
    FROM _
    WHERE type = 'note' AND match(note-fts, $query)
    ORDER BY rank(note-fts)
    LIMIT 10
    ''',
  );

  // Query parameters are defined by prefixing an identifier with `$`.
  await query.setParameters(Parameters({'query': '$queryString*'}));

  // Each time a query is executed, its results are returned in a ResultSet.
  final resultSet = await query.execute();

  // To create the NoteSearchResults, we turn the ResultSet into a stream
  // and collect the results into a List, after transforming them into
  // NoteSearchResults.
  return resultSet.asStream().map(NoteSearchResult.fromResult).toList();
}