I found a problem in the following snippet of your amazing flutter course in step-15 at notes_service.dart

 Future<DatabaseNote> updateNote({
    required DatabaseNote note,
    required String text,
  }) async {
    await _ensureDbIsOpen();
    final db = _getDatabaseOrThrow();
    // make sure note exists
    await getNote(id: note.id);
    // >>>>>>>>>>>>>>>> The problem origin
    final updatesCount = await db.update(noteTable, {
      textColumn: text,
      isSyncedWithCloudColumn: 0,
    });
// >>>>>>>>>>>>>
    if (updatesCount == 0) {
      throw CouldNotUpdateNote();
    } else {
      final updatedNote = await getNote(id: note.id);
      _notes.removeWhere((note) => note.id == updatedNote.id);
      _notes.add(updatedNote);
      _notesStreamController.add(_notes);
      return updatedNote;
    }
  }

The result of this problem only prevails upon hot restart/reload of the app, as all the list elements will get the same value as the last created note due to that issue.

I fixed the problem in my codebase by specifying the exact id of the updated note, and the problem no longer persists

The fix

// update DB
    final updatesCount = await db.update(
      noteTable,
      {
        textColumn: text,
        isSyncedWithCloudColumn: 0,
      },
      where: 'id = ?',
      whereArgs: [note.id],
    );

Regards

I have just found a tiny bug in updateNote function in notes_service. If you add a note and close the app, after restart you will see that the text of all your notes will be the same and equal to the value of the last note. Hot restart also reproduces this behaviour.

The actual fix is to add id of note to a update query. Please see a snippet below

final updCount = await db.update(noteTable, where: 'id =?', whereArgs: [ id ], { textCol: text, });

Hi, I am following the course and have a problem on notes view. StreamBuilder is in connection state done and doesn't display the notes from the list. In the course we are displaying with the state active.

Here is what I am doing: body: FutureBuilder( future: _notesService.getOrCreateUser(email: userEmail), builder: (context, snapshot) { switch (snapshot.connectionState) { case ConnectionState.done: return StreamBuilder( stream: _notesService.allNotes, builder: (context, builder) { switch (snapshot.connectionState) { case ConnectionState.waiting: case ConnectionState.active: if (snapshot.hasData) { final allNotes = snapshot.data as List; return ListView.builder( itemCount: allNotes.length, itemBuilder: (context, index) { final note = allNotes[index]; return ListTile( title: Text( note.text, maxLines: 1, softWrap: true, overflow: TextOverflow.ellipsis, ), ); }, ); } else { return const CircularProgressIndicator(); }

                default:
                  return const CircularProgressIndicator();
              }
            },
          );