Module: SchemaPlus::Triggers::Middleware::Dumper::Tables

Defined in:
lib/schema_plus/triggers/middleware.rb

Instance Method Summary collapse

Instance Method Details

#after(env) ⇒ Object

Dump



8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
 
# File 'lib/schema_plus/triggers/middleware.rb', line 8

def after(env)
  env.connection.triggers.each do |table_name, trigger_name|
    next if env.dumper.ignored?(table_name)
    trigger, definition = env.connection.trigger_definition(table_name, trigger_name)
    heredelim           = "END_TRIGGER_#{table_name.upcase}_#{trigger_name.upcase}"
    statement           = "        create_trigger \"\#{table_name}\", \"\#{trigger_name}\", \"\#{trigger}\", <<-'\#{heredelim}', :force => true\n      \#{definition}\n        \#{heredelim}\n\n    ENDTRIGGER\n\n    env.dump.final << statement\n  end\nend\n"