class Sequel::Postgres::JSONBSubscriptOp

  1. lib/sequel/extensions/pg_json_ops.rb
Superclass: Expression

Represents JSONB subscripts. This is abstracted because the subscript support depends on the database version.

Methods

Public Class

  1. new

Public Instance

  1. expression
  2. sequel_ast_transform
  3. sub
  4. to_s_append

Constants

SUBSCRIPT = ["".freeze, "[".freeze, "]".freeze].freeze  

Attributes

expression [R]

The expression being subscripted
sub [R]

The subscript to use

Public Class methods

new(expression, sub)

Set the expression and subscript to the given arguments

[show source] 
    # File lib/sequel/extensions/pg_json_ops.rb
689 def initialize(expression, sub)
690   @expression = expression
691   @sub = sub
692   freeze
693 end

Public Instance methods

sequel_ast_transform(transformer)

Support transforming of jsonb subscripts

[show source] 
    # File lib/sequel/extensions/pg_json_ops.rb
703 def sequel_ast_transform(transformer)
704   self.class.new(transformer.call(@expression), transformer.call(@sub))
705 end
to_s_append(ds, sql)

Use subscripts instead of -> operator on PostgreSQL 14+

[show source] 
    # File lib/sequel/extensions/pg_json_ops.rb
696 def to_s_append(ds, sql)
697   server_version = ds.db.server_version
698   frag = server_version && server_version >= 140000 ? SUBSCRIPT : JSONOp::GET
699   ds.literal_append(sql, Sequel::SQL::PlaceholderLiteralString.new(frag, [@expression, @sub]))
700 end