4523: add a new migration script that invokes search_index migration down and up...

diff --git a/services/api/db/migrate/20150122175935_no_description_in_search_index.rb b/services/api/db/migrate/20150122175935_no_description_in_search_index.rb
new file mode 100644 (file)
index 0000000..01f94e5
--- /dev/null
+++ b/services/api/db/migrate/20150122175935_no_description_in_search_index.rb
@@ -0,0 +1,24 @@
+require "./db/migrate/20141208185217_search_index.rb"
+
+class NoDescriptionInSearchIndex < ActiveRecord::Migration
+  def change
+    all_tables = %w{collections groups jobs pipeline_instances pipeline_templates}
+    all_tables.each do |table|
+      indexes = ActiveRecord::Base.connection.indexes(table)
+      search_index_by_name = indexes.select do |index|
+        index.name == "#{table}_search_index"
+      end
+
+      index_columns = search_index_by_name.first.andand.columns
+      has_description = index_columns.select.each do |column|
+        column == 'description'
+      end
+
+      if !has_description.empty?
+        SearchIndex.new.migrate(:down)
+        SearchIndex.new.migrate(:up)
+        break
+      end
+    end
+  end
+end

diff --git a/services/api/db/structure.sql b/services/api/db/structure.sql
index 96180c7d3c008e1abf2a6f8fa8f957d53853ff15..e1b9702a0b9c1087fb7efcaa618db2ce77f025ab 100644 (file)
--- a/services/api/db/structure.sql
+++ b/services/api/db/structure.sql
@@ -2314,4 +2314,6 @@ INSERT INTO schema_migrations (version) VALUES ('20141208174553');
 
 INSERT INTO schema_migrations (version) VALUES ('20141208174653');
 
-INSERT INTO schema_migrations (version) VALUES ('20141208185217');
\ No newline at end of file
+INSERT INTO schema_migrations (version) VALUES ('20141208185217');
+
+INSERT INTO schema_migrations (version) VALUES ('20150122175935');
\ No newline at end of file