如何在一个变异中插入一个对象和相关的数组对象

Question

我有两个表reels和reel_variations，卷轴可以有许多reel_variations和reel_variations属于一个卷轴。我读过Hasura的文档，但还不知道如何在一个突变中插入一个卷轴和几个卷轴变体。

mutation insertReelsAndVariations($objects: [reels_insert_input!]! = {}) {
  insert_reels(objects: $objects) {
    affected_rows
    returning {
      description
      id
      name
      variations {
        ball_bearings
        braid_capacity
        created_at
        deleted_at
        gear_ratio
        max_drag
        line_capacity
        id
        model_number
        recovery
        reel_id
        retrieve
      }
    }
  }
}

变量

{
  "objects": {
    "name": "nice reel",
    "description": "wicked nice reel",
    "variations": {
      "data": {
        "ball_bearings": "djjdfkjdkjfdjkfjkd",
        "braid_capacity": "dkfjdkfjkdf",
        "gear_ratio": "20:1",
        "max_drag": "20lbs",
        "line_capacity": "400yrds",
        "model_number": "jfdkjfkjdkfjkdjfjdf",
        "recovery": "30 per turn"
      }
    }
  }
}

错误

{
  "errors": [
    {
      "extensions": {
        "path": "$.selectionSet.insert_reels.args.objects[0].variations.data",
        "code": "constraint-violation"
      },
      "message": "Not-NULL violation. null value in column \"reel_id\" violates not-null constraint"
    }
  ]
}

Answer 1

这是因为没有将reel_id列设置为引用reels表的外键列。所以你可以简单地：

使reel_id列成为指向reels表的id列的外键！