[Dbix-class] Resultset chaining

Benjamin Hitz hitz at genome.stanford.edu
Wed Oct 14 20:39:38 GMT 2009


I am having trouble chaining result sets; that is running ->search  
subsequently.
So then I tried this:

(with DBIC_TRACE =1)

DB::Mod ISA DBIx::Class::Schema

fasolt 140 > perl -I./ -MDB::Mod -e
'$r=DB::Mod->schema->resultset("Feature"); \
$r->search(gene_name=>"ACT1");\
$r->all' ;
SELECT me.feature_no, me.taxon_id, me.dbxref_id, me.feature_name,  
me.feature_type, me.source, me.status, me.gene_name, me.date_created,  
me.created_by FROM BUD.feature me:


fasolt 141 > perl -I./ -MDB::Mod -e
'$r=DB::Mod->schema->resultset("Feature")->search(gene_name=>"ACT1");\
$r->all' ;
SELECT me.feature_no, me.taxon_id, me.dbxref_id, me.feature_name,  
me.feature_type, me.source, me.status, me.gene_name, me.date_created,  
me.created_by FROM BUD.feature me WHERE ( gene_name = ? ): 'ACT1'

Why does the first one give me different SQL?
My DBIx::Class version is 0.08111
My SQL::Abstract version is 1.58

Thanks,
Ben
--
Ben Hitz
Senior Scientific Programmer ** Saccharomyces Genome Database ** GO  
Consortium
Stanford University ** hitz at genome.stanford.edu






More information about the DBIx-Class mailing list