How to do relationship updates? Prisma fails when doing connection to relationship.
One entity has relationship to another entity (table relationship). Per prisma docs I should be able to update it like this from .update method:
data: {
status: status,
city: {
connect: {
id: cityId
}
}
So city is the relationship, cityId is a column in user as a FK. I tried other variations such as setting cityId: cityId directly. It won't work. Auto generated and compiled types are a mess and I think that is the reason.
data: {
status: status,
city: {
connect: {
id: cityId
}
}
So city is the relationship, cityId is a column in user as a FK. I tried other variations such as setting cityId: cityId directly. It won't work. Auto generated and compiled types are a mess and I think that is the reason.
