How to create a factory for a entity with many to many relationships ?

[golubvladimir]

Skills entity

@Entity({
  name: 'skills'
})
export class SkillEntity {

  @PrimaryGeneratedColumn({
    name: 'id'
  })
  id: number;

  @Column({
    name: 'title'
  })
  title: string;

  @Column({
    name: 'description'
  })
  description: string;

  @Column({
    name: 'slug'
  })
  slug: string;

  @CreateDateColumn({
    name: 'created_at'
  })
  createdAt: string;

  @CreateDateColumn({
    name: 'updated_at'
  })
  updatedAt: string;

  @Column({
    name: 'status',
    type: 'tinyint'
  })
  status: number;

  @ManyToMany(
    () => IntershipEntity,
    (interships) => interships.skills,
    {
      nullable: true
    }
  )
  interships: IntershipEntity[]
}

IntershipEntity

@Entity({
  name: 'interships'
})
export class IntershipEntity {

  @PrimaryGeneratedColumn({
    name: 'id'
  })
  id: number;

  @Column({
    name: 'title'
  })
  title: string;

  @Column({
    name: 'description'
  })
  description: string;

  @Column({
    name: 'slug'
  })
  slug: string;

  @CreateDateColumn({
    name: 'created_at'
  })
  createdAt: string;

  @CreateDateColumn({
    name: 'updated_at'
  })
  updatedAt: string;

  @Column({
    name: 'status',
    type: 'tinyint'
  })
  status: number;

  @ManyToMany(
    () => SkillEntity,
    (skills) => skills.interships,
    {
      nullable: true
    }
  )
  @JoinTable({
    name: 'interships_skills'
  })
  skills: SkillEntity[];

My vesion of a factory.

export default setSeederFactory(IntershipEntity, async faker => {
  const instance = await useDataSource();

  const skillRepository = instance.getRepository(SkillEntity);

  const skill = skillRepository.create({
    title: 'HTML'
  });

  const intership = new IntershipEntity();

  const intershipTitle = faker.name.jobTitle();

  intership.title = intershipTitle
  intership.description = faker.name.jobDescriptor();
  intership.status = DbHelper.STATUS_PUBLISHED;
  intership.slug = UrlHelper.createSlug(intershipTitle);
  intership.skills = [ skill ];

  return intership;
})

This version created only one record of IntershipEntity.

[golubvladimir]

Try

  const skill1 = await useSeederFactory(SkillEntity).make();
  intership.skills = [skill1];

, but it's not work.

[golubvladimir]

It works.

  const skill1 = new SkillEntity();

  const skill1Title = 'titl'

  skill1.title = skill1Title;
  skill1.description = 'test';
  skill1.slug = UrlHelper.createSlug(skill1Title);
  skill1.status = DbHelper.STATUS_PUBLISHED;
  const dataSource = await useDataSource();
  await dataSource.manager.save(skill1);

  const intership = new IntershipEntity();

  const intershipTitle = faker.name.jobTitle();

  intership.title = intershipTitle
  intership.description = faker.name.jobDescriptor();
  intership.status = DbHelper.STATUS_PUBLISHED;
  intership.slug = UrlHelper.createSlug(intershipTitle);
  intership.skills = [skill1];

  return intership;