Class Sequel::SQL::OrderedExpression
In: lib/sequel/extensions/eval_inspect.rb
lib/sequel/sql.rb
Parent: Object

Represents a column/expression to order the result set by.

Methods

asc   desc   invert   new  

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={})

Set the expression and descending attributes to the given values. Options:

:nulls :Can be :first/:last for NULLS FIRST/LAST.

[Source]

      # File lib/sequel/sql.rb, line 1368
1368:       def initialize(expression, descending = true, opts={})
1369:         @expression, @descending, @nulls = expression, descending, opts[:nulls]
1370:       end

Public Instance methods

asc()

Return a copy that is ordered ASC

[Source]

      # File lib/sequel/sql.rb, line 1373
1373:       def asc
1374:         OrderedExpression.new(@expression, false, :nulls=>@nulls)
1375:       end
desc()

Return a copy that is ordered DESC

[Source]

      # File lib/sequel/sql.rb, line 1378
1378:       def desc
1379:         OrderedExpression.new(@expression, true, :nulls=>@nulls)
1380:       end
invert()

Return an inverted expression, changing ASC to DESC and NULLS FIRST to NULLS LAST.

[Source]

      # File lib/sequel/sql.rb, line 1383
1383:       def invert
1384:         OrderedExpression.new(@expression, !@descending, :nulls=>INVERT_NULLS.fetch(@nulls, @nulls))
1385:       end

[Validate]