Setup database (#20)

[rayhanadev]

Why

• 20

What changed

• Added drizzle-orm and drizzle-kit
• Defined a schema in ./src/db/schema.ts
• Added migration script pnpm db:migrate
• Added migration generation script pnpm db:gen-migration
• Added message template helpers in ./src/lib/helpers/templates.ts
• Added user helpers in ./src/lib/helpers/users.ts

Test plan

• Able to generate migrations using the migration generation script
• Able to run migrations using the migration script
• The below code works (no testing library yet womp womp)

import { addUser, getFollowupTimestamps } from "./src/libs/helpers/users";
import { getTemplate, getAllTemplates, addTemplate, editTemplate, deleteTemplate } from "./src/libs/helpers/templates";

const TORIEL_TEST_PAYLOAD = {
  userId: "00000",
  joinReason: "Test",
}

const TEMPLATE = {
  name: "Test",
  content: "foo",
}

async function main() {
  const user = await addUser(TORIEL_TEST_PAYLOAD);
  console.log(user);

  const timestamps = await getFollowupTimestamps(user.externalId);
  console.log(timestamps);

  const template = await addTemplate(TEMPLATE.name, TEMPLATE.content);
  console.log(template);

  const templates = await getAllTemplates();
  console.log(templates);

  await editTemplate(TEMPLATE.name, "bar");
  console.log(await getTemplate(TEMPLATE.name));

  await deleteTemplate(TEMPLATE.name);
  console.log(await getAllTemplates());
}

main();