Managing transactions in Ballerina
It is a common requirement for applications to access databases concurrently. In this case, you need to focus seriously on the transaction management of the system to ensure that the system does not end up in inconsistent states. We will discuss more about transaction management systems with reference to the order verification use case in the order management system.
Building an order management system
To implement the order management system, first, we need to define the table structure that holds the data. The following diagram contains all the tables that we need to implement the order verification scenario.
The supplier is the entity that adds products to the system. The list of suppliers is saved in the Suppliers
table. A supplier can have a supplier name and a supplier ID to uniquely identify it. Each supplier can have multiple inventories. Each inventory...