Page MenuHomeWickedGov Phorge
Files F4110440

MigrateFileTablesTest.php
No OneTemporary
Actions

Size
5 KB
Referenced Files
None
Subscribers
None

MigrateFileTablesTest.php
View Options

<?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 ) );
}
}

File Metadata

Mime Type
text/x-php
Expires
Tue, Aug 18, 21:47 (17 h, 52 m ago)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
37/55/f76831a11f416a53fb1d4dab9bf0
Default Alt Text
MigrateFileTablesTest.php (5 KB)

Event Timeline