Search code examples
ruby-on-rails-3sqlite3-ruby

Rails database ID number not being updated with destroy call

I'm new to rails so maybe the record id is not updated on destroy.

I used rails scaffold to generate my MVC for a products page. When I add an entry to my data base through my products/new page it adds an id number to the entry. When in a browser if I rollover the show/edit/destroy links on my index view it will give me a url link of localhost:3000/products/1. Now if I remove the entry by using the destroy link it removes the entry correctly, but now when I add another entry it shows the id as 2 not 1. Why does it remove the entry from the database but not reset the id back to 1.

This is for the build in server in rails app sqlite3.

Solution

  • you would have to rake db:drop your database (which deletes it) and then rake db:migrate to create your tables again.