README.md

Database

I used Prisma to manage & access the database. As such you will need a database for this project, either locally or hosted in the cloud.

To make this process easier, I put a docker-compose.yml file to deploy a MySQL server locally with a new database named bakery:

💡 Commands are all issued form a shell at the root level of the monorepo

cd interlogica-coding-assignment
docker-compose up -d

Once deployed you will need to copy the .env.example file to .env in order for Prisma to have a DATABASE_URL environment variable to access.

cp .env.example .env

If you added a custom database name, or use a cloud based database, you will need to update the DATABASE_URL in your .env accordingly.

Once deployed & up & running, you will need to create & deploy migrations to your database to add the necessary tables. This can be done using Prisma Migrate:

npx prisma migrate dev

If you need to push any existing migrations to the database, you can use either the Prisma db push or the Prisma migrate deploy command(s):

pnpm db:push

# OR

pnpm db:migrate:deploy

There is slight difference between the two commands & Prisma offers a breakdown on which command is best to use.

An optional additional step is to seed some initial or fake data to your database using Prisma's seeding functionality.

To do this update check the seed script located in packages/database/src/seed.ts & add or update any users you wish to seed to the database.

Once edited run the following command to run tell Prisma to run the seed script defined in the Prisma configuration:

pnpm db:seed

For further more information on migrations, seeding & more, I recommend reading through the Prisma Documentation.