npx prisma migrate dev --create-only

Environment variables loaded from .env Prisma schema loaded from libs\api\core\data-access\src\prisma\schema.prisma Datasource "db" - SQL Server Drift detected: Your database schema is not in sync with your migration history. The following is a summary of the differences between the expected database schema given your migrations files, and the actual schema of the database. It should be understood as the set of changes to get from the expected schema to the actual schema. [+] Added tables • stage_Providers [*] Changed the 

ProviderSearch

 table [+] Added column 

geography

? We need to reset the database. Do you want to continue? All data will be lost. » (y/N) My table has geography String? @ignore on it, the geography type is not supported by prisma yet... so have to work around it somehow. How do I tell Prisma not to touch that column and move on? Also, this is a production database and people need to move data into it via different methods. Seen here, there is a stage table that was added. We need a way to ignore that table. Also, don't you think it is odd that your only option you present to the user when a "New" table is added is to DELETE all of the other data from the database? Even if this was development, and we have all of the Prisma seed methods in place, deletion all data doesn't seem like the first choice I would go with.

I went into the database and manually deleted the table and the column to see if I can move forward, but prisma gives same message. Is there a way to clear this cached schema?

Hello i have question i just want to try an string value to render as markdown but when i trying to record via prisma studio i got the

\n

as

\\n

? not sure if this is a good solution but on result i made it into

value.replace(/\\n/gi, '\n');

I didn't know where to put this, but thank you Prisma team 😄 😄 ! My swag arrived!

Hello 👋 I'm trying out this Prisma client thing and it's cool and all but I need to understand it better. I'm having trouble understanding how the automatically generated classes are generated. I've looked at the documentation but I cant find the bit where it is explained. Could someone point me to it please?

