| Server IP : 167.235.224.122 / Your IP : 216.73.216.110 Web Server : Apache/2.4.58 (Ubuntu) System : Linux newplayground 6.8.0-136-generic #136-Ubuntu SMP PREEMPT_DYNAMIC Wed Jul 1 21:33:11 UTC 2026 aarch64 User : deploy ( 1000) PHP Version : 8.4.23 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : OFF Directory : /var/www/html/wiki/tests/phpunit/structure/ |
Upload File : |
<?php
use MediaWiki\MediaWikiServices;
use Wikimedia\Rdbms\Database;
/**
* @group Database
* @coversNothing
*/
class DatabaseIntegrationTest extends MediaWikiIntegrationTestCase {
/**
* @var Database
*/
protected $db;
protected function setUp(): void {
parent::setUp();
$this->db = MediaWikiServices::getInstance()
->getConnectionProvider()
->getPrimaryDatabase();
}
public function testUnknownTableCorruptsResults() {
$res = $this->db->newSelectQueryBuilder()
->select( '*' )
->from( 'page' )
->where( [ 'page_id' => 1 ] )
->fetchResultSet();
$this->assertFalse( $this->db->tableExists( 'foobarbaz' ) );
$this->assertIsInt( $res->numRows() );
}
public function testUniformTablePrefix() {
global $IP;
$path = "$IP/sql/tables.json";
$tables = json_decode( file_get_contents( $path ), true );
// @todo Remove exception once these tables are fixed
$excludeList = [
'user_newtalk',
'objectcache',
];
$prefixes = [];
foreach ( $tables as $table ) {
$tableName = $table['name'];
if ( in_array( $tableName, $excludeList ) ) {
continue;
}
foreach ( $table['columns'] as $column ) {
$prefixes[] = strtok( $column['name'], '_' );
}
foreach ( $table['indexes'] ?? [] as $index ) {
$prefixes[] = strtok( $index['name'], '_' );
}
if ( count( array_unique( $prefixes ) ) === 1 ) {
$prefixes = []; // reset
continue;
}
$list = implode( '_, ', $prefixes ) . '_';
$this->fail(
"Columns and indexes of '$tableName' table should"
. " have uniform prefix. Non-uniform found: [ $list ]"
);
}
$this->assertSame( [], $prefixes );
}
/**
* T352229
*/
public function testBooleanValues() {
$res = $this->db->newSelectQueryBuilder()
->select( [ 'false' => '1=0', 'true' => '1=1' ] )
->fetchResultSet();
$obj = $res->fetchObject();
$this->assertCount( 2, (array)$obj );
$this->assertSame( '0', $obj->false );
$this->assertSame( '1', $obj->true );
$res->seek( 0 );
$row = $res->fetchRow();
$this->assertCount( 4, $row );
$this->assertSame( '0', $row[0] );
$this->assertSame( '1', $row[1] );
$this->assertSame( '0', $row['false'] );
$this->assertSame( '1', $row['true'] );
}
public function testListTables() {
$prefix = $this->db->tablePrefix() . 'listtables_';
$table = $prefix . 'table';
$view = $prefix . 'view';
$allTables = $this->db->listTables();
$this->assertIsArray( $allTables );
$this->assertSame( [], $this->db->listTables( $prefix ) );
try {
$this->db->query( "CREATE TABLE $table (i INT)" );
$this->assertSame( [ $table ], $this->db->listTables( $prefix ) );
// Confirm that listTables() does not include views (T45571)
$this->db->query( "CREATE VIEW $view AS SELECT * FROM $table" );
$this->assertSame( [ $table ], $this->db->listTables( $prefix ) );
} finally {
$this->db->query( "DROP VIEW IF EXISTS $view" );
$this->db->query( "DROP TABLE IF EXISTS $table" );
}
}
}