[Dbix-class] match against ...

[RAPPAZ Francois]

I tried
my @b; push @b, $bla;
my $rs = $self->{schema}->resultset('Jrn')->search_rs(undef, { -and => [ \["WHERE match(ti, ex, ad)  against(? in boolean mode)", @b]], order_by => 'tri'});

and gets all the table back, not the row matching the criteria.

Sorry but I really new to all these DBiC things.

You mean there is no need to use SQL::Abstract at all ? or the $sql value are coming from there ?

Could you be more explicit ?

Thanks
François


> -----Original Message-----
> From: Peter Rabbitson [mailto:rabbit+dbic at rabbit.us]
> Sent: jeudi, 3. avril 2014 16:04
> To: DBIx::Class user and developer list
> Subject: Re: [Dbix-class] match against ...
> 
> On Fri, Mar 28, 2014 at 03:46:05PM +0000, RAPPAZ Francois wrote:
> > Hi there
> >
> > I haven't look deep enough in the doc pages, sorry, but how can I
> > translate this with resultset('table')->search_rs();
> >
> > SELECT * FROM table WHERE match(field1, field2, field3)
> against('+$bla' in boolean mode) ORDER BY field1 ?
> 
> Sorry for the late reply. There is no multi-parameter op support in
> SQLA yet, due to the complexity of the corner cases (as you already
> discovered). As suggested earlier in the thread - simply tell DBIC "in
> this particular snippet - I'll drive":
> 
> ->search(
>   {
>     criteria1 => val1,
>     criteria2 => val2,
>     -and => [
>       \[ $sql, @bind ],
>       \[ $more_sql, @more_bind ],
>     ]
>   },
>   {
>     order_by => ...
>     prefetch => ...
>     ...
>   },
> );
> 
> _______________________________________________
> 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/dbix-
> class at lists.scsys.co.uk