Transactions Failing on Collection Deletion about python-arango HOT 3 CLOSED

Hello @sha-eln!

Sorry for the delay in responding to your issue, we truly appreciate your patience. Our team has been heavily occupied with other tasks.

In ArangoDB, creating and deleting collections are operations that can't be done inside a transaction. Transactions are designed to provide atomicity and isolation to data manipulation operations (like insert, update, delete) on existing collections, rather than structural changes to the database itself (like creating or deleting collections).

If you need to empty a collection (i.e., delete all documents but keep the collection itself), you should be able to do that using a truncate operation:

db = client.db(DB_NAME , username=DB_USER, password=DB_PASSWORD)
collection = db.collection(COLL_NAME)
collection.truncate()

Lastly, while you can truncate a collection inside a transaction, it's important to note that if truncation is all you're doing, a transaction is not necessary. Transactions are typically used to ensure atomicity of multiple interdependent operations.

from python-arango.

Dear @sha-eln,

I believe my answer clears some of the confusion regarding transactions. Therefore, I am going to close this issue. In case you experience any problems with our Python driver, don't hesitate to open a new one.

from python-arango.

@apetenchea Thank you so much for your response! Yes that does clear things up quite a bit. Wishing you all the best. :)

from python-arango.