I'm developing NestJS app with MySQL. I have two tables (Sport and Referee) with one-to-many relation between them. When I test the create operation, the foreign key in Referee table is null. Also, I can't read referees for a certain sport. Can anyone check what the problem is?Here is the code:
//class Sport
@Entity()
export class Sport
{
@PrimaryGeneratedColumn("uuid")
id: string;
@Column()
name: string;
@OneToMany(type => Referee, ref => ref.sport)
referees: Referee[];
}
//class Referee
@Entity()
export class Referee
{
@PrimaryGeneratedColumn("uuid")
id: string;
@Column()
name: string;
@ManyToOne(type => Sport, sp => sp.referees)
sport: Sport;
}
//code in referee service
async findBySport(sportId: string): Promise<Referee[]>
{
return await this.refereesRepository.find({where: {id: sportId}});
}
async add(referee: Referee)
{
await this.refereesRepository.save(referee);
}
}
//code in controller
@Get()
getRefereesBySport(@Param('sportId') sportId: string)
{
return this.refereesService.findBySport(sportId);
}
}