I am using the below to process a file that I receive via a cron job across multiple EC2 instances. I need to ensure I don't add the same data twice into the table so I'm using trace_id.
However I've just looked at the table and there are duplicate entries of trace_id? Is updateOrCreate not the right function to use for this?
Appreciate the help
points::updateOrCreate([ 'trace_id' => $this->trace ], [ 'userid' => $this->userid, 'points' => $this->points, 'message' => $this->msg, 'year' => $this->year ]);