Run this project (existing repo)

Prerequisites

1) Install dependencies

yarn install

2) Configure environment

DATABASE_URL="mysql://root:[email protected]:3306/mydb"

mysql -u root -proot -e "CREATE DATABASE IF NOT EXISTS mydb;"

\connect root@localhost:3306;
USE mydb;
SHOW TABLES;
SHOW DATABASES;
SELECT * FROM user;

3) Apply migrations and generate Prisma Client

yarn prisma migrate dev --name init

4) Start the server

yarn dev    # uses nodemon
# or
yarn start  # plain node

5) Prisma quick commands (Yarn)

yarn prisma:migrate:dev      # Apply migrations in dev mode
yarn prisma:migrate:deploy   # Apply migrations in production
yarn prisma:generate         # Generate Prisma client
yarn prisma:studio           # Open Prisma Studio
yarn prisma:db:push          # Push schema without migrations