Prisma

Many internal server errors and custom resolver timeouts here also (graphcool)

Thanks <@U4CABATSP> <@U42NTKX2T> <@U5VAFSX8U> I reached out to your support requests.

Hi <@U0RQY0KK5> thanks looking into this. my endpoint is still not functioning - I still receive internal errors

This is a dumb question, but how do I submit a GraphQL mutation that calls the same mutation twice?

Hey <@UA79982DT> :wave: Please ask questions about code in the Forum: <https://www.graph.cool/forum/c/questions> :slightly_smiling_face:

There are certain question for which the realtime Slack is not the correct venue and you have to signup on a forum to ask a specific kind of question. Sorry, but that is a rubbish idea.

Yes, I prefer to discuss code and usage questions in the Forum, because those tend to explode in complexity :slightly_smiling_face:
It's more a recommendation than a hard rule though, feel free to discuss any questions here.

FWIW, Prisma is amazing, and I don't mean to express any displeasure with it. :slightly_smiling_face:

```
ERROR: Field 'createChannel' conflict because they have differing arguments. Use different aliases on the fields to fetch both if this was intentional. (line 2, column 5):
    createChannel(data: {
    ^
 (line 5, column 5):
    createChannel(data: {
    ^
```

is there a guide on how to combine graphql-yoga/prisma with algolia?

not yet, but check this: <https://github.com/graphcool/prisma/issues/2105>

Hi guys!! How to add many nested conection when mutation in prisma?

Sin_titulo.js

Only add the last conection id in RoleProfile

Hey Gerardo :wave: Please ask questions about code in the Forum: <https://www.graph.cool/forum/c/questions> :slightly_smiling_face:

any idea how to add unique contraint between relations?

<https://github.com/graphcool/prisma/issues/1237#issue-272896339>

You can add unique indices on the DB level yourself - apart from that, there is no way at the moment.

How do I access my project after starting a local cluster with `prisma local start` ?

What do you mean with accessing your project?

A cluster hosts many services. If you never deployed a service to your cluster, there is no service yet.

So, you can do
```
prisma init test
cd test
prisma deploy # choose local
prisma playground
```

Yeah, I thought that was being done automatically. Need moar coffee!

service/stage will be optional in an upcoming version: <https://github.com/graphcool/prisma/issues/2217>

then there will be a "default" service for a cluster

So, I just tested with `prisma init` and chose the TypeScript advanced with auth and when I try running the playground after a deploy I get `Your token is invalid. It might have expired or you might be using a token from a different project.`

I am guessing this has to do with auth? :stuck_out_tongue:

Yes. you can protect your Prisma API with a _secret_ (entered in `prisma.yml`)

To generate a token that is _signed_ with this secret, run `prisma token`

Then set the authorization header to access your Prisma API:
```
{
  "Authorization": "Bearer &lt;token&gt;"
}
```

Read more here: <https://www.prismagraphql.com/docs/reference/prisma-api/concepts-utee3eiquo#authentication>

I just added a Authorization header with a Bearer token

Seems to work fine :slightly_smiling_face:

Hi! I'm hosting my MySQL db in Azure and am looking at connecting it to Prisma so I can deploy the docker container running the prisma service to azure but I can't find a solid answer in the docs. Anyone got any tips?

not quite getting this - resolvers (custom &amp; standard eg yoga), they are contained on same server as database right? Or else we'd be seeing lots of roundtrips for data manipulation??

I deleted the generated files, and after that `prisma deploy` will fail. Shouldn't it just recreate them?

You should not delete generated files <@UA6BP0QCQ>

Generated files are generated. They should be regenerated if they do not exist. It's a bug imo.

I agree! could you create a bug report here: <https://github.com/graphcool/prisma/>?

<https://github.com/graphcool/prisma/issues/2228>

Hello all! I've been having an issue getting graphql-request to work in a browser project, it's failing because of require, any idea on some work around or fix? <https://github.com/graphcool/graphql-request/issues/74>

createdAt is read-only according to the docs: <https://www.prisma.io/docs/reference/service-configuration/data-modelling-(sdl)-eiroozae8u#system-fields>

Hi, is Prisma production ready? how does it compare to Typeorm in terms of features? I'm trying to decide which to choose for an app I'm building so any information is helpful, thanks!

<@U0RQY0KK5> I'd be great to get your thoughts on this!

Yes, Prisma is production ready.

The resulting API is GraphQL, different than Typeorm.

is there a way to get an aggregate like SUM yet of a number field? Im thinking about how to best implement a rating system, where each rating can be between 1 and 5

Maybe you can be more specific on the backend you're implementing this on. But have a look at this, it might help...
<https://stackoverflow.com/questions/2324446/how-to-build-a-basic-and-simple-5-star-rating-system>

oh im just using prisma cloud and graphql-yoga

Hej. We just migrated to the newest Apollo-Client and have problems with redux integration support. (apolloClient.reducer() is not a function). Do you know how to get around it? 
Thanks

<@U2WSND93P> didn't they remove redux from the v2+ implementation? I think they might have their own state management

<https://github.com/apollographql/apollo-client/issues/2593>

Yeah exactly they removed and it gives me a headache as out app is heavly dependent on Redux....this is why I am looking for some work around if possible or we will just go back to 1.0 version

Have you searched for an apollo-link-redux (or similar package)?  I'd be surprised if it isn't out there.

Why does upsert require update and create? I am confuse on this.

Trying to figure out how to create a item if it doesn't exist or update it if it does...

<https://github.com/graphcool/prisma/issues/2194>

What is the purpose of the update and create?

either you want to update or you want to create, hence two objects

for create you need at least all required fields, for update you need at least any field. those are different requirements.

So there is no way create if it doesn't exist, update if it does. It requires both update and create. I plan to run a lambda script every two hours to fetch data and update / create.

well, that is EXACTLY the way to create if it doesn't exist, update if it does.

You just need to specify both all the time.

Oh sorry, I didn't understand your question and messed it up.  That's why we have Nilan :slightly_smiling_face:

So in my case I have boat loads of fields. (real estate). So I would need to copy it for create and upsert?

Yes. But both are objects, so it's still two GraphQL/(presumably) JavaScript variables.

If this somehow doesn't fit your use case, you can always split it up in an `exists` query + `create` OR `update` mutation by hand.

So where means find whatever your looking for, if it doesn't exist create, if it does it updates and create doesn't get executed.

`where` accepts any unique field. And yep, it's as you say.

I may just skip the mutation part in general, waiting on the monogdb connector cause i already seed my database directly through mongo. I have a lambda function that runs every two hours that I update directly through mongo. I don't plan to use a SQL database when I push this live. So I was just experimenting the mutation side because i done forgot the SQL. lol

So is nested mutations not working correctly with upsert?

That's discussed in the issue <@U6Z07HY14> shared at the very top of this thread.

So i could run a check to see if something exist, then use create if it doesn't, use update if it does...

Has anyone gotten Prisma 1.6.1 off NPM yet?  I'm still getting 1.6.0

it's `1.6.2` already - `npm install -g prisma`

... turns out my iTerm client was grumpy.  Bad iTerm

I have a question on the forums that I could really use some help with. It is probably a trivial problem, I'm just super new. <https://www.graph.cool/forum/t/prism-seed-data/3180>

<@UA79982DT> you have two createChannels...