avoid float in prisma template param

stackernews · Jul 14, 2024 · dd4806c · dd4806c
1 parent e045c46
commit dd4806c
Showing 1 changed file with 4 additions and 3 deletions.
diff --git a/api/paidAction/itemCreate.js b/api/paidAction/itemCreate.js
@@ -200,15 +200,16 @@ export async function onPaid ({ invoice, id }, context) {
     // denormalize ncomments, lastCommentAt, and "weightedComments" for ancestors, and insert into reply table
     await tx.$executeRaw`
       WITH comment AS (
-        SELECT *
+        SELECT "Item".*, users.trust
         FROM "Item"
-        WHERE id = ${item.id}::INTEGER
+        JOIN users ON "Item"."userId" = users.id
+        WHERE "Item".id = ${item.id}::INTEGER
       ), ancestors AS (
         UPDATE "Item"
         SET ncomments = "Item".ncomments + 1,
           "lastCommentAt" = now(),
           "weightedComments" = "Item"."weightedComments" +
-            CASE WHEN comment."userId" = "Item"."userId" THEN 0 ELSE ${item.user.trust}::FLOAT END
+            CASE WHEN comment."userId" = "Item"."userId" THEN 0 ELSE comment.trust END
         FROM comment
         WHERE "Item".path @> comment.path AND "Item".id <> comment.id
         RETURNING "Item".*