Class: Sequel::SQL::Window

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

Overview

A Window is part of a window function specifying the window over which the function operates. It is separated from the WindowFunction class because it also can be used separately on some databases.

Instance Attribute Summary (collapse)

Instance Method Summary (collapse)

Methods inherited from Expression

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

Constructor Details

- (Window) initialize(opts = OPTS)

Set the options to the options given



1705
1706
1707
# File 'lib/sequel/sql.rb', line 1705

def initialize(opts=OPTS)
  @opts = opts
end

Instance Attribute Details

- (Object) opts (readonly)

The options for this window. Options currently supported:

:frame

if specified, should be :all, :rows, or a String that is used literally. :all always operates over all rows in the partition, while :rows excludes the current row's later peers. The default is to include all previous rows in the partition up to the current row's last peer.

:order

order on the column(s) given

:partition

partition/group on the column(s) given

:window

base results on a previously specified named window



1702
1703
1704
# File 'lib/sequel/sql.rb', line 1702

def opts
  @opts
end