How to update Prisma @unique
Unanswered
Scarlet Ibis posted this in #help-forum
Scarlet IbisOP
Hello,
So I started a new NextJS project.
I did this:
Then I added to slug @unique
But when I tried to do
It gave me an error : Invalid
How do I apply the new @unique? the npx prisma db push did not work
So I started a new NextJS project.
I did this:
model Post {
id String @id @default(cuid())
title String
slug String
content String
updatedAt DateTime @updatedAt
createdAt DateTime @default(now())
}Then I added to slug @unique
But when I tried to do
const post = await prisma.post.findUnique({
where: {
slug
}
});It gave me an error : Invalid
prisma.user.findUnique() invocation:How do I apply the new @unique? the npx prisma db push did not work
4 Replies
Transvaal lion
Whenever you modify your prisma schema, you'll have to:
- first, migrate your db via
- once done, regenerate the prisma client via
- now you can continue your work.
- first, migrate your db via
npx prisma migrate --name <migration_name>;- once done, regenerate the prisma client via
npm prisma generate;- now you can continue your work.
@Transvaal lion Whenever you modify your prisma schema, you'll have to:
- first, migrate your db via `npx prisma migrate --name <migration_name>`;
- once done, regenerate the prisma client via `npm prisma generate`;
- now you can continue your work.
Scarlet IbisOP
Hey!
Can I just do "npx prisma migrate" ? without the name
Can I just do "npx prisma migrate" ? without the name
Also, I found the issue, I had to do again npm run dev.
The prisma migrate would also fix that issue?
The prisma migrate would also fix that issue?
@Scarlet Ibis Hello,
So I started a new NextJS project.
I did this:
ts
model Post {
id String @id @default(cuid())
title String
slug String
content String
updatedAt DateTime @updatedAt
createdAt DateTime @default(now())
}
Then I added to slug @unique
But when I tried to do
ts
const post = await prisma.post.findUnique({
where: {
slug
}
});
It gave me an error : Invalid `prisma.user.findUnique()` invocation:
How do I apply the new @unique? the npx prisma db push did not work
if you are using mongo db then use npx prisma generate