Re: DBIx::Class and many-to-many searching

Hi, If you already have an array of tag row objects, then you want to do something like this:

@with = map { $_->id } @with;
@without = map { $_->id } @without;

my @articles = $schema->resultset('articles')->search({}, 
 { join => { 'articlelinks' => 'tag' },
   tag.tag => { '-not_in' => \@without, '-in' => \@with } });
[download]

This is basically an SQL::Abstract construct, look there for details.

(Untested!)

Update: Fixed code.. maybe

PS: This will return all articles with any of the tags in @with, there's a discussion going on in #dbix-class as to whether you wanted any, or all of them..

Please give an example of the SQL you'd like to produce, for further help

Comment on Re: DBIx::Class and many-to-many searching Download Code

Replies are listed 'Best First'.
Re^2: DBIx::Class and many-to-many searching (bare non-words) by tye (Sage) on May 30, 2006 at 17:22 UTC
`tag.tag` is likely not what you want: `$_= $_->id() for @with, @without; my @articles= $schema->resultset('articles')->search( {}, { join => { 'articlelinks' => 'tag' }, 'tag.tag' => { '-not_in' => \@without, '-in' => \@with }, }, );` [download] - tye	[reply] [d/l] [select]
Re^2: DBIx::Class and many-to-many searching by BrentDax (Hermit) on May 30, 2006 at 18:57 UTC
For the record, I'm looking for articles with all of the tags in `@with` and none of the tags in `@without`. =cut --Brent Dax There is no sig.	[reply] [d/l] [select]