Prisma

i have a mutation in my api to create a element in a list of an object

-.txt

as parameters i want the id where the MrX should be added and the name of the mrx

so i was under the impression, that i had to load the gamesession and put it into mrx

the mrxCreateInput has a weird object inside “GameSessionCreateOneWithoutMrXInput”

do i get this from my game sesion or how?

or do i have something completely wrong because i think too restlike?

<@U94EY9LPN> I don't quite follow what you are trying to do. So the gameSession object already exists in the db and you want to connect it to MrX's user profile?

well, actually no, i want to create anew mrx and connect him to the gamesession

oh so you want to run 
```
ctx.db.mutation.updateUser({ 
where: { id: userId},
data: { gameSession: { connect: { id: gameSessionId}}})
```

ah ok, did not know about the connect, i will try this one out

<https://www.prismagraphql.com/docs/reference/prisma-api/mutations-ol0yuoz6go>

I'm not sure if my syntax is 100% correct

<@U94EY9LPN> in the docs they have the following 
```mutation {
  createUser(
    data: {
      email: "<mailto:zeus@example.com|zeus@example.com>"
      name: "Zeus"
      age: 42
      posts: {
        create: [{
          published: true
          title: "First blog post"
        }, {
          published: true
          title: "Second blog post"
        }]
        connect: [{
          id: "cjcdi63j80adw0146z7r59bn5"
        }, {
          id: "cjcdi63l80ady014658ud1u02"
        }]
      }
    }
  ) {
    id
    posts {
      id
    }
  }
}```

So you could do:
```
ctx.db.mutation.createUser(
data: { 
name: name
gameSession: { connect: { id: gameSessionId}
})```

createMrXInGameSession(parent, {gameSessionId, name}, context: Context, info) {

createMrXInGameSession(gameSessionId: ID!, name: String!): MrX

the resolver somehow does not “connect” to the schema

so when you call `createMrXInGameSession(gameSessionId: ID!, name: String!): MrX` it's not call your resolver function? `createMrXInGameSession(parent, {gameSessionId, name}, context: Context, info) {`

I would recommend starting with this tutorial <https://www.howtographql.com/graphql-js/1-getting-started/>

hmmm, nevermind, it worked but the autocomplete did not

Before starting, I want to know if it works good with a CDN i.e. cloudfront

I don't think you can do http caching with GraphQL. You could use Apollo Engine for cache (i've not used it)

What would you be putting on a CDN? I use Cloudflare for my site static assets, but all requests to the API bypass any caching.

:thinking_face: just asking, do i need the `@relation` when i want to make a relation between to models? I've problems with my schema at the moment and have seen a example from graph-cool (landing-page) where they dont use this `@relation` thing ...

This is a screenshot from the graph.cool website

Take a look: <https://www.prismagraphql.com/docs/reference/service-configuration/data-modelling-(sdl)-eiroozae8u#relations>

```This argument is only required if relations are ambiguous.```

Mhh.. just noticed i'am using graph-cool (also the CLI) and not prisma

is graph-cool depricated? (didn't read that anywhere)

I would like to ask you a question, if someone knows how to import my users, and the schema from another graphcool?

you could write a node app with apollo-client

There are a bunch of migration-y/import-y scripts in this github repo that I used as a starting point for this kind of task. Basically you have write a script to do this. <https://github.com/marktani/scripts>

i would like to overload some resolvers, so i can have multiple queries over the same endpoint. Like something like that:

i also thought about making the string nullable, but i do not want to make a “If (queryParameter)… as this might result in a lot of if/else stuff depending on the given arguments

does anybody have an idea how to solve this nicely?

like maybe i want to filter for age and other stuff later on

Hm.. does anyone know if prisma also gets a UI like graph-cool? (when i understand everything right it looks like graph-cool moves to prisma)

<@U973ZKEBU> I've that graphcool will keep existing

But why is prisma a copy of graph-cool? I mean.. everything but the console / login

The main difference is, that graphcool offers resolver functions that you can deploy alongside the database on the graphcool cloud. Prisma is only a wrapper around the database and exposes only CRUD operations through a graphql interface. It’s not supposed to be queried directly from the client but from another server that hostes your businesslogiv and implemtens your custom resolvers. You can implement such a server with graphql-yoga.

i mean the basics, like the CLI, the core seems to be completly different

What is the difference between to playground localhost:4466/xxxx/dev and the localhost:4000 yarn dev environment?

I'm not getting the login and signup mutations at the port 4466

Not sure how your setup. Are you using graphql-yoga or apollo-server?

Could be one is a direct connection to your Prisma instance/db and the other is your graphql-yoga server which sits in front of Prisma

okay it's what I thought. See my answer above

you won't see login or signup on the Prisma instance

So I actually need to use both, one for mutations with authentication the other for the other queires I define?

the graphql-yoga api is what you expose to your client  / users. You handle auth and permissions in there. The server then calls the Prisma instance for anything relating to the database. You will typically hide the Prisma endpoint from external parties for security purposes

when you query prisma it's like you're directly querying your db as admin

Does anybody know how i can use enums in prisma? I have a type like this