flutter moor - update only specified columns without custom query

Question

I want to update only specified columns, when I execute update(table).replace(model) it replaces all data corresponding to primary key. How to update only specified column without writing custom queries.

you can update based on their id. – John Joe Dec 30 '19 at 09:47 — John Joe, Dec 30 '19 at 09:47

score 4 · Answer 1 · edited Jun 29 '20 at 22:35

4

You have to declare your function with Insertable like that:

Future updateVisit(Insertable<Visit> visit) => update(visits).replace(visit);

so, when you call a function you can do this:

visitDao.updateVisit(visit.copyWith(completed: newValue))

or

visitDao.updateVisit(VisitsCompanion(id: Value(visitId), checkOut: Value(DateTime.now())));

edited Jun 29 '20 at 22:35

Boken

4,825
10
32
42

answered Jan 31 '20 at 11:40

Rafael Menicucci

137
2
8

1

this doesn't answer his question. I need the same answered – valeriana Jul 20 '21 at 22:32

score 2 · Answer 2 · answered Jul 20 '21 at 22:35

In the docs, I found this that might be helpful, depending on your use case. This is how you could replace values of a single column.

   Future moveImportantTasksIntoCategory(Category target) {
     // for updates, we use the "companion" version of a 
     generated class. This wraps the
     // fields in a "Value" type which can be set to be absent using "Value.absent()". This
     // allows us to separate between "SET category = NULL" 
    (`category: Value(null)`) and not
    // updating the category at all: `category: Value.absent()`.

    return (update(todos)
     ..where((t) => t.title.like('%Important%'))
      ).write(TodosCompanion(
      category: Value(target.id),
     ),
   );
 }

flutter moor - update only specified columns without custom query

2 Answers2