[Dbix-class] match against ...

[Peter Rabbitson]

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 => ...
    ...
  },
);