Transactional Integrity in Data Store

Transactional Integrity in Data Store

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:
  1. 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?

      Catalyst Community