ON DUPLICATE KEY update counter

Rails
1

When my DB insert into MySQL is denied due to a unique field that is
already populated, I want to update the field called “counter” for that
record so I know how many times a duplicate record tried to perform the
insert.

I know that MySQL has something called ON DUPLICATE KEY but I was hoping
that there might already be something similar in Rails?

If not, I was thinking I would have to do something like:

  • unless @record.save
  • find the ID of the duplicate record
  • add one to the value of the counter field for that record

Any ideas would be received warmly :slight_smile:

jackster