Hello All, So I am new to rails and the first project I am creating is a ticketing system to log customer support. All I am trying to do is have the primary id of each new ticket auto increment like ticket id 1001, 1002, 1003, ect. and display the ticket id in the show tickets. I am confused because I''m not sure if this would be created doing a migration or in the model tickets after the migration has been done?? Any help would be great. Thanks, Duggan --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
kingduggan wrote:> Hello All, > > So I am new to rails and the first project I am creating is a > ticketing system to log customer support. All I am trying to do is > have the primary id of each new ticket auto increment like ticket id > 1001, 1002, 1003, ect. and display the ticket id in the show tickets. > > I am confused because I''m not sure if this would be created doing a > migration or in the model tickets after the migration has been done?? > > Any help would be great.Unless I''m not understanding the question, you already have this. With ActiveRecord, (by default) every record has an id that will be unique. You don''t have to do anything to get it. While you can override it, every table has a field named ''id''. This will be incremented and maintained by the system. In MySQL it will be an ''auto_increment'' field and defined as the primary key. ---Michael -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Thank you very much. You are right about the id and that is sufficient for me to use as ticket id. Now just for personal know how, How can I change the id from numbering 1,2,3 to 1001, 1002, 1003? On Sun, Apr 5, 2009 at 1:16 PM, Michael Satterwhite < rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> > kingduggan wrote: > > Hello All, > > > > So I am new to rails and the first project I am creating is a > > ticketing system to log customer support. All I am trying to do is > > have the primary id of each new ticket auto increment like ticket id > > 1001, 1002, 1003, ect. and display the ticket id in the show tickets. > > > > I am confused because I''m not sure if this would be created doing a > > migration or in the model tickets after the migration has been done?? > > > > Any help would be great. > > Unless I''m not understanding the question, you already have this. > > With ActiveRecord, (by default) every record has an id that will be > unique. You don''t have to do anything to get it. While you can override > it, every table has a field named ''id''. This will be incremented and > maintained by the system. In MySQL it will be an ''auto_increment'' field > and defined as the primary key. > > ---Michael > -- > Posted via http://www.ruby-forum.com/. > > > >--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Duggan Roberts wrote:> Thank you very much. You are right about the id and that is sufficient > for > me to use as ticket id. Now just for personal know how, How can I change > the > id from numbering 1,2,3 to 1001, 1002, 1003? > > On Sun, Apr 5, 2009 at 1:16 PM, Michael Satterwhite <Either as a migration or as raw SQL, enter the following statement: Alter table <table-name> AUTO_INCREMENT = 1000; -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Is it approved of to use the id as a meaningful number? I have always assumed that you should not do this as, for example, once you have added number 1000 and deleted it (possibly by mistake) you cannot ever use this number again (without hacking). If you need a meaningful number then I would suggest adding a ticket_number field and controlling this by hand. 2009/4/6 Michael Satterwhite <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org>> > Duggan Roberts wrote: > > Thank you very much. You are right about the id and that is sufficient > > for > > me to use as ticket id. Now just for personal know how, How can I change > > the > > id from numbering 1,2,3 to 1001, 1002, 1003? > > > > On Sun, Apr 5, 2009 at 1:16 PM, Michael Satterwhite < > > Either as a migration or as raw SQL, enter the following statement: > > Alter table <table-name> AUTO_INCREMENT = 1000; > > > -- > Posted via http://www.ruby-forum.com/. > > > >--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---