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:
    INSERT INTO table1 (column1, column2) VALUES (value1, value2);
    DELETE FROM table2 WHERE condition;
    UPDATE table3 SET column1 = value1 WHERE condition;

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?
    • Announcements

    • Important Announcements in Support for Catalyst Features

      Hello Catalyst Users, This announcement is to bring to your notice some of the recent updates in our support for various Catalyst components, to ensure that your existing Catalyst applications function properly. You can continue to build robust applications
    • Introducing Catalyst 2.0, the simplest cloud-based pro-code development platform.

      Dear Catalyst Community, We are beyond thrilled to present you Catalyst 2.0—the new-age, pro-code development platform that redefines the way you build, deploy, and scale apps. Catalyst 2.0 is not a mere upgrade, but a significant leap into the future
    • Set budgets to optionally disable your Catalyst production environment

      Hello all,    We are pleased to inform you that you can now configure the automatic disabling of a project's production environment upon reaching a specified budget's threshold. Budget alerts in Catalyst facilitate setting usage limits in amounts or Catalyst
    • #CatalystServerless Hackathon 2022

      We are pleased to announce #CatalystServerless Hackathon with prizes worth $5000 up for grabs. Create a working prototype aimed to solve a critical business issue using Catalyst and stand a chance to win exciting prizes. The Hackathon will happen in 3
    • Share your interest to participate in the #CatalystServerless Blogathon

      Hi, we are working on announcing the next edition of the #CatalystServerless Blogathon. Please fill up this form to stay posted on all updates related to the Blogathon.

      Catalyst Community