feat(devtool): local development environment with docker

[davidlhw]

I realise this PR might be a little huge, let me know if it'll be better if I were to do a separate one to address cleanups & deps version bumps instead

Changes

core

• mock local supabase development environment with docker
• mock data at prisma/data/*.json
• db seeding logic at prisma/seed.ts
• updated db schema to be less ambiguous and support relevant data required for reviews
• update .env.example with working local dev db url

optional

• deps version bump
  • breaking changes to trpc (low impact due to lack of features using trpc)
  • minor changes to /account/auth/login & /account/auth/verify pages, wrap <Suspense> around components using useSearchParam hook
• cleanup unused .vscode/settings.json fields
• add .vscode/extensions.json recommendations

Testing

1. ensure that docker compose is installed

   docker compose version

   or

   docker-compose --version

2. run docker compose to spin up db container

   docker compose up -d

3. make a copy of .env.example and rename it to .env
4. run db migration + seeding command

   npx prisma migrate dev
   npx prisma db seed

   or

   yarn db:reset

5. confirm with a db client that database is populated as expected
6. run yarn dev
7. navigate to / after logging in as test@test.com user
8. confirm that data is present
9. changing any values from public.university should reflect on / upon refresh

[vercel[bot]]

The latest updates on your projects. Learn more about Vercel for Git ↗︎

Name	Status	Preview	Comments	Updated (UTC)
afterclass-io-v2	✅ Ready (Inspect)	Visit Preview	💬 Add feedback	Apr 1, 2024 4:11am

[davidlhw]

merging ahead of time to close the other PRs

verified that all are working on 3 separate machines, (1 on windows and 2 on mac)

further improvements will be tackled as separate tasks