Merge pull request #2247 from msantosjader/fix/postgres-chat-constraint

DavidsonGomes · web-flow · commit cea1fa097911 · 2025-12-05T10:59:22.000-03:00
fix(prisma): add unique constraint to Chat model in Postgres
diff --git a/prisma/postgresql-migrations/20251122003044_add_chat_instance_remotejid_unique/migration.sql b/prisma/postgresql-migrations/20251122003044_add_chat_instance_remotejid_unique/migration.sql
@@ -0,0 +1,16 @@
+-- 1. Cleanup: Remove duplicate chats, keeping the most recently updated one
+DELETE FROM "Chat"
+WHERE id IN (
+  SELECT id FROM (
+    SELECT id,
+           ROW_NUMBER() OVER (
+             PARTITION BY "instanceId", "remoteJid"
+             ORDER BY "updatedAt" DESC
+           ) as row_num
+    FROM "Chat"
+  ) t
+  WHERE t.row_num > 1
+);
+
+-- 2. Create the unique index (Constraint)
+CREATE UNIQUE INDEX "Chat_instanceId_remoteJid_key" ON "Chat"("instanceId", "remoteJid");
diff --git a/prisma/postgresql-schema.prisma b/prisma/postgresql-schema.prisma
@@ -132,6 +132,7 @@ model Chat {
   instanceId     String
   unreadMessages Int       @default(0)
 
+  @@unique([instanceId, remoteJid])
   @@index([instanceId])
   @@index([remoteJid])
 }

Original file line number	Diff line number	Diff line change
`@@ -132,6 +132,7 @@ model Chat {`
`132`	`132`	`instanceId String`
`133`	`133`	`unreadMessages Int @default(0)`
`134`	`134`
	`135`	`+ @@unique([instanceId, remoteJid])`
`135`	`136`	`@@index([instanceId])`
`136`	`137`	`@@index([remoteJid])`
`137`	`138`	`}`