Page Menu
Home
WickedGov Phorge
Search
Configure Global Search
Log In
Files
F4022045
DbTestPreviewer.php
No One
Temporary
Actions
Download File
Edit File
Delete File
View Transforms
Subscribe
Flag For Later
Award Token
Size
6 KB
Referenced Files
None
Subscribers
None
DbTestPreviewer.php
View Options
<?php
/**
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License along
* with this program; if not, write to the Free Software Foundation, Inc.,
* 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
* http://www.gnu.org/copyleft/gpl.html
*
* @file
* @ingroup Testing
*/
use
Wikimedia\Rdbms\IMaintainableDatabase
;
class
DbTestPreviewer
extends
TestRecorder
{
/** @var callable|false Test name filter callback */
protected
$filter
;
/** @var IMaintainableDatabase Database connection to the main DB */
protected
$db
;
/** @var int run ID number for the current run */
protected
$curRun
;
/** @var int|false run ID number for the previous run, if any */
protected
$prevRun
;
/** @var array<string,int> Result array */
protected
$results
;
/**
* This should be called before the table prefix is changed
* @param IMaintainableDatabase $db
* @param callable|false $filter
*/
public
function
__construct
(
$db
,
$filter
=
false
)
{
$this
->
db
=
$db
;
$this
->
filter
=
$filter
;
}
/**
* Set up result recording; insert a record for the run with the date
* and all that fun stuff
*/
public
function
start
()
{
if
(
!
$this
->
db
->
tableExists
(
'testrun'
,
__METHOD__
)
||
!
$this
->
db
->
tableExists
(
'testitem'
,
__METHOD__
)
)
{
print
"WARNING> `testrun` table not found in database.
\n
"
;
$this
->
prevRun
=
false
;
}
else
{
// We'll make comparisons against the previous run later...
$this
->
prevRun
=
$this
->
db
->
newSelectQueryBuilder
()
->
select
(
'MAX(tr_id)'
)
->
from
(
'testrun'
)
->
fetchField
();
}
$this
->
results
=
[];
}
public
function
record
(
ParserTestResult
$result
)
{
$desc
=
$result
->
getDescription
();
$this
->
results
[
$desc
]
=
$result
->
isSuccess
()
?
1
:
0
;
}
public
function
report
()
{
if
(
$this
->
prevRun
)
{
// f = fail, p = pass, n = nonexistent
// codes show before then after
$table
=
[
'fp'
=>
'previously failing test(s) now PASSING! :)'
,
'pn'
=>
'previously PASSING test(s) removed o_O'
,
'np'
=>
'new PASSING test(s) :)'
,
'pf'
=>
'previously passing test(s) now FAILING! :('
,
'fn'
=>
'previously FAILING test(s) removed O_o'
,
'nf'
=>
'new FAILING test(s) :('
,
'ff'
=>
'still FAILING test(s) :('
,
];
$prevResults
=
[];
$res
=
$this
->
db
->
newSelectQueryBuilder
()
->
select
(
[
'ti_name'
,
'ti_success'
]
)
->
from
(
'testitem'
)
->
where
(
[
'ti_run'
=>
$this
->
prevRun
]
)
->
caller
(
__METHOD__
)->
fetchResultSet
();
$filter
=
$this
->
filter
;
foreach
(
$res
as
$row
)
{
if
(
!
$filter
||
$filter
(
$row
->
ti_name
)
)
{
$prevResults
[
$row
->
ti_name
]
=
$row
->
ti_success
;
}
}
$combined
=
array_keys
(
$this
->
results
+
$prevResults
);
# Determine breakdown by change type
$breakdown
=
[];
foreach
(
$combined
as
$test
)
{
if
(
!
isset
(
$prevResults
[
$test
]
)
)
{
$before
=
'n'
;
}
elseif
(
$prevResults
[
$test
]
==
1
)
{
$before
=
'p'
;
}
else
/* if ( $prevResults[$test] == 0 ) */
{
$before
=
'f'
;
}
if
(
!
isset
(
$this
->
results
[
$test
]
)
)
{
$after
=
'n'
;
}
elseif
(
$this
->
results
[
$test
]
==
1
)
{
$after
=
'p'
;
}
else
/* if ( $this->results[$test] == 0 ) */
{
$after
=
'f'
;
}
$code
=
$before
.
$after
;
if
(
isset
(
$table
[
$code
]
)
)
{
$breakdown
[
$code
][
$test
]
=
$this
->
getTestStatusInfo
(
$test
,
$after
);
}
}
# Write out results
foreach
(
$table
as
$code
=>
$label
)
{
if
(
!
empty
(
$breakdown
[
$code
]
)
)
{
$count
=
count
(
$breakdown
[
$code
]
);
printf
(
"
\n
%4d %s
\n
"
,
$count
,
$label
);
foreach
(
$breakdown
[
$code
]
as
$differing_test_name
=>
$statusInfo
)
{
// @phan-suppress-next-line SecurityCheck-XSS CLI-only script
print
" * $differing_test_name [$statusInfo]
\n
"
;
}
}
}
}
else
{
print
"No previous test runs to compare against.
\n
"
;
}
print
"
\n
"
;
}
/**
* 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).
* @param string $testname
* @param string $after
* @return string
*/
private
function
getTestStatusInfo
(
$testname
,
$after
)
{
// If we're looking at a test that has just been removed, then say when it first appeared.
if
(
$after
==
'n'
)
{
$changedRun
=
$this
->
db
->
newSelectQueryBuilder
()
->
select
(
'MIN(ti_run)'
)
->
from
(
'testitem'
)
->
where
(
[
'ti_name'
=>
$testname
]
)
->
caller
(
__METHOD__
)->
fetchField
();
$appear
=
$this
->
db
->
newSelectQueryBuilder
()
->
select
(
[
'tr_date'
,
'tr_mw_version'
]
)
->
from
(
'testrun'
)
->
where
(
[
'tr_id'
=>
$changedRun
]
)
->
caller
(
__METHOD__
)->
fetchRow
();
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.
$conds
=
[
'ti_name'
=>
$testname
,
'ti_success'
=>
(
$after
==
'f'
?
"1"
:
"0"
)
];
if
(
$this
->
curRun
)
{
$conds
[]
=
$this
->
db
->
expr
(
'ti_run'
,
'!='
,
$this
->
curRun
);
}
$changedRun
=
$this
->
db
->
newSelectQueryBuilder
()
->
select
(
'MAX(ti_run)'
)
->
from
(
'testitem'
)
->
where
(
$conds
)
->
caller
(
__METHOD__
)->
fetchField
();
// If no record of ever having had a different result.
if
(
$changedRun
===
null
)
{
if
(
$after
==
"f"
)
{
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
->
newSelectQueryBuilder
()
->
select
(
[
'tr_date'
,
'tr_mw_version'
]
)
->
from
(
'testrun'
)
->
where
(
[
'tr_id'
=>
$changedRun
]
)
->
caller
(
__METHOD__
)->
fetchRow
();
$post
=
$this
->
db
->
newSelectQueryBuilder
()
->
select
(
[
'tr_date'
,
'tr_mw_version'
]
)
->
from
(
'testrun'
)
->
where
(
$this
->
db
->
expr
(
'tr_id'
,
'>'
,
$changedRun
)
)
->
orderBy
(
'tr_id'
)
->
limit
(
1
)
->
caller
(
__METHOD__
)->
fetchRow
();
if
(
$post
)
{
$postDate
=
date
(
"d-M-Y H:i:s"
,
strtotime
(
$post
->
tr_date
)
)
.
", {$post->tr_mw_version}"
;
}
else
{
$postDate
=
'now'
;
}
return
(
$after
==
"f"
?
"Introduced"
:
"Fixed"
)
.
" between "
.
date
(
"d-M-Y H:i:s"
,
strtotime
(
$pre
->
tr_date
)
)
.
", "
.
$pre
->
tr_mw_version
.
" and $postDate"
;
}
}
File Metadata
Details
Attached
Mime Type
text/x-php
Expires
Aug 14 2026, 18:40 (14 w, 13 h ago)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
78/e0/7d829f2e59739aba7b52a149f525
Default Alt Text
DbTestPreviewer.php (6 KB)
Attached To
Mode
rMWPROD MediaWiki Production
Attached
Detach File
Event Timeline
Log In to Comment