Same thing for github the for

access_token

and

token_type

nvmd I figured it out. I adjusted my schema

I have an API that I'm deploying via the serverless framework. The problem I'm running into is that my RDS instance cannot be accessed outside of the VPC that cloud formation sets up by default. Unless I create a bastion host within the same security group I can't connect from my development machine or CI pipeline to run the initial (or any) migration. It seems like a huge hassle. Is there a better way to execute a Prisma migration from within an a lambda to avoid all of the additional tooling? If so I could just invoke a cloud function to execute any migrations to production.

Hello guys can you help me?

Anyone yt?

Hello Why prisma cannot create record and say you did nit set the required field even due I have been set it? and Why it says I have to fill a

relation field

?

model Country {
  id                   Int     @id @default(autoincrement())
  // Country Code Alphabet 3
  cca3                 String  @unique() @db.VarChar(3)
 
  states               State[]
  capital              City?   @relation(name: "country_capital")
 
  @@map("countries")
}

model State {
  id                   Int     @id @default(autoincrement())
  // State Code Alphabet 3
  sca3                 String  @db.VarChar(3)
  countryId            Int

  belongsToCountry     Country @relation(fields: [countryId], references: [id], map: "belongs_to_country")

  @@index([sca3])
  @@map("states")
}

Any thought on this?

Hi Guys! I am a complete newbie. I am following the great course /Fullstack App With TypeScript, PostgreSQL, Next.js, Prisma & GraphQL: Data Modeling from: Mahmoud. I am waiting with great expectations 😉 for the new and probably the latest part. I have the code working. I still need some help with returning to the code that also visitors can see all the links created. Now you have to login. Is there anyone who could help me with this?

Hello guys 👋 Does anyone know how to pass request information from my API to a Prisma middleware? I want to obtain the user id of the client that is executing a query so that I can use it as a filter for the

owner

column 🤔

Hello there, need some help on the search using previewFeature filterJson when a property doesn't exist ,,, it would ignore the document or would throw an error?

Will we see something similar to the

type

support for MongoDB in SQL databases (mapping to

Json

, but giving us typescript typings and safety)?

Is there a way in prisma schema to make sure that

DateTime

is ordered correctly when creating new rows?

Question Regarding Optimistic concurrency control https://www.prisma.io/docs/guides/performance-and-optimization/prisma-client-transactions-guide#when-to-use-optimistic-concurrency-control Is there a reason not to use a column

updatedAt  DateTime @updatedAt

instead of the in the docs mentioned

version

column? The code would then look like this:

const availableSeat = await client.seat.findFirst({
  where: {
    Movie: {
      name: movieName,
    },
    claimedBy: null,
  },
})

if (!availableSeat) {
  throw new Error(`Oh no! ${movieName} is all booked.`)
}

const seats = await client.seat.updateMany({
  data: {
    claimedBy: userEmail,
  },
  where: {
    id: availableSeat.id,
    updatedAt: availableSeat.updatedAt,
  },
})

I have a very strange issue: Prisma is saying my auth details are wrong, but the same URL works fine in Sequel Ace, and I can also connect command line (

mysql -u etc

) from my laptop, so there is no firewall or other issue.. There are no strange chars in the URL that would need encoding. Any pointers? Even at highest debug level, Prisma doesn’t show the password it sends (which I understand from security standpoint, but still, the only thing I can think of is it sending a different password than I tell it to…)?

Does anyone know of a way that we can use one database URL for reads and one URL for writes so that writes are spread across the cluster as opposed to all going to the write endpoint generated by the RDS cluster?

Hi! 👋 I’m quite new to Prisma and I’ve recently using it in a project and it has worked quite well for me. I now have to implement some logic that involves writing to the database and making POST/PUT/DELETE calls to an external API. I want to implement the Unit of Work pattern to execute all these “data writing” operations in a way that, if the external API call fails then the transaction should be rolled back. To that end, I decided to use the preview feature “interactive transactions”. The problem I face now, is that it’s quite challenging writing unit tests for that because the logic to be unit tested is within the body of an

async

function passed to the

prisma.$transaction()

function. I’m using Jest to mock the Prisma client, but in this case I would have to provide a mock for the

