Delete rows inside relation in Adonis 5

[dajpes]

Hi, Is it possible to remove data that is inside a relation?

For example in Adonis js 4, you can achieve that like this:

await user.post().delete()

AdonisJs 5:

await user.related("post").delete() // Error
await user.preload("post").delete() // Error

[iammrsea]

await user.preload('post');
await user.post.delete();

[dajpes]

I tried that, but an error says that delete method not found.

[thetutlage]

Here's how you can access the query builder of a relationship and then just chain the delete method on it.

https://preview.adonisjs.com/guides/model-relations/introduction#access-to-the-direct-query-builder

[dajpes]

Hi,

By using this query, it can actually delete all the associate records:

//Typescript
await user?.related("post").query().delete();