(bug 20275) Fixed LIKE queries on SQLite backend
[lhc/web/wiklou.git] / includes / filerepo / LocalRepo.php
index 57b1872..6c4d21a 100644 (file)
@@ -2,37 +2,32 @@
 /**
  * A repository that stores files in the local filesystem and registers them
  * in the wiki's own database. This is the most commonly used repository class.
+ * @ingroup FileRepo
  */
 class LocalRepo extends FSRepo {
        var $fileFactory = array( 'LocalFile', 'newFromTitle' );
        var $oldFileFactory = array( 'OldLocalFile', 'newFromTitle' );
-
-       function getSlaveDB() {
-               return wfGetDB( DB_SLAVE );
-       }
-
-       function getMasterDB() {
-               return wfGetDB( DB_MASTER );
-       }
+       var $fileFromRowFactory = array( 'LocalFile', 'newFromRow' );
+       var $oldFileFromRowFactory = array( 'OldLocalFile', 'newFromRow' );
 
        function newFileFromRow( $row ) {
                if ( isset( $row->img_name ) ) {
-                       return LocalFile::newFromRow( $row, $this );
+                       return call_user_func( $this->fileFromRowFactory, $row, $this );
                } elseif ( isset( $row->oi_name ) ) {
-                       return OldLocalFile::newFromRow( $row, $this );
+                       return call_user_func( $this->oldFileFromRowFactory, $row, $this );
                } else {
                        throw new MWException( __METHOD__.': invalid row' );
                }
        }
-       
+
        function newFromArchiveName( $title, $archiveName ) {
                return OldLocalFile::newFromArchiveName( $title, $this, $archiveName );
        }
 
        /**
-        * Delete files in the deleted directory if they are not referenced in the 
-        * filearchive table. This needs to be done in the repo because it needs to 
-        * interleave database locks with file operations, which is potentially a 
+        * Delete files in the deleted directory if they are not referenced in the
+        * filearchive table. This needs to be done in the repo because it needs to
+        * interleave database locks with file operations, which is potentially a
         * remote operation.
         * @return FileRepoStatus
         */
@@ -40,21 +35,168 @@ class LocalRepo extends FSRepo {
                $root = $this->getZonePath( 'deleted' );
                $dbw = $this->getMasterDB();
                $status = $this->newGood();
+               $storageKeys = array_unique($storageKeys);
                foreach ( $storageKeys as $key ) {
                        $hashPath = $this->getDeletedHashPath( $key );
                        $path = "$root/$hashPath$key";
                        $dbw->begin();
-                       $inuse = $dbw->select( 'filearchive', '1', 
+                       $inuse = $dbw->selectField( 'filearchive', '1',
                                array( 'fa_storage_group' => 'deleted', 'fa_storage_key' => $key ),
                                __METHOD__, array( 'FOR UPDATE' ) );
-                       if ( !$inuse && !unlink( $path ) ) {
-                               $status->error( 'undelete-cleanup-error', $path );
-                               $status->failCount++;
+                       if( !$inuse ) {
+                               $sha1 = substr( $key, 0, strcspn( $key, '.' ) );
+                               $ext = substr( $key, strcspn($key,'.') + 1 );
+                               $ext = File::normalizeExtension($ext);
+                               $inuse = $dbw->selectField( 'oldimage', '1',
+                                       array( 'oi_sha1' => $sha1,
+                                               'oi_archive_name ' . $dbw->buildLike( $dbw->anyString(), ".$ext" ),
+                                               $dbw->bitAnd('oi_deleted', File::DELETED_FILE) => File::DELETED_FILE ),
+                                       __METHOD__, array( 'FOR UPDATE' ) );
+                       }
+                       if ( !$inuse ) {
+                               wfDebug( __METHOD__ . ": deleting $key\n" );
+                               if ( !@unlink( $path ) ) {
+                                       $status->error( 'undelete-cleanup-error', $path );
+                                       $status->failCount++;
+                               }
                        } else {
+                               wfDebug( __METHOD__ . ": $key still in use\n" );
                                $status->successCount++;
                        }
                        $dbw->commit();
                }
                return $status;
        }
+       
+       /**
+        * Checks if there is a redirect named as $title
+        *
+        * @param Title $title Title of image
+        */
+       function checkRedirect( $title ) {
+               global $wgMemc;
+
+               if( is_string( $title ) ) {
+                       $title = Title::newFromTitle( $title );
+               }
+               if( $title instanceof Title && $title->getNamespace() == NS_MEDIA ) {
+                       $title = Title::makeTitle( NS_FILE, $title->getText() );
+               }
+
+               $memcKey = $this->getSharedCacheKey( 'image_redirect', md5( $title->getDBkey() ) );
+               if ( $memcKey === false ) {
+                       $memcKey = $this->getLocalCacheKey( 'image_redirect', md5( $title->getDBkey() ) );
+                       $expiry = 300; // no invalidation, 5 minutes
+               } else {
+                       $expiry = 86400; // has invalidation, 1 day
+               }
+               $cachedValue = $wgMemc->get( $memcKey );
+               if ( $cachedValue === ' '  || $cachedValue === '' ) {
+                       // Does not exist
+                       return false;
+               } elseif ( strval( $cachedValue ) !== '' ) {
+                       return Title::newFromText( $cachedValue, NS_FILE );
+               } // else $cachedValue is false or null: cache miss
+
+               $id = $this->getArticleID( $title );
+               if( !$id ) {
+                       $wgMemc->set( $memcKey, " ", $expiry );
+                       return false;
+               }
+               $dbr = $this->getSlaveDB();
+               $row = $dbr->selectRow(
+                       'redirect',
+                       array( 'rd_title', 'rd_namespace' ),
+                       array( 'rd_from' => $id ),
+                       __METHOD__
+               );
+
+               if( $row && $row->rd_namespace == NS_FILE ) {
+                       $targetTitle = Title::makeTitle( $row->rd_namespace, $row->rd_title );
+                       $wgMemc->set( $memcKey, $targetTitle->getDBkey(), $expiry );
+                       return $targetTitle;
+               } else {
+                       $wgMemc->set( $memcKey, '', $expiry );
+                       return false;
+               }
+       }
+
+
+       /**
+        * Function link Title::getArticleID().
+        * We can't say Title object, what database it should use, so we duplicate that function here.
+        */
+       protected function getArticleID( $title ) {
+               if( !$title instanceof Title ) {
+                       return 0;
+               }
+               $dbr = $this->getSlaveDB();
+               $id = $dbr->selectField(
+                       'page', // Table
+                       'page_id',      //Field
+                       array(  //Conditions
+                               'page_namespace' => $title->getNamespace(),
+                               'page_title' => $title->getDBkey(),
+                       ),
+                       __METHOD__      //Function name
+               );
+               return $id;
+       }
+
+       /**
+        * Get an array or iterator of file objects for files that have a given 
+        * SHA-1 content hash.
+        */
+       function findBySha1( $hash ) {
+               $dbr = $this->getSlaveDB();
+               $res = $dbr->select(
+                       'image',
+                       LocalFile::selectFields(),
+                       array( 'img_sha1' => $hash )
+               );
+               
+               $result = array();
+               while ( $row = $res->fetchObject() )
+                       $result[] = $this->newFileFromRow( $row );
+               $res->free();
+               return $result;
+       }
+
+       /**
+        * Get a connection to the slave DB
+        */
+       function getSlaveDB() {
+               return wfGetDB( DB_SLAVE );
+       }
+
+       /**
+        * Get a connection to the master DB
+        */
+       function getMasterDB() {
+               return wfGetDB( DB_MASTER );
+       }
+
+       /**
+        * Get a key on the primary cache for this repository.
+        * Returns false if the repository's cache is not accessible at this site. 
+        * The parameters are the parts of the key, as for wfMemcKey().
+        */
+       function getSharedCacheKey( /*...*/ ) {
+               $args = func_get_args();
+               return call_user_func_array( 'wfMemcKey', $args );
+       }
+
+       /**
+        * Invalidates image redirect cache related to that image
+        *
+        * @param Title $title Title of image
+        */     
+       function invalidateImageRedirect( $title ) {
+               global $wgMemc;
+               $memcKey = $this->getSharedCacheKey( 'image_redirect', md5( $title->getDBkey() ) );
+               if ( $memcKey ) {
+                       $wgMemc->delete( $memcKey );
+               }
+       }
 }
+