33 / Users can sign up and log in with WebAuthn (#39)

* Installs @vercel/postgres

* Installs @simplewebauthn/server

* Installs @simplewebauthn/browser

* Git-ignores all files starting with .env

* Reorganises folders in API

* Defines User type

* Defines Subscription type

* Defines Authenticator type

* Sets up table definition file

* Can get user from database

* Can add user to database

* Can get user's current challenge

* Can set user's current challenge

* Can get user's authenticators from database

* Can get authenticator by ID from database

* Can add user authenticator to database

* Can update authenticator in database

* Defines Relying Party information

* Can generate registration options

* Can verify registration response

* Defines registration API endpoint

* Defines user API endpoint

* Reorganises API functions on frontend

* Can access authentication API functions on frontend

* Can generate authentication options

* Can verify authentication response

* Documents the registration flow

* Fix dev_csso

* Form styling

* WIP adds sign up page

1 files changed, 29 insertions, 0 deletions

diff --git a/api/db/_getUser.ts b/api/db/_getUser.ts
new file mode 100644
index 0000000..30a879e
--- /dev/null
+++ b/api/db/_getUser.ts
@@ -0,0 +1,29 @@
+import { QueryResultRow, sql } from '@vercel/postgres';
+import User from '../types/User';
+import { USERS } from './_tables';
+
+export default async function getUser(
+  userId: string
+): Promise<Pick<User, 'id' | 'displayName'> | null> {
+  try {
+    const result = await sql.query(`
+      SELECT
+        ${USERS.fields.displayName}
+      FROM ${USERS.name}
+      WHERE ${USERS.fields.id} = '${userId}';
+    `);
+
+    if (!result.rows.length) {
+      return null;
+    }
+
+    const row: QueryResultRow = result.rows.at(0);
+
+    return {
+      id: userId,
+      displayName: row[USERS.fields.displayName],
+    };
+  } catch (err) {
+    throw new Error(`Failed to get user with ID ${userId} from database.`, err);
+  }
+}
\ No newline at end of file