1 files changed, 20 insertions, 0 deletions
diff --git a/api/db/_addUser.ts b/api/db/_addUser.ts
new file mode 100644
index 0000000..ef72447
--- /dev/null
+++ b/api/db/_addUser.ts
@@ -0,0 +1,20 @@
+import type User from '../types/User';
+
+import { sql } from '@vercel/postgres';
+import { USERS } from './_tables';
+
+export default async function addUser(user: User) {
+  try {
+    await sql.query(`
+      INSERT INTO ${USERS.name} (
+        ${USERS.fields.id},
+        ${USERS.fields.displayName}
+      ) VALUES (
+        '${user.id}',
+        '${user.displayName}'
+      );
+    `);
+  } catch (err) {
+    throw new Error(`Failed to insert user into database: ${JSON.stringify(user)}.`, err);
+  }
+}
+\ No newline at end of file