Raw SQL in Migrations?

rubyonrails-talk
1

After reading AWDWR and searching the API, it appears the Rails' implementation of Migrations has no way to execute a raw SQL statement. True?

-- gw

2

Greg -

3

After reading AWDWR and searching the API, it appears the Rails' implementation of Migrations has no way to execute a raw SQL statement. True?

Simple, just use execute:

class MyMigration < ActiveRecord::Migration   def self.up     execute "alter table bar add constraint fk_bar_foo foreign key (foo_id) references foo(id)"   end

  def self.down     # ...   end end

4

Doh! Found it (in AWDWR not in the API docs). Funny, it uses the same execute command that I opted for when I wrote a migrations framework for Lasso :stuck_out_tongue:

-- gw