Changeset 82aa6ae for database

Timestamp:

12/27/25 02:16:17 (7 months ago)

Author:

Tome <gjorgievtome@…>

Branches:

main

Children:

9854393

Parents:

dd5067a

Message:

fix getFavoriteBuildings

File:

• database/drizzle/queries/builds.ts (modified) (2 diffs)

database/drizzle/queries/builds.ts

@@ -77 +77 @@
             name: buildsTable.name,
             created_at: buildsTable.createdAt,
-            total_price: buildsTable.totalPrice
+            total_price: buildsTable.totalPrice,
+            avgRating: sql<number>`COALESCE(AVG(${ratingBuildsTable.value}::float),0)`
         })
         .from(buildsTable)
@@ -84 +85 @@
             eq(buildsTable.id, favoriteBuildsTable.buildId)
         )
+        .leftJoin(
+            ratingBuildsTable,
+            eq(buildsTable.id, ratingBuildsTable.buildId)
+        )
         .where(
             eq(favoriteBuildsTable.userId, userId)
+        )
+        .groupBy(
+            buildsTable.id,
+            buildsTable.userId,
+            buildsTable.name,
+            buildsTable.createdAt,
+            buildsTable.totalPrice
         )
         .orderBy(