Class: Sequel::Vertica::Dataset

Inherits:
Dataset
  • Object
show all
Defined in:
lib/sequel/adapters/vertica.rb

Constant Summary collapse

EXPLAIN = 
'EXPLAIN '
EXPLAIN_LOCAL = 
'EXPLAIN LOCAL '
QUERY_PLAN = 
'QUERY PLAN'

Instance Method Summary collapse

Instance Method Details

#columns ⇒ Object 



132
133
134
135
136
137
138
 
# File 'lib/sequel/adapters/vertica.rb', line 132

def columns
  return @columns if @columns
  ds = unfiltered.unordered.clone(:distinct => nil, :limit => 0, :offset => nil)
  res = @db.execute(ds.select_sql)
  @columns = res.columns.map { |c| c.name }
  @columns
end

#explain(opts = {}) ⇒ Object 



146
147
148
 
# File 'lib/sequel/adapters/vertica.rb', line 146

def explain(opts={})
  execute((opts[:local] ? EXPLAIN_LOCAL : EXPLAIN) + select_sql).map { |k, v| k == QUERY_PLAN }.join("\$")
end

#fetch_rows(sql) ⇒ Object 



140
141
142
143
144
 
# File 'lib/sequel/adapters/vertica.rb', line 140

def fetch_rows(sql)
  execute(sql) do |row|
    yield row
  end
end

#supports_regexp? ⇒ Boolean

Returns:

  • (Boolean) 


150
151
152
 
# File 'lib/sequel/adapters/vertica.rb', line 150

def supports_regexp?
  true
end