RE: 'Delete', not just 'retire' users?

Thanks for speedy suggestions Richard and Jean. 

Actually, we found that exporting and importing the user table to CSV
seemed the easiest solution (didn't want to spend to much time learning
the joys of python). Note that we didn't actually need to edit the
table, as unwanted users were already retired and weren't included in
the export. 

Seems like a simple solution for cases like ours, but I presume you have
to be very careful not to delete users reference in other tables (as
Richard noted).

-Gordon
 
> > We had a mishap where a large number of users (~1500) were
> accidentally
> > added to our Roundup user list (don't ask - our tracker email
address
> > got on a mailing list with tons of people on the 'to' line, so
Roundup
> > added them all). Since then, Roundup has been running very slowly
(its
> > on an old machine and we aren't using the most efficient db).
> >
> > We went through and retired the unwanted users, but roundup is still
> > slow. Is there is a way to 'delete' users rather than just retire
> them?
> > I realize you would not usually do this, as it might break links in
> the
> > hyperdb.
> 
> The Item class destroy() method was written for this sort of extreme
> case.
> From its docstring:
> 
>    WARNING: this method should never be used except in extremely rare
>             situations where there could never be links to the item
> being
>             deleted
>    WARNING: use retire() instead
>    WARNING: the properties of this item will not be available ever
again
>    WARNING: really, use retire() instead
> 
> The hyperdb *will break* if you delete an item which is referenced by
> another
> item.
> 
> Let me know if you need help writing the code. The example scripts
that
> come
> with Roundup should provide a starting point though.
> 
> 
>     Richard



-------------------------------------------------------
This SF.net email is sponsored by:  Etnus, makers of TotalView, The best
thread debugger on the planet. Designed with thread debugging features
you've never dreamed of, try TotalView 6 free at www.etnus.com.