Prisma

Has anyone made a more resilient Graphcool data export script? I’ve tried the standard CLI data export tool, but Graphcool sometimes throws a 502 proxy timeout error (I think it’s behind Cloudflare or something like that?) and the script fails. Then retrying the script, it exports again from the very beginning, and then fails again randomly. I’ve tried forking the CLI tool, but it looks like the various dependencies are now out of date, so it’s quite a task to get it to compile my adapted version of the code.

Hi, someone can help with this problem I have about Nodejs and glob? <https://stackoverflow.com/questions/54280052/trying-to-get-asynchronous-functionality-with-glob> thanks :bug: 

hi, does anyone have any tips for importing data into prisma that have auto-incrementing IDs?

i'm using the ndf format, and i have auto-incrementing IDs on some of the obejects i'm trying to insert

it's telling me it needs an id property though on import

When I have an array of strings or enums on a type I don't get way to query them with 'where:'

Its working just for relations right now. There is RFC for lists you can check it out on github.

Oh okay thank you! I thought I was going crazy. Is there a way to query only the items that have a specific enum is the way to do that by creating a relationship

Looking for some example code using Express and Graphql-yoga. Any help would be appreciated

Hi, I found spectrum project really usefull as example

index.js

<https://github.com/withspectrum/spectrum/blob/487ce26e0c59efbdf6153e0a321aed0be7429840/api/index.js>


api/graphql.js

<https://github.com/withspectrum/spectrum/blob/487ce26e0c59efbdf6153e0a321aed0be7429840/api/routes/api/graphql.js>

it's an expressjs app and graphql it's under the `routes/api`

I have a prisma schema that I’m using with Python

I’m trying to import and use it with my JS express server as well

Should I be trying to import the /generated/index.js file? Or the .schema file?

hi, the generated/index.js contains the prisma client that it's everything you need for 'calling' your db, internally it uses the schema.js, as typeDefs that is a parameter to instantiate the Prisma client


```
// index.js

exports.Prisma = prisma_lib_1.makePrismaClientClass({
  typeDefs,
  models,
  endpoint: `${process.env["PRISMA_ENDPOINT"]}`,
  secret: `${process.env["PRISMA_MANAGEMENT_API_SECRET"]}`
});

exports.prisma = new exports.Prisma();

```

```
 // your file.js

const { prisma } = require('./generated/prisma-client')

```

here an example: <https://github.com/prisma/prisma-examples/blob/master/node/graphql/src/index.js>


if u want to generate a shema.graphql u can use the graphql-schema generator

```
  # prisma.yml

  - generator: graphql-schema
    output: ../src/data-access-layer/prisma-client/

```

is it possible to generate a .graphql file? Is one necessary?

Is it possible to use `import` with the `datamodel.prisma` when doing `prisma deploy`? Like: <https://oss.prisma.io/content/graphql-import/overview>

Or are there other methods to define the `datamodel` across multiple files, making it modular?

Hi, you can define your datamodel across multiple files:

```
# prisma.yml

datamodel:
  - database/types.prisma
  - database/enums.prisma
  - database/foo.prisma
  - database/bar.prisma
```

Ah yes!! I thought I had seen this before, but could not find it anywhere! Searching around for too long. THANK YOU! :grin:

<https://www.prisma.io/docs/prisma-cli-and-configuration/prisma-yml-5cy7/#exhaustive-example>

I was looking for the wording `modular` and `import` going through all the documentation. Thank you for linking it. :thumbsup:

how come I can't do where OR / NOT in mongodb

How can i use a value of an enum as a default value of a model field?

there is a @default anotation <@U83B7Q58T>

<@UFHUZ7A4U> thank you. i know it but i don't know how to access an enum's value

```
enum PAYMENT {
  MONTHY
  ANNUAL
}
```

how can i access `MONTHY` or `ANNUAL` in the model

```
type Order {
  payment: PAYMENT @default(value: ???)
}
```

Hey, u can reffer to it as a String

```
# datamodel.prisma

enum PAYMENT {
  MONTHY
  ANNUAL
}

type Order {
  payment: PAYMENT @default(value: "MONTHY")
}

```

<https://www.prisma.io/docs/datamodel-and-migrations/datamodel-MYSQL-knul/#default-value>

anyone can answer my question? :disappointed:

sorry i didn't understand your question `how come I can't do where OR / NOT in mongodb`

image.png

Screen Shot 2019-01-21 at 09.56.41.png

I'm using postgress and prisma ` 1.24.0 `

but i think the db is not releated with this

Could you not use where `IN` for the same effect?

I can but I want to query two fields for my condition

OR [
  {"field1_contains": "something"},
  {"field2_contains": "something"}
]

Ah, thank makes it tricky without the `OR`, strange it's not an option. :thinking_face:

Hi all.

Getting this weird error, probably common, using Prisma version 1.23.2 "Unexpected Name, found }"

It's not this: <https://github.com/prisma/prisma/issues/3452> because I'm ONLY using scalar types.

Any help?

```type Item {
  id: ID! @unique
  title: String!
  description: String!
  image: String
  largeImage: String
  price: Int!
  dummy: Boolean
}
```

<@UCZMXEP3J>: Do you have any idea for this one? ^

Hi <@U8YV63GF4>,

I am unable to reproduce this in the latest version.

Can you please try the latest version of prisma :slightly_smiling_face:

I think that you get this error when you run `prisma generate`. This happens because of this <https://github.com/prisma/prisma/issues/3184>

You can get around this by bypassing the JS schema generation by running the following command `prisma generate --endpoint` - note that this would work only after Prisma service is live i.e. after a `prisma deploy`

cc <@UCZMXEP3J>: Can you reproduce this issue with `prisma generate`? If yes, can you please create an issue for this using the data model provided by <@U8YV63GF4> :pray:

Interesting, <@U8YV63GF4> Can you please share your prisma cli version via `prisma --version` command?

Most likely this issue is resolved in the latest CLI version, can you please try an update via `npm install -g prisma`?

<@UCZMXEP3J>: What version of Prisma CLI are you on?

prisma/1.24.0 (darwin-x64) node-v11.5.0 , I think <@U8YV63GF4> is using 1.23

Note, I'm getting the error when running `graphql playground`

Sorry I should have specified

<@UCZMXEP3J> Is `graphql playground` working for you?

Hi,i will look into this a bit later but can you try prisma playground instead of that one

Do you have a .graphqlconfig file, if yes please share it

Also you can go-to localhost:4466 for now

```projects:
  app:
    schemaPath: 'src/schema.graphql'
    extensions:
      endpoints:
        default: '<http://localhost:4444>'
  prisma:
    schemaPath: 'src/generated/prisma.graphql'```
    extensions:
      prisma: prisma.yml

Try deleting this and run prisma playground

This works but I'm not interacting with my GraphQL Yoga server

You can access the yoga playground in it's url for now,I will check your config a bit later to enable yoga as well

Fixed! I was missing a query in my `schema.graphql` file - apparently not having one causes an error

i tottaly feel <@UFHUZ7A4U>, i'm not sure what's going on, are they are increadibly busy with development or fame hit them in the head, but it would be really nice if you guys could answer basic question like 'how the hell one can use Connections with graphqlgen???' don't get me wrong, i like what you are doing, heck i love it, but slow down, and make shit stable and answer the qustions, here and on github. one of the BEST and most IMPORTRANT aspects of graph databases ARE connections and they are not implemented with graphqlgen. how do you think we can implement infinite scroll, pagination???