Rails - Apr 2009 - Re: how to combine SQL queries in self.up

ActiveRecord is available to you. Inside the self.up, you can do:

AnyArbitraryModel.connection.execute(all_of_your_sql)

Any model in your app will do, as you are bypassing your model''s  
business rules and going directly to the connection. The return is a  
Mysql::Result, which you can look up here: http://www.tmtm.org/en/ruby/mysql/

Hope this helps.

On Apr 28, 2009, at 9:31 PM, Vipin wrote:
>
> Hi
>
> How can i combine multiple SQL statements into one place in self.up in
> a migration.
> For the following, method if i combine 3 SQL statements into one
> section I get the error.
>
> ######### following works fine
> def self.up
>      execute <<-EOF
> 	CREATE TABLE pks (SNO TINYINT,BUSNO CHAR(20),EXPTIME TIME, PRIMARY
> KEY (SNO));
>      EOF
>      execute <<-EOF
> INSERT INTO pks (SNO,BUSNO,EXPTIME)
VALUES(''1'',''5L'',080000);
>      EOF
>      execute <<-EOF
> INSERT INTO pks (SNO,BUSNO,EXPTIME)
VALUES(''2'',''5A'',081500);
>      EOF
>
>  end
>
> ########## it doesn''t work
>
> def self.up
>      execute <<-EOF
> 	CREATE TABLE pks (SNO TINYINT,BUSNO CHAR(20),EXPTIME TIME, PRIMARY
> KEY (SNO));
> INSERT INTO pks (SNO,BUSNO,EXPTIME)
VALUES(''1'',''5L'',080000);
> INSERT INTO pks (SNO,BUSNO,EXPTIME)
VALUES(''2'',''5A'',081500);
>      EOF
>
>  end
>
> >

> AnyArbitraryModel.connection.execute(all_of_your_sql)
>
but in my case, my whole of the data is static and i want to populate
into the table at the time of migration itself.
It is going to be like creation of table followed by insertion of
1000s of rows into them.

Will it work there too?
If possible can you please explain the syntax of above command in the
context of my problem.

--vipin