Changeset dd5067a for database/drizzle

Timestamp:

12/26/25 22:43:20 (7 months ago)

Author:

Tome <gjorgievtome@…>

Branches:

main

Children:

82aa6ae

Parents:

898cf68

Message:

Add sorting

File:

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

database/drizzle/queries/builds.ts

@@ -23 +23 @@
         .where(
             eq(buildsTable.isApproved, false)
+        )
+        .orderBy(
+            desc(buildsTable.createdAt)
         );
 
@@ -40 +43 @@
         .where(
             eq(buildsTable.userId, userId)
+        )
+        .orderBy(
+            desc(buildsTable.createdAt)
         );
 
@@ -80 +86 @@
         .where(
             eq(favoriteBuildsTable.userId, userId)
+        )
+        .orderBy(
+            desc(sql<number>`COALESCE(AVG(${ratingBuildsTable.value}::float),0)`)
         );