module Spectacles::SchemaStatements::VerticaAdapter
Public Instance Methods
view_build_query(view, name = nil)
click to toggle source
# File lib/spectacles/schema_statements/vertica_adapter.rb, line 16 def view_build_query(view, name = nil) q = <<-SQL SELECT view_definition FROM v_catalog.views WHERE table_name = '#{view}' SQL select_value(q, name) or raise "No view called #{view} found" end
views(name = nil)
click to toggle source
# File lib/spectacles/schema_statements/vertica_adapter.rb, line 8 def views(name = nil) q = <<-SQL SELECT table_name FROM v_catalog.views SQL execute(q, name).map { |row| row['table_name'] } end