Open
Description
Original code
class Foo
scope :by_bar, -> {
order(Arel.sql(
<<-SQL
(CASE WHEN foo LIKE 'bar%' THEN 1 ELSE 2 END) asc,
classification asc
SQL
))
}
scope :by_foo_and_bar, -> { by_classification.order(:foo) }
end
Format 1:
class Foo
scope :by_bar, -> { order(Arel.sql(<<-SQL)) }
(CASE WHEN foo LIKE 'bar%' THEN 1 ELSE 2 END) asc,
classification asc
SQL
scope :by_foo_and_bar, -> { by_classification.order(:foo) }
end
Format 2:
class Foo
scope :by_bar, -> { order(Arel.sql(<<-SQL)) }
(CASE WHEN foo LIKE 'bar%' THEN 1 ELSE 2 END) asc,
classification asc
SQL
scope :by_foo_and_bar, -> { by_classification.order(:foo) }
end
Metadata
Metadata
Assignees
Labels
No labels