如何在一个事务中进行相关的插入和更新?

Question

想象两个表:

People {
id: uuid
home_id: uuid
}
Homes {
id: uuid
}

<<p>表strong>人已经有人居住了。我要做的是插入一个新的Homeand updatehome_idPeople中的字段同时在桌子上。这可能吗?

Answer 1

我最终通过创建HomeOwnership来解决这个问题表{ person_id: uuid, home_id: uuid }并从People中删除home_id表格然后在表之间建立外键关系。然后突变看起来像这样:

mutation MyMutation($person_id: uuid = "some_id") {
insert_home_one(object: {home_membership: {data: {person_id: $person_id}}}) {
id
home_membership{
person{
name
}
}
}
}