We have question reg DB-Virtualization. How can we actually maintain the state of a new record created during playback in the Virtual DB? In our app we create a Repair record in the DB with a unique repair ID and it can go through multiple status changes. (e.g Open, Ready for Repair, Ready for Pickup, Closed)
Now we have recorded all these flows at the DAO level capturing the corresponding transactions. Now when we playback these flows how can we maintain the state of a repair record in our case such that we can actually retrieve it and update a status further ?
Use case Flow 1 - Create Repair ID with Default status Open - My SUT is always going to create a new Repair ID each time during this flow say R345
Use case Flow 2 - Retrieve the same Repair ID R345 in Open Status and Change it to Ready for Repair status.
Use case Flow 3 - Retrieve the same Repair ID R345 - Now the status would be in Ready for Repair - Change it to Ready for Pickup
Use case Flow 4- Retrieve the same Repair ID R345 - Now the status would be in Ready for Pickup - Change it to Closed
How can we maintain the state of the repair record in our case in the virtual DB during playback ?