31 use MediaWikiCoversValidator;
32 use PHPUnit4And6Compat;
40 ->disableOriginalConstructor()
44 $quoted = $db->addIdentifierQuotes( $in );
71 [
"`'`",
"'" ], # single quote
72 [
'`"`',
'"' ], #
double quote
73 [
'````',
'`' ], # backtick
74 [
'`’`',
'’' ], #
apostrophe (look at your encyclopedia)
78 [
'`xyzzy`',
"\0x\0y\0z\0z\0y\0" ],
82 "`\u{0001}a\u{FFFF}b`",
87 "\u{0001}\u{0000}\u{FFFF}\u{0000}"
90 [
'`メインページ`',
'メインページ' ],
91 [
'`Басты_бет`',
'Басты_бет' ],
94 [
'`Alix`',
'Alix' ], #
while( ! $recovered ) {
sleep(); }
95 [
'`Backtick: ```',
'Backtick: `' ],
96 [
'`This is a test`',
'This is a test' ],
102 ->disableOriginalConstructor()
103 ->setMethods( [
'fetchRow',
'query',
'getDBname' ] )
106 $db->method(
'query' )
108 ->willReturn(
new FakeResultWrapper( [
109 (
object)[
'Tables_in_' =>
'view1' ],
110 (
object)[
'Tables_in_' =>
'view2' ],
111 (
object)[
'Tables_in_' =>
'myview' ]
113 $db->method(
'getDBname' )->willReturn(
'' );
129 $db->listViews(
'view' ) );
131 $db->listViews(
'my' ) );
133 $db->listViews(
'UNUSED_PREFIX' ) );
135 $db->listViews(
'' ) );
145 $this->
assertEquals(
"db1052.2424", $pos->getLogFile() );
146 $this->
assertEquals( [ 2424, 4643 ], $pos->getLogPosition() );
201 new MySQLMasterPos(
'3E11FA47-71CA-11E1-9E33-C80AA9429562:1-23', $now ),
202 new MySQLMasterPos(
'3E11FA47-71CA-11E1-9E33-C80AA9429562:5-24', $now ),
207 new MySQLMasterPos(
'3E11FA47-71CA-11E1-9E33-C80AA9429562:5-99', $now ),
208 new MySQLMasterPos(
'3E11FA47-71CA-11E1-9E33-C80AA9429562:1-100', $now ),
213 new MySQLMasterPos(
'3E11FA47-71CA-11E1-9E33-C80AA9429562:1-99', $now ),
214 new MySQLMasterPos(
'1E11FA47-71CA-11E1-9E33-C80AA9429562:1-100', $now ),
285 $this->
assertEquals( (
string)$pos1, (
string)$roundtripPos );
320 $this->
assertEquals( $gtids, MySQLMasterPos::getCommonDomainGTIDs( $pos, $ref ) );
332 '2E11FA47-71CA-11E1-9E33-C80AA9429562:1-5,' .
333 '3E11FA47-71CA-11E1-9E33-C80AA9429562:20-99,' .
334 '7E11FA47-71CA-11E1-9E33-C80AA9429562:1-30',
338 '1E11FA47-71CA-11E1-9E33-C80AA9429562:30-100,' .
339 '3E11FA47-71CA-11E1-9E33-C80AA9429562:30-66',
342 [
'3E11FA47-71CA-11E1-9E33-C80AA9429562:20-99' ]
354 ->disableOriginalConstructor()
356 'getLagDetectionMethod',
'getHeartbeatData',
'getMasterServerInfo' ] )
359 $db->method(
'getLagDetectionMethod' )
360 ->willReturn(
'pt-heartbeat' );
362 $db->method(
'getMasterServerInfo' )
363 ->willReturn( [
'serverId' => 172,
'asOf' => time() ] );
370 $ptTime = $now -
$lag;
371 $ptSec = (
int)$ptTime;
372 $ptSecFrac = ( $ptTime -
$ptSec );
373 $ptDateTime =
new DateTime(
"@$ptSec" );
374 $ptTimeISO = $ptDateTime->format(
'Y-m-d\TH:i:s' );
377 $db->method(
'getHeartbeatData' )
378 ->with( [
'server_id' => 172 ] )
379 ->willReturn( [ $ptTimeISO, $now ] );
381 $db->setLBInfo(
'clusterMasterHost',
'db1052' );
382 $lagEst = $db->getLag();
385 $this->
assertLessThan( $lag + 0.010, $lagEst,
"Correct heatbeat lag" );
409 ->disableOriginalConstructor()
413 'getServerRoleStatus',
419 $db->method(
'useGTIDs' )->willReturn(
true );
420 $db->method(
'getServerGTIDs' )->willReturn( $gtable );
421 $db->method(
'getServerRoleStatus' )->willReturnCallback(
422 function ( $role ) use ( $rBLtable, $mBLtable ) {
423 if ( $role ===
'SLAVE' ) {
425 }
elseif ( $role ===
'MASTER' ) {
432 $db->method(
'getServerId' )->willReturn( 1 );
433 $db->method(
'getServerUUID' )->willReturn(
'2E11FA47-71CA-11E1-9E33-C80AA9429562' );
436 $this->
assertEquals( $rGTIDs, $db->getReplicaPos()->getGTIDs() );
441 $this->
assertEquals( $mGTIDs, $db->getMasterPos()->getGTIDs() );
452 'gtid_domain_id' => 100,
453 'gtid_current_pos' =>
'100-13-77',
454 'gtid_binlog_pos' =>
'100-13-77',
455 'gtid_slave_pos' =>
null
458 'Relay_Master_Log_File' =>
'host.1600',
459 'Exec_Master_Log_Pos' =>
'77'
462 'File' =>
'host.1600',
466 [
'100' =>
'100-13-77' ]
470 'gtid_domain_id' => 100,
471 'gtid_current_pos' =>
'100-13-77',
472 'gtid_binlog_pos' =>
'100-13-77',
473 'gtid_slave_pos' =>
'100-13-77'
476 'Relay_Master_Log_File' =>
'host.1600',
477 'Exec_Master_Log_Pos' =>
'77'
480 [
'100' =>
'100-13-77' ],
481 [
'100' =>
'100-13-77' ]
485 'gtid_current_pos' =>
'100-13-77',
486 'gtid_binlog_pos' =>
'100-13-77',
487 'gtid_slave_pos' =>
'100-13-77'
490 'Relay_Master_Log_File' =>
'host.1600',
491 'Exec_Master_Log_Pos' =>
'77'
494 [
'100' =>
'100-13-77' ],
495 [
'100' =>
'100-13-77' ]
500 'gtid_executed' =>
'2E11FA47-71CA-11E1-9E33-C80AA9429562:1-77'
503 'Relay_Master_Log_File' =>
'host.1600',
504 'Exec_Master_Log_Pos' =>
'77'
507 [
'2E11FA47-71CA-11E1-9E33-C80AA9429562'
508 =>
'2E11FA47-71CA-11E1-9E33-C80AA9429562:1-77' ],
510 [
'2E11FA47-71CA-11E1-9E33-C80AA9429562'
511 =>
'2E11FA47-71CA-11E1-9E33-C80AA9429562:1-77' ],
515 'gtid_executed' =>
'2E11FA47-71CA-11E1-9E33-C80AA9429562:1-49,' .
516 '2E11FA47-71CA-11E1-9E33-C80AA9429562:51-77'
519 'Relay_Master_Log_File' =>
'host.1600',
520 'Exec_Master_Log_Pos' =>
'77'
523 [
'2E11FA47-71CA-11E1-9E33-C80AA9429562'
524 =>
'2E11FA47-71CA-11E1-9E33-C80AA9429562:51-77' ],
526 [
'2E11FA47-71CA-11E1-9E33-C80AA9429562'
527 =>
'2E11FA47-71CA-11E1-9E33-C80AA9429562:51-77' ],
531 'gtid_executed' =>
null,
532 'gtid_binlog_pos' =>
null
535 'Relay_Master_Log_File' =>
'host.1600',
536 'Exec_Master_Log_Pos' =>
'77'
544 'gtid_executed' =>
null,
545 'gtid_binlog_pos' =>
null
559 $pos =
new MySQLMasterPos(
'3E11FA47-71CA-11E1-9E33-C80AA9429562:99', 53636363 );
576 ->disableOriginalConstructor()
577 ->setMethods( [
'getReplicationSafetyInfo' ] )
579 $db->method(
'getReplicationSafetyInfo' )->willReturn( (
object)$row );
580 $dbw = TestingAccessWrapper::newFromObject( $db );
582 $this->
assertEquals( $safe, $dbw->isInsertSelectSafe( $insertOpts, $selectOpts ) );
591 'innodb_autoinc_lock_mode' =>
'2',
592 'binlog_format' =>
'ROW',
600 'innodb_autoinc_lock_mode' =>
'2',
601 'binlog_format' =>
'ROW',
609 'innodb_autoinc_lock_mode' =>
'0',
610 'binlog_format' =>
'STATEMENT',
618 'innodb_autoinc_lock_mode' =>
'2',
619 'binlog_format' =>
'STATEMENT',
624 [
'NO_AUTO_COLUMNS' ],
627 'innodb_autoinc_lock_mode' =>
'0',
628 'binlog_format' =>
'STATEMENT',
636 'innodb_autoinc_lock_mode' => 0,
637 'binlog_format' =>
'STATEMENT',
642 [
'NO_AUTO_COLUMNS' ],
645 'innodb_autoinc_lock_mode' => 2,
646 'binlog_format' =>
'STATEMENT',
651 [
'NO_AUTO_COLUMNS' ],
654 'innodb_autoinc_lock_mode' => 0,
655 'binlog_format' =>
'STATEMENT',
668 ->disableOriginalConstructor()
671 $output = $db->buildIntegerCast(
'fieldName' );
680 ->disableOriginalConstructor()
681 ->setMethods( [
'mysqlRealEscapeString',
'dbSchema',
'tablePrefix' ] )
683 $db->method(
'mysqlRealEscapeString' )->willReturnCallback(
689 $db->setIndexAliases( [
'a_b_idx' =>
'a_c_idx' ] );
690 $sql = $db->selectSQLText(
691 'zend',
'field', [
'a' =>
'x' ], __METHOD__, [
'USE INDEX' =>
'a_b_idx' ] );
694 "SELECT field FROM `zend` FORCE INDEX (a_c_idx) WHERE a = 'x' ",
698 $db->setIndexAliases( [] );
699 $sql = $db->selectSQLText(
700 'zend',
'field', [
'a' =>
'x' ], __METHOD__, [
'USE INDEX' =>
'a_b_idx' ] );
703 "SELECT field FROM `zend` FORCE INDEX (a_b_idx) WHERE a = 'x' ",
713 ->disableOriginalConstructor()
714 ->setMethods( [
'mysqlRealEscapeString',
'dbSchema',
'tablePrefix' ] )
716 $db->method(
'mysqlRealEscapeString' )->willReturnCallback(
722 $db->setTableAliases( [
723 'meow' => [
'dbname' =>
'feline',
'schema' =>
null,
'prefix' =>
'cat_' ]
725 $sql = $db->selectSQLText(
'meow',
'field', [
'a' =>
'x' ], __METHOD__ );
728 "SELECT field FROM `feline`.`cat_meow` WHERE a = 'x' ",
732 $db->setTableAliases( [] );
733 $sql = $db->selectSQLText(
'meow',
'field', [
'a' =>
'x' ], __METHOD__ );
736 "SELECT field FROM `meow` WHERE a = 'x' ",
unserialize( $serialized)
and that you know you can do these things To protect your we need to make restrictions that forbid anyone to deny you these rights or to ask you to surrender the rights These restrictions translate to certain responsibilities for you if you distribute copies of the or if you modify it For if you distribute copies of such a whether gratis or for a you must give the recipients all the rights that you have You must make sure that receive or can get the source code And you must show them these terms so they know their rights We protect your rights with two and(2) offer you this license which gives you legal permission to copy
static provideDiapers()
Feeds testAddIdentifierQuotes.
static provideChannelPositions()
testServerGtidTable( $gtable, $rBLtable, $mBLtable, $rGTIDs, $mGTIDs)
provideGtidData Wikimedia\Rdbms\MySQLMasterPos Wikimedia\Rdbms\DatabaseMysqlBase::getReplicaPos Wikim...
testPtHeartbeat( $lag)
provideLagAmounts Wikimedia\Rdbms\DatabaseMysqlBase::getLag Wikimedia\Rdbms\DatabaseMysqlBase::getLag...
static provideLagAmounts()
testInsertSelectIsSafe( $insertOpts, $selectOpts, $row, $safe)
Wikimedia\Rdbms\DatabaseMysqlBase::isInsertSelectSafe provideInsertSelectCases.
testTableAliases()
Wikimedia\Rdbms\Database::setTableAliases.
testBuildIntegerCast()
\Wikimedia\Rdbms\DatabaseMysqlBase::buildIntegerCast
testAddIdentifierQuotes( $expected, $in)
provideDiapers Wikimedia\Rdbms\DatabaseMysqlBase::addIdentifierQuotes
testIndexAliases()
Wikimedia\Rdbms\Database::setIndexAliases.
testHasReached(MySQLMasterPos $lowerPos, MySQLMasterPos $higherPos, $match, $hetero)
provideComparePositions Wikimedia\Rdbms\MySQLMasterPos
static provideComparePositions()
static provideCommonDomainGTIDs()
testCommonGtidDomains(MySQLMasterPos $pos, MySQLMasterPos $ref, $gtids)
provideCommonDomainGTIDs Wikimedia\Rdbms\MySQLMasterPos
provideInsertSelectCases()
testSerialize()
Wikimedia\Rdbms\MySQLMasterPos.
testChannelsMatch(MySQLMasterPos $pos1, MySQLMasterPos $pos2, $matches)
provideChannelPositions Wikimedia\Rdbms\MySQLMasterPos
testBinLogName()
Wikimedia\Rdbms\MySQLMasterPos.
testListviews()
Wikimedia\Rdbms\DatabaseMysqlBase::listViews.
deferred txt A few of the database updates required by various functions here can be deferred until after the result page is displayed to the user For updating the view updating the linked to tables after a etc PHP does not yet have any way to tell the server to actually return and disconnect while still running these but it might have such a feature in the future We handle these by creating a deferred update object and putting those objects on a global list
This document is intended to provide useful advice for parties seeking to redistribute MediaWiki to end users It s targeted particularly at maintainers for Linux since it s been observed that distribution packages of MediaWiki often break We ve consistently had to recommend that users seeking support use official tarballs instead of their distribution s and this often solves whatever problem the user is having It would be nice if this could such and we might be restricted by PHP settings such as safe mode or open_basedir We cannot assume that the software even has read access anywhere useful Many shared hosts run all users web applications under the same so they can t rely on Unix and must forbid reads to even standard directories like tmp lest users read each others files We cannot assume that the user has the ability to install or run any programs not written as web accessible PHP scripts Since anything that works on cheap shared hosting will work if you have shell or root access MediaWiki s design is based around catering to the lowest common denominator Although we support higher end setups as the way many things work by default is tailored toward shared hosting These defaults are unconventional from the point of view of and they certainly aren t ideal for someone who s installing MediaWiki as MediaWiki does not conform to normal Unix filesystem layout Hopefully we ll offer direct support for standard layouts in the but for now *any change to the location of files is unsupported *Moving things and leaving symlinks will *probably *not break anything
this hook is for auditing only or null if authentication failed before getting that far or null if we can t even determine that When $user is not null
null means default in associative array with keys and values unescaped Should be merged with default with a value of false meaning to suppress the attribute in associative array with keys and values unescaped noclasses just before the function returns a value If you return true
static configuration should be added through ResourceLoaderGetConfigVars instead can be used to get the real title e g db for database replication lag or jobqueue for job queue size converted to pseudo seconds It is possible to add more fields and they will be returned to the user in the API response after the basic globals have been set but before ordinary actions take place $output
processing should stop and the error should be shown to the user * false