Enhance logic for determining the referencing entity when fields backed by a column with default value is present. about data-api-builder HOT 4 CLOSED

Require user to provide values for default columns in the request. and add explicit error messaging if not provided so user knows what to do to mitigate HTTP 400 bad request/ GraphQL equivalent error message.

from data-api-builder.

@severussundar please update expectations and description for this feature.

from data-api-builder.

Relationship fields when backed by default values will be required to be provided by the user.

Consider two entities: User_AutogenToNonAutogenRelationshipColumn and UserProfile

Entity User_AutogenToNonAutogenRelationshipColumn has the following relationship defined with entity UserProfile.

"UserProfile_AutogenToNonAutogenRelationshipColumn": {
          "cardinality": "one",
          "target.entity": "UserProfile",
          "source.fields": [
            "userid",
            "username"
          ],
          "target.fields": [
            "userid",
            "username"
          ],
          "linking.source.fields": [],
          "linking.target.fields": []
        }

Relationship Fields

User_AutogenToNonAutogenRelationshipColumn: userid, username
UserProfile: userid, username. userid column has a default value of 1.

Multiple Create request:

mutation {
  createUser_AutogenToNonAutogenRelationshipColumn(
    item: {
      email: "[email protected]"
      UserProfile_AutogenToNonAutogenRelationshipColumn: {
        profilepictureurl: "https://example.com/profiles/alice"
        username: "Alice"
      }
    }
  ) {
    userid
    username
    email
    UserProfile_AutogenToNonAutogenRelationshipColumn {
      profileid
      username
      userid
      profilepictureurl
    }
  }
}

The above mutation request does not provide an input for userid field for the relationship field UserProfile_AutogenToNonAutogenRelationshipColumn. It only provides input for username. When executed this request, it will error out with the following error message.

Error Message:

{
  "errors": [
    {
      "message": "Neither source entity: User_AutogenToNonAutogenRelationshipColumn nor the target entity: UserProfile for the relationship: UserProfile_AutogenToNonAutogenRelationshipColumn at level: 1 provide sufficient data to perform a multiple-create (related insertion) on the entities.",
      "extensions": {
        "code": "BadRequest"
      }
    }
  ],
  "data": {
    "createUser_AutogenToNonAutogenRelationshipColumn": null
  }
}

from data-api-builder.

Require values to be provided even for columns which have defaults to determine referencing and referenced entities.

from data-api-builder.