how to update many?

[wesleytoshio]

I have a list of selected items eg: [item1, item2, item3] and I need to update them all at once, any example that can help me?

//This exemplo update one
Future updateNote(Insertable<Note> note) => update(notes).replace(note);

[simolus3]

Instead of using replace (which targets a single row), you can just use write and where to update some rows. The documentation has an example here, does that help?

In your case, it would probably look like this:

(update(notes)..where((note) => note.id.isIn([your, target, ids]))).write(yourUpdate)

[wesleytoshio]

in this case, what would be [your] and [target]?

[wesleytoshio]

I need to change the value of several items that were selected in my list eg: checked

Future updateSelected(List<Note> selecteds){
// ex:
(update(notes)..where((note) => note.id.isIn(selecteds.map((e) => e.id).toList())))
          .write(selecteds);
}

[simolus3]

I just meant that [your, target, ids] would be a list of ids to update, but that would apply the same update to every row. Judging by your second snippet, it looks like you essentially want to perform many independent updates? In that case, you can use a batch:

await batch((b) {
  b.replaceAll(notes, selecteds);
});