Database schema

• https://prisma.io/

Development

cd backend
export SCHEMA="--schema=schema.prisma"

Pull changes from DB

yarn prisma db pull $SCHEMA

Create migration

• https://www.prisma.io/docs/guides/database/developing-with-prisma-migrate/enable-native-database-functions

yarn prisma migrate dev $SCHEMA <name-of-migration>
yarn prisma migrate dev $SCHEMA <name-of-migration> --create-only

Reset database

⚠️ Destructive action

yarn prisma migrate reset $SCHEMA

Deploy database

yarn prisma migrate deploy $SCHEMA

Generate PrismaClient

yarn prisma generate $SCHEMA
yarn prisma generate $SCHEMA --watch

Run Prisma Studio

yarn prisma studio $SCHEMA

Then visit http://localhost:5555/

Running unit tests

Run nx test models to execute the unit tests via Jest.