How can you filter by part of the query in an include? Like ` SELECT * FROM A INNER JOIN B on B.aId = A.id AND B.amount < A.price or SELECT * FROM A INNER JOIN B on a.aId = A.id WHERE B.amount < A.price Meaning your query’s filter parameter is part of the query itself. I couldn’t figure anyway to do it and it’s crazy… This is a super basic SQL capability

At my day job, we're working on a design doc to migrate our node.js backend monolith to a microservice architecture. Likely we'll convert the repo to an Nx monorepo. Each service would then live in

apps/**

, and have it's own

prisma/schema.prisma

file, since the services will be backend by their own postgres dbs. For example:

apps/
  service1/
    src/
      ...
    prisma/
      schema.prisma
  service2/
    src/
      ...
    prisma/
      schema.prisma
libs/
  ...

Has anyone done a setup like this using Nx + Prisma? Are there any gotchas that I'm not foreseeing?

Hiring Developers with experience in Javascript and React, React Native / VueJS Make account and adding more info inside the Settings like CV, Projects, ... On website => https://startups-hire.com I Will reach you later

Hey, I'm using prisma and graphql. I want to add many to many connection between two types and the connection between them should also have information that describes the connection (time of when the connection was added, who added the connection etc...) In prisma I did it with connection table, how do I add this connection table in correct way to graphql?

So, when i declare a data source in the Prisma schema and run

npx prisma migrate dev

for the first time, Prisma will create a database

mydb

on the given MySQL server for me, but is there any way I can programmatically create a new database using Prisma or is my only resport to run the command?

Hi all , good day Please does anyone have any guide or write-up on writing Tests using Mocha and Prisma ? Any help is greatly appreciated

Is it possible to combine to queries in prisma? I wanted one query to fetch the reviews and other query to check whether or not the user has upvoted that review. almost like creating a virtual field for the response, like a view so to speak review & votes are different tables with keys referencing each other A review can be structured like:

{
score: float;
reviewVotes: ReviewVote[]
}

And the review vote:

{
reviewId: string;
userId: string;
}

When querying the

reviews

I wanted to be able to return a "virtual field"

hasUserVoted

that would rely on checking whether or not a

reviewVote

with its

userId

exists. I was trying to figure out how to do this in an optimal way

In case anyone is wondering why their seed script(s) crash in Docker, Heroku, etc. https://github.com/prisma/docs/pull/2787.

🌟 We have reached 20,000+ stars on GitHub 🌟 We're deeply thankful to our community for all their support and super stoked about everything we have in store 💚 👉 Help us reach 30k! github.com/prisma/prisma

Hey, building docker for λ with Prisma support, so this needs the

rhel-openssl-1.0.x

binary target. We're building the docker images in the CI, and sometimes, installing deps and building works just fine, however, the binary is corrupt. It's only 3 MB in the faulty image 1. Does it happen to someone else? 2. Is there a checksum somewhere that I can validate with?

I’m working on micro service design and want to create a common logging and tracing middleware for prisma service call. I want to create nestjs library to share the logging and tracing middleware, but library doesn’t have the PrismaClient instance. Does anyone used Prisma to create library to dynamically inject configuration to create prismaservice instance and log query request and response data.

👋🏻 I know alot of people have been asking for a discord server, this is a community one here: https://discord.gg/Wa7fU7dqqS This is in the reply to a discussion - https://github.com/prisma/prisma/discussions/3920#discussioncomment-2083437

Hey 👋, does anyone know if there is a way with cascading deletes to change relations for userID to a default userID? or would i have to change to set to null? Just had an admin of an app leave a company and their account was deleted and it deleted all the posts she created that they would've like to stay like. Trying to figure out how to make sure posts aren't deleted when the publishing admin is removed from the DB. Thanks!

Can anyone point me to an article or something that shows how to use a @prisma/custom-client export directory?

Native type VarChar is not supported for sqlite connector. Does anyone know any native type that is supported by sqlite connector ??

I've been getting this error anytime I run

prisma generate

and I don't know what is wrong.

This is my generate function in my schema.prisma file

generator client { 
    provider = "prisma-client-js"
    output = "../src/generated/client"
    engineType = "binary"
    binaryTargets = "native"
}

What's new in Prisma (v3.9.0) Daniel and Niko from the Prisma team discuss the latest 3.6.0 release of Prisma and other news from the Prisma ecosystem. Tune in to learn about new releases, how to upgrade, planned features, and other interesting bits from the Prisma world. 📣 Release notes: https://github.com/prisma/prisma/releases

Serverless Berlin Meetup - an online edition Join us for the online edition of Serverless Berlin Meetup and take a deep dive into the world of all things serverless! Our speakers for this evening: Yan Cui (@theburningmonk) - "Lessons from running AppSync in production" Heit Lessa (@heitor_lessa) - on Lambda Powertools, Aleksandar Simovic (@simalexan) - TBA During this meetup, you'll have a chance to win ebooks from Manning Publications (https://www.manning.com/).

Hi everyone, good day. Please I am getting a

Foreign key constraint failed on the field: transactions_senderId_fkey (index)

When I try to insert. And I have no idea why. There shouldn't be on that field. Here's my model

model user {
  id         Int      @id @default(autoincrement())
  email      String   @unique
  password   String
  tokens     String[]
  created_at DateTime @default(now())
  updated_at DateTime @updatedAt()
  account    account?
}

model account {
  accNumber Int            @id @default(autoincrement())
  balance   Float
  user      user           @relation(fields: [userId], references: [id], onDelete: Cascade, onUpdate: Cascade)
  userId    Int            @unique
  Sender    transactions[] @relation("sender")
  Receiver  transactions[] @relation("receiver")

  created_at DateTime @default(now())
  updated_at DateTime @updatedAt()
}

model transactions {
  id         Int     @id @default(autoincrement())
  txRef      String  @unique
  amount     Float
  refundRef  String? @unique // this will reference a txRef column of a transaction whenn it is a refund

  from       account @relation("sender", fields: [senderId], references: [accNumber])
  senderId   Int

  to         account @relation("receiver", fields: [receiverId], references: [accNumber])
  receiverId Int

  created_at DateTime @default(now())
  updated_at DateTime @updatedAt()
}

Please can anyone see what's wrong with the model?

Hello awesome people! I have a quick question: The context:

prisma.users.findFirst({ where: { id: 1, isActive: true }, select: { name: true } });

The default where clause is with

AND

or

OR

? 🤷🏻‍♂️

and by default: https://www.prisma.io/docs/concepts/components/prisma-client/filtering-and-sorting#filtering

Great, I missed that small and. Thank you 🍻

Is there a method within prisma client instance to check if the connection to the db is successful and there are no interferences or it is not down?

Prisma support for CockroachDB is now in Preview Today we are excited to expand the range of Prisma compatible databases with Preview support for CockroachDB. Try it out and let us know what you think!