[v5] Delete Many-To-Many relationship from a parent

[melokki]

Hello 👋 🙃 ,
I am trying to delete a many-to-many relationship from a parent relationship, but the entries from the pivot table are not deleted

this is what I have so far

const course = await Course.findOrFail(params.id);
course.preload("subscriptions", (query) => {
    query.delete();
});
await course.delete();

My relationships are as follows:

Course -> hasMany -> Subscription
Subscription -> Many-To-Many -> User

Don't know how to gain access to that detach method 🤔

[thetutlage]

The preload method is used to select the related rows and hence cannot be used to delete rows. You can access the detach method as follows:

course.related('subscriptions').detach()

It's cover in documentation too https://preview.adonisjs.com/guides/model-relations/many-to-many#detach

[melokki]

thank you for your reply

Yes, but my many-to-many relationship is not on course -> subscriptions, it's on subscriptions -> users so course.related('subscriptions').detach() won't work

Property 'detach' does not exist on type 'HasManyClientContract<HasManyRelationContract

[melokki]

I came up with something like this after all

await course.preload("subscriptions");
course.subscriptions.map(async (subscription) => {
    await subscription.related("users").detach();
    await subscription.delete();
});

I was trying to avoid that .map() but it appears it's not possible