]>
Commit | Line | Data |
---|---|---|
01e3b242 MKG |
1 | #!/usr/bin/env perl |
2 | # BEGIN BPS TAGGED BLOCK {{{ | |
3 | # | |
4 | # COPYRIGHT: | |
5 | # | |
6 | # This software is Copyright (c) 1996-2013 Best Practical Solutions, LLC | |
7 | # <sales@bestpractical.com> | |
8 | # | |
9 | # (Except where explicitly superseded by other copyright notices) | |
10 | # | |
11 | # | |
12 | # LICENSE: | |
13 | # | |
14 | # This work is made available to you under the terms of Version 2 of | |
15 | # the GNU General Public License. A copy of that license should have | |
16 | # been provided with this software, but in any event can be snarfed | |
17 | # from www.gnu.org. | |
18 | # | |
19 | # This work is distributed in the hope that it will be useful, but | |
20 | # WITHOUT ANY WARRANTY; without even the implied warranty of | |
21 | # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU | |
22 | # General Public License for more details. | |
23 | # | |
24 | # You should have received a copy of the GNU General Public License | |
25 | # along with this program; if not, write to the Free Software | |
26 | # Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA | |
27 | # 02110-1301 or visit their web page on the internet at | |
28 | # http://www.gnu.org/licenses/old-licenses/gpl-2.0.html. | |
29 | # | |
30 | # | |
31 | # CONTRIBUTION SUBMISSION POLICY: | |
32 | # | |
33 | # (The following paragraph is not intended to limit the rights granted | |
34 | # to you to modify and distribute this software under the terms of | |
35 | # the GNU General Public License and is only of importance to you if | |
36 | # you choose to contribute your changes and enhancements to the | |
37 | # community by submitting them to Best Practical Solutions, LLC.) | |
38 | # | |
39 | # By intentionally submitting any modifications, corrections or | |
40 | # derivatives to this work, or any other work intended for use with | |
41 | # Request Tracker, to Best Practical Solutions, LLC, you confirm that | |
42 | # you are the copyright holder for those contributions and you grant | |
43 | # Best Practical Solutions, LLC a nonexclusive, worldwide, irrevocable, | |
44 | # royalty-free, perpetual, license to use, copy, create derivative | |
45 | # works based on those contributions, and sublicense and distribute | |
46 | # those contributions and any derivatives thereof. | |
47 | # | |
48 | # END BPS TAGGED BLOCK }}} | |
af59614d | 49 | use 5.10.1; |
01e3b242 MKG |
50 | use strict; |
51 | use warnings; | |
52 | ||
53 | use RT; | |
54 | RT::LoadConfig(); | |
af59614d | 55 | RT->Config->Set('LogToSTDERR' => 'debug'); |
01e3b242 MKG |
56 | RT::Init(); |
57 | ||
58 | use RT::CachedGroupMembers; | |
59 | my $cgms = RT::CachedGroupMembers->new( RT->SystemUser ); | |
60 | $cgms->Limit( | |
61 | FIELD => 'id', | |
62 | OPERATOR => '!=', | |
63 | VALUE => 'main.Via', | |
64 | QUOTEVALUE => 0, | |
65 | ENTRYAGGREGATOR => 'AND', | |
66 | ); | |
67 | $cgms->FindAllRows; | |
68 | ||
69 | my $alias = $cgms->Join( | |
70 | TYPE => 'LEFT', | |
71 | FIELD1 => 'Via', | |
72 | TABLE2 => 'CachedGroupMembers', | |
73 | FIELD2 => 'id', | |
74 | ); | |
75 | $cgms->Limit( | |
76 | ALIAS => $alias, | |
77 | FIELD => 'MemberId', | |
78 | OPERATOR => '=', | |
79 | VALUE => $alias .'.GroupId', | |
80 | QUOTEVALUE => 0, | |
81 | ENTRYAGGREGATOR => 'AND', | |
82 | ); | |
83 | $cgms->Limit( | |
84 | ALIAS => $alias, | |
85 | FIELD => 'id', | |
86 | OPERATOR => '=', | |
87 | VALUE => $alias .'.Via', | |
88 | QUOTEVALUE => 0, | |
89 | ENTRYAGGREGATOR => 'AND', | |
90 | ); | |
91 | ||
92 | $| = 1; | |
93 | my $total = $cgms->Count; | |
94 | my $i = 0; | |
95 | ||
96 | FetchNext( $cgms, 'init' ); | |
97 | while ( my $rec = FetchNext( $cgms ) ) { | |
98 | $i++; | |
99 | printf("\r%0.2f %%", 100 * $i / $total); | |
100 | $RT::Handle->BeginTransaction; | |
101 | my ($status) = $rec->Delete; | |
102 | unless ($status) { | |
103 | print STDERR "Couldn't delete CGM #". $rec->id; | |
104 | exit 1; | |
105 | } | |
106 | $RT::Handle->Commit; | |
107 | } | |
108 | ||
109 | use constant PAGE_SIZE => 10000; | |
110 | sub FetchNext { | |
111 | my ($objs, $init) = @_; | |
112 | if ( $init ) { | |
113 | $objs->RowsPerPage( PAGE_SIZE ); | |
114 | $objs->FirstPage; | |
115 | return; | |
116 | } | |
117 | ||
118 | my $obj = $objs->Next; | |
119 | return $obj if $obj; | |
120 | $objs->RedoSearch; | |
121 | $objs->FirstPage; | |
122 | return $objs->Next; | |
123 | } | |
124 |