We have a script that should function like so:
Script inserts n rows into database inserting the same unique number into the batch column.
Script puts a job on the AWS queue with the batch number.
AWS worker does some processing and fires off another script on our server.
Script on our server inserts the response from the AWS worker into all rows in the batch.
This is all easy except - creating the batch number. We can't just get the max batch number and add 1 due to multiple users being able to create a batch at the same time.
So what is the most ideal way to do this? The batch number does not have to be an integer although it could be useful.