Class: Sequel::SQL::OrderedExpression

Inherits:
Expression show all
Defined in:
lib/sequel/sql.rb

Overview

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

Constant Summary collapse

INVERT_NULLS = 
{:first=>:last, :last=>:first}.freeze

Instance Attribute Summary collapse

Instance Method Summary collapse

Methods inherited from Expression

#==, attr_reader, comparison_attrs, #eql?, #hash, #inspect, #lit, #sql_literal

Constructor Details

#initialize(expression, descending = true, opts = {}) ⇒ OrderedExpression

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

:nulls

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



1234
1235
1236
 
# File 'lib/sequel/sql.rb', line 1234

def initialize(expression, descending = true, opts={})
  @expression, @descending, @nulls = expression, descending, opts[:nulls]
end

Instance Attribute Details

#descending ⇒ Object (readonly)

Whether the expression should order the result set in a descending manner



1225
1226
1227
 
# File 'lib/sequel/sql.rb', line 1225

def descending
  @descending
end

#expression ⇒ Object (readonly)

The expression to order the result set by.



1222
1223
1224
 
# File 'lib/sequel/sql.rb', line 1222

def expression
  @expression
end

#nulls ⇒ Object (readonly)

Whether to sort NULLS FIRST/LAST



1228
1229
1230
 
# File 'lib/sequel/sql.rb', line 1228

def nulls
  @nulls
end

Instance Method Details

#asc ⇒ Object

Return a copy that is ordered ASC



1239
1240
1241
 
# File 'lib/sequel/sql.rb', line 1239

def asc
  OrderedExpression.new(@expression, false, :nulls=>@nulls)
end

#desc ⇒ Object

Return a copy that is ordered DESC



1244
1245
1246
 
# File 'lib/sequel/sql.rb', line 1244

def desc
  OrderedExpression.new(@expression, true, :nulls=>@nulls)
end

#invert ⇒ Object

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



1249
1250
1251
 
# File 'lib/sequel/sql.rb', line 1249

def invert
  OrderedExpression.new(@expression, !@descending, :nulls=>INVERT_NULLS.fetch(@nulls, @nulls))
end