Ruby on Rails

The id is coming from an auto-increment column in your database. There are two options if you want to reset to start at 1:

* You can roll back your migrations until you drop the table,
* or your can use SQL: truncate table [your_table_name] in a SQL console.

Really, though, the numerical ID is utterly meaningless, so it's not clear why you would care that the ID start back at 1 or not. It matters to the database, because it's the primary key, so there's a real need for it to never repeat ever. But unless you're worried about a few digits in a 64-bit numberspace... You have larger issues to worry about if you ever hit the end of that possible id value.

Walter

> On Dec 23, 2017, at 9:02 AM, Robert Phillips <robert.phillips37@gmail.com> wrote:
>
> I've got the program in chapter 2.
>
> is there anything i can type in the console to reset the id? I can do e.g. User.delete_all and delete all users, but if a new user is then created it doesn't have an id of 1 'cos the id doesn't reset.
>
> this User.reset_primary_key doesn't work either.
>
> Notice how I removed all users I reset the primary key, I added a user, and they got quite a high id.
> irb(main):064:0> User.first
> User Load (1.0ms) SELECT "users".* FROM "users" ORDER BY "user
> => nil
> irb(main):065:0> User.primary_key
> => "id"
> irb(main):066:0> User.reset_primary_key
> => "id"
> irb(main):067:0> User.first
> User Load (0.0ms) SELECT "users".* FROM "users" ORDER BY "user
> => #<User id: 13, name: "f", email: "f", created_at: "2017-12-23 0
> irb(main):068:0>
>
>
>
> I get this error
>
> C:\rubyarud\hartl\ch2\toy_app>rails db:drop
> Permission denied @ unlink_internal - C:/rubyarud/h
> Couldn't drop database 'db/development.sqlite3'
> rails aborted!
> Errno::EACCES: Permission denied @ unlink_internal
> bin/rails:4:in `require'
> bin/rails:4:in `<main>'
> Tasks: TOP => db:drop:_unsafe
> (See full trace by running task with --trace)
>
>
>
> I notice the error mentions sqlite. I'm using the correct gem file, I think. https://pastebin.com/E2R77amU I know the gemfile in the book that we are to use moves sqlite into the development and test groups. I have that and am using the gemfile that the book gives.
>
> Is there anything I can do from the console to reset it?
>
> Thanks
>
>
> --
> You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
> To post to this group, send email to rubyonrails-talk@googlegroups.com.
> To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/128e2eaa-2168-4ae9-b1fc-bcabcbb7a39a%40googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/88CAF5E2-447F-4EE7-840C-D3D63FA60D2A%40wdstudio.com.
For more options, visit https://groups.google.com/d/optout.