Fix unique constraint error of generated columns

[martinsellergren]

Using a unique constraint on a "GENERATED ALWAYS AS ( generation_expr ) STORED" - column, gives you:

Error: Unique constraint "_the_key" violated for
model "model" on fields (_field) with values ().

This is because
const values = constraint.fields.map((c) => props.modelData[c]);
is [ undefined ], in this case.

Suggested fix by doing this update to constraints.ts:

before:

  for (const constraint of sortedConstraints) {
    // We skip the constraint if it contains null values
    if (
      constraint.fields.some((c) => props.modelData[c] === null)

after:

for (const constraint of sortedConstraints) {
    // We skip the constraint if it contains null values
    if (
      constraint.fields.some((c) => props.modelData[c] === null || props.modelData[c] === undefined)

[peterp]

@martinsellergren Would you consider opening a PR to fix this?

[martinsellergren]

@martinsellergren Would you consider opening a PR to fix this?

Sure, but unfortunately not gonna have the time to write tests. Would you add me as a collaborator and I'll do it.