maintenance/refreshFileHeaders.php

   1 <?php
   2 /**
   3  * Refresh file headers from metadata.
   4  *
   5  * Usage: php refreshFileHeaders.php
   6  *
   7  * This program is free software; you can redistribute it and/or modify
   8  * it under the terms of the GNU General Public License as published by
   9  * the Free Software Foundation; either version 2 of the License, or
  10  * (at your option) any later version.
  11  *
  12  * This program is distributed in the hope that it will be useful,
  13  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  14  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  15  * GNU General Public License for more details.
  16  *
  17  * You should have received a copy of the GNU General Public License along
  18  * with this program; if not, write to the Free Software Foundation, Inc.,
  19  * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
  20  * http://www.gnu.org/copyleft/gpl.html
  21  *
  22  * @file
  23  * @ingroup Maintenance
  24  */
  25
  26 require_once __DIR__ . '/Maintenance.php';
  27
  28 /**
  29  * Maintenance script to refresh file headers from metadata
  30  *
  31  * @ingroup Maintenance
  32  */
  33 class RefreshFileHeaders extends Maintenance {
  34         function __construct() {
  35                 parent::__construct();
  36                 $this->addDescription( 'Script to update file HTTP headers' );
  37                 $this->addOption( 'verbose', 'Output information about each file.', false, false, 'v' );
  38                 $this->addOption( 'start', 'Name of file to start with', false, true );
  39                 $this->addOption( 'end', 'Name of file to end with', false, true );
  40                 $this->addOption( 'media_type', 'Media type to filter for', false, true );
  41                 $this->addOption( 'major_mime', 'Major mime type to filter for', false, true );
  42                 $this->addOption( 'minor_mime', 'Minor mime type to filter for', false, true );
  43                 $this->setBatchSize( 200 );
  44         }
  45
  46         public function execute() {
  47                 $repo = RepoGroup::singleton()->getLocalRepo();
  48                 $start = str_replace( ' ', '_', $this->getOption( 'start', '' ) ); // page on img_name
  49                 $end = str_replace( ' ', '_', $this->getOption( 'end', '' ) ); // page on img_name
  50                  // filter by img_media_type
  51                 $media_type = str_replace( ' ', '_', $this->getOption( 'media_type', '' ) );
  52                  // filter by img_major_mime
  53                 $major_mime = str_replace( ' ', '_', $this->getOption( 'major_mime', '' ) );
  54                  // filter by img_minor_mime
  55                 $minor_mime = str_replace( ' ', '_', $this->getOption( 'minor_mime', '' ) );
  56
  57                 $count = 0;
  58                 $dbr = $this->getDB( DB_REPLICA );
  59
  60                 $fileQuery = LocalFile::getQueryInfo();
  61
  62                 do {
  63                         $conds = [ "img_name > {$dbr->addQuotes( $start )}" ];
  64
  65                         if ( strlen( $end ) ) {
  66                                 $conds[] = "img_name <= {$dbr->addQuotes( $end )}";
  67                         }
  68
  69                         if ( strlen( $media_type ) ) {
  70                                 $conds[] = "img_media_type = {$dbr->addQuotes( $media_type )}";
  71                         }
  72
  73                         if ( strlen( $major_mime ) ) {
  74                                 $conds[] = "img_major_mime = {$dbr->addQuotes( $major_mime )}";
  75                         }
  76
  77                         if ( strlen( $minor_mime ) ) {
  78                                 $conds[] = "img_minor_mime = {$dbr->addQuotes( $minor_mime )}";
  79                         }
  80
  81                         $res = $dbr->select( $fileQuery['tables'],
  82                                 $fileQuery['fields'],
  83                                 $conds,
  84                                 __METHOD__,
  85                                 [
  86                                         'LIMIT' => $this->getBatchSize(),
  87                                         'ORDER BY' => 'img_name ASC'
  88                                 ],
  89                                 $fileQuery['joins']
  90                         );
  91
  92                         if ( $res->numRows() > 0 ) {
  93                                 $row1 = $res->current();
  94                                 $this->output( "Processing next {$res->numRows()} row(s) starting with {$row1->img_name}.\n" );
  95                                 $res->rewind();
  96                         }
  97
  98                         $backendOperations = [];
  99
 100                         foreach ( $res as $row ) {
 101                                 $file = $repo->newFileFromRow( $row );
 102                                 $headers = $file->getContentHeaders();
 103
 104                                 if ( count( $headers ) ) {
 105                                         $backendOperations[] = [
 106                                                 'op' => 'describe', 'src' => $file->getPath(), 'headers' => $headers
 107                                         ];
 108                                 }
 109
 110                                 // Do all of the older file versions...
 111                                 foreach ( $file->getHistory() as $oldFile ) {
 112                                         $headers = $oldFile->getContentHeaders();
 113                                         if ( count( $headers ) ) {
 114                                                 $backendOperations[] = [
 115                                                         'op' => 'describe', 'src' => $oldFile->getPath(), 'headers' => $headers
 116                                                 ];
 117                                         }
 118                                 }
 119
 120                                 if ( $this->hasOption( 'verbose' ) ) {
 121                                         $this->output( "Queued headers update for file '{$row->img_name}'.\n" );
 122                                 }
 123
 124                                 $start = $row->img_name; // advance
 125                         }
 126
 127                         $backendOperationsCount = count( $backendOperations );
 128                         $count += $backendOperationsCount;
 129
 130                         $this->output( "Updating headers for {$backendOperationsCount} file(s).\n" );
 131                         $this->updateFileHeaders( $repo, $backendOperations );
 132                 } while ( $res->numRows() === $this->getBatchSize() );
 133
 134                 $this->output( "Done. Updated headers for $count file(s).\n" );
 135         }
 136
 137         protected function updateFileHeaders( $repo, $backendOperations ) {
 138                 $status = $repo->getBackend()->doQuickOperations( $backendOperations );
 139
 140                 if ( !$status->isGood() ) {
 141                         $this->error( "Encountered error: " . print_r( $status, true ) );
 142                 }
 143         }
 144 }
 145
 146 $maintClass = 'RefreshFileHeaders';
 147 require_once RUN_MAINTENANCE_IF_MAIN;