Class: ScideaSchools02RemoveMenu

Inherits:
ActiveRecord::Migration
  • Object
show all
Defined in:
lib/generators/scidea/schools/templates/scidea_schools_02_remove_menu.rb

Instance Method Summary collapse

Instance Method Details

#down ⇒ Object 



7
8
9
10
11
12
13
14
15
16
17
18
19
20
 
# File 'lib/generators/scidea/schools/templates/scidea_schools_02_remove_menu.rb', line 7

def down

  sql = <<-SQL
    set @course_and_scitent_admins = (select group_concat(id) from roles where symbol in ('course_admin', 'scitent_admin'));
    set @product_and_scitent_admins = (select group_concat(id) from roles where symbol in ('product_admin', 'scitent_admin'));

    SELECT @admin_nav_secondary_id:=id FROM menus WHERE name = 'Admin Navigation: Secondary' LIMIT 1;

    INSERT INTO menu_elements (display_name, menu_id, url, view_role_list, edit_role_list, order_sequence) VALUES ('Educational Institutions', @admin_nav_secondary_id, '/admin/schools', @course_and_scitent_admins, @product_and_scitent_admins, 102);
  SQL

  sql.split("\n").reject{|s| s.strip.start_with?('#') || s.strip.empty? }.each{ |s| execute s.strip }

end

#up ⇒ Object 



3
4
5
 
# File 'lib/generators/scidea/schools/templates/scidea_schools_02_remove_menu.rb', line 3

def up
  execute "delete from menu_elements where display_name = 'Educational Institutions';"
end