Improves error logging in database queries (#53)

1 files changed, 13 insertions, 11 deletions

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
+}