Changeset e729b88 for database

Timestamp:

12/24/25 23:10:35 (7 months ago)

Author:

Tome <gjorgievtome@…>

Branches:

main

Children:

3fca46c

Parents:

67dfe57

Message:

remove deprecated query and telefunc

Location:

database/drizzle

Files:

• db.ts (modified) (1 diff)
• queries/builds.ts (modified) (1 diff)

database/drizzle/db.ts

@@ -7 +7 @@
 })
 
+pool.on("connect", (client) => {
+    client.query('SET search_path TO pcforge, public');
+});
+
 export const db = drizzle(pool, { schema });
 

database/drizzle/queries/builds.ts

@@ -100 +100 @@
             name: buildsTable.name,
             created_at: buildsTable.createdAt,
-            total_price: buildsTable.totalPrice
+            total_price: buildsTable.totalPrice,
+            avgRating: sql<number>`AVG(${ratingBuildsTable.value}::float)`
         })
         .from(buildsTable)