SONAR-4178 Delete Oracle triggers when dropping table

1 files changed, 31 insertions, 6 deletions

diff --git a/sonar-server/src/main/webapp/WEB-INF/config/environment.rb b/sonar-server/src/main/webapp/WEB-INF/config/environment.rb
index 259de14ed11..98b97b52c8e 100644
--- a/sonar-server/src/main/webapp/WEB-INF/config/environment.rb
+++ b/sonar-server/src/main/webapp/WEB-INF/config/environment.rb
@@ -126,7 +126,7 @@ class ActiveRecord::Migration
         change_column(tablename, columnname, :big_integer, :null => true)
     end
   end
-  
+
   # SONAR-4178
   def self.create_table(table_name, options = {})
     super(table_name, options)
@@ -137,12 +137,22 @@ class ActiveRecord::Migration
         # Do nothing
     end
   end
-  
+
+  def drop_table(table_name, options = {})
+    super(table_name, options)
+    case dialect()
+      when "oracle"
+        drop_id_trigger(table_name)
+      else
+        # Do nothing
+    end
+  end
+
   def self.create_id_trigger(table)
-      execute_ddl("create trigger for table #{table}", 
-      
+      execute_ddl("create trigger for table #{table}",
+
       %{CREATE OR REPLACE TRIGGER #{table}_id_trg
-          BEFORE INSERT ON #{table} 
+          BEFORE INSERT ON #{table}
           FOR EACH ROW
         BEGIN
            IF :new.id IS null THEN
@@ -151,6 +161,21 @@ class ActiveRecord::Migration
         END;})
   end
 
+
+  def self.drop_id_trigger(table)
+      execute_ddl("drop trigger for table #{table}",
+
+      %{DECLARE
+          e EXCEPTION;
+          PRAGMA EXCEPTION_INIT(e,-4080);
+        BEGIN
+           EXECUTE IMMEDIATE 'DROP TRIGGER #{table}_id_trg';
+        EXCEPTION
+          WHEN e THEN
+            NULL;
+        END;})
+  end
+
   private
 
   def self.execute_ddl(message, ddl)
@@ -192,4 +217,4 @@ DatabaseVersion.automatic_setup
 # Some changes have been done in activerecord-jdbc-adapter. Most of them relate to column types.
 # All these changes are prefixed by the comment #sonar
 #
-#
\ No newline at end of file
+#