Ignore field when batch.update

[lsaudon]

Is it possible to ignore a field when updating a row?

[North101]

Use a Companion. One is generated for each table.

TodosCompanion(
  category: Value(target.id),
);

You need to wrap each value in Value(<value>) and if you don't want to update the value (or use the default for inserts) either don't include the field or do:

TodosCompanion(
  category: Value.absent(),
);

[MathiasCochet]

If category is not set as nullable it gets the "required" annotation. When updating the column using the companion object and setting category to Value.absent() I get an error saying category is required. But I just want to set the category once and never update it. How do I go about doing that ?

[simolus3]

You should be able to keep the category absent for updates. Could you post the error and the code you've used to create the companion?