Module: Card::Query::SqlStatement::Order
- Included in:
- Card::Query::SqlStatement
- Defined in:
- lib/card/query/sql_statement/order.rb
Overview
build ORDER BY clause
Instance Method Summary collapse
- #order ⇒ Object
- #order_as ⇒ Object
- #order_config ⇒ Object
- #order_dir(order_key) ⇒ Object
- #order_directive(order_key) ⇒ Object
- #order_directives ⇒ Object
- #order_field(order_key) ⇒ Object
Instance Method Details
#order ⇒ Object
19 20 21 22 23 |
# File 'lib/card/query/sql_statement/order.rb', line 19 def order full_syntax do "ORDER BY #{order_directives.join ', '}" end end |
#order_as ⇒ Object
47 48 49 50 51 52 |
# File 'lib/card/query/sql_statement/order.rb', line 47 def order_as field = yield return field unless (as = @mods[:sort_as]) "CAST(#{field} AS #{cast_type(safe_sql(as))})" end |
#order_config ⇒ Object
62 63 64 |
# File 'lib/card/query/sql_statement/order.rb', line 62 def order_config @mods[:sort].blank? ? "update" : @mods[:sort] end |
#order_dir(order_key) ⇒ Object
54 55 56 57 58 59 60 |
# File 'lib/card/query/sql_statement/order.rb', line 54 def order_dir order_key if @mods[:dir].blank? DEFAULT_ORDER_DIRS[order_key.to_sym] || "asc" else safe_sql @mods[:dir] end end |
#order_directive(order_key) ⇒ Object
31 32 33 34 35 |
# File 'lib/card/query/sql_statement/order.rb', line 31 def order_directive order_key field = order_field order_key @fields += ", #{field}" "#{field} #{order_dir order_key}" end |
#order_directives ⇒ Object
25 26 27 28 29 |
# File 'lib/card/query/sql_statement/order.rb', line 25 def order_directives Array.wrap(order_config).map do |order_key| order_directive order_key end end |
#order_field(order_key) ⇒ Object
37 38 39 40 41 42 43 44 45 |
# File 'lib/card/query/sql_statement/order.rb', line 37 def order_field order_key order_as do if (field = ORDER_MAP[order_key]) "#{@query.table_alias}.#{field}" else safe_sql order_key end end end |