In my Data Store, I want to subtract quantities from some tables, add them to others and subtract them from others. However, I want to make sure that if one operation fails, the others are reverted, or don't occur. In SQL I know I can achieve this like:
BEGIN TRANSACTION;
INSERT INTO table1 (column1, column2) VALUES (value1, value2);
DELETE FROM table2 WHERE condition;
UPDATE table3 SET column1 = value1 WHERE condition;
COMMIT;
ROLLBACK;
This way, I ensure that my data keeps integrity and is synchronised. My understanding is that ZCQL doesn't support this. How's the best way to achieve something like this in Catalyst?