How to remove orphaned relations or manage relationship synchronisation?

[krishna-404]

How to remove orphaned relations or manage relationship synchronisation?

For both one-to-many & many-to-many relationships?

For example a product was created with links to 5 medias. During edit/update one of the medias was delinked. How to delete the removed media?

Thanks!

[romeerez]

For one-to-many/one-to-one you can use onDelete: 'CASCADE' option in the foreign key, then Postgres will take care of deleting orphaned records. Otherwise, delete them manually.

For many-to-many, as far as I know this is not implemented and you should delete them manually. For example

It's better to wrap it in a transaction.

db.transaction(async () => {
    await db.product.find(id).chain('medias').delete()
    await db.product.find(id).delete()
})

It's worth adding cascade deletes option in relations config to automate this.

[krishna-404]

This is if the product is itself to be deleted right? I don’t want to do that. I want the joint table (product-media) to be deleted & not the product itself.

…

On Mon, 28 Jul 2025 at 1:34 AM, Roman Kushyn ***@***.***> wrote: For one-to-many/one-to-one you can use onDelete: 'CASCADE' option in the foreign key, then Postgres will take care of deleting orphaned records. For many-to-many, as far as I know this is not implemented and you should delete them manually. For example <https://orchid-orm.netlify.app/guide/relation-queries.html#delete> It's better to wrap it in a transaction. db.transaction(async () => { await db.product.find(id).chain('medias').delete() await db.product.find(id).delete()}) — Reply to this email directly, view it on GitHub <#543 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/APAJCB3MY6QXJPJZKKVBRYT3KUWDTAVCNFSM6AAAAACCIB3BQWVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTGOJQGM2DOMI> . You are receiving this because you authored the thread.Message ID: ***@***.***>