I have 3 entities:
CategoryEntity that stores lessons:
@Entity('category')
export class CategoryEntity extends BaseEntity {
@Column({
default: true,
})
isActive: boolean;
@OneToMany(() => LessonEntity,
(lessons) => lessons.category)
lessons: LessonEntity[];
}
LessonEntity that stores questions:
@Entity('lessons')
export class LessonEntity {
@Column({
default: true,
})
isActive: boolean;
@ManyToOne(() => CategoryEntity,
(category) => category.lessons)
@JoinColumn()
category: CategoryEntity | number;
@OneToMany(() => QuestionEntity,
(question) => question.lesson)
questions: QuestionEntity;
}
QuestionEntity:
@Entity('question')
export class QuestionEntity {
@Column({
default: true
})
isActive: boolean;
@ManyToOne(() => LessonEntity,
(lesson) => lesson.questions)
lesson: LessonEntity;
}
I want change isActive in 3 binded entities when i change it in category. How i can do it using Query Builder?