[Catalyst] Class::DBI::Sweet search method error?

Maxim Nechaev nechaev at technodesign.ru
Wed Apr 5 04:13:48 CEST 2006

Maybe this wrong list for my question but SUPPORT section of `perldoc
Class::DBI::Sweet` point on it.

I have some Class::DBI based module with own column accessor names:
package UserAgent;
use base 'Class::DBI';
    Class::DBI::Column->new(txtLog   => {accessor => 'log'  }),
    Class::DBI::Column->new(intCount => {accessor => 'count'}),
    Class::DBI::Column->new(lstType  => {accessor => 'type' }),
    Class::DBI::Column->new(lstName  => {accessor => 'name' }),

Search and access through modified accessors work fine:
my @mobileAgents = UserAgent->search(type => 'mobile');
print $mobileAgents[0]->name;

But if i try switch base module to Class::DBI::Sweet i get error message
in search method: "DBD::mysql::st execute failed: Unknown column
'me.type' in 'where clause'" When i change to real column name "lstType"
all works again. Look like "Class::DBI::Sweet" ignore customized columns
accessors. Is there any work arounds for this? Can i have different
column names in my table and in my "Class::DBI::Sweet" class?


Maxim Nechaev

More information about the Catalyst mailing list