class Dbsketch::Rendering::SQL::TriggerRenderer

Public Instance Methods

create(trigger) click to toggle source
# File lib/dbsketch/rendering/sql/trigger_renderer.rb, line 13
def create trigger
        ### Preconditions
        raise ArgumentError, "trigger is not a Dbsketch::Model::Trigger" unless trigger.is_a? Dbsketch::Model::Trigger
        ###
        "create trigger #{trigger.name} on #{trigger.target.name} #{trigger.activation_time} as\nbegin\n\t#{trigger.algo}\nend"
end
drop(trigger) click to toggle source
# File lib/dbsketch/rendering/sql/trigger_renderer.rb, line 20
def drop trigger
        ### Preconditions
        raise ArgumentError, "trigger is not a Dbsketch::Model::Trigger" unless trigger.is_a? Dbsketch::Model::Trigger
        ###
        "if object_id('#{trigger.name}', 'TR') is not null drop trigger #{trigger.name}"
end