Changeset c4dd17d for database/drizzle/queries/components.ts

Timestamp:

12/20/25 04:03:51 (7 months ago)

Author:

Tome <gjorgievtome@…>

Branches:

main

Children:

5ce5904

Parents:

37bcb87

Message:

update queries

File:

• database/drizzle/queries/components.ts (modified) (1 diff)

database/drizzle/queries/components.ts

@@ -1 +1 @@
 import type { Database } from "../db";
-import { componentsTable, suggestionsTable } from "../schema";
+import {buildsTable, componentsTable } from "../schema";
+import {and, desc, eq, ilike} from "drizzle-orm";
 
-export async function getComponentSuggestions(db: Database) {
+export async function getAllComponents(db: Database, limit?: number,  q?: string, componentType?: string) {
+    let queryConditions = [];
 
+    if (q) {
+        queryConditions.push(
+            ilike(componentsTable.name, `%${q}%`)
+        );
+    }
+
+    if(componentType && componentType.trim() !== 'all') {
+        queryConditions.push(
+            eq(componentsTable.type, componentType.trim().toLowerCase())
+        );
+    }
+
+    const componentsList = await db
+        .select({
+            id: componentsTable.id,
+            name: componentsTable.name,
+            brand: componentsTable.brand,
+            price: componentsTable.price,
+        })
+        .from(componentsTable)
+        .where(
+            queryConditions.length > 0 ?
+                and (
+                    ...queryConditions
+                )
+                : undefined
+        )
+        .orderBy(
+            desc(componentsTable.price)
+        )
+        .limit(limit || 100); // 100 placeholder
+
+    return componentsList;
 }
 
-export async function setComponentSuggestionStatus(db: Database, suggestionId: number, status: string, adminComment: string) {
+export async function getComponentDetails(db: Database, componentId: number) {
+    const [componentDetails] = await db
+        .select()
+        .from(componentsTable)
+        .where(
+            eq(componentsTable.id, componentId)
+        )
+        .limit(1);
 
+    return componentDetails ?? null;
 }
-
-export async function getAllComponents(db: Database, componentType?: string, q?: string, page?: number, pageSize?: number) {
-
-}