prisma.$transaction()

function and in doing so, I would be replacing the very logic I’m trying to unit test. I hope I explained the case well enough. I’d really appreciate some guidance from any that has run into this scenario. Thanks in advance! P/S: Is the Prisma Team planning to implement manual transaction control (start, commit, rollback)?

Hey everyone! 👋 I struggle with the decision what type of many-to-many relation I should use (explicit or implicit). I know what it does and also when to use it but is it hard to migrate from an implicit to an explicit later if I need extra data for the relation some day? I'm always a fan of being explicit but the explicit many-to-many relation adds overhead, especially for queries although I don't need to be explicit because I don't need any extra information (yet). I would love to hear your feedback on this and how often you really need to be explicit with the relation!

Maybe unrelated to prisma itself, but it’s related to database and I’m using prisma. And someone might be able to help. I’m setting up for CI/CD for our frontend project(using github actions). And I need to run the tests(cypress) on each PR to block merge if they fail. How do you guys create an instance of the backend and database for that? • Do you create a new Backend/Database instance from scrach for every PR? • Do you use an existing

dev

backend/database but reset all the data? • Do you use an existing

dev

backend/database but don’t reset all the data and have the tests work around other data on the dev environment?

Bit of a noob here when it comes to the backend. I am looking at using GitHub Actions for continuous integration. My question is do you guys also push the migration files in prisma/migrations or no? Will these pushed migration files be used in any case when running

npx prisma migrate deploy

?

Hey, frontend guy here. Is there a service where I could plug my prisma schema and it will auto generate i.e. express REST api for my models?

Property not known: "output". is this expected? was working before

Is there a way to find the names of primary key colums on a table?

Is there a good Docker Image setup for Prisma that's maintained by the team or those close? I'm using MySql and SqlServer and I'm struggling with combining Apollo Server and Prisma in one Image. Maybe Vanilla and Vanilla is better then the Swirl. Thinking maybe I should make GraphQL one image and Prisma it's own.

I have a users table and an orders table. Is there a way that I can set user.name as a default value for the field “createdBy” in the orders model ?

Hello everyone, We’re currently recreating a js/express microservice backend in ts/nestjs. Early in january I testd prisma vs typeorm and was impressed. Though I only tested it in a small monolithic environment. Now we got multiple microservices build with the nestjs microservice architecture and a gateway, glueing the services to a rest api. the problem i now see is that all the types are generated in the services. if i want to type the functions in the gateway or use swagger then i have to rewrite every type. is there an easy way to export generated types to put them into a npm module? was this use case considered?

Is anyone writing migration scripts in Typescript with the Prisma client? I am pretty tired of struggling with SQL

If you have any good thoughts on this I’d love to hear it

how to structure and run the migration scripts

something like this: https://github.com/prisma/prisma/issues/4688

Hello Everyone, We have been building on top of Apollo and Prisma1 and are finally migrating to Prisma2, but are running into a lot of schema incompatibilities. Since Prisma1 is both an ORM as a GraphQL API we were used to building upon the Prisma1 generated GraphQL schema (opencrud). Over the years our prisma model has grown and is now used trough Apollo by two Apps and React Admin (ra-data-opencrud). With this setup as our staring point we started to look for a way to generate a compatible GraphQL schema for Prisma2. Prisma2 has the concept of generators with a bunch already written by the community: https://www.prisma.io/docs/concepts/components/prisma-schema/generators We started out by looking at the graphql-schema-generator, but this schema is much simpler and nowhere close to the Prisma1 generated GraphQL schema. TypeGraphQL Prisma comes closer, but there are still a lot of incompatibilities. Fixing these incompatibilities might be weeks or maybe months of work. Building our own generator would be a huge project as well. This all made me wonder if I'm missing something? It shouldn't be this hard to migrate, should it? Not entirely sure what to do at this point: • Is there a generator out there that is compatible that I haven't found? • Or should we just implement compatible resolvers ourselves in apollo? • Or pick for instance TypeGraphQL and rewrite the data layer of our App? • What is the risk of staying on Prisma1?

const users = await prisma.users.groupBy({

by: ['email'],

_sum: {

likes:true

}

})