class Dbsketch::Rendering::SQL::ViewRenderer

Public Instance Methods

create(view) click to toggle source
# File lib/dbsketch/rendering/sql/view_renderer.rb, line 13
def create view
        ### Preconditions
        raise ArgumentError, "view is not a Dbsketch::Model::View" unless view.is_a? Dbsketch::Model::View
        ###
        "create view #{view.name} as #{view.query}"
end
drop(view) click to toggle source
# File lib/dbsketch/rendering/sql/view_renderer.rb, line 20
def drop view
        ### Preconditions
        raise ArgumentError, "view is not a Dbsketch::Model::View" unless view.is_a? Dbsketch::Model::View
        ###
        "if object_id('#{view.name}', 'V') is not null drop view #{view.name}"
end