[CDBI] processing mysql errors

Matt S Trout dbix-class at trout.me.uk
Thu Aug 25 14:01:19 BST 2005


On Thu, Aug 25, 2005 at 12:49:54PM +0100, Dave Howorth wrote:
> Matt S Trout wrote:
> Thanks for this. Yes DBD::mysql makes some attributes available, 
> including mysql_errno and mysql_error. I believe these are propagated up 
> through DBI and Class::DBI. But the detailed information, which users 
> want and which my attempt at automatic recovery needs, is buried in the 
> MySQL mysql_error string, AFAIK. So it seems like I need to parse that 
> and I can't believe I'm the first to want to do it :)

Ahh, right. You didn't make what you were trying to do clear in your first
e-mail - or at least not to me :)

"No idea" then but some of the following might be a starting point (and the
pipeline's a handy one for people's records anyway IMO) -

matthewt$ zcat 02packages.details.txt.gz | awk '{print $3}' | grep -i mysql \
>           | perl -pe 's!.*/!!; s!-\d.*!!;' | sort -u
ApacheMysql
CGI-Session-Driver-flexmysql
CGI-Session-FlexMySQL
Class-DBI-Loader-mysql-Grok
Class-DBI-mysql
Class-DBI-mysql-FullTextSearch
Crypt-MySQL
DBD-mysql
DBD-mysql-AutoTypes
DBD-mysql-SimpleMySQL
DBD-mysqlPP
DBIx-MySQLSequence
DateTime-Format-MySQL
Msql-Mysql-modules
MySQL-Backup
MySQL-Config
MySQL-DateFormat
MySQL-Diff
MySQL-Easy
MySQL-GUI
MySQL-TableInfo
Mysql-Locker
Mysql-NameLocker
Net-MySQL
Persistent-MySQL
Qmail-Mysql
Time-Piece-MySQL
XAO-MySQL

-- 
     Matt S Trout       Specialists in perl consulting, web development, and
  Technical Director    UNIX/Linux systems architecture and automation. Mail
Shadowcat Systems Ltd.  mst (at) shadowcatsystems.co.uk for more information

 + Help us build a better perl ORM: http://dbix-class.shadowcatsystems.co.uk/ +




More information about the ClassDBI mailing list