rails generate migration command to insert data into the table

Question

I have a table and I had to add a migration script to add rows in the table. Please help with the rails generate migration command to insert data into the table.

Thanks, Ramya.

Answer 1

You can write regular ruby code inside a migration. So you can simply do something like this:

class Foo < ActiveRecord::Migration
  def self.up
    User.create(:username => "Hello", :role => "Admin")
  end
  def self.down
    User.delete_all(:username => "Hello")
  end
end

Just write regular ruby inside your migration same as you would in pry or rails console.

Answer 2

The code helped me is the sql statement as show

In migration file

def up
execute("insert into salary_ranges(salary_range) values('Above 2000');")
end