Create document with relations, if error can result in orphan relation document

Hey, little question, about foreign relationship. How do you deals with orphan when a create document failed ?

I try to upload a lot of data to appwrite cloud, so i loop over my parsed json, and sometimes i have issue (like a new attribute that i don' know or a something else) that leads to an error of the creating document, but foreign key can have be created. And after that i have very hard to find orphans in my collection

Thanks 🙂

i use sdk node-appwrite

You might have to manually iterate over the collection to find them because querying is not supported 😕

Yes =\ I have change how to insert my data and don’t use relationship

I insert a foreign key in the related documents

So i can handle orphan in the script before insert and everything is working

If your issue has been solved, you can mark this post as closed by adding "[SOLVED]" to the beginning of the title