Rails - Populate test database with development data

Question

Is there any trivial way to copy the data from developmenet database into the test one? I know theres a way to copy schema and recreate database, but is there any rake task to populate test database with development one?

ndp · Accepted Answer · 2010-04-18 02:28:21Z

17

You can use mysql directly:

mysqldump app_development | mysql app_test

answered Apr 18, 2010 at 2:28

ndp

22.1k5 gold badges42 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Krut Over a year ago

if your not using mysql, @j0k has best answer so far with: rake db:test:clone && rake db:seed RAILS_ENV='test'

Toby Hede · Accepted Answer · 2010-04-15 12:19:31Z

14

You can use:

rake db:test:clone

To copy the development db into test.

answered Apr 15, 2010 at 12:19

Toby Hede

37.3k28 gold badges139 silver badges164 bronze badges

6 Comments

mdrozdziel Over a year ago

Doesn't work for me at all. Structure is created, but no records are copied. Is that task ment to copy the data at all? The description isn't pointing that directly.

Terra Kestrel Over a year ago

db:test:clone is a combination of db:schema:dump and db:test:prepare and does not actually copy the data

Ed Bishop Over a year ago

Unfortunately doesn't answer the question.

Pak Over a year ago

this is deprecated.

Chris Habgood Over a year ago

@mdrozdziel, the test db should never have and data, the data should be created for each test.

|

j0k · Accepted Answer · 2012-10-26 07:28:27Z

6

For all databases:

rake db:test:clone && rake db:seed RAILS_ENV='test'

edited Oct 26, 2012 at 7:28

j0k

22.8k28 gold badges81 silver badges90 bronze badges

answered Jan 4, 2012 at 13:16

drr

971 silver badge1 bronze badge

1 Comment

drr Over a year ago

ops, i thought that you wanted to populate test database with the seed.rb file.

Ollie Glass · Accepted Answer · 2014-08-09 11:23:11Z

6

With Postgres, copy the database like so:

CREATE DATABASE newdb WITH TEMPLATE originaldb OWNER dbuser;

answered Aug 9, 2014 at 11:23

Ollie Glass

20.1k24 gold badges79 silver badges109 bronze badges

1 Comment

Aymen Bou Over a year ago

I didn't use this command but it helped create a copy of the db using pgAdmin.

Jon · Accepted Answer · 2011-05-25 00:48:00Z

4

If you just want to clone the development DB in its entirety, what's wrong with just copying the development.sqlite3 and renaming it test.sqlite3? You can automate the process by setting up a batch file (or its equivalent on your OS) that you can run from the command line.

This will work locally, but I just realized you might be thinking a non-local environment, in which case it probably won't.

edited May 25, 2011 at 0:48

answered May 25, 2011 at 0:38

Jon

3102 silver badges10 bronze badges

Comments

jaycode · Accepted Answer · 2011-11-11 15:43:20Z

4

An alternative method if you use seeds (db/seeds.rb)

First, add a rake task for example to lib/tasks/test_seed.rake with this code:

namespace :db do
  namespace :test do
    task :prepare => :environment do
        Rake::Task["db:seed"].invoke
    end
  end
end

Then whenever you changed your database structure / content through migration and seeds, you can run

rake:db:test:prepare

To copy the schema and seed data.

So the complete steps would be:

rake db:migrate
rake db:seed
rake db:test:prepare

answered Nov 11, 2011 at 15:43

jaycode

2,9585 gold badges39 silver badges72 bronze badges

1 Comment

professormeowingtons Over a year ago

If you run rake db:test:prepare after rake db:seed it will delete your seed data =]

Collectives™ on Stack Overflow

Rails - Populate test database with development data

6 Answers 6

1 Comment

6 Comments

1 Comment

1 Comment

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

1 Comment

6 Comments

1 Comment

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related