Changeset 83fb5e2 for database/drizzle/queries/users.ts

Timestamp:

12/25/25 01:49:51 (7 months ago)

Author:

Tome <gjorgievtome@…>

Branches:

main

Children:

e7f1bfa

Parents:

d4842f4

Message:

fix returns and add checks

File:

• database/drizzle/queries/users.ts (modified) (7 diffs)

database/drizzle/queries/users.ts

@@ -4 +4 @@
 
 export async function createUser(db: Database, username: string, email: string, passwordHash: string) {
-    await db
+    const [newUser] = await db
         .insert(usersTable)
         .values({
@@ -10 +10 @@
             email: email,
             passwordHash: passwordHash,
+        })
+        .returning({
+            id: usersTable.id,
         });
+
+    return newUser?.id ?? null;
 }
 
@@ -29 +34 @@
 
 export async function isAdmin(db: Database, userId: number) {
-    const admin = await db
+    const [admin] = await db
         .selectDistinct()
         .from(adminsTable)
@@ -37 +42 @@
         .limit(1);
 
-    return admin.length ?? null;
+    return !!admin;
 }
 
@@ -55 +60 @@
 
 export async function setComponentSuggestionStatus(db: Database, suggestionId: number, adminId: number, status: string, adminComment: string) {
-    const result = await db
+    const [result] = await db
         .update(suggestionsTable)
         .set({
@@ -64 +69 @@
         .where(
             eq(suggestionsTable.id, suggestionId)
-        );
+        )
+        .returning({
+            id: suggestionsTable.id
+        });
 
-    return result.rowCount ?? null;
+    return result?.id ?? null;
 }
 
@@ -78 +86 @@
             componentType: componentType
         })
-        .returning({ id: suggestionsTable.id });
+        .returning({
+            id: suggestionsTable.id
+        });
 
-    return newSuggestion.id ?? null;
+    return newSuggestion?.id ?? null;
 }