packetstormer has asked for the wisdom of the Perl Monks concerning the following question:
Hello Monks
I have a small Perl script that parses a csv file, builds a hash and then, depenging on certain things, inserts some/all of the data into a MySQL table.
I have a unique, multi-column index, on the SQL table because I know the end user will run this script over the same data multiple times and I need to make sure we don't get multiple inserts of the same data
My problem is that, although this all works fine, the message sent back to the end user, from the script, is something like:
DBD::mysql::st execute failed: Duplicate entry '167423-192.168.160.153-b8:12:xx:yy:zc-2012-11-10 11:21:43' for key 'idx_unique_session
While this is fine for me, the end user won't have a clue what is going on!
Does anyone have any tricks on how to trap this error, compare it and if true replace it with a user friendly message e.g
"Duplicate data inserted, have you processed this file already"
etc.
Thanks
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: Custom DBD error message
by mje (Curate) on Nov 12, 2012 at 16:04 UTC | |
Re: Custom DBD error message
by sweetblood (Prior) on Nov 12, 2012 at 19:10 UTC |