Revert r35538:
[lhc/web/wiklou.git] / maintenance / parserTests.inc
index c85220d..a005813 100644 (file)
@@ -20,8 +20,8 @@
 /**
  * @todo Make this more independent of the configuration (and if possible the database)
  * @todo document
- * @package MediaWiki
- * @subpackage Maintenance
+ * @file
+ * @ingroup Maintenance
  */
 
 /** */
@@ -29,46 +29,32 @@ $options = array( 'quick', 'color', 'quiet', 'help', 'show-output', 'record' );
 $optionsWithArgs = array( 'regex' );
 
 require_once( 'commandLine.inc' );
-require_once( "$IP/includes/ObjectCache.php" );
-require_once( "$IP/includes/BagOStuff.php" );
-require_once( "$IP/includes/Hooks.php" );
 require_once( "$IP/maintenance/parserTestsParserHook.php" );
 require_once( "$IP/maintenance/parserTestsStaticParserHook.php" );
 require_once( "$IP/maintenance/parserTestsParserTime.php" );
 
 /**
- * @package MediaWiki
- * @subpackage Maintenance
+ * @ingroup Maintenance
  */
 class ParserTest {
        /**
         * boolean $color whereas output should be colorized
-        * @private
         */
-       var $color;
-
-       /**
-        * boolean $lightcolor whereas output should use light colors
-        * @private
-        */
-       var $lightcolor;
+       private $color;
 
        /**
         * boolean $showOutput Show test output
         */
-       var $showOutput;
+       private $showOutput;
 
        /**
         * Sets terminal colorization and diff/quick modes depending on OS and
         * command-line options (--color and --quick).
-        *
-        * @public
         */
-       function ParserTest() {
+       public function ParserTest() {
                global $options;
 
                # Only colorize output if stdout is a terminal.
-               $this->lightcolor = false;
                $this->color = !wfIsWindows() && posix_isatty(1);
 
                if( isset( $options['color'] ) ) {
@@ -76,9 +62,6 @@ class ParserTest {
                        case 'no':
                                $this->color = false;
                                break;
-                       case 'light':
-                               $this->lightcolor = true;
-                               # Fall through
                        case 'yes':
                        default:
                                $this->color = true;
@@ -86,11 +69,16 @@ class ParserTest {
                        }
                }
                $this->term = $this->color
-                       ? new AnsiTermColorer( $this->lightcolor )
+                       ? new AnsiTermColorer()
                        : new DummyTermColorer();
 
                $this->showDiffs = !isset( $options['quick'] );
-               $this->quiet = isset( $options['quiet'] );
+               $this->showProgress = !isset( $options['quiet'] );
+               $this->showFailure = !(
+                       isset( $options['quiet'] )
+                       && ( isset( $options['record'] )
+                               || isset( $options['compare'] ) ) ); // redundant output
+               
                $this->showOutput = isset( $options['show-output'] );
 
 
@@ -100,22 +88,24 @@ class ParserTest {
                        # Matches anything
                        $this->regex = '';
                }
-               
+
                if( isset( $options['record'] ) ) {
                        $this->recorder = new DbTestRecorder( $this->term );
+               } elseif( isset( $options['compare'] ) ) {
+                       $this->recorder = new DbTestPreviewer( $this->term );
                } else {
                        $this->recorder = new TestRecorder( $this->term );
                }
-               
+               $this->keepUploads = isset( $options['keep-uploads'] );
+
                $this->hooks = array();
                $this->functionHooks = array();
        }
 
        /**
         * Remove last character if it is a newline
-        * @private
         */
-       function chomp($s) {
+       private function chomp($s) {
                if (substr($s, -1) === "\n") {
                        return substr($s, 0, -1);
                }
@@ -134,28 +124,26 @@ class ParserTest {
         *
         * @param array of strings $filenames
         * @return bool True if passed all tests, false if any tests failed.
-        * @public
         */
-       function runTestsFromFiles( $filenames ) {
+       public function runTestsFromFiles( $filenames ) {
                $this->recorder->start();
                $ok = true;
                foreach( $filenames as $filename ) {
                        $ok = $this->runFile( $filename ) && $ok;
                }
-               $this->recorder->end();
                $this->recorder->report();
+               $this->recorder->end();
                return $ok;
        }
-       
+
        private function runFile( $filename ) {
                $infile = fopen( $filename, 'rt' );
                if( !$infile ) {
                        wfDie( "Couldn't open $filename\n" );
                } else {
-                       print $this->term->color( 1 ) .
-                               "Reading tests from \"$filename\"..." .
-                               $this->term->reset() .
-                               "\n";
+                       global $IP;
+                       $relative = wfRelativePath( $filename, $IP );
+                       $this->showRunFile( $relative );
                }
 
                $data = array();
@@ -164,6 +152,7 @@ class ParserTest {
                $ok = true;
                while( false !== ($line = fgets( $infile ) ) ) {
                        $n++;
+                       $matches = array();
                        if( preg_match( '/^!!\s*(\w+)/', $line, $matches ) ) {
                                $section = strtolower( $matches[1] );
                                if( $section == 'endarticle') {
@@ -250,7 +239,9 @@ class ParserTest {
                                $data[$section] .= $line;
                        }
                }
-               print "\n";
+               if ( $this->showProgress ) {
+                       print "\n";
+               }
                return $ok;
        }
 
@@ -263,8 +254,9 @@ class ParserTest {
         * @param string $result Result to output
         * @return bool
         */
-       function runTest( $desc, $input, $result, $opts ) {
-               if( !$this->quiet ) {
+       private function runTest( $desc, $input, $result, $opts ) {
+               global $wgParserConf;
+               if( $this->showProgress ) {
                        $this->showTesting( $desc );
                }
 
@@ -278,6 +270,7 @@ class ParserTest {
                        $options->setUseTex(true);
                }
 
+               $m = array();
                if (preg_match('/title=\[\[(.*)\]\]/', $opts, $m)) {
                        $titleText = $m[1];
                }
@@ -287,26 +280,29 @@ class ParserTest {
 
                $noxml = (bool)preg_match( '~\\b noxml \\b~x', $opts );
 
-               $parser = new Parser();
+               $class = $wgParserConf['class'];
+               $parser = new $class( $wgParserConf );
                foreach( $this->hooks as $tag => $callback ) {
                        $parser->setHook( $tag, $callback );
                }
-               foreach( $this->functionHooks as $tag => $callback ) {
-                       $parser->setFunctionHook( $tag, $callback );
+               foreach( $this->functionHooks as $tag => $bits ) {
+                       list( $callback, $flags ) = $bits;
+                       $parser->setFunctionHook( $tag, $callback, $flags );
                }
                wfRunHooks( 'ParserTestParser', array( &$parser ) );
-               
+
                $title =& Title::makeTitle( NS_MAIN, $titleText );
 
+               $matches = array();
                if (preg_match('/\\bpst\\b/i', $opts)) {
                        $out = $parser->preSaveTransform( $input, $title, $user, $options );
                } elseif (preg_match('/\\bmsg\\b/i', $opts)) {
                        $out = $parser->transformMsg( $input, $options );
-               } elseif( preg_match( '/\\bsection=(\d+)\b/i', $opts, $matches ) ) {
-                       $section = intval( $matches[1] );
+               } elseif( preg_match( '/\\bsection=([\w-]+)\b/i', $opts, $matches ) ) {
+                       $section = $matches[1];
                        $out = $parser->getSection( $input, $section );
-               } elseif( preg_match( '/\\breplace=(\d+),"(.*?)"/i', $opts, $matches ) ) {
-                       $section = intval( $matches[1] );
+               } elseif( preg_match( '/\\breplace=([\w-]+),"(.*?)"/i', $opts, $matches ) ) {
+                       $section = $matches[1];
                        $replace = $matches[2];
                        $out = $parser->replaceSection( $input, $section, $replace );
                } else {
@@ -318,7 +314,8 @@ class ParserTest {
                        } else if (preg_match('/\\bcat\\b/i', $opts)) {
                                global $wgOut;
                                $wgOut->addCategoryLinks($output->getCategories());
-                               $out = $this->tidy ( implode( ' ', $wgOut->getCategoryLinks() ) );
+                               $cats = $wgOut->getCategoryLinks();
+                               $out = $this->tidy( implode( ' ', $cats['normal'] ) );
                        }
 
                        $result = $this->tidy($result);
@@ -333,15 +330,29 @@ class ParserTest {
                }
        }
 
+
+       /**
+        * Use a regex to find out the value of an option
+        * @param $regex A regex, the first group will be the value returned
+        * @param $opts Options line to look in
+        * @param $defaults Default value returned if the regex does not match
+        */
+       private static function getOptionValue( $regex, $opts, $default ) {
+               $m = array();
+               if( preg_match( $regex, $opts, $m ) ) {
+                       return $m[1];
+               } else {
+                       return $default;
+               }
+       }
+
        /**
         * Set up the global variables for a consistent environment for each test.
         * Ideally this should replace the global configuration entirely.
-        *
-        * @private
         */
-       function setupGlobals($opts = '') {
+       private function setupGlobals($opts = '') {
                # Save the prefixed / quoted table names for later use when we make the temporaries.
-               $db =& wfGetDB( DB_READ );
+               $db = wfGetDB( DB_SLAVE );
                $this->oldTableNames = array();
                foreach( $this->listTables() as $table ) {
                        $this->oldTableNames[$table] = $db->tableName( $table );
@@ -349,18 +360,14 @@ class ParserTest {
                if( !isset( $this->uploadDir ) ) {
                        $this->uploadDir = $this->setupUploadDir();
                }
-               
-               if( preg_match( '/language=([a-z]+(?:_[a-z]+)?)/', $opts, $m ) ) {
-                       $lang = $m[1];
-               } else {
-                       $lang = 'en';
-               }
-
-               if( preg_match( '/variant=([a-z]+(?:-[a-z]+)?)/', $opts, $m ) )
-                       $variant = $m[1];
-               else 
-                       $variant = false;
 
+               # Find out values for some special options.
+               $lang =
+                       self::getOptionValue( '/language=([a-z]+(?:_[a-z]+)?)/', $opts, 'en' );
+               $variant =
+                       self::getOptionValue( '/variant=([a-z]+(?:-[a-z]+)?)/', $opts, false );
+               $maxtoclevel =
+                       self::getOptionValue( '/wgMaxTocLevel=(\d+)/', $opts, 999 );
 
                $settings = array(
                        'wgServer' => 'http://localhost',
@@ -368,8 +375,15 @@ class ParserTest {
                        'wgScriptPath' => '/',
                        'wgArticlePath' => '/wiki/$1',
                        'wgActionPaths' => array(),
-                       'wgUploadPath' => 'http://example.com/images',
-                       'wgUploadDirectory' => $this->uploadDir,
+                       'wgLocalFileRepo' => array(
+                               'class' => 'LocalRepo',
+                               'name' => 'local',
+                               'directory' => $this->uploadDir,
+                               'url' => 'http://example.com/images',
+                               'hashLevels' => 2,
+                               'transformVia404' => false,
+                       ),
+                       'wgEnableUploads' => true,
                        'wgStyleSheetPath' => '/skins',
                        'wgSitename' => 'MediaWiki',
                        'wgServerName' => 'Britney Spears',
@@ -380,7 +394,7 @@ class ParserTest {
                        'wgLang' => null,
                        'wgContLang' => null,
                        'wgNamespacesWithSubpages' => array( 0 => preg_match('/\\bsubpage\\b/i', $opts)),
-                       'wgMaxTocLevel' => 999,
+                       'wgMaxTocLevel' => $maxtoclevel,
                        'wgCapitalLinks' => true,
                        'wgNoFollowLinks' => true,
                        'wgThumbnailScriptPath' => false,
@@ -390,6 +404,14 @@ class ParserTest {
                        'wgUseTidy' => false,
                        'wgDefaultLanguageVariant' => $variant,
                        'wgVariantArticlePath' => false,
+                       'wgGroupPermissions' => array( '*' => array(
+                               'createaccount' => true,
+                               'read'          => true,
+                               'edit'          => true,
+                               'createpage'    => true,
+                               'createtalk'    => true,
+                       ) ),
+                       'wgDefaultExternalStore' => array(),
                        );
                $this->savedGlobals = array();
                foreach( $settings as $var => $val ) {
@@ -400,7 +422,6 @@ class ParserTest {
                $GLOBALS['wgLang'] = $langObj;
                $GLOBALS['wgContLang'] = $langObj;
 
-               $GLOBALS['wgLoadBalancer']->loadMasterPos();
                //$GLOBALS['wgMessageCache'] = new MessageCache( new BagOStuff(), false, 0, $GLOBALS['wgDBname'] );
                $this->setupDatabase();
 
@@ -408,28 +429,28 @@ class ParserTest {
                $wgUser = new User();
        }
 
-       # List of temporary tables to create, without prefix
-       # Some of these probably aren't necessary
-       function listTables() {
-               $tables = array('user', 'page', 'revision', 'text',
-                       'pagelinks', 'imagelinks', 'categorylinks',
-                       'templatelinks', 'externallinks', 'langlinks',
-                       'site_stats', 'hitcounter',
-                       'ipblocks', 'image', 'oldimage',
-                       'recentchanges',
-                       'watchlist', 'math', 'searchindex',
-                       'interwiki', 'querycache',
-                       'objectcache', 'job', 'redirect',
-                       'querycachetwo'
+       /**
+        * List of temporary tables to create, without prefix.
+        * Some of these probably aren't necessary.
+        */
+       private function listTables() {
+               global $wgDBtype;
+               $tables = array('user', 'page', 'page_restrictions',
+                       'protected_titles', 'revision', 'text', 'pagelinks', 'imagelinks',
+                       'categorylinks', 'templatelinks', 'externallinks', 'langlinks',
+                       'site_stats', 'hitcounter',     'ipblocks', 'image', 'oldimage',
+                       'recentchanges', 'watchlist', 'math', 'interwiki',
+                       'querycache', 'objectcache', 'job', 'redirect', 'querycachetwo',
+                       'archive', 'user_groups', 'page_props', 'category'
                );
 
-               // FIXME manually adding additional table for the tasks extension
-               // we probably need a better software wide system to register new
-               // tables.
-               global $wgExtensionFunctions;
-               if( in_array('wfTasksExtension' , $wgExtensionFunctions ) ) {
-                       $tables[] = 'tasks';
-               }
+               if ($wgDBtype === 'mysql') 
+                       array_push( $tables, 'searchindex' );
+               
+               // Allow extensions to add to the list of tables to duplicate;
+               // may be necessary if they hook into page save or other code
+               // which will require them while running tests.
+               wfRunHooks( 'ParserTestTables', array( &$tables ) );
 
                return $tables;
        }
@@ -438,18 +459,16 @@ class ParserTest {
         * Set up a temporary set of wiki tables to work with for the tests.
         * Currently this will only be done once per run, and any changes to
         * the db will be visible to later tests in the run.
-        *
-        * @private
         */
-       function setupDatabase() {
+       private function setupDatabase() {
                static $setupDB = false;
                global $wgDBprefix;
 
                # Make sure we don't mess with the live DB
                if (!$setupDB && $wgDBprefix === 'parsertest_') {
                        # oh teh horror
-                       $GLOBALS['wgLoadBalancer'] = LoadBalancer::newFromParams( $GLOBALS['wgDBservers'] );
-                       $db =& wfGetDB( DB_MASTER );
+                       LBFactory::destroy();
+                       $db = wfGetDB( DB_MASTER );
 
                        $tables = $this->listTables();
 
@@ -525,7 +544,7 @@ class ParserTest {
                                'img_minor_mime'  => "jpeg",
                                'img_metadata'    => serialize( array() ),
                                ) );
-                               
+
                        # Update certain things in site_stats
                        $db->insert( 'site_stats', array( 'ss_row_id' => 1, 'ss_images' => 1, 'ss_good_articles' => 1 ) );
 
@@ -537,34 +556,32 @@ class ParserTest {
         * Create a dummy uploads directory which will contain a couple
         * of files in order to pass existence tests.
         * @return string The directory
-        * @private
         */
-       function setupUploadDir() {
+       private function setupUploadDir() {
                global $IP;
+               if ( $this->keepUploads ) {
+                       $dir = wfTempDir() . '/mwParser-images';
+                       if ( is_dir( $dir ) ) {
+                               return $dir;
+                       }
+               } else {
+                       $dir = wfTempDir() . "/mwParser-" . mt_rand() . "-images";
+               }
 
-               $dir = wfTempDir() . "/mwParser-" . mt_rand() . "-images";
+               wfDebug( "Creating upload directory $dir\n" );
                mkdir( $dir );
                mkdir( $dir . '/3' );
                mkdir( $dir . '/3/3a' );
-
-               $img = "$IP/skins/monobook/headbg.jpg";
-               $h = fopen($img, 'r');
-               $c = fread($h, filesize($img));
-               fclose($h);
-
-               $f = fopen( $dir . '/3/3a/Foobar.jpg', 'wb' );
-               fwrite( $f, $c );
-               fclose( $f );
+               copy( "$IP/skins/monobook/headbg.jpg", "$dir/3/3a/Foobar.jpg" );
                return $dir;
        }
 
        /**
         * Restore default values and perform any necessary clean-up
         * after each test runs.
-        *
-        * @private
         */
-       function teardownGlobals() {
+       private function teardownGlobals() {
+               RepoGroup::destroySingleton();
                foreach( $this->savedGlobals as $var => $val ) {
                        $GLOBALS[$var] = $val;
                }
@@ -576,11 +593,14 @@ class ParserTest {
 
        /**
         * Remove the dummy uploads directory
-        * @private
         */
-       function teardownUploadDir( $dir ) {
+       private function teardownUploadDir( $dir ) {
+               if ( $this->keepUploads ) {
+                       return;
+               }
+
                // delete the files first, then the dirs.
-               self::deleteFiles( 
+               self::deleteFiles(
                        array (
                                "$dir/3/3a/Foobar.jpg",
                                "$dir/thumb/3/3a/Foobar.jpg/180px-Foobar.jpg",
@@ -589,9 +609,9 @@ class ParserTest {
                                "$dir/thumb/3/3a/Foobar.jpg/120px-Foobar.jpg",
                        )
                );
-                   
+
                self::deleteDirs(
-                       array ( 
+                       array (
                                "$dir/3/3a",
                                "$dir/3",
                                "$dir/thumb/6/65",
@@ -606,7 +626,7 @@ class ParserTest {
        }
 
        /**
-        * @desc delete the specified files, if they exist.
+        * Delete the specified files, if they exist.
         * @param array $files full paths to files to delete.
         */
        private static function deleteFiles( $files ) {
@@ -616,9 +636,9 @@ class ParserTest {
                        }
                }
        }
-       
+
        /**
-        * @desc delete the specified directories, if they exist. Must be empty.
+        * Delete the specified directories, if they exist. Must be empty.
         * @param array $dirs full paths to directories to delete.
         */
        private static function deleteDirs( $dirs ) {
@@ -628,12 +648,11 @@ class ParserTest {
                        }
                }
        }
-       
+
        /**
         * "Running test $desc..."
-        * @private
         */
-       function showTesting( $desc ) {
+       protected function showTesting( $desc ) {
                print "Running test $desc... ";
        }
 
@@ -642,10 +661,9 @@ class ParserTest {
         *
         * @param string $desc The test name
         * @return bool
-        * @private
         */
-       function showSuccess( $desc ) {
-               if( !$this->quiet ) {
+       protected function showSuccess( $desc ) {
+               if( $this->showProgress ) {
                        print $this->term->color( '1;32' ) . 'PASSED' . $this->term->reset() . "\n";
                }
                return true;
@@ -659,22 +677,23 @@ class ParserTest {
         * @param string $result Expected HTML output
         * @param string $html Actual HTML output
         * @return bool
-        * @private
         */
-       function showFailure( $desc, $result, $html ) {
-               if( $this->quiet ) {
-                       # In quiet mode we didn't show the 'Testing' message before the
-                       # test, in case it succeeded. Show it now:
-                       $this->showTesting( $desc );
-               }
-               print $this->term->color( '1;31' ) . 'FAILED!' . $this->term->reset() . "\n";
-               if ( $this->showOutput ) {
-                       print "--- Expected ---\n$result\n--- Actual ---\n$html\n";
-               }
-               if( $this->showDiffs ) {
-                       print $this->quickDiff( $result, $html );
-                       if( !$this->wellFormed( $html ) ) {
-                               print "XML error: $this->mXmlError\n";
+       protected function showFailure( $desc, $result, $html ) {
+               if( $this->showFailure ) {
+                       if( !$this->showProgress ) {
+                               # In quiet mode we didn't show the 'Testing' message before the
+                               # test, in case it succeeded. Show it now:
+                               $this->showTesting( $desc );
+                       }
+                       print $this->term->color( '31' ) . 'FAILED!' . $this->term->reset() . "\n";
+                       if ( $this->showOutput ) {
+                               print "--- Expected ---\n$result\n--- Actual ---\n$html\n";
+                       }
+                       if( $this->showDiffs ) {
+                               print $this->quickDiff( $result, $html );
+                               if( !$this->wellFormed( $html ) ) {
+                                       print "XML error: $this->mXmlError\n";
+                               }
                        }
                }
                return false;
@@ -689,9 +708,8 @@ class ParserTest {
         * @param string $inFileTail Tailing for the input file name
         * @param string $outFileTail Tailing for the output file name
         * @return string
-        * @private
         */
-       function quickDiff( $input, $output, $inFileTail='expected', $outFileTail='actual' ) {
+       protected function quickDiff( $input, $output, $inFileTail='expected', $outFileTail='actual' ) {
                $prefix = wfTempDir() . "/mwParser-" . mt_rand();
 
                $infile = "$prefix-$inFileTail";
@@ -712,9 +730,8 @@ class ParserTest {
         *
         * @param string $data
         * @param string $filename
-        * @private
         */
-       function dumpToFile( $data, $filename ) {
+       private function dumpToFile( $data, $filename ) {
                $file = fopen( $filename, "wt" );
                fwrite( $file, $data . "\n" );
                fclose( $file );
@@ -726,9 +743,8 @@ class ParserTest {
         *
         * @param string $text
         * @return string
-        * @private
         */
-       function colorDiff( $text ) {
+       protected function colorDiff( $text ) {
                return preg_replace(
                        array( '/^(-.*)$/m', '/^(\+.*)$/m' ),
                        array( $this->term->color( 34 ) . '$1' . $this->term->reset(),
@@ -736,14 +752,25 @@ class ParserTest {
                        $text );
        }
 
+       /**
+        * Show "Reading tests from ..."
+        *
+        * @param String $path
+        */
+       protected function showRunFile( $path ){
+               print $this->term->color( 1 ) .
+                       "Reading tests from \"$path\"..." .
+                       $this->term->reset() .
+                       "\n";
+       }
+
        /**
         * Insert a temporary test article
         * @param string $name the title, including any prefix
         * @param string $text the article text
         * @param int $line the input line number, for reporting errors
-        * @private
         */
-       function addArticle($name, $text, $line) {
+       private function addArticle($name, $text, $line) {
                $this->setupGlobals();
                $title = Title::newFromText( $name );
                if ( is_null($title) ) {
@@ -759,7 +786,7 @@ class ParserTest {
                $art->insertNewArticle($text, '', false, false );
                $this->teardownGlobals();
        }
-       
+
        /**
         * Steal a callback function from the primary parser, save it for
         * application to our scary parser. If the hook is not installed,
@@ -775,7 +802,6 @@ class ParserTest {
                }
        }
 
-       
        /**
         * Steal a callback function from the primary parser, save it for
         * application to our scary parser. If the hook is not installed,
@@ -798,9 +824,8 @@ class ParserTest {
         * @param string $text the text to tidy
         * @return string
         * @static
-        * @private
         */
-       function tidy( $text ) {
+       private function tidy( $text ) {
                global $wgUseTidy;
                if ($wgUseTidy) {
                        $text = Parser::tidy($text);
@@ -808,7 +833,7 @@ class ParserTest {
                return $text;
        }
 
-       function wellFormed( $text ) {
+       private function wellFormed( $text ) {
                $html =
                        Sanitizer::hackDocType() .
                        '<html>' .
@@ -832,7 +857,7 @@ class ParserTest {
                return true;
        }
 
-       function extractFragment( $text, $position ) {
+       private function extractFragment( $text, $position ) {
                $start = max( 0, $position - 10 );
                $before = $position - $start;
                $fragment = '...' .
@@ -855,23 +880,21 @@ class ParserTest {
                        $this->term->color( 0 );
                return "$display\n$caret";
        }
-       
 }
 
 class AnsiTermColorer {
-       function __construct( $light ) {
-               $this->light = $light;
+       function __construct() {
        }
-       
+
        /**
         * Return ANSI terminal escape code for changing text attribs/color
         *
         * @param string $color Semicolon-separated list of attribute/color codes
         * @return string
-        * @private
         */
-       function color( $color ) {
-               $light = $this->light ? "1;" : "";
+       public function color( $color ) {
+               global $wgCommandLineDarkBg;
+               $light = $wgCommandLineDarkBg ? "1;" : "0;";
                return "\x1b[{$light}{$color}m";
        }
 
@@ -879,20 +902,19 @@ class AnsiTermColorer {
         * Return ANSI terminal escape code for restoring default text attributes
         *
         * @return string
-        * @private
         */
-       function reset() {
-               return "\x1b[0m";
+       public function reset() {
+               return $this->color( 0 );
        }
 }
 
 /* A colour-less terminal */
 class DummyTermColorer {
-       function color( $color ) {
+       public function color( $color ) {
                return '';
        }
-       
-       function reset() {
+
+       public function reset() {
                return '';
        }
 }
@@ -901,21 +923,21 @@ class TestRecorder {
        function __construct( $term ) {
                $this->term = $term;
        }
-       
+
        function start() {
                $this->total = 0;
                $this->success = 0;
        }
-       
+
        function record( $test, $result ) {
                $this->total++;
                $this->success += ($result ? 1 : 0);
        }
-       
+
        function end() {
                // dummy
        }
-       
+
        function report() {
                if( $this->total > 0 ) {
                        $this->reportPercentage( $this->success, $this->total );
@@ -923,14 +945,15 @@ class TestRecorder {
                        wfDie( "No tests found.\n" );
                }
        }
-       
+
        function reportPercentage( $success, $total ) {
                $ratio = wfPercent( 100 * $success / $total );
                print $this->term->color( 1 ) . "Passed $success of $total tests ($ratio)... ";
                if( $success == $total ) {
-                       print $this->term->color( 32 ) . "PASSED!";
+                       print $this->term->color( 32 ) . "ALL TESTS PASSED!";
                } else {
-                       print $this->term->color( 31 ) . "FAILED!";
+                       $failed = $total - $success ;
+                       print $this->term->color( 31 ) . "$failed tests failed!";
                }
                print $this->term->reset() . "\n";
                return ($success == $total);
@@ -938,27 +961,37 @@ class TestRecorder {
 }
 
 class DbTestRecorder extends TestRecorder  {
-       private $db;      ///< Database connection to the main DB
-       private $curRun;  ///< run ID number for the current run
-       private $prevRun; ///< run ID number for the previous run, if any
-       
+       protected $db;      ///< Database connection to the main DB
+       protected $curRun;  ///< run ID number for the current run
+       protected $prevRun; ///< run ID number for the previous run, if any
+
        function __construct( $term ) {
                parent::__construct( $term );
                $this->db = wfGetDB( DB_MASTER );
        }
-       
+
        /**
         * Set up result recording; insert a record for the run with the date
         * and all that fun stuff
         */
        function start() {
+               global $wgDBtype;
                parent::start();
-               
+
                $this->db->begin();
-               
+
+               if( ! $this->db->tableExists( 'testrun' ) or ! $this->db->tableExists( 'testitem') ) {
+                       print "WARNING> `testrun` table not found in database. Trying to create table.\n";
+            if ($wgDBtype === 'postgres')
+                               dbsource( dirname(__FILE__) . '/testRunner.postgres.sql',  $this->db );
+                       else
+                               dbsource( dirname(__FILE__) . '/testRunner.sql',  $this->db );
+                       echo "OK, resuming.\n";
+               }
+
                // We'll make comparisons against the previous run later...
                $this->prevRun = $this->db->selectField( 'testrun', 'MAX(tr_id)' );
-               
+
                $this->db->insert( 'testrun',
                        array(
                                'tr_date'        => $this->db->timestamp(),
@@ -968,9 +1001,12 @@ class DbTestRecorder extends TestRecorder  {
                                'tr_uname'       => php_uname()
                        ),
                        __METHOD__ );
-               $this->curRun = $this->db->insertId();
+                       if ($wgDBtype === 'postgres')
+                               $this->curRun = $this->db->currentSequenceValue('testrun_id_seq');
+                       else
+                               $this->curRun = $this->db->insertId();
        }
-       
+
        /**
         * Record an individual test item's success or failure to the db
         * @param string $test
@@ -986,7 +1022,7 @@ class DbTestRecorder extends TestRecorder  {
                        ),
                        __METHOD__ );
        }
-       
+
        /**
         * Commit transaction and clean up for result recording
         */
@@ -994,38 +1030,40 @@ class DbTestRecorder extends TestRecorder  {
                $this->db->commit();
                parent::end();
        }
-       
+
        function report() {
                if( $this->prevRun ) {
                        $table = array(
                                array( 'previously failing test(s) now PASSING! :)', 0, 1 ),
                                array( 'previously PASSING test(s) removed o_O', 1, null ),
                                array( 'new PASSING test(s) :)', null, 1 ),
-                               
+
                                array( 'previously passing test(s) now FAILING! :(', 1, 0 ),
                                array( 'previously FAILING test(s) removed O_o', 0, null ),
                                array( 'new FAILING test(s) :(', null, 0 ),
+                               array( 'still FAILING test(s) :(', 0, 0 ),
                        );
                        foreach( $table as $criteria ) {
                                list( $label, $before, $after ) = $criteria;
                                $differences = $this->compareResult( $before, $after );
                                if( $differences ) {
                                        $count = count($differences);
-                                       printf( "%4d %s\n", $count, $label );
-                                       foreach ($differences as $differing_test_name) {
-                                               print "      * $differing_test_name\n";
+                                       printf( "\n%4d %s\n", $count, $label );
+                                       foreach ($differences as $differing_test_name => $statusInfo) {
+                                               print "      * $differing_test_name  [$statusInfo]\n";
                                        }
                                }
                        }
                } else {
                        print "No previous test runs to compare against.\n";
                }
+               print "\n";
                parent::report();
        }
-       
+
        /**
-        ** @desc: Returns an array of the test names with changed results, based on the specified
-        **        before/after criteria.
+        ** Returns an array of the test names with changed results, based on the specified
+        ** before/after criteria.
         */
        private function compareResult( $before, $after ) {
                $testitem = $this->db->tableName( 'testitem' );
@@ -1033,7 +1071,7 @@ class DbTestRecorder extends TestRecorder  {
                $curRun = intval( $this->curRun );
                $prevStatus = $this->condition( $before );
                $curStatus = $this->condition( $after );
-               
+
                // note: requires mysql >= ver 4.1 for subselects
                if( is_null( $after ) ) {
                        $sql = "
@@ -1055,14 +1093,77 @@ class DbTestRecorder extends TestRecorder  {
                $result = $this->db->query( $sql, __METHOD__ );
                $retval = array();
                while ($row = $this->db->fetchObject( $result )) {
-                       $retval[] = $row->t;
+                       $testname = $row->t;
+                       $retval[$testname] = $this->getTestStatusInfo( $testname, $after, $curRun );
                }
                $this->db->freeResult( $result );
                return $retval;
        }
-       
+
        /**
-        ** @desc: Helper function for compareResult() database querying.
+        ** Returns a string giving information about when a test last had a status change.
+        ** Could help to track down when regressions were introduced, as distinct from tests
+        ** which have never passed (which are more change requests than regressions).
+        */
+       private function getTestStatusInfo($testname, $after, $curRun) {
+
+               // If we're looking at a test that has just been removed, then say when it first appeared.
+               if ( is_null( $after ) ) {
+                       $changedRun = $this->db->selectField ( 'testitem',
+                                                                                                  'MIN(ti_run)',
+                                                                                                  array( 'ti_name' => $testname ),
+                                                                                                  __METHOD__ );
+                       $appear = $this->db->selectRow ( 'testrun',
+                                                                                        array( 'tr_date', 'tr_mw_version' ),
+                                                                                        array( 'tr_id' => $changedRun ),
+                                                                                        __METHOD__ );
+                       return "First recorded appearance: "
+                              . date( "d-M-Y H:i:s",  strtotime ( $appear->tr_date ) )
+                              .  ", " . $appear->tr_mw_version;
+               }
+
+               // Otherwise, this test has previous recorded results.
+               // See when this test last had a different result to what we're seeing now.
+               $changedRun = $this->db->selectField ( 'testitem',
+                                                                                          'MAX(ti_run)',
+                                                                                          array( 
+                                                                                              'ti_name'    => $testname,
+                                                                                              'ti_success' => ($after ? "0" : "1"),
+                                                                                              "ti_run != " . $this->db->addQuotes ( $curRun )
+                                                                                               ), 
+                                                                                               __METHOD__ );
+
+               // If no record of ever having had a different result.
+               if ( is_null ( $changedRun ) ) {
+                       if ($after == "0") {
+                               return "Has never passed";
+                       } else {
+                               return "Has never failed";
+                       }
+               }
+
+               // Otherwise, we're looking at a test whose status has changed.
+               // (i.e. it used to work, but now doesn't; or used to fail, but is now fixed.)
+               // In this situation, give as much info as we can as to when it changed status.
+               $pre  = $this->db->selectRow ( 'testrun',
+                                                                               array( 'tr_date', 'tr_mw_version' ),
+                                                                               array( 'tr_id' => $changedRun ),
+                                                                               __METHOD__ );
+               $post = $this->db->selectRow ( 'testrun',
+                                                                               array( 'tr_date', 'tr_mw_version' ),
+                                                                               array( "tr_id > " . $this->db->addQuotes ( $changedRun) ),
+                                                                               __METHOD__,
+                                                                               array( "LIMIT" => 1, "ORDER BY" => 'tr_id' )
+                                                                        );
+
+               return ( $after == "0" ? "Introduced" : "Fixed" ) . " between "
+                               . date( "d-M-Y H:i:s",  strtotime ( $pre->tr_date ) ) .  ", " . $pre->tr_mw_version
+                               . " and "
+                               . date( "d-M-Y H:i:s",  strtotime ( $post->tr_date  ) ) .  ", " . $post->tr_mw_version ;
+       }
+
+       /**
+        ** Helper function for compareResult() database querying.
         */
        private function condition( $value ) {
                if( is_null( $value ) ) {
@@ -1074,4 +1175,12 @@ class DbTestRecorder extends TestRecorder  {
 
 }
 
-?>
+class DbTestPreviewer extends DbTestRecorder  {
+       /**
+        * Commit transaction and clean up for result recording
+        */
+       function end() {
+               $this->db->rollback();
+               TestRecorder::end();
+       }
+}