[Dbix-class] order by field?

[Peter Rabbitson]

On Tue, Dec 18, 2012 at 10:53:25AM +0200, Octavian Rasnita wrote:
> From: "Peter Rabbitson" <rabbit+dbic at rabbit.us>
> 
> > On Mon, Dec 17, 2012 at 11:04:22AM +0100, QE :: Felix Ostmann wrote:
> >> I am doing such a order with the following SQL:
> >> 
> >> ...
> >> ORDER BY
> >>   (department = 'Marketing') DESC,
> >>   (department = 'Sales') DESC,
> >>   (department = 'Financial') DESC,
> >>   (department = 'IT') DESC,
> >>   (department = 'Operations') DESC,
> >>   ...
> >> 
> >> But there is no special way to use this with DBIx::Class :-/
> >> 
> > 
> > Can you elaborate? You can always do:
> > 
> > order_by => \' anything you feel like goes here'.
> > 
> > Is this not sufficient?
> > 
> > Cheers
> > 
> 
> 
> 
> I can do:
> 
> order_by => \'field(department, "Marketing", "Sales", "IT")',
> 
> But the problem is that those names of the departments should be manually cleaned/escaped before inserting them in that script, to avoid SQL injection.

I actually misread the above, didn't pay enough attention that only department
is an identifier. You'd want to do:

order_by => \[ 'field(department, ?, ?, ?)',
  [ {} => 'Marketing' ],
  [ {} => 'Sales' ],
  [ {} => 'IT' ],
],

Cheers