We have a use case in our application where we need to create an entity. Each entity will have a start date and end date. These are sequential in order based on start and end dates.
We are facing an issue in this use case. Since we have business rules that we should not have duplicates we have created a unique constraint on the start date in entity level. Everything works perfect from UI. The issue started when automated tests are run. We have multiple test all running the above use case and normally the tests are fired together which might run in parallel. We recently noticed that there are duplicate rows getting created in the system. We assume the only reason this happens can be the tests running in parallel which might be firing the inserts before or after simultaneous. Since the unique constraint on the entity level also not stopping the duplicate, we are not sure how to handle this issue.
If anyone is familiar with these kind of use case, any suggestions would be really helpful. Can any kind of synchronization be done to handle this.