diff options
Diffstat (limited to 'api/db/_addUser.ts')
| -rw-r--r-- | api/db/_addUser.ts | 24 |
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 +} |
