I have a keyspace killrvideo. I have 3 tables named "addProduct", "productDetails", "buyProduct". Now when I insert or update any one of the tables, I needed it to be copied to the related tables also. My choice is to use batch statement (With caution). I can execute it in CLI but unable to execute it in python. So how do I create batch statements in python? What libraries should I import for that other than cassandra-driver? Note: I'm running a single node cluster on docker compose with rf=1 and SimpleStrategy.
This question was
closed
by
Erick Ramirez for the following reason: The question is answered, right answer was accepted
What libraries should I import to create Cassandra batch statements in python ?
To run BATCH queries, you need to import BatchQuery:
from cassandra.cqlengine.query import BatchQuery
and create a BatchQuery instance, for example:
b = BatchQuery()
For details and examples, see Batch Queries in the Python driver. cheers!
Hi Erick,
I'm so sorry that I'm not able to understand the code given in the link https://docs.datastax.com/en/developer/python-driver/3.24/cqlengine/batches/ in a section "Batch Query genral use pattern".
If possible could you kindly clarify with a simple code to insert a record using batch :)
That would be very helpful:)
I've just managed to circle back to this post and see that you got your answer in question #7445. Cheers!
5 People are following this question.
