From 2f7541ae836a99d9f189845547010e470e0efa8c Mon Sep 17 00:00:00 2001
From: Joe Carstairs <65492573+Sycamost@users.noreply.github.com>
Date: Sun, 24 Dec 2023 10:49:40 +0000
Subject: Improves error logging in database queries (#53)

---
 api/db/_addUser.ts | 24 +++++++++++++-----------
 1 file changed, 13 insertions(+), 11 deletions(-)

(limited to 'api/db/_addUser.ts')

diff --git a/api/db/_addUser.ts b/api/db/_addUser.ts
index ef72447..776391a 100644
--- a/api/db/_addUser.ts
+++ b/api/db/_addUser.ts
@@ -4,17 +4,19 @@ import { sql } from '@vercel/postgres';
 import { USERS } from './_tables';
 
 export default async function addUser(user: User) {
+  const query = `
+    INSERT INTO ${USERS.name} (
+      ${USERS.fields.id},
+      ${USERS.fields.displayName}
+    ) VALUES (
+      '${user.id}',
+      '${user.displayName}'
+    );
+  `;
+
   try {
-    await sql.query(`
-      INSERT INTO ${USERS.name} (
-        ${USERS.fields.id},
-        ${USERS.fields.displayName}
-      ) VALUES (
-        '${user.id}',
-        '${user.displayName}'
-      );
-    `);
+    await sql.query(query);
   } catch (err) {
-    throw new Error(`Failed to insert user into database: ${JSON.stringify(user)}.`, err);
+    throw new Error(`Failed to insert user into database: ${JSON.stringify(user)}. Query was ${query.replace(/\s+/g, ' ')}. ${err}`);
   }
-}
\ No newline at end of file
+}
-- 
cgit v1.2.3