When prisma generates the client, what is it using to do so exactly? The

databasemodel.prisma

? The

schema.graphql

? All of the resolver function definitions? I ask b/c I have a bug when starting my service and I think it’s in the generated client, so I’m trying to comment things out until I get it working again.

/node_modules/graphql/language/parser.js:1433
  throw (0, _error.syntaxError)(lexer.source, token.start, "Expected ".concat(kind, ", found ").concat((0, _lexer.getTokenDesc)(token)));
  ^
GraphQLError: Syntax Error: Expected Name, found }
    at syntaxError (/Users/coreysnyder/Development/Web/GraphQL/drone-part-picker/server/node_modules/graphql/error/syntaxError.js:24:10)

Is there any reason why the following would return Error: Cannot return null for non-nullable field Event.id ?

const res = async ( root, args, ctx ) => await ctx.prisma.updateUser({
        where: {id: promoter.id},
        data: { 
          promotions: { 
            create: [{ ...event }]
          }
        }
      })
return res;

Is it possible to query on a relationship like so:

/* Given This Schema */
type Shape{
  id: ID! @id
  square: Square @relation(name: "SquareShapeRelation", link: TABLE, onDelete: CASCADE)
  price: Float
}
type Square{
  id: ID! @id
  article: Article @relation(name: "SquareShapeRelation")
  area: Float
}

/* I'd like to query 
    - the first 5 Shapes
    - starting with the 6th
    - Ordered by price desc
    where {
      the Square has an area >= 5     
    }
*/

// I was thinking it'd be:
await context.prisma.shapes({
    orderBy: price_DESC,
    where: {
      square: {
        area_gte: 5
      }
    },
    skip: 5,
    first: 5,
  })
  
// It's important that the first & skip happen AFTER the filtering on the child relation has been applied.

Is there a way to pass in PRISMA_CONFIG into docker without compose? I have to use a GUI to access docker due to security restrictions and I can only pass in individual environment variables and the multiline string from the yml compose file doesn't work in a single line input for an environment variable. I've looked at this repo (https://github.com/akoenig/prisma-docker-compose/blob/master/.prisma.env) which uses some environment variables that do not work. After trying to use these env variables with my postgres database I get this error from Prisma:

Unable to load Prisma config: java.lang.RuntimeException: No valid Prisma config could be loaded.

any ideas?

Why does create not automatically create the id for Event? Does anyone have an idea why the following would return Error: Cannot return null for non-nullable field Event.id ?

const res = async ( root, args, ctx ) => await ctx.prisma.updateUser({
        where: {id: promoter.id},
        data: { 
          promotions: { 
            create: [{ ...event }]
          }
        }
      })
return res;

General question: If I am hosting my own Prisma server do I need to set it up as ‘Prisma server/Workspace/Service name/Stage’? If so I don’t get how to add own hosted server into Prisma cloud. Seems a bit chicken and egg to me!

How to fix this ambiguous relationship in prisma2 datamodel?

Non Prisma specific. What is the proper way to hide certain queries/mutators based on role? Anyone have information on that? I like the crud operations but i don't think I want to expose most of them. I'd probably prefer a "register" "endpoint" /mutator. I may want a mutator that runs two crud operations I don't want the user to see

the following schema is creating user id as foreign key in

Address

table instead of creating address id as foreign key in

User

table

model User {
  id       String  @default(cuid()) @id
  email    String  @unique
  password String
  name     String
  gender   Gender  @default(value: null)
  address  Address?
}

model Address {
  id           String   @default(cuid()) @id
  addressLine1 String
  addressLine2 String?
  createdAt    DateTime @default(now())
  updatedAt    DateTime @updatedAt
}

not sure what is wrong here. Can someone please help? TIA

Hey, I want to share an article I wrote about seeding databases with Prisma:

Does anyone know how to use

set

with no items? So it works if you have two things and then take one away. But you can’t just pass it an empty array (or null, I tried), it just ignores it, and doesn’t disconnect anything. If you can’t make

set

disconnect everything, it kinda feels broken to even use it most of the time…

query updateUser {
    updateUser (
        where: {
            id: "asdfasdlfkjasdlfkj"
        }
        data: {
            posts: {
                set: [] // < ---- What can you pass here to disconnect all relations?
            }
        }
    ) {
        id
    }
}

does anyone know if it is possible to have multiple DBs for one Prisma API endpoint? I am trying to think of how I can use Prisma for a SaaS app .. I like to have a database for each Company that is on our system.

How can I call a resolver from an other resolver?

just call it and pass the same arguments through

I've tried that @adam. When I do I get an error along the lines "cannot get property 'prisma' of undefined"

can anyone tell me what is the keyword for using a filter as below

query {
  ads(filter: {
    url_has: "google"
  }) {
    response
  }
}

i basically want to filter out ads whose url has google in it @Adam Jacob? URL is a string here

Hey I'm strugging with a certain concepts in prisma since I cant find any documentation on it. I would like to create something to this effect

so I want to add some listing object (args.listing) into and existing array (shoppingCart.items), given a user id

the schema or shopping cart is something like this

how do I properly connect "where: { user: { find user by id } }"

My abover code is giving me error and I don't know how to fix it

so i need something like "where: { id: { --find shopping cart id from user id-- } } "

hi! we've been working on rewriting our PHP API to Prisma 1. we're ready to launch in about 6 weeks. big question is: should we launch with Prisma 1 or start migrating to Prisma 2 now? my concern is that Prisma 2 is not ready (for production) in 6 weeks

I don't know what your concerns are but chances are using Prisma 1 for now is the safest way to go. A ruth of thumb is to wait for new releases to mature or at least undergo an acceptable amount of testing @Morten Bo Rønsholdt

Is it possible to define relationships that reference other fields than primary key in prisma schema?

How can I change the default help text that appears in GraphQL Playground? "Write your query or mutation here"

What is the best way to call a resolver inside an other? I want to keep my resolvers DRY. I've tried :

const variable = async ( root, args, ctx ) => await [resolver]({...args}).then( res => res )

and

const variable = await [resolver]({...args})

neither works

I want to use id as a number, not a string. Is there a way?