nest new .

node_modules

nest g resource [Endpoint Name]
# REST APIを選択
# yを入力

npm install prisma -D
npx prisma init

version: '3'

services:
  db:
    image: mysql:5.7 # プロダクトで使うならバージョンはlatestじゃないほうが良いです
    container_name: mysql_db
    environment:
      MYSQL_ROOT_PASSWORD: root # MySQLパスワード設定
      MYSQL_DATABASE: test # MySQLデータベース名設定
      TZ: 'Asia/Tokyo'
    ports:
      - '3306:3306'

  phpmyadmin:
    image: phpmyadmin/phpmyadmin
    container_name: mysql_web
    ports:
      - 8080:80
    environment:
      - PMA_ARBITRARY=1
      - PMA_HOST=db
      - PMA_USER=root
      - PMA_PASSWORD=root

DATABASE_URL="mysql://root:root@localhost/test"

datasource db {
  provider = "mysql"
  url      = env("DATABASE_URL")
}

generator client {
  provider = "prisma-client-js"
}

model User {
  id       Int        @id @default(autoincrement())
  name     String
  phone    String
  Call     Call[]
  Response Response[]
}

model Call {
  id        Int        @id @default(autoincrement())
  email     String     @unique
  name      String?
  responses Response[]
  patient   User?      @relation(fields: [patientId], references: [id])
  patientId Int?
}

model Response {
  id        Int    @id @default(autoincrement())
  request   String
  pushed_no Int
  call      Call?  @relation(fields: [callId], references: [id])
  callId    Int?
  patient   User?  @relation(fields: [patientId], references: [id])
  patientId Int?
}

npx prisma migrate dev --name init

touch src/prisma.service.ts

import { INestApplication, Injectable, OnModuleInit } from '@nestjs/common';
import { PrismaClient } from '@prisma/client';

@Injectable()
export class PrismaService extends PrismaClient implements OnModuleInit {
  async onModuleInit() {
    await this.$connect();
  }

  async enableShutdownHooks(app: INestApplication) {
    this.$on('beforeExit', async () => {
      await app.close();
    });
  }
}

nest g resource responses calls users

npm i -D prisma-erd-generator @mermaid-js/mermaid-cli
# or
yarn add -D prisma-erd-generator @mermaid-js/mermaid-cli

...
generator erd {
  provider = "prisma-erd-generator"
  output = "../scheme.svg"
  theme = "forest"
}
...

npx prisma generate

#!/usr/bin/env sh
. "$(dirname -- "$0")/_/husky.sh"

npm run lint-staged
npx prisma generate

version: 1.0
runtime: nodejs14
build:
  commands:
    build:
      - npm ci --unsafe-perm
      - npx prisma generate
      - npx prisma migrate deploy
      - npm run build
run:
  command: npm prisma migrate deploy && npm run start
  network:
    port: 3000

version: 1.0
runtime: nodejs14
build:
  commands:
    build:
      - npm i --unsafe-perm
      - npx prisma generate
      - npx prisma migrate deploy
      - npm run build
run:
  command: npm run start
  network:
    port: 3000

"prisma": {
  "seed": "ts-node prisma/seed.ts"
},

import { PrismaClient } from '@prisma/client';
const prisma = new PrismaClient();

async function main() {
  const alice = await prisma.user.create({
    data: {
      hospitalId: 1,
      name: 'Alice',
      email: 'alice@prisma.io',
      phone: '0000',
    },
  });

  console.log({ alice });
}

main()
  .catch((e) => {
    console.error(e);
    process.exit(1);
  })
  .finally(async () => {
    await prisma.$disconnect();
  });

npx prisma db seed

Running seed command `ts-node prisma/seed.ts` ...
{
  alice: {
    id: 3,
    hospitalId: 1,
    name: 'Alice',
    email: 'alice@prisma.io',
    phone: '0000',
    createdAt: 2022-05-29T23:30:04.762Z,
    updatedAt: 2022-05-29T23:30:04.763Z
  }
}

🌱  The seed command has been executed.

npx prisma studio

categories.forEach(async (category) => {
    console.log(`Creating category ${category.categoryName}...`);
    await prisma.category.create({
        data: {
            categoryName: category.categoryName,
            categoryDescription: category.categoryDescription
        }
    })
    console.log(`Category ${category.categoryName} created!~`);

})

datasource db {
  provider = "mysql"
  url      = env("DATABASE_URL")
  // provider = "sqlite"
  // url      = "file:./dev.db"
}

DATABASE_URL="mysql://root:root@localhost:3306/test"

npx prisma migrate reset

npm i dotenv

import { config } from 'dotenv'
config({ path: '.env.' })

m ERR! code 1
npm ERR! path /root/repos/reborn/node_modules/puppeteer
npm ERR! command failed
npm ERR! command sh -c node install.js
npm ERR! ERROR: Failed to set up Chromium r991974! Set "PUPPETEER_SKIP_DOWNLOAD" env variable to skip download.
npm ERR! Error: self signed certificate in certificate chain
npm ERR!     at TLSSocket.onConnectSecure (_tls_wrap.js:1515:34)
npm ERR!     at TLSSocket.emit (events.js:400:28)
npm ERR!     at TLSSocket._finishInit (_tls_wrap.js:937:8)
npm ERR!     at TLSWrap.ssl.onhandshakedone (_tls_wrap.js:709:12) {
npm ERR!   code: 'SELF_SIGNED_CERT_IN_CHAIN'
npm ERR! }

npm ERR! A complete log of this run can be found in:
npm ERR!     /root/.npm/_logs/2022-05-30T07_45_29_989Z-debug-0.log

npm rm @mermaid-js/mermaid-cli

npm i -g @nestjs/cli npm-check-updates
nest update --force

Error: P3014

Prisma Migrate could not create the shadow database. Please make sure the database user has permission to create databases. Read more about the shadow database (and workarounds) at https://pris.ly/d/migrate-shadow

Original error: Error code: P1010