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