Having a one-to-many relationship in TypeORM, I am interested in deleting rows from the many side of the connection rather than just unlinking them and leaving orphaned entries. Can anyone suggest a way to achieve this since the proposed feature for it was rejected? Any workarounds or alternative methods would be greatly appreciated. Here's a simplified code snippet for reference:
@Entity()
@TableInheritance({ column: { name: 'type', type: 'text' } })
export default class Geolocation {
@PrimaryGeneratedColumn()
id!: number;
@IsGeoJSONPoint
@Column('geography')
point!: Point;
}
@ChildEntity('offer')
export default class OfferGeolocation extends Geolocation {
@ManyToOne(type => Offer, offer => offer.geolocations, { onDelete: 'CASCADE' })
offer!: Offer;
}
@ChildEntity('business')
export default class BusinessGeolocation extends Geolocation {
@ManyToOne(type => Business, business => business.geolocations, { onDelete: 'CASCADE' })
business!: Business;
}
@Entity()
export default class Business {
@PrimaryGeneratedColumn()
id!: number;
// To remove orphaned business geolocations
@OneToMany(type => BusinessGeolocation, businessGeolocation => businessGeolocation.business, { cascade: true })
geolocations!: BusinessGeolocation[];
}
@Entity()
export default class Offer {
@PrimaryGeneratedColumn()
id!: number;
// To remove orphaned offer geolocations as well
@OneToMany(type => OfferGeolocation, offerGeolocation => offerGeolocation.offer, { cascade: true })
geolocations!: OfferGeolocation[];
}