You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
29 lines
731 B
29 lines
731 B
class CreateUserClasses < ActiveRecord::Migration[5.2]
|
|
def change
|
|
unless table_exists?(:user_classes)
|
|
create_table :user_classes do |t|
|
|
t.string :name
|
|
t.boolean :is_use, default:true,comment:"是否启用"
|
|
|
|
t.timestamps
|
|
end
|
|
arr = []
|
|
sql = "select * from class_table"
|
|
data = ActiveRecord::Base.connection.execute(sql)
|
|
arr += data.map{|item| item[0]}
|
|
array = (1..22).to_a
|
|
array.each do |item|
|
|
sql = "select * from week#{item}"
|
|
data = ActiveRecord::Base.connection.execute(sql)
|
|
arr += data.map{|item| item[0]}
|
|
end
|
|
arr = arr.uniq
|
|
|
|
arr.each do |item|
|
|
UserClass.create(name:item)
|
|
end
|
|
end
|
|
|
|
end
|
|
end
|