Prisma postgresql когда удаляю, то остается какие-то поля «A,B»?

Question

[linoa123]

generator client {
  provider = "prisma-client-js"
  output   = "generated/client"
}

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

model User {
  id        String   @id @default(cuid())
  createdAt DateTime @default(now()) @map("created_at")
  updatedAt DateTime @updatedAt @map("updated_at")

  name     String
  lastName String

  email       String @unique
  linkedEmail String @unique 
  password    String

  phone     String
  birthdate String
  gender    String

  questions      Question[]
  likedQuestions Question[] @relation("LikedQuestions")

  @@map("user")
}

model Question {
  id        String   @id @default(cuid())
  createdAt DateTime @default(now()) @map("created_at")
  updatedAt DateTime @updatedAt @map("updated_at")

  themeText   String  @map("theme_text")
  text        String? @default("")
  category    String
  subcategory String

  likes    Int?     @default(0)
  likedBy  User[]   @relation("LikedQuestions")
  isLeader Boolean? @default(false) @map("is_leader")

  user   User?   @relation(fields: [userId], references: [id])
  userId String?

  @@map("question")
}

допустим я создал 1 Question и в нем добавил 1 лайк:

@UsePipes(new ValidationPipe())
	@HttpCode(200)
  @Auth()
  @Put(':id')
  async update(
    @Body() dto: QuestionDto,
    @CurrentUser('id') userId: string,
    @Param('id') id: string
  ) {
    return this.questionService.update(dto, id, userId);
  }
  @UsePipes(new ValidationPipe())
  @Patch('like/:id')
  @Auth()
  async addLike(@Param('id') id: string, @CurrentUser('id') userId: string) {
    return this.questionService.addLike(id, userId);
  }

  async create(dto: QuestionDto, userId: string) {
		return this.prisma.question.create({
			data: {
				...dto,
				user: {
					connect: {
						id: userId,
					},
				},
			},
		});
  }
  async addLike(questionId: string, userId: string) {
    return this.prisma.question.update({
      where: { id: questionId },
      data: {
        likes: { increment: 1 },
        likedBy: {
          connect: {
            id: userId,
          },
        }
      }
    });
  }

И потом я удалил сам question и вот эти "A,B" почему-то остались в LikedQuestions, что я не так связал?

Answer 1

[Виктор Л]

По-моему Prisma не удаляет автоматически связанные записи в таблицах связей, если это не указано явно
надо юзать onDelete: Cascade
Документация

Comments

[linoa123]

как мне это к likedBy с question привязать?

generator client {
  provider = "prisma-client-js"
  output   = "generated/client"
}

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

model User {
  id        String   @id @default(cuid())
  createdAt DateTime @default(now()) @map("created_at")
  updatedAt DateTime @updatedAt @map("updated_at")

  name     String
  lastName String

  email       String @unique
  linkedEmail String @unique 
  password    String

  phone     String
  birthdate String
  gender    String

  questions      Question[]
  likedQuestions Question[] @relation("LikedQuestions")

  @@map("user")
}

model Question {
  id        String   @id @default(cuid())
  createdAt DateTime @default(now()) @map("created_at")
  updatedAt DateTime @updatedAt @map("updated_at")

  themeText   String  @map("theme_text")
  text        String? @default("")
  category    String
  subcategory String

  likes    Int?     @default(0)
  likedBy  User[]   @relation("LikedQuestions")
  isLeader Boolean? @default(false) @map("is_leader")

  user   User?   @relation(fields: [userId], references: [id])
  userId String?

  @@map("question")
}

[Виктор Л]

likedBy  User[]   @relation("LikedQuestions", references: [id], onDelete: Cascade)

[linoa123]

пишет

Error parsing attribute "@relation": Implicit many-to-many relation should not have references argument defined. Either remove it, or change the relation to one-to-many.


Error validating: Referential actions on implicit many-to-many relations are not supported