Class: Sequel::SQL::Subscript

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

Overview

Represents an SQL array access, with multiple possible arguments.

Instance Attribute Summary collapse

Instance Method Summary collapse

Methods included from Postgres::HStoreOpMethods

#hstore

Methods included from Postgres::RangeOpMethods

#pg_range

Methods included from Postgres::ArrayOpMethods

#pg_array

Methods included from Postgres::JSONOpMethods

#pg_json

Methods included from Postgres::PGRowOp::ExpressionMethods

#pg_row

Methods included from SubscriptMethods

#sql_subscript

Methods included from StringMethods

#ilike, #like

Methods included from OrderMethods

#asc, #desc

Methods included from NumericMethods

#+

Methods included from ComplexExpressionMethods

#extract, #sql_boolean, #sql_number, #sql_string

Methods included from CastMethods

#cast, #cast_numeric, #cast_string

Methods included from BooleanMethods

#~

Methods included from AliasMethods

#as

Methods inherited from Expression

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

Constructor Details

#initialize(f, sub) ⇒ Subscript

Set the array column and subscripts to the given arguments



1524
1525
1526
# File 'lib/sequel/sql.rb', line 1524

def initialize(f, sub)
  @f, @sub = f, sub
end

Instance Attribute Details

#fObject (readonly)

The SQL array column



1518
1519
1520
# File 'lib/sequel/sql.rb', line 1518

def f
  @f
end

#subObject (readonly)

The array of subscripts to use (should be an array of numbers)



1521
1522
1523
# File 'lib/sequel/sql.rb', line 1521

def sub
  @sub
end

Instance Method Details

#[](sub) ⇒ Object

Create a new Subscript by accessing a subarray of a multidimensional array.

:a.sql_subscript(2) # a[2]
:a.sql_subscript(2)[1] # a[2][1]


1542
1543
1544
# File 'lib/sequel/sql.rb', line 1542

def [](sub)
  Subscript.new(self, Array(sub))
end

#|(sub) ⇒ Object

Create a new Subscript appending the given subscript(s) to the current array of subscripts.

:a.sql_subscript(2) # a[2]
:a.sql_subscript(2) | 1 # a[2, 1]


1533
1534
1535
# File 'lib/sequel/sql.rb', line 1533

def |(sub)
  Subscript.new(@f, @sub + Array(sub))
end