diff options
Diffstat (limited to 'api/db/_getUser.ts')
| -rw-r--r-- | api/db/_getUser.ts | 18 |
1 files changed, 10 insertions, 8 deletions
diff --git a/api/db/_getUser.ts b/api/db/_getUser.ts index 30a879e..1188927 100644 --- a/api/db/_getUser.ts +++ b/api/db/_getUser.ts @@ -5,13 +5,15 @@ import { USERS } from './_tables'; export default async function getUser( userId: string ): Promise<Pick<User, 'id' | 'displayName'> | null> { + const query = ` + SELECT + ${USERS.fields.displayName} + FROM ${USERS.name} + WHERE ${USERS.fields.id} = '${userId}'; + `; + try { - const result = await sql.query(` - SELECT - ${USERS.fields.displayName} - FROM ${USERS.name} - WHERE ${USERS.fields.id} = '${userId}'; - `); + const result = await sql.query(query); if (!result.rows.length) { return null; @@ -24,6 +26,6 @@ export default async function getUser( displayName: row[USERS.fields.displayName], }; } catch (err) { - throw new Error(`Failed to get user with ID ${userId} from database.`, err); + throw new Error(`Failed to get user with ID ${userId} from database. Query was ${query.replace(/\s+/g, ' ')}. ${err}`); } -}
\ No newline at end of file +} |
