create a new migration in rails code example
Example 1: how create migration rails
rails g migration AddPartNumberToProducts
Example 2: activerecord add column
class AddPartNumberToProducts < ActiveRecord::Migration[6.0]
def change
add_column :products, :part_number, :string
end
end
Example 3: how to create an SQL table in ruby
def self.create_table
sql = <<-SQL
CREATE TABLE IF NOT EXISTS students (
name TEXT,
grade TEXT
)
SQL
DB[:conn].execute(sql)
end