The scenario when one would get deleted would be if the user doesn't mail out the Invitation with RSVP ID #5, but mails out all others from #1-#20, then deletes #5 for whatever reason.
As long as per user there are no duplicate RSVP ID's that's all that matters. The user is the owner of all my application data models. On May 10, 9:36 pm, Matt Jones <[email protected]> wrote: > On May 10, 2010, at 6:54 PM, Jeremy Savoy wrote: > > > > > > > Not saying no gaps, in fact if an Invitation is deleted the gap in > > numbers must remain, because once you physically write an RSVP ID on > > an invitation and send it out in the mail, then that RSVP ID must not > > be changed by the software. > > > This is why acts_as_list wont' work, because when you remove one all > > records beyond that would get renumbered (reordered really). > > > The RSVP ID is used to quickly locate the record in the system by the > > user when the RSVP is returned in the mail. This is a hard > > requirement. > > > So each invitation/rsvp needs it's own unique id, but invitation_id > > won't work because that is unique for the entire table. Each user > > needs to have their set of RSVP ID's start at 1 (Invitations and RSVPs > > are tracked by the same model and the terms are used interchangeably > > here) > > Right, but why delete an RSVP record? Especially if there's paper mail > involved, I'd have guessed it would be good to have the ability to get > a total aggregate count of what went out (possibly broken out by > status: "sent", "discarded", "undeliverable", etc). But if deletion is > an absolute requirement *and* there's only going to be one person > creating RSVPs at a time for a particular user, Henry's solution looks > like it would work. Add in multiple users, and you'll eventually end > up with duplicate RSVP IDs. > > --Matt Jones > > -- > You received this message because you are subscribed to the Google Groups > "Hobo Users" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group > athttp://groups.google.com/group/hobousers?hl=en. -- You received this message because you are subscribed to the Google Groups "Hobo Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/hobousers?hl=en.
