Represents a column/expression to order the result set by.
Constants
INVERT_NULLS | = | {:first=>:last, :last=>:first}.freeze |
Attributes
descending | [R] |
Whether the expression should order the result set in a descending manner |
expression | [R] |
The expression to order the result set by. |
nulls | [R] |
Whether to sort NULLS FIRST/LAST |
Public Class methods
new(expression, descending = true, opts=OPTS)
Set the expression and descending attributes to the given values. Options:
:nulls |
Can be :first/:last for NULLS FIRST/LAST. |
[show source]
# File lib/sequel/sql.rb 1673 def initialize(expression, descending = true, opts=OPTS) 1674 @expression = expression 1675 @descending = descending 1676 @nulls = opts[:nulls] 1677 freeze 1678 end
Public Instance methods
asc()
Return a copy that is ordered ASC
[show source]
# File lib/sequel/sql.rb 1681 def asc 1682 OrderedExpression.new(@expression, false, :nulls=>@nulls) 1683 end
desc()
Return a copy that is ordered DESC
[show source]
# File lib/sequel/sql.rb 1686 def desc 1687 OrderedExpression.new(@expression, true, :nulls=>@nulls) 1688 end
invert()
Return an inverted expression, changing ASC to DESC and NULLS FIRST to NULLS LAST.
[show source]
# File lib/sequel/sql.rb 1691 def invert 1692 OrderedExpression.new(@expression, !@descending, :nulls=>INVERT_NULLS.fetch(@nulls, @nulls)) 1693 end