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