Changeset 9854393 for database/drizzle/queries/builds.ts

Timestamp:

12/27/25 02:27:36 (7 months ago)

Author:

Tome <gjorgievtome@…>

Branches:

main

Children:

ad311c3

Parents:

82aa6ae

Message:

implement components query and filtering

File:

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

database/drizzle/queries/builds.ts

@@ -108 +108 @@
 export async function getApprovedBuilds(db: Database, limit?: number, sort?: string, q?: string) {
     let queryConditions = [eq(buildsTable.isApproved, true)];
-    let sortConditions = [];
+    let sortCondition:any;
 
     if (q) {
@@ -118 +118 @@
     switch(sort) {
         case 'price_asc':
-            sortConditions.push(
-                asc(buildsTable.totalPrice)
-            );
+            sortCondition = asc(buildsTable.totalPrice)
             break;
         case 'price_desc':
-            sortConditions.push(
-                desc(buildsTable.totalPrice)
-            );
+            sortCondition = desc(buildsTable.totalPrice)
             break;
         case 'rating_desc':
-            sortConditions.push(
-                desc(sql<number>`COALESCE(AVG(${ratingBuildsTable.value}::float),0)`)
-            );
+            sortCondition = desc(sql<number>`COALESCE(AVG(${ratingBuildsTable.value}::float),0)`)
             break;
         case 'oldest':
-            sortConditions.push(
-                asc(buildsTable.createdAt)
-            );
+            sortCondition = asc(buildsTable.createdAt)
             break;
         case 'newest':
-            sortConditions.push(
-                desc(buildsTable.createdAt)
-            );
+            sortCondition = desc(buildsTable.createdAt)
             break;
         default:
-            sortConditions.push(
-                desc(buildsTable.createdAt)
-            );
+            sortCondition = desc(buildsTable.createdAt)
             break;
         }
@@ -176 +164 @@
         )
         .orderBy(
-            ...sortConditions
+            sortCondition
         )
         .limit(limit || 100); // 100 placeholder