On Wed, 29 Oct 2008, Brandi Cantarel wrote:
Thanks Cory for your response, but I am quite familiar with all of the online
help.
After already consulting this and being able to write lots and lots of good
statements. I have noticed that when use the table object and join it to a
table it "belongs_to" I get the "Can't handle this error"
But if I do the opposite join I do not get the error. Why??
__PACKAGE__->belongs_to('entry' => 'Cazy::Schema::Entry','entry_id');
__PACKAGE__->add_relationship('entry' => 'Cazy::Schema::Entry','entry_id');
__PACKAGE__->might_have('entry_orgname' =>
'Cazy::Schema::EntryOrgname','entry_id');
__PACKAGE__->add_relationship('entry_orgname' =>
'Cazy::Schema::EntryOrgname','entry_id');
Somehow youre relationship is getting set with a condition that is neither
a hashref nor an arrayref. Those "add_relationship" calls are incorrect
for example. The "belongs_to" call on its own should produce a correct
relationship condition.
Would you please send your entire schema class file, instead of parts of
it? Both the one the relationship is in, and the Entry.pm one. It's very
hard to help debug with just bits of info.
You can also check what the relationship condition is by doing:
print Dumper($schema->source('XXX')->relationship_info('entry')->{cond};
If that is not a hashref of an array, you did something wrong somewhere.
my $query1 = $entryorg_rs->search(\%where,{join=>'entry'}); ###DOESN'T WORK
This should work fine if the relationship definitions are correct.
What I would really like to do is this statement:
my $query1 = $entryorg_rs->search(\%where,{
join=>{'entry'=>{'fam_comp'=>'family'}}
'+select'=>['entry.description','entry.note','entry.tax_id','entry.genome_id',
'family.fam_acc','family.subf','fam_comp.seq_begin','fam_comp.seq_end'],
'+as'=>['entry_desc','entry_note','taxid','genome_id','fam_acc','subf','begin','end']
});
This one looks ok too.
Jess
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[email protected]
