api/db/_addUser.ts


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
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);
  }
}