Ruby-on-rails – Execute sql script inside seed.rb in rails3

ruby-on-railsseed

I want to execute this sql script inside my seed.rb

LOAD DATA LOCAL INFILE '/home/list-38.csv'
INTO TABLE list
FIELDS TERMINATED BY ':'
LINES TERMINATED BY '\n'
(email,name,password);

I checked this link but unable to figure out the solution.So that once we run rake db:seed

How to seed mysql database by running sql scripts in Ruby Rails platform? it dumps my data into the table.

any queries ..do reply

Thanx

Best Answer

Try this in db/seeds.rb to execute raw SQL with rake db:seed

connection = ActiveRecord::Base.connection()
connection.execute("*_YOUR_SQL_HERE_*")

Related Solutions

Ruby-on-rails – Why is rake db:migrate:reset not listed in rake -T

Tasks that don't have a description will not show up.

EDIT: Looks like DHH removed the description from Rails 3 for a few tasks to 'cut down on noise'. rake db:setup has a note about db:reset though.

http://github.com/rails/rails/commit/983815632cc1d316c7c803a47be28f1abe6698fb

Mysql – How to seed thesql database by running sql scripts in Ruby Rails platform

I personally don't like using migrations to seed large amounts of "static" data. You can easily execute sql statements from db/seeds.rb by:

# Empty the soon-to-be-seeded table
MyModel.delete_all

# Get the current DB connection
connection = ActiveRecord::Base.connection();

# Execute a sql statement
connection.execute("Insert INTO my_models (id, name) VALUES
    (1, 'Example 1'),
    (2, 'Example 2'),
    (3, 'Example 3');")

Basically, once you have the current connection, you can just call a sql statement useing connection.execute("SQL CODE HERE").

Best Answer

Related Solutions

Ruby-on-rails – Why is rake db:migrate:reset not listed in rake -T

Mysql – How to seed thesql database by running sql scripts in Ruby Rails platform

Related Topic