Has anyone else ran into issues trying to dockerize their prisma2 app? when trying to migrate I get errors with not being able to find the db, and yes I did update the localhost to the name of the postgres service. Any help would be amaizing! thanks

Our Developer’s Advocate, Ryan Chenkie, will give a talk about setting up Prisma for This Dot Lab tomorrow (September 23rd)! Tune in at 21:30 CEST here.

i tried to CRUD like this

await prisma.A.create({ data }).then((e) => {
	await prisma.B.delete({ where: { seq: e.seq } });
});

but delete API didn’t work even create was successed. can i get help with it?

anyone been able to apply migrations to Digital ocean managed database? Getting "sql_require_primary_key"

Seems like at least the last few versions of

@prisma/engine-core

depend on a version of the Undici module, but specifically reference a commit on github instead of a version packed in NPM. Our corp environment means we can't actually install prisma in our CI/CD pipelines because of this, as all dependencies must be on NPM. Seems the referenced commit is now in a mainline release of the undici module. Can this be changed to reference a versioned number?

Is there any reason a simple

prisma.[entity].findMany()

command would cause an error,

invalid invocation

? that basically all what the error says

Hey there im using prisma with nexus someone know how to handle upload file ?

Is there an easy way to change my database with prisma, after I’ve created it? Right now, If I want to add a new field like “age” to my User, I have to access my postgres instance, run SQL commands to change the table, and then introspect the database with prisma CLI.

Just a heads up: we just pushed a new article to Prisma's Data Guide: Using joins to combine data from different tables in PostgreSQL

You can jump into the live coding session with Xiaoru Li (Leo, for short), Developer’s Success Advocate at Prisma, this Sunday at 6pm CEST! The session is called Building with Next.js and Prisma: Passwordless Authentication with next-auth. !

Does anyone know, is it possible to call a function inside a file? Something like:

ts-node -func seed() ./scripts.ts

,

ts-node -func clear() ./scripts.ts

package.json ... { "scripts": { "run_me": prisma deploy --env-file src/env_files/.env.<ENV_ARGUMENT_FROM_CLI> } } i want to run ... yarn run_me local so the scripts runs - prisma deploy --env-file src/env_files/.env.local

I’m trying to use case-insensitive filter in Prisma but after enabling the preview feature in the schema, I’m getting an error when I attempt to add mode: ‘insensitive’ to any queries. Tried to regenerate the client but that didn’t help. “Unknown arg ‘mode’”

how do I get Prisma to generate date for a createdAt field automatically? I had it before but stopped working

Hi guys. Great work everyone at the prisma community. Love working with it! I am a frontend developer who want to learn data-modeling, with relational dbs. Now i am working on a learning project and this is my use case for a table tennis schema. We are playing table tennis on work and have different Leagues ( = A league is just a team of people playing each other). The question is: 1. How can I save one Game with two players and their score? 2. Feedback is welcome on my schema! This is the schema:

model User {
  id            String   @id
  email         String   @unique
  createdAt     DateTime @default(now())
  updatedAt     DateTime @updatedAt

  profile Profile?
}

model Profile {
  id            String           @id @default(cuid())
  user          User?            @relation(fields: [userId], references: [id])
  userId        String?
  playedGames   PlayerInGame[]
  joinedLeagues PlayerInLeague[]
}

model League {
  id      String           @id @default(cuid())
  name    String           @unique
  games   Game[]
  players PlayerInLeague[]
}

model PlayerInLeague {
  id        String  @id @default(cuid())
  league    League  @relation(fields: [leagueId], references: [id])
  player    Profile @relation(fields: [profileId], references: [id])
  points    Int
  leagueId  String
  profileId String
}

model Game {
  id        Int      @id @default(autoincrement())
  createdAt DateTime @default(now())
  homePoints Int
  awayPoints Int
  league           League       @relation(fields: [leagueId], references: [id])
  leagueId         String

  // HERE I NEED TO KEEP TRACK OF PLAYERS and their statistics. Who won, how many point etc. 
}

model PlayerInGame {
  id        String  @id @default(cuid())
  game      Game    @relation(fields: [gameId], references: [id])
  player    Profile @relation(fields: [profileId], references: [id])
  gameId    Int
  profileId String  @unique
}

Hi All, We are trying to do a fresh deploy of prisma1 in one of our new cloud region. ( our application is using Prisma1 thats why we have to stick with it). While trying to run

prisma deploy --force --no-seed

