Hi,
I am trying to find best way to fetch data from multiple table using
DBIx::Class relationship.
I have 3 tables as follows.
Articles ( id, title, sort_text) primary key => id
ArticleAuthor (article_id, author_id) primary key => (article_id, author_id)
Author (id, author_name) primary key => id
Relationship.
Article.pm
has_many(article_author => "Article::Author", "article_id")
ArticleAuthor.pm
has_many(author => "Author", "id")
I want to get title and sort_text from articles table and author_name form
author table for a given id.
I tried this
$schema->resultset('Article)->search(
{
id => '1'
},
{ join => { article_author => author }
prefetch => { article_author => author }
}
);
This returns me all the table filelds from all three table, I tried to put
something columns => [qw/ title sort_text author_name/] but did not work.
I want to know if above is correct way to use relationship? or is there a
better way of doing the same?
And how I can get only required columns.
Thanks
_______________________________________________
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]
