If I understand your question properly, I think Record Versioning could do it.
http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Record-versioning If you 'deleted' auth_user.id == 1, all that happens then is that the is_active field gets set to False. You could then search for it and make your updates as it didn't really get deleted from the DB. Then just change is_active back to True. -Jim On Tuesday, November 3, 2015 at 12:25:07 PM UTC-6, Alex Glaros wrote: > > I'd lilke to reuse a primary key that has been deleted > > For example, I'd like to take deleted auth_user.id == 1, and change the > first_name and other field data in it for reuse. > > Same for other tables, for example, db.Organization.id ==1, would like to > replace old org name with "Department of Motor Vehicles" > > Those primary keys have been deleted and records are not accessible so I > can't edit them. > > The only way I can think of doing it is to drop table and re-enter data in > correct order. > > thanks, > > Alex Glaros > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
