Prisma•3mo ago

How to populate array in one-to-many relationship (or may be even persist)?

Hi. I have the following example models:

model User {
  id        String     @id @default(auto()) @map("_id") @db.ObjectId
  email     String     @unique
  articles  Article[]
}

model Article {
  user    User     @relation(fields: [userId], references: [id])
  userId  String   @db.ObjectId
}

model User {
  id        String     @id @default(auto()) @map("_id") @db.ObjectId
  email     String     @unique
  articles  Article[]
}

model Article {
  user    User     @relation(fields: [userId], references: [id])
  userId  String   @db.ObjectId
}

Then I create my user:

findOrCreate(createUserDto: CreateUserDto) {
  return this.prismaService.user.upsert({
    where: { email: createUserDto.email },
    update: {},
    create: {
      email: createUserDto.email,
    }
  });
}

findOrCreate(createUserDto: CreateUserDto) {
  return this.prismaService.user.upsert({
    where: { email: createUserDto.email },
    update: {},
    create: {
      email: createUserDto.email,
    }
  });
}

Then I create my article:

create(createArticleDto: CreateArticleDto) {
  return this.prismaService.article.create({ data: createArticleDto });
}

create(createArticleDto: CreateArticleDto) {
  return this.prismaService.article.create({ data: createArticleDto });
}

createArticleDto contains userId and thus it should connect these two models together. Then I try to find user and populate their articles:

findOne(id: string) {
 return this.prismaService.user.findUnique({
   where: { id },
   include: {
     articles: true,
   }
 });
}

findOne(id: string) {
 return this.prismaService.user.findUnique({
   where: { id },
   include: {
     articles: true,
   }
 });
}

But it does not have nor return any article. Please, tell me, what am I doing wrong and possible fixes of the situation? Thanks.

Solution:

Okay, I probably found a solution. It seems that restarting Nest.js application helped....

Jump to solution

1 Reply

Solution

AveTaylor•3mo ago

Okay, I probably found a solution. It seems that restarting Nest.js application helped.

Gaming

Programming

How to populate array in one-to-many relationship (or may be even persist)?