From 23bdb5946a955a7da9ce22ff92c8735ccb3630cf Mon Sep 17 00:00:00 2001 From: shatfield4 Date: Tue, 16 Jan 2024 09:32:51 -0800 Subject: [PATCH 1/2] add check to skip empty messages --- server/models/welcomeMessages.js | 1 + 1 file changed, 1 insertion(+) diff --git a/server/models/welcomeMessages.js b/server/models/welcomeMessages.js index 43e2d3f964e..534af6471dd 100644 --- a/server/models/welcomeMessages.js +++ b/server/models/welcomeMessages.js @@ -32,6 +32,7 @@ const WelcomeMessages = { // Create new messages for (const [index, message] of messages.entries()) { + if (!message.response) continue; await prisma.welcome_messages.create({ data: { user: message.user, From 29eb6d99415b5f60de4dd5cf6cc308281b95a948 Mon Sep 17 00:00:00 2001 From: shatfield4 Date: Tue, 16 Jan 2024 17:01:31 -0800 Subject: [PATCH 2/2] add comment explaining prisma + sqlite not supporting createMany() --- server/models/welcomeMessages.js | 2 ++ 1 file changed, 2 insertions(+) diff --git a/server/models/welcomeMessages.js b/server/models/welcomeMessages.js index 534af6471dd..88393f36cdb 100644 --- a/server/models/welcomeMessages.js +++ b/server/models/welcomeMessages.js @@ -31,6 +31,8 @@ const WelcomeMessages = { await prisma.welcome_messages.deleteMany({}); // Delete all existing messages // Create new messages + // We create each message individually because prisma + // with sqlite does not support createMany() for (const [index, message] of messages.entries()) { if (!message.response) continue; await prisma.welcome_messages.create({