rails db create_migration code example

Example 1: how create migration rails

rails g migration AddPartNumberToProducts

Example 2: 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

Example 3: using SQL in rails migration

def change
  execute <<-SQL
    UPDATE table1
    SET column1 = "value"
  SQL
end

Tags:

Sql Example

Related