Class: ScideaSchools01Install

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

Instance Method Summary collapse

Instance Method Details

#down ⇒ Object 



30
31
32
33
34
 
# File 'lib/generators/scidea/schools/templates/scidea_schools_01_install.rb', line 30

def down
  drop_table :schools
  remove_column :profiles, :school_id
  execute "delete from menu_elements where display_name = 'Educational Institutions';"
end

#up ⇒ Object 



2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
 
# File 'lib/generators/scidea/schools/templates/scidea_schools_01_install.rb', line 2

def up
  create_table "schools" do |t|
    t.string   "name"
    t.string   "address_1"
    t.string   "address_2"
    t.string   "city"
    t.string   "state"
    t.string   "zipcode"
    t.boolean  "approved"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "phone"
  end

  add_column :profiles, :school_id, :integer

  sql = "    set @course_and_scitent_admins = (select group_concat(id) from roles where symbol in ('course_admin', 'scitent_admin'));\n    set @product_and_scitent_admins = (select group_concat(id) from roles where symbol in ('product_admin', 'scitent_admin'));\n    \n    SELECT @admin_nav_secondary_id:=id FROM menus WHERE name = 'Admin Navigation: Secondary' LIMIT 1;\n\n    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);\n  SQL\n\n  sql.split(\"\\n\").reject{|s| s.strip.start_with?('#') || s.strip.empty? }.each{ |s| execute s.strip }\nend\n"