tests/phpunit/MediaWikiTestCase.php

   1 <?php
   2
   3 /**
   4  * @since 1.18
   5  */
   6 abstract class MediaWikiTestCase extends PHPUnit_Framework_TestCase {
   7         /**
   8          * $called tracks whether the setUp and tearDown method has been called.
   9          * class extending MediaWikiTestCase usually override setUp and tearDown
  10          * but forget to call the parent.
  11          *
  12          * The array format takes a method name as key and anything as a value.
  13          * By asserting the key exist, we know the child class has called the
  14          * parent.
  15          *
  16          * This property must be private, we do not want child to override it,
  17          * they should call the appropriate parent method instead.
  18          */
  19         private $called = array();
  20
  21         /**
  22          * @var TestUser[]
  23          * @since 1.20
  24          */
  25         public static $users;
  26
  27         /**
  28          * @var DatabaseBase
  29          * @since 1.18
  30          */
  31         protected $db;
  32
  33         /**
  34          * @var array
  35          * @since 1.19
  36          */
  37         protected $tablesUsed = array(); // tables with data
  38
  39         private static $useTemporaryTables = true;
  40         private static $reuseDB = false;
  41         private static $dbSetup = false;
  42         private static $oldTablePrefix = false;
  43
  44         /**
  45          * Original value of PHP's error_reporting setting.
  46          *
  47          * @var int
  48          */
  49         private $phpErrorLevel;
  50
  51         /**
  52          * Holds the paths of temporary files/directories created through getNewTempFile,
  53          * and getNewTempDirectory
  54          *
  55          * @var array
  56          */
  57         private $tmpFiles = array();
  58
  59         /**
  60          * Holds original values of MediaWiki configuration settings
  61          * to be restored in tearDown().
  62          * See also setMwGlobals().
  63          * @var array
  64          */
  65         private $mwGlobals = array();
  66
  67         /**
  68          * Table name prefixes. Oracle likes it shorter.
  69          */
  70         const DB_PREFIX = 'unittest_';
  71         const ORA_DB_PREFIX = 'ut_';
  72
  73         /**
  74          * @var array
  75          * @since 1.18
  76          */
  77         protected $supportedDBs = array(
  78                 'mysql',
  79                 'sqlite',
  80                 'postgres',
  81                 'oracle'
  82         );
  83
  84         public function __construct( $name = null, array $data = array(), $dataName = '' ) {
  85                 parent::__construct( $name, $data, $dataName );
  86
  87                 $this->backupGlobals = false;
  88                 $this->backupStaticAttributes = false;
  89         }
  90
  91         public function run( PHPUnit_Framework_TestResult $result = null ) {
  92                 /* Some functions require some kind of caching, and will end up using the db,
  93                  * which we can't allow, as that would open a new connection for mysql.
  94                  * Replace with a HashBag. They would not be going to persist anyway.
  95                  */
  96                 ObjectCache::$instances[CACHE_DB] = new HashBagOStuff;
  97
  98                 $needsResetDB = false;
  99                 $logName = get_class( $this ) . '::' . $this->getName( false );
 100
 101                 if ( $this->needsDB() ) {
 102                         // set up a DB connection for this test to use
 103
 104                         self::$useTemporaryTables = !$this->getCliArg( 'use-normal-tables' );
 105                         self::$reuseDB = $this->getCliArg( 'reuse-db' );
 106
 107                         $this->db = wfGetDB( DB_MASTER );
 108
 109                         $this->checkDbIsSupported();
 110
 111                         if ( !self::$dbSetup ) {
 112                                 wfProfileIn( $logName . ' (clone-db)' );
 113
 114                                 // switch to a temporary clone of the database
 115                                 self::setupTestDB( $this->db, $this->dbPrefix() );
 116
 117                                 if ( ( $this->db->getType() == 'oracle' || !self::$useTemporaryTables ) && self::$reuseDB ) {
 118                                         $this->resetDB();
 119                                 }
 120
 121                                 wfProfileOut( $logName . ' (clone-db)' );
 122                         }
 123
 124                         wfProfileIn( $logName . ' (prepare-db)' );
 125                         $this->addCoreDBData();
 126                         $this->addDBData();
 127                         wfProfileOut( $logName . ' (prepare-db)' );
 128
 129                         $needsResetDB = true;
 130                 }
 131
 132                 wfProfileIn( $logName );
 133                 parent::run( $result );
 134                 wfProfileOut( $logName );
 135
 136                 if ( $needsResetDB ) {
 137                         wfProfileIn( $logName . ' (reset-db)' );
 138                         $this->resetDB();
 139                         wfProfileOut( $logName . ' (reset-db)' );
 140                 }
 141         }
 142
 143         /**
 144          * @since 1.21
 145          *
 146          * @return bool
 147          */
 148         public function usesTemporaryTables() {
 149                 return self::$useTemporaryTables;
 150         }
 151
 152         /**
 153          * Obtains a new temporary file name
 154          *
 155          * The obtained filename is enlisted to be removed upon tearDown
 156          *
 157          * @since 1.20
 158          *
 159          * @return string Absolute name of the temporary file
 160          */
 161         protected function getNewTempFile() {
 162                 $fileName = tempnam( wfTempDir(), 'MW_PHPUnit_' . get_class( $this ) . '_' );
 163                 $this->tmpFiles[] = $fileName;
 164
 165                 return $fileName;
 166         }
 167
 168         /**
 169          * obtains a new temporary directory
 170          *
 171          * The obtained directory is enlisted to be removed (recursively with all its contained
 172          * files) upon tearDown.
 173          *
 174          * @since 1.20
 175          *
 176          * @return string Absolute name of the temporary directory
 177          */
 178         protected function getNewTempDirectory() {
 179                 // Starting of with a temporary /file/.
 180                 $fileName = $this->getNewTempFile();
 181
 182                 // Converting the temporary /file/ to a /directory/
 183                 //
 184                 // The following is not atomic, but at least we now have a single place,
 185                 // where temporary directory creation is bundled and can be improved
 186                 unlink( $fileName );
 187                 $this->assertTrue( wfMkdirParents( $fileName ) );
 188
 189                 return $fileName;
 190         }
 191
 192         protected function setUp() {
 193                 wfProfileIn( __METHOD__ );
 194                 parent::setUp();
 195                 $this->called['setUp'] = 1;
 196
 197                 $this->phpErrorLevel = intval( ini_get( 'error_reporting' ) );
 198
 199                 // Cleaning up temporary files
 200                 foreach ( $this->tmpFiles as $fileName ) {
 201                         if ( is_file( $fileName ) || ( is_link( $fileName ) ) ) {
 202                                 unlink( $fileName );
 203                         } elseif ( is_dir( $fileName ) ) {
 204                                 wfRecursiveRemoveDir( $fileName );
 205                         }
 206                 }
 207
 208                 if ( $this->needsDB() && $this->db ) {
 209                         // Clean up open transactions
 210                         while ( $this->db->trxLevel() > 0 ) {
 211                                 $this->db->rollback();
 212                         }
 213
 214                         // don't ignore DB errors
 215                         $this->db->ignoreErrors( false );
 216                 }
 217
 218                 wfProfileOut( __METHOD__ );
 219         }
 220
 221         protected function tearDown() {
 222                 wfProfileIn( __METHOD__ );
 223
 224                 // Cleaning up temporary files
 225                 foreach ( $this->tmpFiles as $fileName ) {
 226                         if ( is_file( $fileName ) || ( is_link( $fileName ) ) ) {
 227                                 unlink( $fileName );
 228                         } elseif ( is_dir( $fileName ) ) {
 229                                 wfRecursiveRemoveDir( $fileName );
 230                         }
 231                 }
 232
 233                 if ( $this->needsDB() && $this->db ) {
 234                         // Clean up open transactions
 235                         while ( $this->db->trxLevel() > 0 ) {
 236                                 $this->db->rollback();
 237                         }
 238
 239                         // don't ignore DB errors
 240                         $this->db->ignoreErrors( false );
 241                 }
 242
 243                 // Restore mw globals
 244                 foreach ( $this->mwGlobals as $key => $value ) {
 245                         $GLOBALS[$key] = $value;
 246                 }
 247                 $this->mwGlobals = array();
 248
 249                 $phpErrorLevel = intval( ini_get( 'error_reporting' ) );
 250
 251                 if ( $phpErrorLevel !== $this->phpErrorLevel ) {
 252                         ini_set( 'error_reporting', $this->phpErrorLevel );
 253
 254                         $oldHex = strtoupper( dechex( $this->phpErrorLevel ) );
 255                         $newHex = strtoupper( dechex( $phpErrorLevel ) );
 256                         $message = "PHP error_reporting setting was left dirty: "
 257                                 . "was 0x$oldHex before test, 0x$newHex after test!";
 258
 259                         $this->fail( $message );
 260                 }
 261
 262                 parent::tearDown();
 263                 wfProfileOut( __METHOD__ );
 264         }
 265
 266         /**
 267          * Make sure MediaWikiTestCase extending classes have called their
 268          * parent setUp method
 269          */
 270         final public function testMediaWikiTestCaseParentSetupCalled() {
 271                 $this->assertArrayHasKey( 'setUp', $this->called,
 272                         get_called_class() . "::setUp() must call parent::setUp()"
 273                 );
 274         }
 275
 276         /**
 277          * Sets a global, maintaining a stashed version of the previous global to be
 278          * restored in tearDown
 279          *
 280          * The key is added to the array of globals that will be reset afterwards
 281          * in the tearDown().
 282          *
 283          * @example
 284          * <code>
 285          *     protected function setUp() {
 286          *         $this->setMwGlobals( 'wgRestrictStuff', true );
 287          *     }
 288          *
 289          *     function testFoo() {}
 290          *
 291          *     function testBar() {}
 292          *         $this->assertTrue( self::getX()->doStuff() );
 293          *
 294          *         $this->setMwGlobals( 'wgRestrictStuff', false );
 295          *         $this->assertTrue( self::getX()->doStuff() );
 296          *     }
 297          *
 298          *     function testQuux() {}
 299          * </code>
 300          *
 301          * @param array|string $pairs Key to the global variable, or an array
 302          *  of key/value pairs.
 303          * @param mixed $value Value to set the global to (ignored
 304          *  if an array is given as first argument).
 305          *
 306          * @since 1.21
 307          */
 308         protected function setMwGlobals( $pairs, $value = null ) {
 309                 if ( is_string( $pairs ) ) {
 310                         $pairs = array( $pairs => $value );
 311                 }
 312
 313                 $this->stashMwGlobals( array_keys( $pairs ) );
 314
 315                 foreach ( $pairs as $key => $value ) {
 316                         $GLOBALS[$key] = $value;
 317                 }
 318         }
 319
 320         /**
 321          * Stashes the global, will be restored in tearDown()
 322          *
 323          * Individual test functions may override globals through the setMwGlobals() function
 324          * or directly. When directly overriding globals their keys should first be passed to this
 325          * method in setUp to avoid breaking global state for other tests
 326          *
 327          * That way all other tests are executed with the same settings (instead of using the
 328          * unreliable local settings for most tests and fix it only for some tests).
 329          *
 330          * @param array|string $globalKeys Key to the global variable, or an array of keys.
 331          *
 332          * @throws Exception when trying to stash an unset global
 333          * @since 1.23
 334          */
 335         protected function stashMwGlobals( $globalKeys ) {
 336                 if ( is_string( $globalKeys ) ) {
 337                         $globalKeys = array( $globalKeys );
 338                 }
 339
 340                 foreach ( $globalKeys as $globalKey ) {
 341                         // NOTE: make sure we only save the global once or a second call to
 342                         // setMwGlobals() on the same global would override the original
 343                         // value.
 344                         if ( !array_key_exists( $globalKey, $this->mwGlobals ) ) {
 345                                 if ( !array_key_exists( $globalKey, $GLOBALS ) ) {
 346                                         throw new Exception( "Global with key {$globalKey} doesn't exist and cant be stashed" );
 347                                 }
 348                                 // NOTE: we serialize then unserialize the value in case it is an object
 349                                 // this stops any objects being passed by reference. We could use clone
 350                                 // and if is_object but this does account for objects within objects!
 351                                 try {
 352                                         $this->mwGlobals[$globalKey] = unserialize( serialize( $GLOBALS[$globalKey] ) );
 353                                 }
 354                                         // NOTE; some things such as Closures are not serializable
 355                                         // in this case just set the value!
 356                                 catch ( Exception $e ) {
 357                                         $this->mwGlobals[$globalKey] = $GLOBALS[$globalKey];
 358                                 }
 359                         }
 360                 }
 361         }
 362
 363         /**
 364          * Merges the given values into a MW global array variable.
 365          * Useful for setting some entries in a configuration array, instead of
 366          * setting the entire array.
 367          *
 368          * @param string $name The name of the global, as in wgFooBar
 369          * @param array $values The array containing the entries to set in that global
 370          *
 371          * @throws MWException if the designated global is not an array.
 372          *
 373          * @since 1.21
 374          */
 375         protected function mergeMwGlobalArrayValue( $name, $values ) {
 376                 if ( !isset( $GLOBALS[$name] ) ) {
 377                         $merged = $values;
 378                 } else {
 379                         if ( !is_array( $GLOBALS[$name] ) ) {
 380                                 throw new MWException( "MW global $name is not an array." );
 381                         }
 382
 383                         // NOTE: do not use array_merge, it screws up for numeric keys.
 384                         $merged = $GLOBALS[$name];
 385                         foreach ( $values as $k => $v ) {
 386                                 $merged[$k] = $v;
 387                         }
 388                 }
 389
 390                 $this->setMwGlobals( $name, $merged );
 391         }
 392
 393         /**
 394          * @return string
 395          * @since 1.18
 396          */
 397         public function dbPrefix() {
 398                 return $this->db->getType() == 'oracle' ? self::ORA_DB_PREFIX : self::DB_PREFIX;
 399         }
 400
 401         /**
 402          * @return bool
 403          * @since 1.18
 404          */
 405         public function needsDB() {
 406                 # if the test says it uses database tables, it needs the database
 407                 if ( $this->tablesUsed ) {
 408                         return true;
 409                 }
 410
 411                 # if the test says it belongs to the Database group, it needs the database
 412                 $rc = new ReflectionClass( $this );
 413                 if ( preg_match( '/@group +Database/im', $rc->getDocComment() ) ) {
 414                         return true;
 415                 }
 416
 417                 return false;
 418         }
 419
 420         /**
 421          * Stub. If a test needs to add additional data to the database, it should
 422          * implement this method and do so
 423          *
 424          * @since 1.18
 425          */
 426         public function addDBData() {
 427         }
 428
 429         private function addCoreDBData() {
 430                 if ( $this->db->getType() == 'oracle' ) {
 431
 432                         # Insert 0 user to prevent FK violations
 433                         # Anonymous user
 434                         $this->db->insert( 'user', array(
 435                                 'user_id' => 0,
 436                                 'user_name' => 'Anonymous' ), __METHOD__, array( 'IGNORE' ) );
 437
 438                         # Insert 0 page to prevent FK violations
 439                         # Blank page
 440                         $this->db->insert( 'page', array(
 441                                 'page_id' => 0,
 442                                 'page_namespace' => 0,
 443                                 'page_title' => ' ',
 444                                 'page_restrictions' => null,
 445                                 'page_counter' => 0,
 446                                 'page_is_redirect' => 0,
 447                                 'page_is_new' => 0,
 448                                 'page_random' => 0,
 449                                 'page_touched' => $this->db->timestamp(),
 450                                 'page_latest' => 0,
 451                                 'page_len' => 0 ), __METHOD__, array( 'IGNORE' ) );
 452                 }
 453
 454                 User::resetIdByNameCache();
 455
 456                 //Make sysop user
 457                 $user = User::newFromName( 'UTSysop' );
 458
 459                 if ( $user->idForName() == 0 ) {
 460                         $user->addToDatabase();
 461                         $user->setPassword( 'UTSysopPassword' );
 462
 463                         $user->addGroup( 'sysop' );
 464                         $user->addGroup( 'bureaucrat' );
 465                         $user->saveSettings();
 466                 }
 467
 468                 //Make 1 page with 1 revision
 469                 $page = WikiPage::factory( Title::newFromText( 'UTPage' ) );
 470                 if ( $page->getId() == 0 ) {
 471                         $page->doEditContent(
 472                                 new WikitextContent( 'UTContent' ),
 473                                 'UTPageSummary',
 474                                 EDIT_NEW,
 475                                 false,
 476                                 User::newFromName( 'UTSysop' ) );
 477                 }
 478         }
 479
 480         /**
 481          * Restores MediaWiki to using the table set (table prefix) it was using before
 482          * setupTestDB() was called. Useful if we need to perform database operations
 483          * after the test run has finished (such as saving logs or profiling info).
 484          *
 485          * @since 1.21
 486          */
 487         public static function teardownTestDB() {
 488                 if ( !self::$dbSetup ) {
 489                         return;
 490                 }
 491
 492                 CloneDatabase::changePrefix( self::$oldTablePrefix );
 493
 494                 self::$oldTablePrefix = false;
 495                 self::$dbSetup = false;
 496         }
 497
 498         /**
 499          * Creates an empty skeleton of the wiki database by cloning its structure
 500          * to equivalent tables using the given $prefix. Then sets MediaWiki to
 501          * use the new set of tables (aka schema) instead of the original set.
 502          *
 503          * This is used to generate a dummy table set, typically consisting of temporary
 504          * tables, that will be used by tests instead of the original wiki database tables.
 505          *
 506          * @since 1.21
 507          *
 508          * @note: the original table prefix is stored in self::$oldTablePrefix. This is used
 509          * by teardownTestDB() to return the wiki to using the original table set.
 510          *
 511          * @note: this method only works when first called. Subsequent calls have no effect,
 512          * even if using different parameters.
 513          *
 514          * @param DatabaseBase $db The database connection
 515          * @param string $prefix The prefix to use for the new table set (aka schema).
 516          *
 517          * @throws MWException if the database table prefix is already $prefix
 518          */
 519         public static function setupTestDB( DatabaseBase $db, $prefix ) {
 520                 global $wgDBprefix;
 521                 if ( $wgDBprefix === $prefix ) {
 522                         throw new MWException(
 523                                 'Cannot run unit tests, the database prefix is already "' . $prefix . '"' );
 524                 }
 525
 526                 if ( self::$dbSetup ) {
 527                         return;
 528                 }
 529
 530                 $tablesCloned = self::listTables( $db );
 531                 $dbClone = new CloneDatabase( $db, $tablesCloned, $prefix );
 532                 $dbClone->useTemporaryTables( self::$useTemporaryTables );
 533
 534                 self::$dbSetup = true;
 535                 self::$oldTablePrefix = $wgDBprefix;
 536
 537                 if ( ( $db->getType() == 'oracle' || !self::$useTemporaryTables ) && self::$reuseDB ) {
 538                         CloneDatabase::changePrefix( $prefix );
 539
 540                         return;
 541                 } else {
 542                         $dbClone->cloneTableStructure();
 543                 }
 544
 545                 if ( $db->getType() == 'oracle' ) {
 546                         $db->query( 'BEGIN FILL_WIKI_INFO; END;' );
 547                 }
 548         }
 549
 550         /**
 551          * Empty all tables so they can be repopulated for tests
 552          */
 553         private function resetDB() {
 554                 if ( $this->db ) {
 555                         if ( $this->db->getType() == 'oracle' ) {
 556                                 if ( self::$useTemporaryTables ) {
 557                                         wfGetLB()->closeAll();
 558                                         $this->db = wfGetDB( DB_MASTER );
 559                                 } else {
 560                                         foreach ( $this->tablesUsed as $tbl ) {
 561                                                 if ( $tbl == 'interwiki' ) {
 562                                                         continue;
 563                                                 }
 564                                                 $this->db->query( 'TRUNCATE TABLE ' . $this->db->tableName( $tbl ), __METHOD__ );
 565                                         }
 566                                 }
 567                         } else {
 568                                 foreach ( $this->tablesUsed as $tbl ) {
 569                                         if ( $tbl == 'interwiki' || $tbl == 'user' ) {
 570                                                 continue;
 571                                         }
 572                                         $this->db->delete( $tbl, '*', __METHOD__ );
 573                                 }
 574                         }
 575                 }
 576         }
 577
 578         /**
 579          * @since 1.18
 580          *
 581          * @param string $func
 582          * @param array $args
 583          *
 584          * @return mixed
 585          * @throws MWException
 586          */
 587         public function __call( $func, $args ) {
 588                 static $compatibility = array(
 589                         'assertEmpty' => 'assertEmpty2', // assertEmpty was added in phpunit 3.7.32
 590                 );
 591
 592                 if ( isset( $compatibility[$func] ) ) {
 593                         return call_user_func_array( array( $this, $compatibility[$func] ), $args );
 594                 } else {
 595                         throw new MWException( "Called non-existant $func method on "
 596                                 . get_class( $this ) );
 597                 }
 598         }
 599
 600         /**
 601          * Used as a compatibility method for phpunit < 3.7.32
 602          * @param string $value
 603          * @param string $msg
 604          */
 605         private function assertEmpty2( $value, $msg ) {
 606                 return $this->assertTrue( $value == '', $msg );
 607         }
 608
 609         private static function unprefixTable( $tableName ) {
 610                 global $wgDBprefix;
 611
 612                 return substr( $tableName, strlen( $wgDBprefix ) );
 613         }
 614
 615         private static function isNotUnittest( $table ) {
 616                 return strpos( $table, 'unittest_' ) !== 0;
 617         }
 618
 619         /**
 620          * @since 1.18
 621          *
 622          * @param DataBaseBase $db
 623          *
 624          * @return array
 625          */
 626         public static function listTables( $db ) {
 627                 global $wgDBprefix;
 628
 629                 $tables = $db->listTables( $wgDBprefix, __METHOD__ );
 630
 631                 if ( $db->getType() === 'mysql' ) {
 632                         # bug 43571: cannot clone VIEWs under MySQL
 633                         $views = $db->listViews( $wgDBprefix, __METHOD__ );
 634                         $tables = array_diff( $tables, $views );
 635                 }
 636                 $tables = array_map( array( __CLASS__, 'unprefixTable' ), $tables );
 637
 638                 // Don't duplicate test tables from the previous fataled run
 639                 $tables = array_filter( $tables, array( __CLASS__, 'isNotUnittest' ) );
 640
 641                 if ( $db->getType() == 'sqlite' ) {
 642                         $tables = array_flip( $tables );
 643                         // these are subtables of searchindex and don't need to be duped/dropped separately
 644                         unset( $tables['searchindex_content'] );
 645                         unset( $tables['searchindex_segdir'] );
 646                         unset( $tables['searchindex_segments'] );
 647                         $tables = array_flip( $tables );
 648                 }
 649
 650                 return $tables;
 651         }
 652
 653         /**
 654          * @throws MWException
 655          * @since 1.18
 656          */
 657         protected function checkDbIsSupported() {
 658                 if ( !in_array( $this->db->getType(), $this->supportedDBs ) ) {
 659                         throw new MWException( $this->db->getType() . " is not currently supported for unit testing." );
 660                 }
 661         }
 662
 663         /**
 664          * @since 1.18
 665          * @param string $offset
 666          * @return mixed
 667          */
 668         public function getCliArg( $offset ) {
 669                 if ( isset( MediaWikiPHPUnitCommand::$additionalOptions[$offset] ) ) {
 670                         return MediaWikiPHPUnitCommand::$additionalOptions[$offset];
 671                 }
 672         }
 673
 674         /**
 675          * @since 1.18
 676          * @param string $offset
 677          * @param mixed $value
 678          */
 679         public function setCliArg( $offset, $value ) {
 680                 MediaWikiPHPUnitCommand::$additionalOptions[$offset] = $value;
 681         }
 682
 683         /**
 684          * Don't throw a warning if $function is deprecated and called later
 685          *
 686          * @since 1.19
 687          *
 688          * @param string $function
 689          */
 690         public function hideDeprecated( $function ) {
 691                 wfSuppressWarnings();
 692                 wfDeprecated( $function );
 693                 wfRestoreWarnings();
 694         }
 695
 696         /**
 697          * Asserts that the given database query yields the rows given by $expectedRows.
 698          * The expected rows should be given as indexed (not associative) arrays, with
 699          * the values given in the order of the columns in the $fields parameter.
 700          * Note that the rows are sorted by the columns given in $fields.
 701          *
 702          * @since 1.20
 703          *
 704          * @param string|array $table The table(s) to query
 705          * @param string|array $fields The columns to include in the result (and to sort by)
 706          * @param string|array $condition "where" condition(s)
 707          * @param array $expectedRows An array of arrays giving the expected rows.
 708          *
 709          * @throws MWException If this test cases's needsDB() method doesn't return true.
 710          *         Test cases can use "@group Database" to enable database test support,
 711          *         or list the tables under testing in $this->tablesUsed, or override the
 712          *         needsDB() method.
 713          */
 714         protected function assertSelect( $table, $fields, $condition, array $expectedRows ) {
 715                 if ( !$this->needsDB() ) {
 716                         throw new MWException( 'When testing database state, the test cases\'s needDB()' .
 717                                 ' method should return true. Use @group Database or $this->tablesUsed.' );
 718                 }
 719
 720                 $db = wfGetDB( DB_SLAVE );
 721
 722                 $res = $db->select( $table, $fields, $condition, wfGetCaller(), array( 'ORDER BY' => $fields ) );
 723                 $this->assertNotEmpty( $res, "query failed: " . $db->lastError() );
 724
 725                 $i = 0;
 726
 727                 foreach ( $expectedRows as $expected ) {
 728                         $r = $res->fetchRow();
 729                         self::stripStringKeys( $r );
 730
 731                         $i += 1;
 732                         $this->assertNotEmpty( $r, "row #$i missing" );
 733
 734                         $this->assertEquals( $expected, $r, "row #$i mismatches" );
 735                 }
 736
 737                 $r = $res->fetchRow();
 738                 self::stripStringKeys( $r );
 739
 740                 $this->assertFalse( $r, "found extra row (after #$i)" );
 741         }
 742
 743         /**
 744          * Utility method taking an array of elements and wrapping
 745          * each element in it's own array. Useful for data providers
 746          * that only return a single argument.
 747          *
 748          * @since 1.20
 749          *
 750          * @param array $elements
 751          *
 752          * @return array
 753          */
 754         protected function arrayWrap( array $elements ) {
 755                 return array_map(
 756                         function ( $element ) {
 757                                 return array( $element );
 758                         },
 759                         $elements
 760                 );
 761         }
 762
 763         /**
 764          * Assert that two arrays are equal. By default this means that both arrays need to hold
 765          * the same set of values. Using additional arguments, order and associated key can also
 766          * be set as relevant.
 767          *
 768          * @since 1.20
 769          *
 770          * @param array $expected
 771          * @param array $actual
 772          * @param bool $ordered If the order of the values should match
 773          * @param bool $named If the keys should match
 774          */
 775         protected function assertArrayEquals( array $expected, array $actual,
 776                 $ordered = false, $named = false
 777         ) {
 778                 if ( !$ordered ) {
 779                         $this->objectAssociativeSort( $expected );
 780                         $this->objectAssociativeSort( $actual );
 781                 }
 782
 783                 if ( !$named ) {
 784                         $expected = array_values( $expected );
 785                         $actual = array_values( $actual );
 786                 }
 787
 788                 call_user_func_array(
 789                         array( $this, 'assertEquals' ),
 790                         array_merge( array( $expected, $actual ), array_slice( func_get_args(), 4 ) )
 791                 );
 792         }
 793
 794         /**
 795          * Put each HTML element on its own line and then equals() the results
 796          *
 797          * Use for nicely formatting of PHPUnit diff output when comparing very
 798          * simple HTML
 799          *
 800          * @since 1.20
 801          *
 802          * @param string $expected HTML on oneline
 803          * @param string $actual HTML on oneline
 804          * @param string $msg Optional message
 805          */
 806         protected function assertHTMLEquals( $expected, $actual, $msg = '' ) {
 807                 $expected = str_replace( '>', ">\n", $expected );
 808                 $actual = str_replace( '>', ">\n", $actual );
 809
 810                 $this->assertEquals( $expected, $actual, $msg );
 811         }
 812
 813         /**
 814          * Does an associative sort that works for objects.
 815          *
 816          * @since 1.20
 817          *
 818          * @param array $array
 819          */
 820         protected function objectAssociativeSort( array &$array ) {
 821                 uasort(
 822                         $array,
 823                         function ( $a, $b ) {
 824                                 return serialize( $a ) > serialize( $b ) ? 1 : -1;
 825                         }
 826                 );
 827         }
 828
 829         /**
 830          * Utility function for eliminating all string keys from an array.
 831          * Useful to turn a database result row as returned by fetchRow() into
 832          * a pure indexed array.
 833          *
 834          * @since 1.20
 835          *
 836          * @param mixed $r The array to remove string keys from.
 837          */
 838         protected static function stripStringKeys( &$r ) {
 839                 if ( !is_array( $r ) ) {
 840                         return;
 841                 }
 842
 843                 foreach ( $r as $k => $v ) {
 844                         if ( is_string( $k ) ) {
 845                                 unset( $r[$k] );
 846                         }
 847                 }
 848         }
 849
 850         /**
 851          * Asserts that the provided variable is of the specified
 852          * internal type or equals the $value argument. This is useful
 853          * for testing return types of functions that return a certain
 854          * type or *value* when not set or on error.
 855          *
 856          * @since 1.20
 857          *
 858          * @param string $type
 859          * @param mixed $actual
 860          * @param mixed $value
 861          * @param string $message
 862          */
 863         protected function assertTypeOrValue( $type, $actual, $value = false, $message = '' ) {
 864                 if ( $actual === $value ) {
 865                         $this->assertTrue( true, $message );
 866                 } else {
 867                         $this->assertType( $type, $actual, $message );
 868                 }
 869         }
 870
 871         /**
 872          * Asserts the type of the provided value. This can be either
 873          * in internal type such as boolean or integer, or a class or
 874          * interface the value extends or implements.
 875          *
 876          * @since 1.20
 877          *
 878          * @param string $type
 879          * @param mixed $actual
 880          * @param string $message
 881          */
 882         protected function assertType( $type, $actual, $message = '' ) {
 883                 if ( class_exists( $type ) || interface_exists( $type ) ) {
 884                         $this->assertInstanceOf( $type, $actual, $message );
 885                 } else {
 886                         $this->assertInternalType( $type, $actual, $message );
 887                 }
 888         }
 889
 890         /**
 891          * Returns true if the given namespace defaults to Wikitext
 892          * according to $wgNamespaceContentModels
 893          *
 894          * @param int $ns The namespace ID to check
 895          *
 896          * @return bool
 897          * @since 1.21
 898          */
 899         protected function isWikitextNS( $ns ) {
 900                 global $wgNamespaceContentModels;
 901
 902                 if ( isset( $wgNamespaceContentModels[$ns] ) ) {
 903                         return $wgNamespaceContentModels[$ns] === CONTENT_MODEL_WIKITEXT;
 904                 }
 905
 906                 return true;
 907         }
 908
 909         /**
 910          * Returns the ID of a namespace that defaults to Wikitext.
 911          *
 912          * @throws MWException If there is none.
 913          * @return int The ID of the wikitext Namespace
 914          * @since 1.21
 915          */
 916         protected function getDefaultWikitextNS() {
 917                 global $wgNamespaceContentModels;
 918
 919                 static $wikitextNS = null; // this is not going to change
 920                 if ( $wikitextNS !== null ) {
 921                         return $wikitextNS;
 922                 }
 923
 924                 // quickly short out on most common case:
 925                 if ( !isset( $wgNamespaceContentModels[NS_MAIN] ) ) {
 926                         return NS_MAIN;
 927                 }
 928
 929                 // NOTE: prefer content namespaces
 930                 $namespaces = array_unique( array_merge(
 931                         MWNamespace::getContentNamespaces(),
 932                         array( NS_MAIN, NS_HELP, NS_PROJECT ), // prefer these
 933                         MWNamespace::getValidNamespaces()
 934                 ) );
 935
 936                 $namespaces = array_diff( $namespaces, array(
 937                         NS_FILE, NS_CATEGORY, NS_MEDIAWIKI, NS_USER // don't mess with magic namespaces
 938                 ) );
 939
 940                 $talk = array_filter( $namespaces, function ( $ns ) {
 941                         return MWNamespace::isTalk( $ns );
 942                 } );
 943
 944                 // prefer non-talk pages
 945                 $namespaces = array_diff( $namespaces, $talk );
 946                 $namespaces = array_merge( $namespaces, $talk );
 947
 948                 // check default content model of each namespace
 949                 foreach ( $namespaces as $ns ) {
 950                         if ( !isset( $wgNamespaceContentModels[$ns] ) ||
 951                                 $wgNamespaceContentModels[$ns] === CONTENT_MODEL_WIKITEXT
 952                         ) {
 953
 954                                 $wikitextNS = $ns;
 955
 956                                 return $wikitextNS;
 957                         }
 958                 }
 959
 960                 // give up
 961                 // @todo Inside a test, we could skip the test as incomplete.
 962                 //        But frequently, this is used in fixture setup.
 963                 throw new MWException( "No namespace defaults to wikitext!" );
 964         }
 965
 966         /**
 967          * Check, if $wgDiff3 is set and ready to merge
 968          * Will mark the calling test as skipped, if not ready
 969          *
 970          * @since 1.21
 971          */
 972         protected function checkHasDiff3() {
 973                 global $wgDiff3;
 974
 975                 # This check may also protect against code injection in
 976                 # case of broken installations.
 977                 wfSuppressWarnings();
 978                 $haveDiff3 = $wgDiff3 && file_exists( $wgDiff3 );
 979                 wfRestoreWarnings();
 980
 981                 if ( !$haveDiff3 ) {
 982                         $this->markTestSkipped( "Skip test, since diff3 is not configured" );
 983                 }
 984         }
 985
 986         /**
 987          * Check whether we have the 'gzip' commandline utility, will skip
 988          * the test whenever "gzip -V" fails.
 989          *
 990          * Result is cached at the process level.
 991          *
 992          * @return bool
 993          *
 994          * @since 1.21
 995          */
 996         protected function checkHasGzip() {
 997                 static $haveGzip;
 998
 999                 if ( $haveGzip === null ) {
1000                         $retval = null;
1001                         wfShellExec( 'gzip -V', $retval );
1002                         $haveGzip = ( $retval === 0 );
1003                 }
1004
1005                 if ( !$haveGzip ) {
1006                         $this->markTestSkipped( "Skip test, requires the gzip utility in PATH" );
1007                 }
1008
1009                 return $haveGzip;
1010         }
1011
1012         /**
1013          * Check if $extName is a loaded PHP extension, will skip the
1014          * test whenever it is not loaded.
1015          *
1016          * @since 1.21
1017          * @param string $extName
1018          * @return bool
1019          */
1020         protected function checkPHPExtension( $extName ) {
1021                 $loaded = extension_loaded( $extName );
1022                 if ( !$loaded ) {
1023                         $this->markTestSkipped( "PHP extension '$extName' is not loaded, skipping." );
1024                 }
1025
1026                 return $loaded;
1027         }
1028
1029         /**
1030          * Asserts that an exception of the specified type occurs when running
1031          * the provided code.
1032          *
1033          * @since 1.21
1034          * @deprecated since 1.22 Use setExpectedException
1035          *
1036          * @param callable $code
1037          * @param string $expected
1038          * @param string $message
1039          */
1040         protected function assertException( $code, $expected = 'Exception', $message = '' ) {
1041                 $pokemons = null;
1042
1043                 try {
1044                         call_user_func( $code );
1045                 } catch ( Exception $pokemons ) {
1046                         // Gotta Catch 'Em All!
1047                 }
1048
1049                 if ( $message === '' ) {
1050                         $message = 'An exception of type "' . $expected . '" should have been thrown';
1051                 }
1052
1053                 $this->assertInstanceOf( $expected, $pokemons, $message );
1054         }
1055
1056         /**
1057          * Asserts that the given string is a valid HTML snippet.
1058          * Wraps the given string in the required top level tags and
1059          * then calls assertValidHtmlDocument().
1060          * The snippet is expected to be HTML 5.
1061          *
1062          * @since 1.23
1063          *
1064          * @note Will mark the test as skipped if the "tidy" module is not installed.
1065          * @note This ignores $wgUseTidy, so we can check for valid HTML even (and especially)
1066          *        when automatic tidying is disabled.
1067          *
1068          * @param string $html An HTML snippet (treated as the contents of the body tag).
1069          */
1070         protected function assertValidHtmlSnippet( $html ) {
1071                 $html = '<!DOCTYPE html><html><head><title>test</title></head><body>' . $html . '</body></html>';
1072                 $this->assertValidHtmlDocument( $html );
1073         }
1074
1075         /**
1076          * Asserts that the given string is valid HTML document.
1077          *
1078          * @since 1.23
1079          *
1080          * @note Will mark the test as skipped if the "tidy" module is not installed.
1081          * @note This ignores $wgUseTidy, so we can check for valid HTML even (and especially)
1082          *        when automatic tidying is disabled.
1083          *
1084          * @param string $html A complete HTML document
1085          */
1086         protected function assertValidHtmlDocument( $html ) {
1087                 // Note: we only validate if the tidy PHP extension is available.
1088                 // In case wgTidyInternal is false, MWTidy would fall back to the command line version
1089                 // of tidy. In that case however, we can not reliably detect whether a failing validation
1090                 // is due to malformed HTML, or caused by tidy not being installed as a command line tool.
1091                 // That would cause all HTML assertions to fail on a system that has no tidy installed.
1092                 if ( !$GLOBALS['wgTidyInternal'] ) {
1093                         $this->markTestSkipped( 'Tidy extension not installed' );
1094                 }
1095
1096                 $errorBuffer = '';
1097                 MWTidy::checkErrors( $html, $errorBuffer );
1098                 $allErrors = preg_split( '/[\r\n]+/', $errorBuffer );
1099
1100                 // Filter Tidy warnings which aren't useful for us.
1101                 // Tidy eg. often cries about parameters missing which have actually
1102                 // been deprecated since HTML4, thus we should not care about them.
1103                 $errors = preg_grep(
1104                         '/^(.*Warning: (trimming empty|.* lacks ".*?" attribute).*|\s*)$/m',
1105                         $allErrors, PREG_GREP_INVERT
1106                 );
1107
1108                 $this->assertEmpty( $errors, implode( "\n", $errors ) );
1109         }
1110 }