27 require_once __DIR__ .
'/Maintenance.php';
36 parent::__construct();
38 $this->
addOption(
'force',
"Recalculate sha1 for rows that already have a value" );
39 $this->
addOption(
'multiversiononly',
"Calculate only for files with several versions" );
40 $this->
addOption(
'method',
"Use 'pipe' to pipe to mysql command line,\n" .
41 "\t\tdefault uses Database class",
false,
true );
44 'Fix for a specific file, without File: namespace prefixed',
51 return 'populate img_sha1';
55 return 'img_sha1 column of image table already populated.';
67 $method = $this->
getOption(
'method',
'normal' );
70 $isRegen = ( $force ||
$file !=
'' );
72 $t = -microtime(
true );
75 $res = $dbw->newSelectQueryBuilder()
76 ->select( [
'img_name' ] )
78 ->where( [
'img_name' =>
$file ] )
79 ->caller( __METHOD__ )->fetchResultSet();
83 $this->
output(
"Populating img_sha1 field for specified files\n" );
85 if ( $this->
hasOption(
'multiversiononly' ) ) {
87 $this->
output(
"Populating and recalculating img_sha1 field for versioned files\n" );
90 $this->
output(
"Populating and recalculating img_sha1 field\n" );
92 $conds = [
'img_sha1' =>
'' ];
93 $this->
output(
"Populating img_sha1 field\n" );
95 if ( $this->
hasOption(
'multiversiononly' ) ) {
96 $res = $dbw->newSelectQueryBuilder()
97 ->select( [
'img_name' =>
'DISTINCT(oi_name)' ] )
100 ->caller( __METHOD__ )->fetchResultSet();
102 $res = $dbw->newSelectQueryBuilder()
103 ->select( [
'img_name' ] )
106 ->caller( __METHOD__ )->fetchResultSet();
110 $imageTable = $dbw->tableName(
'image' );
111 $oldImageTable = $dbw->tableName(
'oldimage' );
113 if ( $method ==
'pipe' ) {
119 $cmd =
'mysql -u' . Shell::escape( $config->get( MainConfigNames::DBuser ) ) .
120 ' -h' . Shell::escape( $config->get( MainConfigNames::DBserver ) ) .
121 ' -p' . Shell::escape( $config->get( MainConfigNames::DBpassword ),
122 $config->get( MainConfigNames::DBname ) );
123 $this->
output(
"Using pipe method\n" );
124 $pipe = popen( $cmd,
'w' );
127 $numRows = $res->numRows();
129 foreach ( $res as $row ) {
132 "Done %d of %d, %5.3f%% \r", $i, $numRows, $i / $numRows * 100 ) );
137 ->newFile( $row->img_name );
143 $sha1 =
$file->getRepo()->getFileSha1(
$file->getPath() );
144 if ( strval( $sha1 ) !==
'' ) {
145 if ( $isRegen &&
$file->getSha1() !== $sha1 ) {
150 $sql =
"UPDATE $imageTable SET img_sha1=" . $dbw->addQuotes( $sha1 ) .
151 " WHERE img_name=" . $dbw->addQuotes(
$file->getName() );
152 if ( $method ==
'pipe' ) {
155 fwrite( $pipe,
"$sql;\n" );
157 $dbw->query( $sql, __METHOD__ );
162 foreach (
$file->getHistory() as $oldFile ) {
164 '@phan-var OldLocalFile $oldFile';
165 $sha1 = $oldFile->getRepo()->getFileSha1( $oldFile->getPath() );
166 if ( strval( $sha1 ) !==
'' ) {
167 if ( $isRegen && $oldFile->getSha1() !== $sha1 ) {
170 $oldFile->upgradeRow();
172 $sql =
"UPDATE $oldImageTable SET oi_sha1=" . $dbw->addQuotes( $sha1 ) .
173 " WHERE (oi_name=" . $dbw->addQuotes( $oldFile->getName() ) .
" AND" .
174 " oi_archive_name=" . $dbw->addQuotes( $oldFile->getArchiveName() ) .
")";
175 if ( $method ==
'pipe' ) {
178 fwrite( $pipe,
"$sql;\n" );
180 $dbw->query( $sql, __METHOD__ );
187 if ( $method ==
'pipe' ) {
193 $t += microtime(
true );
194 $this->
output( sprintf(
"\nDone %d files in %.1f seconds\n", $numRows,
$t ) );
201 require_once RUN_MAINTENANCE_IF_MAIN;
Class for scripts that perform database maintenance and want to log the update in updatelog so we can...
getDB( $db, $groups=[], $dbDomain=false)
Returns a database to be used by current maintenance script.
output( $out, $channel=null)
Throw some output to the user.
waitForReplication()
Wait for replica DBs to catch up.
hasOption( $name)
Checks to see if a particular option was set.
getServiceContainer()
Returns the main service container.
getBatchSize()
Returns batch size.
addDescription( $text)
Set the description text.
addOption( $name, $description, $required=false, $withArg=false, $shortName=false, $multiOccurrence=false)
Add a parameter to the script.
getOption( $name, $default=null)
Get an option, or return the default.
fatalError( $msg, $exitCode=1)
Output a message and terminate the current script.
A class containing constants representing the names of configuration variables.
Maintenance script to populate the img_sha1 field.
execute()
Do the actual work.
doDBUpdates()
Do the actual work.
__construct()
Default constructor.
getUpdateKey()
Get the update key name to go in the update log table.
updateSkippedMessage()
Message to show that the update was done already and was just skipped.
if(PHP_SAPI !='cli-server') if(!isset( $_SERVER['SCRIPT_FILENAME'])) $file
Item class for a filearchive table row.