I have a question about the Data Browser on app.pr...
# orm-help
b
I have a question about the Data Browser on app.prisma. I see I that all of my data is viewable in there. I’m sure at one point I was able to bring up a window that let me update/delete nodes but it doesn’t seem to be working anymore? Is there a trick? Was I hallucinating? Have I found a bug?
k
Hey Brant! You should still be able to update and delete nodes when you double-click on the node and edit it through the modal.
b
Ahhh I think I see the issue
1. I didn’t realize you had to double click and must have done that by accident
Copy code
GraphcoolSchema.ts:173 Uncaught (in promise) Error: {
  "locations": [
    {
      "line": 2,
      "column": 7
    }
  ],
  "path": [
    "deletePost"
  ],
  "code": 3042,
  "message": "The change you are trying to make would violate the required relation '_PostToVote' between Post and Vote",
  "requestId": "us1:api:cjiaj88cpnuuv0b732i0whzs1"
}
I guess I haven’t properly set up deletion
k
I agree that the data browser experience in Prisma Cloud could be bit better. We're actually working on that right now, by the way. 🙌
b
Awesome. Somewhat related, 2 things I’m stuck on right now are: deletion when there are relations, and migrations when changing the data models.
a
Are you referring to the inability to query nested data on a deletion? If so, there's an issue for that here: https://github.com/prismagraphql/prisma/issues/2347
b
Mostly talking about the error I got above where I am unable to delete a node because it requires other relations to be removed. That’s from the data browser, I’m not sure if I’d need to do something to handle those cases.
n
@brant you might want to set up your relation to be cascading delete