Changeset c4dd17d for database/drizzle/queries/users.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/users.ts (modified) (4 diffs)

database/drizzle/queries/users.ts

@@ -1 +1 @@
 import type { Database } from "../db";
-import {adminsTable, usersTable } from "../schema";
-import { eq } from "drizzle-orm";
+import {adminsTable, suggestionsTable, usersTable} from "../schema";
+import {desc, eq} from "drizzle-orm";
 
 export async function createUser(db: Database, username: string, email: string, passwordHash: string) {
@@ -14 +14 @@
 
 export async function getUserProfile(db: Database, userId: number) {
-    const user = await db
+    const [user] = await db
         .select({
             username: usersTable.username,
@@ -25 +25 @@
         .limit(1);
 
-    return user[0] ?? null;
+    return user ?? null;
 }
 
@@ -39 +39 @@
     return admin.length > 0;
 }
+
+export async function getComponentSuggestions(db: Database) {
+    const suggestionsList = await db
+        .select()
+        .from(suggestionsTable)
+        .where(
+            eq(suggestionsTable.status, 'pending')
+        )
+        .orderBy(
+            desc(suggestionsTable.id)
+        )
+
+    return suggestionsList;
+}
+
+export async function setComponentSuggestionStatus(db: Database, suggestionId: number, adminId: number, status: string, adminComment: string) {
+    const result = await db
+        .update(suggestionsTable)
+        .set({
+            adminId: adminId,
+            status: status,
+            adminComment: adminComment
+        })
+        .where(
+            eq(suggestionsTable.id, suggestionId)
+        );
+
+    return result.rowCount;
+}
+
+export async function addComponentSuggestion(db: Database, userId: number, link: string, description: string, componentType: string) {
+    const [newSuggestion] = await db
+        .insert(suggestionsTable)
+        .values({
+            userId: userId,
+            link: link,
+            description: description,
+            componentType: componentType
+        })
+        .returning({ id: suggestionsTable.id });
+
+    return newSuggestion.id ?? null;
+}