rails test database cloning dev database

Question

I'm new to Ruby on Rails and following Michael Hartls Ruby on Rails Tutorial. When I run bundle rake exec test, I am getting this error:

ERROR["test_should_get_new", SessionsControllerTest, 2.331314]
test_should_get_new#SessionsControllerTest (2.33s)
ActiveRecord::StatementInvalid:         
ActiveRecord::StatementInvalid: Could    not find table 'users'

and once similar for all of my tests. I see that my test database: test.sqlite3 is empty. My development database development.sqlite3 does have the users table in it.

I tried running the following to attempt cloning the users database to the test database, but nothing is working:

rake db:migrate:reset
rake db:migrate db:test:prepare

rake db:test:clone

rake db:test:prepare
rake db:test:load

but it's still empty. Any suggestions please?

Can you post your config/database.yml

MZaragoza
– MZaragoza

2015-12-21 00:01:43 +00:00
Commented Dec 21, 2015 at 0:01 — MZaragoza
– MZaragoza, Commented Dec 21, 2015 at 0:01

James Milani · Accepted Answer · 2015-12-20 21:26:29Z

1

I think you might be able to get it with:

RAILS_ENV=test rake db:migrate

Give it a try, I've had this problem before myself. I believe that

rake db:test:prepare

is deprecated. What version of ruby and rails are you using?

answered Dec 20, 2015 at 21:26

James Milani

1,9532 gold badges16 silver badges26 bronze badges

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

Comments

user2884789 · Accepted Answer · 2015-12-21 03:59:18Z

1

I figured out a fix, although I'm still not sure why there was a problem to begin with. What I did was I took the pure Sql CREATE TABLE used to create the development table and executed it in the users table. Now everything is working fine.

answered Dec 21, 2015 at 3:59

user2884789

5331 gold badge11 silver badges22 bronze badges

Collectives™ on Stack Overflow

rails test database cloning dev database

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related