Use prisma transactions for write queries to correctly automatically rollback in error situations

[chiragjn]

See: https://prisma-client-py.readthedocs.io/en/stable/reference/transactions/#usage

[jalotra]

This is a good one, giving some context for dev working on this : Creation of a collection is 3 step process :

1. Create a postgres row in table : "collections"
2. Create a vector document in vector db, defaults : "qdrant"
3. Then Associate the collection created with associated data sources.

Say if step 2 was failing, which was the case as I didnt looked that profiles --profile ollama and --profile --dev was needed, same collection cant be made 2nd time; as postgres already knows that this collection exists.

[ayeankit]

hello @chiragjn I want to work on this issue. Can you please assign me this issue?