we are getting an error the complains about

cluster$default

ERROR: Project not found: 'cluster$default'
24-Sep-2020 22:11:59	
24-Sep-2020 22:11:59	{
24-Sep-2020 22:11:59	  "errors": [
24-Sep-2020 22:11:59	    {
24-Sep-2020 22:11:59	      "message": "Project not found: 'cluster$default'",
24-Sep-2020 22:11:59	      "code": 3016,
24-Sep-2020 22:11:59	      "requestId": "local:ckfhqavwf0vkh0734eamd1bd0"
24-Sep-2020 22:11:59	    }
24-Sep-2020 22:11:59	  ],
24-Sep-2020 22:11:59	  "status": 200
24-Sep-2020 22:11:59	}

would be helpful if some guidance is provided on this. We are on Prisma 1.30.5

Hi All, Now i am see the following error while trying to do a Prisma deploy using prisma 1.30.5 cli

ERROR: Variable "$input" got invalid value {"workspaceSlug":null,"clusterName":"default","serviceName":"cxic-umbrella","stageName":"prod"}; Expected non-nullable type String! not to be null at value.workspaceSlug.

{
  "errors": [
    {
      "message": "Variable \"$input\" got invalid value {\"workspaceSlug\":null,\"clusterName\":\"default\",\"serviceName\":\"cxic-umbrella\",\"stageName\":\"prod\"}; Expected non-nullable type String! not to be null at value.workspaceSlug.",
      "locations": [
        {
          "line": 2,
          "column": 17
        }
      ],
      "code": 222
    }
  ],
  "status": 400
}

not sure if i am missing anything in the prisma setup

Hi, I have a question about nested creates. Lets say I have 3 objects defined like that:

model A {
 id Int @id
 b B[]
}
model B {
 id Int @id
 c C[]
}
model C {
 id Int @id
 text String
}

And I have an object

"A": {"id":10 { { "text": "Some text here"}}}

can I do

prisma.a.update({wgere: id: 10}, data: {input_object})

?

Does it make sense at all?

Basically the question is how do I do nested inserts/updates when the nesting level is more than 1 deep?

Hi All, trying to figure out if postgres12 is supported in primsa1

Great article at https://www.prisma.io/dataguide/database-tools/top-nodejs-orms-query-builders-and-database-libraries-in-2020. One feature I’m interested in though is not included - streaming support. I know Sequelize doesn’t support streaming, for example. It would add to the value of the article to indicate which ORMs, if any, support streaming in Node 😄

whenever I change something in Prisma schema, I need to delete migration folder, delete volumes of docker. and re rerun the migrate command. This makes the development process very slow. How to get rid of this

Are there plans to include condition checks for updating and creating? Atm I always have to use Update many to unsure a record is only updated when it has a certain state

👋 Join us at week’s events that are featuring or organised by Prisma: • September 29, 6:00PM CEST - GraphQL Berlin/Munich Meetup - livestream hosted by Prisma and commercetools ; • September 30, 6:30PM CEST - Wroclaw TypeScript Meetup - where Daniel Norman, Prisma’s Developer’s Advocate, will give a talk: Rapid and type-safe Node.js development with Prisma - more info and a link to tune in here; • October 1, 5PM CEST - What’s new in Prisma (v2.8.0) -  Looking forward to having you there! 🤗

Hey i'm reading this old prisma post about wrapping rest microservices in a graphql gateway: https://www.prisma.io/blog/how-to-wrap-a-rest-api-with-graphql-8bf3fb17547d I'm really interested in this last paragraph in particular:

Wrapping REST APIs with GraphQL is probably one of the most exciting applications of GraphQL — and still in its infancy. The process explained in this article was entirely manual, the real interesting part is the idea of automating the different steps. Stay tuned for more content on that topic!

If you’d like to explore this area yourself, you can already check out the graphql-binding-openapi package which allows to automatically generate GraphQL APIs (in the form of a GraphQL binding) based on a Swagger / Open API specification.

Is there any advancements in auto-generated graphql gateways since, or and community agreement on the best practices etc? Any help super appreciated 🙂

Has anyone had issues with ordering when using

findOne

with relations fields? Our model specifically does not have a field which we can use to enforce order (via

orderBy

), we just want the data read in the same order we wrote it the DB. Do we need to add an explicit order field to guarantee this order (this is what we are currently thinking of doing)? Thought we'd ask here in case anyone might have encountered this before, any help would be much appreciated, thanks! 😊