Page Menu
Home
WickedGov Phorge
Search
Configure Global Search
Log In
Files
F5939633
initUserPreference.php
No One
Temporary
Actions
Download File
Edit File
Delete File
View Transforms
Subscribe
Flag For Later
Award Token
Size
2 KB
Referenced Files
None
Subscribers
None
initUserPreference.php
View Options
<?php
use
MediaWiki\Maintenance\Maintenance
;
// @codeCoverageIgnoreStart
require_once
__DIR__
.
'/Maintenance.php'
;
// @codeCoverageIgnoreEnd
/**
* Maintenance script that initializes a user preference
* based on the value of another preference.
*
* This is done by copying any non-empty (i.e. excluding 0 or null) value for a given
* source preference to be the value of the target preference. Only users with the value set
* will have the target preference set.
*
* @ingroup Maintenance
*/
class
InitUserPreference
extends
Maintenance
{
public
function
__construct
()
{
parent
::
__construct
();
$this
->
addOption
(
'target'
,
'Name of the user preference to initialize'
,
true
,
true
,
't'
);
$this
->
addOption
(
'source'
,
'Name of the user preference to take the value from'
,
true
,
true
,
's'
);
$this
->
setBatchSize
(
300
);
}
public
function
execute
()
{
$target
=
$this
->
getOption
(
'target'
);
$source
=
$this
->
getOption
(
'source'
);
$this
->
output
(
"Initializing '$target' based on the value of '$source'
\n
"
);
$dbr
=
$this
->
getReplicaDB
();
$dbw
=
$this
->
getPrimaryDB
();
$iterator
=
new
BatchRowIterator
(
$dbr
,
$dbr
->
newSelectQueryBuilder
()
->
from
(
'user_properties'
)
->
select
(
[
'up_user'
,
'up_value'
]
)
->
where
(
[
'up_property'
=>
$source
,
$dbr
->
expr
(
'up_value'
,
'!='
,
null
),
$dbr
->
expr
(
'up_value'
,
'!='
,
'0'
),
]
)
->
caller
(
__METHOD__
),
[
'up_user'
,
'up_property'
],
$this
->
getBatchSize
()
);
$processed
=
0
;
foreach
(
$iterator
as
$batch
)
{
foreach
(
$batch
as
$row
)
{
$dbw
->
newInsertQueryBuilder
()
->
insertInto
(
'user_properties'
)
->
row
(
[
'up_user'
=>
$row
->
up_user
,
'up_property'
=>
$target
,
'up_value'
=>
$row
->
up_value
,
]
)
->
onDuplicateKeyUpdate
()
->
uniqueIndexFields
(
[
'up_user'
,
'up_property'
]
)
->
set
(
[
'up_value'
=>
$row
->
up_value
]
)
->
caller
(
__METHOD__
)->
execute
();
$processed
+=
$dbw
->
affectedRows
();
}
}
$this
->
output
(
"Processed $processed user(s)
\n
"
);
$this
->
output
(
"Finished!
\n
"
);
}
}
// @codeCoverageIgnoreStart
$maintClass
=
InitUserPreference
::
class
;
require_once
RUN_MAINTENANCE_IF_MAIN
;
// @codeCoverageIgnoreEnd
File Metadata
Details
Attached
Mime Type
text/x-php
Expires
Oct 2 2026, 16:41 (6 w, 5 d ago)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
7a/ef/a207a6a95d63889c399be69964b0
Default Alt Text
initUserPreference.php (2 KB)
Attached To
Mode
rMWPROD MediaWiki Production
Attached
Detach File
Event Timeline
Log In to Comment