Page Menu
Home
c4science
Search
Configure Global Search
Log In
Files
F91388829
102.heraldcleanup.php
No One
Temporary
Actions
Download File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Subscribers
None
File Metadata
Details
File Info
Storage
Attached
Created
Sun, Nov 10, 15:26
Size
862 B
Mime Type
text/x-php
Expires
Tue, Nov 12, 15:26 (2 d)
Engine
blob
Format
Raw Data
Handle
22255784
Attached To
rPH Phabricator
102.heraldcleanup.php
View Options
<?php
echo
pht
(
'Cleaning up old Herald rule applied rows...'
).
"
\n
"
;
$table
=
new
HeraldRule
();
$table
->
openTransaction
();
$table
->
beginReadLocking
();
$rules
=
$table
->
loadAll
();
foreach
(
$rules
as
$key
=>
$rule
)
{
$first_policy
=
HeraldRepetitionPolicyConfig
::
toInt
(
HeraldRepetitionPolicyConfig
::
FIRST
);
if
(
$rule
->
getRepetitionPolicy
()
!=
$first_policy
)
{
unset
(
$rules
[
$key
]);
}
}
$conn_w
=
$table
->
establishConnection
(
'w'
);
$clause
=
''
;
if
(
$rules
)
{
$clause
=
qsprintf
(
$conn_w
,
'WHERE ruleID NOT IN (%Ld)'
,
mpull
(
$rules
,
'getID'
));
}
echo
pht
(
'This may take a moment'
).
"
\n
"
;
do
{
queryfx
(
$conn_w
,
'DELETE FROM %T %Q LIMIT 1000'
,
HeraldRule
::
TABLE_RULE_APPLIED
,
$clause
);
echo
'.'
;
}
while
(
$conn_w
->
getAffectedRows
());
$table
->
endReadLocking
();
$table
->
saveTransaction
();
echo
"
\n
"
.
pht
(
'Done.'
).
"
\n
"
;
Event Timeline
Log In to Comment