Page Menu
Home
WickedGov Phorge
Search
Configure Global Search
Log In
Files
F6085282
resetPageRandom.php
No One
Temporary
Actions
Download File
Edit File
Delete File
View Transforms
Subscribe
Flag For Later
Award Token
Size
4 KB
Referenced Files
None
Subscribers
None
resetPageRandom.php
View Options
<?php
/**
* Resets the page_random field for articles in the provided time range.
*
* @license GPL-2.0-or-later
* @file
* @ingroup Maintenance
*/
use
MediaWiki\Maintenance\Maintenance
;
// @codeCoverageIgnoreStart
require_once
__DIR__
.
'/Maintenance.php'
;
// @codeCoverageIgnoreEnd
/**
* Maintenance script that resets page_random over a time range.
*
* @ingroup Maintenance
*/
class
ResetPageRandom
extends
Maintenance
{
public
function
__construct
()
{
parent
::
__construct
();
$this
->
addDescription
(
'Reset the page_random for articles within given date range'
);
$this
->
addOption
(
'from'
,
'From date range selector to select articles to update, ex: 20041011000000'
,
true
,
true
);
$this
->
addOption
(
'to'
,
'To date range selector to select articles to update, ex: 20050708000000'
,
true
,
true
);
$this
->
addOption
(
'dry'
,
'Do not update column'
);
$this
->
addOption
(
'batch-start'
,
'Optional: Use when you need to restart the reset process from a given page ID offset'
.
' in case a previous reset failed or was stopped'
);
// Initialize batch size to a good default value and enable the batch size option.
$this
->
setBatchSize
(
200
);
}
/** @inheritDoc */
public
function
execute
()
{
$batchSize
=
$this
->
getBatchSize
();
$dbw
=
$this
->
getPrimaryDB
();
$dbr
=
$this
->
getReplicaDB
();
$from
=
wfTimestampOrNull
(
TS_MW
,
$this
->
getOption
(
'from'
)
);
$to
=
wfTimestampOrNull
(
TS_MW
,
$this
->
getOption
(
'to'
)
);
if
(
$from
===
null
||
$to
===
null
)
{
$this
->
output
(
"--from and --to have to be provided"
.
PHP_EOL
);
return
false
;
}
if
(
$from
>=
$to
)
{
$this
->
output
(
"--from has to be smaller than --to"
.
PHP_EOL
);
return
false
;
}
$batchStart
=
(
int
)
$this
->
getOption
(
'batch-start'
,
0
);
$changed
=
0
;
$dry
=
(
bool
)
$this
->
getOption
(
'dry'
);
$message
=
"Resetting page_random column within date range from $from to $to"
;
if
(
$batchStart
>
0
)
{
$message
.=
" starting from page ID $batchStart"
;
}
$message
.=
$dry
?
". dry run"
:
'.'
;
$this
->
output
(
$message
.
PHP_EOL
);
do
{
$this
->
output
(
" ...doing chunk of $batchSize from $batchStart "
.
PHP_EOL
);
// Find the oldest page revision associated with each page_id. Iff it falls in the given
// time range AND it's greater than $batchStart, yield the page ID. If it falls outside the
// time range, it was created before or after the occurrence of T208909 and its page_random
// is considered valid. The replica is used for this read since page_id and the rev_timestamp
// will not change between queries.
$queryBuilder
=
$dbr
->
newSelectQueryBuilder
()
->
select
(
'page_id'
)
->
from
(
'page'
)
->
where
(
$dbr
->
expr
(
'page_id'
,
'>'
,
$batchStart
)
)
->
limit
(
$batchSize
)
->
orderBy
(
'page_id'
);
$subquery
=
$queryBuilder
->
newSubquery
()
->
select
(
'MIN(rev_timestamp)'
)
->
from
(
'revision'
)
->
where
(
'rev_page=page_id'
);
$queryBuilder
->
andWhere
(
'('
.
$subquery
->
getSQL
()
.
') BETWEEN '
.
$dbr
->
addQuotes
(
$dbr
->
timestamp
(
$from
)
)
.
' AND '
.
$dbr
->
addQuotes
(
$dbr
->
timestamp
(
$to
)
)
);
$res
=
$queryBuilder
->
caller
(
__METHOD__
)->
fetchResultSet
();
$row
=
null
;
foreach
(
$res
as
$row
)
{
if
(
!
$dry
)
{
# Update the row...
$dbw
->
newUpdateQueryBuilder
()
->
update
(
'page'
)
->
set
(
[
'page_random'
=>
wfRandom
()
]
)
->
where
(
[
'page_id'
=>
$row
->
page_id
]
)
->
caller
(
__METHOD__
)
->
execute
();
$changed
+=
$dbw
->
affectedRows
();
}
else
{
$changed
++;
}
}
if
(
$row
)
{
$batchStart
=
$row
->
page_id
;
}
else
{
// We don't need to set the $batchStart as $res is empty,
// and we don't need to do another loop
// the while() condition will evaluate to false and
// we will leave the do{}while() block.
}
$this
->
waitForReplication
();
}
while
(
$res
->
numRows
()
===
$batchSize
);
$this
->
output
(
"page_random reset complete ... changed $changed rows"
.
PHP_EOL
);
return
true
;
}
}
// @codeCoverageIgnoreStart
$maintClass
=
ResetPageRandom
::
class
;
require_once
RUN_MAINTENANCE_IF_MAIN
;
// @codeCoverageIgnoreEnd
File Metadata
Details
Attached
Mime Type
text/x-php
Expires
Oct 5 2026, 13:36 (6 w, 1 d ago)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
b3/d5/0e11f4aaa62d2fb0aee47da4ba48
Default Alt Text
resetPageRandom.php (4 KB)
Attached To
Mode
rMWPROD MediaWiki Production
Attached
Detach File
Event Timeline
Log In to Comment