|
Lines 58-115
sub usage {
Link Here
|
| 58 |
print STDERR <<USAGE; |
58 |
print STDERR <<USAGE; |
| 59 |
Usage: $0 [-h|--help] [--confirm] [--sessions] [--sessdays DAYS] [-v|--verbose] [--zebraqueue DAYS] [-m|--mail] [--merged] [--import DAYS] [--logs DAYS] [--searchhistory DAYS] [--restrictions DAYS] [--all-restrictions] [--fees DAYS] [--statute-barred-fees DAYS] [--temp-uploads] [--temp-uploads-days DAYS] [--uploads-missing 0|1 ] [--statistics DAYS] [--deleted-catalog DAYS] [--deleted-patrons DAYS] [--old-issues DAYS] [--old-reserves DAYS] [--transfers DAYS] |
59 |
Usage: $0 [-h|--help] [--confirm] [--sessions] [--sessdays DAYS] [-v|--verbose] [--zebraqueue DAYS] [-m|--mail] [--merged] [--import DAYS] [--logs DAYS] [--searchhistory DAYS] [--restrictions DAYS] [--all-restrictions] [--fees DAYS] [--statute-barred-fees DAYS] [--temp-uploads] [--temp-uploads-days DAYS] [--uploads-missing 0|1 ] [--statistics DAYS] [--deleted-catalog DAYS] [--deleted-patrons DAYS] [--old-issues DAYS] [--old-reserves DAYS] [--transfers DAYS] |
| 60 |
|
60 |
|
| 61 |
-h --help prints this help message, and exits, ignoring all |
61 |
-h --help Prints this help message, and exits, ignoring all other options. |
| 62 |
other options |
62 |
--confirm Confirmation flag, the script will be running in dry-run mode is not set. |
| 63 |
--confirm Confirmation flag, the script will be running in dry-run mode is not set. |
63 |
--sessions Purge the sessions table. If you use this while users |
| 64 |
--sessions purge the sessions table. If you use this while users |
64 |
are logged into Koha, they will have to reconnect. |
| 65 |
are logged into Koha, they will have to reconnect. |
65 |
--sessdays DAYS Purge only sessions older than DAYS days. |
| 66 |
--sessdays DAYS purge only sessions older than DAYS days. |
66 |
-v --verbose Will cause the script to give you a bit more information about the run. |
| 67 |
-v --verbose will cause the script to give you a bit more information |
67 |
--zebraqueue DAYS Purge completed zebraqueue entries older than DAYS days. |
| 68 |
about the run. |
68 |
Defaults to 30 days if no days specified. |
| 69 |
--zebraqueue DAYS purge completed zebraqueue entries older than DAYS days. |
69 |
-m --mail DAYS Purge items from the mail queue that are older than DAYS days. |
| 70 |
Defaults to 30 days if no days specified. |
70 |
Defaults to 30 days if no days specified. |
| 71 |
-m --mail DAYS purge items from the mail queue that are older than DAYS days. |
71 |
--merged Purge completed entries from need_merge_authorities. |
| 72 |
Defaults to 30 days if no days specified. |
72 |
--import DAYS Purge records from import tables older than DAYS days. |
| 73 |
--merged purged completed entries from need_merge_authorities. |
73 |
Defaults to 60 days if no days specified. |
| 74 |
--import DAYS purge records from import tables older than DAYS days. |
74 |
--z3950 Purge records from import tables that are the result of Z39.50 searches. |
| 75 |
Defaults to 60 days if no days specified. |
75 |
--fees DAYS purge entries accountlines older than DAYS days, where |
| 76 |
--z3950 purge records from import tables that are the result |
76 |
amountoutstanding is 0 or NULL. |
| 77 |
of Z39.50 searches |
77 |
DAYS must be greater than or equal to 1. |
| 78 |
--fees DAYS purge entries accountlines older than DAYS days, where |
78 |
--statute-barred-fees DAYS Purge entries accountlines older than DAYS days, where |
| 79 |
amountoutstanding is 0 or NULL. |
79 |
status is RETURNED and amountoutstanding is greater than 0. |
| 80 |
In the case of --fees, DAYS must be greater than |
80 |
DAYS must be greater than or equal to 1. |
| 81 |
or equal to 1. |
81 |
--logs DAYS Purge entries from action_logs older than DAYS days. |
| 82 |
--statute-barred-fees DAYS Purge entries accountlines older than DAYS days, where |
82 |
Defaults to 180 days if no days specified. |
| 83 |
status is RETURNED and amountoutstanding is greater than 0. |
83 |
--searchhistory DAYS Purge entries from search_history older than DAYS days. |
| 84 |
In the case of --statute-barred-fees, DAYS must be greater than |
84 |
Defaults to 30 days if no days specified |
| 85 |
or equal to 1. |
85 |
--list-invites DAYS Purge (unaccepted) list share invites older than DAYS days. |
| 86 |
--logs DAYS purge entries from action_logs older than DAYS days. |
86 |
Defaults to 14 days if no days specified. |
| 87 |
Defaults to 180 days if no days specified. |
87 |
--restrictions DAYS Purge patrons restrictions expired since more than DAYS days. |
| 88 |
--searchhistory DAYS purge entries from search_history older than DAYS days. |
88 |
Defaults to 30 days if no days specified. |
| 89 |
Defaults to 30 days if no days specified |
89 |
--all-restrictions Purge all expired patrons restrictions. |
| 90 |
--list-invites DAYS purge (unaccepted) list share invites older than DAYS |
90 |
--del-exp-selfreg Delete expired self registration accounts. |
| 91 |
days. Defaults to 14 days if no days specified. |
91 |
--del-unv-selfreg DAYS Delete unverified self registrations older than DAYS. |
| 92 |
--restrictions DAYS purge patrons restrictions expired since more than DAYS days. |
92 |
--unique-holidays DAYS Delete all unique holidays older than DAYS. |
| 93 |
Defaults to 30 days if no days specified. |
93 |
--temp-uploads Delete temporary uploads. |
| 94 |
--all-restrictions purge all expired patrons restrictions. |
94 |
--temp-uploads-days DAYS Override the corresponding preference value. |
| 95 |
--del-exp-selfreg Delete expired self registration accounts |
95 |
--uploads-missing FLAG Delete upload records for missing files when FLAG is true, count them otherwise. |
| 96 |
--del-unv-selfreg DAYS Delete unverified self registrations older than DAYS |
96 |
--oauth-tokens Delete expired OAuth2 tokens. |
| 97 |
--unique-holidays DAYS Delete all unique holidays older than DAYS |
97 |
--statistics DAYS Purge statistics entries more than DAYS days old. |
| 98 |
--temp-uploads Delete temporary uploads. |
98 |
This table is used to build reports, make sure you are aware of the consequences |
| 99 |
--temp-uploads-days DAYS Override the corresponding preference value. |
99 |
of this before using it! |
| 100 |
--uploads-missing FLAG Delete upload records for missing files when FLAG is true, count them otherwise |
100 |
--deleted-catalog DAYS Purge catalog records deleted more then DAYS days ago |
| 101 |
--oauth-tokens Delete expired OAuth2 tokens |
101 |
(from tables deleteditems, deletedbiblioitems, deletedbiblio_metadata |
| 102 |
--statistics DAYS Purge statistics entries more than DAYS days old. |
102 |
and deletedbiblio). |
| 103 |
This table is used to build reports, make sure you are aware of the consequences of this before using it! |
103 |
--deleted-patrons DAYS Purge patrons deleted more than DAYS days ago. |
| 104 |
--deleted-catalog DAYS Purge catalog records deleted more then DAYS days ago |
104 |
--old-issues DAYS Purge checkouts (old_issues) returned more than DAYS days ago. |
| 105 |
(from tables deleteditems, deletedbiblioitems, deletedbiblio_metadata and deletedbiblio). |
105 |
--old-reserves DAYS Purge reserves (old_reserves) more than DAYS old. |
| 106 |
--deleted-patrons DAYS Purge patrons deleted more than DAYS days ago. |
106 |
--transfers DAYS Purge transfers completed more than DAYS day ago. |
| 107 |
--old-issues DAYS Purge checkouts (old_issues) returned more than DAYS days ago. |
107 |
--pseudo-transactions DAYS Purge the pseudonymized transactions that have been originally created more |
| 108 |
--old-reserves DAYS Purge reserves (old_reserves) more than DAYS old. |
108 |
than DAYS days ago. DAYS is optional and can be replaced by: |
| 109 |
--transfers DAYS Purge transfers completed more than DAYS day ago. |
109 |
--pseudo-transactions-from YYYY-MM-DD and/or --pseudo-transactions-to YYYY-MM-DD |
| 110 |
--pseudo-transactions DAYS Purge the pseudonymized transactions that have been originally created more than DAYS days ago |
|
|
| 111 |
DAYS is optional and can be replaced by: |
| 112 |
--pseudo-transactions-from YYYY-MM-DD and/or --pseudo-transactions-to YYYY-MM-DD |
| 113 |
USAGE |
110 |
USAGE |
| 114 |
exit $_[0]; |
111 |
exit $_[0]; |
| 115 |
} |
112 |
} |
|
Lines 147-182
my $pTransfers;
Link Here
|
| 147 |
my ( $pPseudoTransactions, $pPseudoTransactionsFrom, $pPseudoTransactionsTo ); |
144 |
my ( $pPseudoTransactions, $pPseudoTransactionsFrom, $pPseudoTransactionsTo ); |
| 148 |
|
145 |
|
| 149 |
GetOptions( |
146 |
GetOptions( |
| 150 |
'h|help' => \$help, |
147 |
'h|help' => \$help, |
| 151 |
'confirm' => \$confirm, |
148 |
'confirm' => \$confirm, |
| 152 |
'sessions' => \$sessions, |
149 |
'sessions' => \$sessions, |
| 153 |
'sessdays:i' => \$sess_days, |
150 |
'sessdays:i' => \$sess_days, |
| 154 |
'v|verbose' => \$verbose, |
151 |
'v|verbose' => \$verbose, |
| 155 |
'm|mail:i' => \$mail, |
152 |
'm|mail:i' => \$mail, |
| 156 |
'zebraqueue:i' => \$zebraqueue_days, |
153 |
'zebraqueue:i' => \$zebraqueue_days, |
| 157 |
'merged' => \$purge_merged, |
154 |
'merged' => \$purge_merged, |
| 158 |
'import:i' => \$pImport, |
155 |
'import:i' => \$pImport, |
| 159 |
'z3950' => \$pZ3950, |
156 |
'z3950' => \$pZ3950, |
| 160 |
'logs:i' => \$pLogs, |
157 |
'logs:i' => \$pLogs, |
| 161 |
'fees:i' => \$fees_days, |
158 |
'fees:i' => \$fees_days, |
| 162 |
'statute-barred-fees:i' => \$statue_barred_fees_days, |
159 |
'statute-barred-fees:i' => \$statue_barred_fees_days, |
| 163 |
'searchhistory:i' => \$pSearchhistory, |
160 |
'searchhistory:i' => \$pSearchhistory, |
| 164 |
'list-invites:i' => \$pListShareInvites, |
161 |
'list-invites:i' => \$pListShareInvites, |
| 165 |
'restrictions:i' => \$pDebarments, |
162 |
'restrictions:i' => \$pDebarments, |
| 166 |
'all-restrictions' => \$allDebarments, |
163 |
'all-restrictions' => \$allDebarments, |
| 167 |
'del-exp-selfreg' => \$pExpSelfReg, |
164 |
'del-exp-selfreg' => \$pExpSelfReg, |
| 168 |
'del-unv-selfreg' => \$pUnvSelfReg, |
165 |
'del-unv-selfreg' => \$pUnvSelfReg, |
| 169 |
'unique-holidays:i' => \$special_holidays_days, |
166 |
'unique-holidays:i' => \$special_holidays_days, |
| 170 |
'temp-uploads' => \$temp_uploads, |
167 |
'temp-uploads' => \$temp_uploads, |
| 171 |
'temp-uploads-days:i' => \$temp_uploads_days, |
168 |
'temp-uploads-days:i' => \$temp_uploads_days, |
| 172 |
'uploads-missing:i' => \$uploads_missing, |
169 |
'uploads-missing:i' => \$uploads_missing, |
| 173 |
'oauth-tokens' => \$oauth_tokens, |
170 |
'oauth-tokens' => \$oauth_tokens, |
| 174 |
'statistics:i' => \$pStatistics, |
171 |
'statistics:i' => \$pStatistics, |
| 175 |
'deleted-catalog:i' => \$pDeletedCatalog, |
172 |
'deleted-catalog:i' => \$pDeletedCatalog, |
| 176 |
'deleted-patrons:i' => \$pDeletedPatrons, |
173 |
'deleted-patrons:i' => \$pDeletedPatrons, |
| 177 |
'old-issues:i' => \$pOldIssues, |
174 |
'old-issues:i' => \$pOldIssues, |
| 178 |
'old-reserves:i' => \$pOldReserves, |
175 |
'old-reserves:i' => \$pOldReserves, |
| 179 |
'transfers:i' => \$pTransfers, |
176 |
'transfers:i' => \$pTransfers, |
| 180 |
'pseudo-transactions:i' => \$pPseudoTransactions, |
177 |
'pseudo-transactions:i' => \$pPseudoTransactions, |
| 181 |
'pseudo-transactions-from:s' => \$pPseudoTransactionsFrom, |
178 |
'pseudo-transactions-from:s' => \$pPseudoTransactionsFrom, |
| 182 |
'pseudo-transactions-to:s' => \$pPseudoTransactionsTo, |
179 |
'pseudo-transactions-to:s' => \$pPseudoTransactionsTo, |
| 183 |
- |
|
|