How to purge discarded review requests?

2011-02-13 Thread Renier
Hello, I'm looking for hints on how to purge discarded review
requests. Which tables would I need to look at or what would be a good
way to do this?

-Renier

-- 
Want to help the Review Board project? Donate today at 
http://www.reviewboard.org/donate/
Happy user? Let us know at http://www.reviewboard.org/users/
-~--~~~~--~~--~--~---
To unsubscribe from this group, send email to 
reviewboard+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/reviewboard?hl=en


Re: How to purge discarded review requests?

2011-02-13 Thread Christian Hammond
Purge, as in from the database?

In general, I'd say deleting from the database isn't a great idea, because
having history is a good thing. However, if you really want to do it, you
*need* to do it from a Python script, not modifying SQL. You will end up
having problems with state.

You can do:

$ rb-site manage /path/to/site shell
 from reviewboard.reviews.models import ReviewRequest
 ReviewRequest.objects.filter(status='D').delete()

Back up your database first.

Christian

-- 
Christian Hammond - chip...@chipx86.com
Review Board - http://www.reviewboard.org
VMware, Inc. - http://www.vmware.com


On Sun, Feb 13, 2011 at 1:22 PM, Renier renier.mora...@gmail.com wrote:

 Hello, I'm looking for hints on how to purge discarded review
 requests. Which tables would I need to look at or what would be a good
 way to do this?

-Renier

 --
 Want to help the Review Board project? Donate today at
 http://www.reviewboard.org/donate/
 Happy user? Let us know at http://www.reviewboard.org/users/
 -~--~~~~--~~--~--~---
 To unsubscribe from this group, send email to
 reviewboard+unsubscr...@googlegroups.com
 For more options, visit this group at
 http://groups.google.com/group/reviewboard?hl=en

-- 
Want to help the Review Board project? Donate today at 
http://www.reviewboard.org/donate/
Happy user? Let us know at http://www.reviewboard.org/users/
-~--~~~~--~~--~--~---
To unsubscribe from this group, send email to 
reviewboard+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/reviewboard?hl=en