rails c not using the same database as rails db

Question

I just realized that when I run rails c I'm getting a different database than when I run rails db.

I initially though the console wasn't connecting to the database at all because it kept returning empty sets, for instance when running User.all, despite having seed data. I then inserted data into the database via the console and did a query from the SQLite console. The new data did not appear even after reloading the console.

My confusion is further exacerbated by the fact that I only have the db/development.sqlite3 file and rails r "puts Rails.env" returns Development.

So where might I have gone wrong here? Why is one using the development database and the other seemingly using something else? Could rake db:seed be pushing to Test perhaps? Is there a way to check the SQLite console for the environment?

theillien · Accepted Answer · 2016-08-02 06:28:16Z

2

Turns out Spring was causing the problem. I had a previous app with the same name and it was loading that when I opened the rails console despite being in the newer app directory.

I've disabled Spring with the DISABLE_SPRING variable and now things are working as expected.

answered Aug 2, 2016 at 6:28

theillien

1,4364 gold badges23 silver badges38 bronze badges

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

1 Comment

XYZ Over a year ago

Having the same issue. Save me about 30mins. Thanks

Collectives™ on Stack Overflow

rails c not using the same database as rails db

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related