class Thorderbolt::OrderAnyQueryBuilder

Builds full query for performing custom ordering

Protected Instance Methods

build_case_else(when_queries) click to toggle source

result example: CASE

WHEN 'cities'.'name'='City 1'
  OR 'cities'.'name'='City 5' THEN 0
ELSE 1

END

# File lib/thorderbolt/order_any_query_builder.rb, line 27
def build_case_else(when_queries)
  "CASE #{when_queries} ELSE 1 END"
end
build_when_then_part(conditions) click to toggle source

result example: WHEN 'cities'.'name'='City 1' OR 'cities'.'name'='City 2' THEN 0

# File lib/thorderbolt/order_any_query_builder.rb, line 17
def build_when_then_part(conditions)
  "WHEN #{conditions.join(' OR ')} THEN 0"
end