Executing raw SQL in migrations?

Rails
1

How can I execute raw SQL statements (like ‘alter table …’) in
migrations? IIRC, AR’s execute function isn’t available, or I wasn’t
accessing it right.

Thanks,
Joe

2

execute should work fine - I do it all the time

Fred

3

execute “ALTER TABLE …”

ed

On 11/1/06, Joe R. MUDCRAP-CE [email protected]
wrote:

Posted via http://www.ruby-forum.com/.

–
Ed Hickey
Developer
Litmus Media
816-533-0409
[email protected]
A Member of Think Partnership, Inc
www.ThinkPartnership.com
Amex ticker symbol: THK

4

On 11/1/06, Joe R. MUDCRAP-CE [email protected]
wrote:

How can I execute raw SQL statements (like ‘alter table …’) in
migrations? IIRC, AR’s execute function isn’t available, or I wasn’t
accessing it right.

execute ‘alter table …’

jeremy

5

On 11/1/06, Joe R. MUDCRAP-CE [email protected]
wrote:

How can I execute raw SQL statements (like ‘alter table …’) in
migrations? IIRC, AR’s execute function isn’t available, or I wasn’t
accessing it right.

def self.up
s = "alter table foo…;’
execute s
end

–
_Deirdre http://deirdre.net/

6

On Wednesday 01 November 2006 23:24, Joe R. MUDCRAP-CE wrote:

How can I execute raw SQL statements (like ‘alter table …’) in
migrations? IIRC, AR’s execute function isn’t available, or I wasn’t
accessing it right.

Just call unqualified execute.

Michael

–
Michael S.
mailto:[email protected]
http://www.schuerig.de/michael/