hi guys been trying to wrap my head around integra...
# orm-helps
swangy
02/22/2019, 3:37 PMhi guys been trying to wrap my head around integrating prisma with our graphql setup
h
Harshit
02/22/2019, 3:46 PMHi @swangy
How can I help you with this 🙂
s
swangy
02/22/2019, 4:00 PMso hoping prisma can help - if i understand it right, with a graphql schema i can point prisma at our current schema and get a backend recreated?
h
Harshit
02/22/2019, 4:00 PM@swangy
Please checkout prisma nexus, it reduces boilerplate code and you can directly expose mutations as well
https://github.com/prisma/nexus-prisma
s
swangy
02/22/2019, 4:02 PMone issue i ran into already is
Copy code
DailyNote
✖ The relation field `author` must specify a `@relation` directive: `@relation(name: "MyRelation")`
✖ The relation field `reviewer` must specify a `@relation` directive: `@relation(name: "MyRelation")`swangy
02/22/2019, 4:02 PMthe schema is
Copy code
author: User @relation(name: "author")
reviewer: User User @relation(name: "reviewer")swangy
02/22/2019, 4:03 PM…. what’s goin on?
h
Harshit
02/22/2019, 4:03 PMwhich connector you are using
Harshit
02/22/2019, 4:05 PMtry
Copy code
author: User @relation(name: "Author")
reviewer: User @relation(name: "Reviewer")s
swangy
02/22/2019, 4:07 PMthe prisma demo connector
h
Harshit
02/22/2019, 4:07 PMoh, ok
Try this, if it doesn't work, paste the whole datamodel here
s
swangy
02/22/2019, 4:08 PMhmm..
Copy code
Deploying service `prisma-hello` to stage `dev` to server `prisma-us1` !
ERROR: Syntax error while parsing GraphQL query. Invalid input ""Author")\n reviewer: User User @", expected IgnoredNoComment or Value (line 111, column 32):
author: User @relation(name: "Author")
^
{
"data": {
"deploy": null
},
"errors": [
{
"locations": [
{
"line": 2,
"column": 9
}
],
"path": [
"deploy"
],
"code": 3017,
"message": "Syntax error while parsing GraphQL query. Invalid input \"\"Author\")\\n reviewer: User User @\", expected IgnoredNoComment or Value (line 111, column 32):\n author: User @relation(name: \"Author\")\n ^",
"requestId": "us1:cjsg91wge5b7t0b30deomp84o"
}
],
"status": 200
}h
Harshit
02/22/2019, 4:09 PMyou have User twice
Harshit
02/22/2019, 4:09 PMpaste the datamodel file here
Harshit
02/22/2019, 4:09 PMI will send you the corrected one
s
swangy
02/22/2019, 4:10 PMright, there are two types of users, author and reviewer, both of User type…
h
Harshit
02/22/2019, 4:10 PMyou have done
Copy code
reviewer: User User @relation(name: "reviewer")Harshit
02/22/2019, 4:10 PMsee User twice
s
swangy
02/22/2019, 4:11 PMwoops
swangy
02/22/2019, 4:11 PM Copy code
Errors:
DailyNote
✖ The relation field `reviewer` has the type `User`. But the other directive for this relation appeared on the type `Evaluation`
✖ The relation field `author` has the type `User`. But the other directive for this relation appeared on the type `Evaluation`
Evaluation
✖ The relation field `reviewer` has the type `User`. But the other directive for this relation appeared on the type `DailyNote`
✖ The relation field `author` has the type `User`. But the other directive for this relation appeared on the type `DailyNote`h
Harshit
02/22/2019, 4:12 PMyou are defining them twice I think
Harshit
02/22/2019, 4:12 PMPlease share your datamodel.prisma file with me so that I can help you
Harshit
02/22/2019, 4:17 PMHi
Harshit
02/22/2019, 4:17 PMI fixed your problem
Harshit
02/22/2019, 4:17 PMthe problem was that you were using same relation name at two places
Harshit
02/22/2019, 4:17 PMthey are must be unique
Harshit
02/22/2019, 4:18 PMlet me paste the modified datamodel
Harshit
02/22/2019, 4:18 PMs
swangy
02/22/2019, 4:19 PMoh huh
swangy
02/22/2019, 4:19 PMthanks!
swangy
02/22/2019, 4:21 PMso now instead of the prisma demo server, how do i get it to connect to local mysql? 🙂
h
Harshit
02/22/2019, 4:22 PMhere are the instructions: https://www.prisma.io/docs/get-started/01-setting-up-prisma-new-database-JAVASCRIPT-a002/
s
swangy
02/22/2019, 4:29 PMTY!