summaryrefslogtreecommitdiff
path: root/api/db/_addUser.ts
diff options
context:
space:
mode:
Diffstat (limited to 'api/db/_addUser.ts')
-rw-r--r--api/db/_addUser.ts24
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
+}