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