3 use Wikimedia\TestingAccessWrapper
;
6 * Test cases in RevisionTest should not interact with the Database.
7 * For test cases that need Database interaction see RevisionDbTestBase.
9 class RevisionTest
extends MediaWikiTestCase
{
11 public function provideConstructFromArray() {
12 yield
'with text' => [
14 'text' => 'hello world.',
15 'content_model' => CONTENT_MODEL_JAVASCRIPT
18 yield
'with content' => [
20 'content' => new JavaScriptContent( 'hellow world.' )
23 // FIXME: test with and without user ID, and with a user object.
24 // We can't prepare that here though, since we don't yet have a dummy DB
28 * @param string $model
31 public function getMockTitle( $model = CONTENT_MODEL_WIKITEXT
) {
32 $mock = $this->getMockBuilder( Title
::class )
33 ->disableOriginalConstructor()
35 $mock->expects( $this->any() )
36 ->method( 'getNamespace' )
37 ->will( $this->returnValue( $this->getDefaultWikitextNS() ) );
38 $mock->expects( $this->any() )
39 ->method( 'getPrefixedText' )
40 ->will( $this->returnValue( 'RevisionTest' ) );
41 $mock->expects( $this->any() )
42 ->method( 'getDBKey' )
43 ->will( $this->returnValue( 'RevisionTest' ) );
44 $mock->expects( $this->any() )
45 ->method( 'getArticleID' )
46 ->will( $this->returnValue( 23 ) );
47 $mock->expects( $this->any() )
48 ->method( 'getModel' )
49 ->will( $this->returnValue( $model ) );
55 * @dataProvider provideConstructFromArray
56 * @covers Revision::__construct
57 * @covers Revision::constructFromRowArray
59 public function testConstructFromArray( array $rowArray ) {
60 $rev = new Revision( $rowArray );
61 $this->assertNotNull( $rev->getContent(), 'no content object available' );
62 $this->assertEquals( CONTENT_MODEL_JAVASCRIPT
, $rev->getContent()->getModel() );
63 $this->assertEquals( CONTENT_MODEL_JAVASCRIPT
, $rev->getContentModel() );
67 * @covers Revision::__construct
68 * @covers Revision::constructFromRowArray
70 public function testConstructFromEmptyArray() {
71 $rev = new Revision( [], 0, $this->getMockTitle() );
72 $this->assertNull( $rev->getContent(), 'no content object should be available' );
75 public function provideConstructFromArray_userSetAsExpected() {
76 yield
'no user defaults to wgUser' => [
78 'content' => new JavaScriptContent( 'hello world.' ),
83 yield
'user text and id' => [
85 'content' => new JavaScriptContent( 'hello world.' ),
86 'user_text' => 'SomeTextUserName',
93 // Note: the below XXX test cases are odd and probably result in unexpected behaviour if used
94 // in production code.
95 yield
'XXX: user text only' => [
97 'content' => new JavaScriptContent( 'hello world.' ),
98 'user_text' => '111.111.111.111',
103 yield
'XXX: user id only' => [
105 'content' => new JavaScriptContent( 'hello world.' ),
114 * @dataProvider provideConstructFromArray_userSetAsExpected
115 * @covers Revision::__construct
116 * @covers Revision::constructFromRowArray
118 * @param array $rowArray
119 * @param mixed $expectedUserId null to expect the current wgUser ID
120 * @param mixed $expectedUserName null to expect the current wgUser name
122 public function testConstructFromArray_userSetAsExpected(
127 $testUser = $this->getTestUser()->getUser();
128 $this->setMwGlobals( 'wgUser', $testUser );
129 if ( $expectedUserId === null ) {
130 $expectedUserId = $testUser->getId();
132 if ( $expectedUserName === null ) {
133 $expectedUserName = $testUser->getName();
136 $rev = new Revision( $rowArray );
137 $this->assertEquals( $expectedUserId, $rev->getUser() );
138 $this->assertEquals( $expectedUserName, $rev->getUserText() );
141 public function provideConstructFromArrayThrowsExceptions() {
142 yield
'content and text_id both not empty' => [
144 'content' => new WikitextContent( 'GOAT' ),
145 'text_id' => 'someid',
147 new MWException( "Text already stored in external store (id someid), " .
148 "can't serialize content object" )
150 yield
'with bad content object (class)' => [
151 [ 'content' => new stdClass() ],
152 new MWException( '`content` field must contain a Content object.' )
154 yield
'with bad content object (string)' => [
155 [ 'content' => 'ImAGoat' ],
156 new MWException( '`content` field must contain a Content object.' )
158 yield
'bad row format' => [
159 'imastring, not a row',
160 new MWException( 'Revision constructor passed invalid row format.' )
165 * @dataProvider provideConstructFromArrayThrowsExceptions
166 * @covers Revision::__construct
167 * @covers Revision::constructFromRowArray
169 public function testConstructFromArrayThrowsExceptions( $rowArray, Exception
$expectedException ) {
170 $this->setExpectedException(
171 get_class( $expectedException ),
172 $expectedException->getMessage(),
173 $expectedException->getCode()
175 new Revision( $rowArray );
179 * @covers Revision::__construct
180 * @covers Revision::constructFromRowArray
182 public function testConstructFromNothing() {
183 $rev = new Revision( [] );
184 $this->assertNull( $rev->getId(), 'getId()' );
187 public function provideConstructFromRow() {
188 yield
'Full construction' => [
192 'rev_text_id' => '2',
193 'rev_timestamp' => '20171017114835',
194 'rev_user_text' => '127.0.0.1',
196 'rev_minor_edit' => '0',
197 'rev_deleted' => '0',
199 'rev_parent_id' => '1',
200 'rev_sha1' => 'rdqbbzs3pkhihgbs8qf2q9jsvheag5z',
201 'rev_comment_text' => 'Goat Comment!',
202 'rev_comment_data' => null,
203 'rev_comment_cid' => null,
204 'rev_content_format' => 'GOATFORMAT',
205 'rev_content_model' => 'GOATMODEL',
207 function ( RevisionTest
$testCase, Revision
$rev ) {
208 $testCase->assertSame( 2, $rev->getId() );
209 $testCase->assertSame( 1, $rev->getPage() );
210 $testCase->assertSame( 2, $rev->getTextId() );
211 $testCase->assertSame( '20171017114835', $rev->getTimestamp() );
212 $testCase->assertSame( '127.0.0.1', $rev->getUserText() );
213 $testCase->assertSame( 0, $rev->getUser() );
214 $testCase->assertSame( false, $rev->isMinor() );
215 $testCase->assertSame( false, $rev->isDeleted( Revision
::DELETED_TEXT
) );
216 $testCase->assertSame( 46, $rev->getSize() );
217 $testCase->assertSame( 1, $rev->getParentId() );
218 $testCase->assertSame( 'rdqbbzs3pkhihgbs8qf2q9jsvheag5z', $rev->getSha1() );
219 $testCase->assertSame( 'Goat Comment!', $rev->getComment() );
220 $testCase->assertSame( 'GOATFORMAT', $rev->getContentFormat() );
221 $testCase->assertSame( 'GOATMODEL', $rev->getContentModel() );
224 yield
'null fields' => [
228 'rev_text_id' => '2',
229 'rev_timestamp' => '20171017114835',
230 'rev_user_text' => '127.0.0.1',
232 'rev_minor_edit' => '0',
233 'rev_deleted' => '0',
234 'rev_comment_text' => 'Goat Comment!',
235 'rev_comment_data' => null,
236 'rev_comment_cid' => null,
238 function ( RevisionTest
$testCase, Revision
$rev ) {
239 $testCase->assertNull( $rev->getSize() );
240 $testCase->assertNull( $rev->getParentId() );
241 $testCase->assertNull( $rev->getSha1() );
242 $testCase->assertSame( 'text/x-wiki', $rev->getContentFormat() );
243 $testCase->assertSame( 'wikitext', $rev->getContentModel() );
249 * @dataProvider provideConstructFromRow
250 * @covers Revision::__construct
251 * @covers Revision::constructFromRowArray
253 public function testConstructFromRow( array $arrayData, $assertions ) {
254 $row = (object)$arrayData;
255 $rev = new Revision( $row );
256 $assertions( $this, $rev );
259 public function provideGetRevisionText() {
260 yield
'Generic test' => [
261 'This is a goat of revision text.',
264 'old_text' => 'This is a goat of revision text.',
269 public function provideGetId() {
281 * @dataProvider provideGetId
282 * @covers Revision::getId
284 public function testGetId( $rowArray, $expectedId ) {
285 $rev = new Revision( $rowArray );
286 $this->assertEquals( $expectedId, $rev->getId() );
289 public function provideSetId() {
290 yield
[ '123', 123 ];
295 * @dataProvider provideSetId
296 * @covers Revision::setId
298 public function testSetId( $input, $expected ) {
299 $rev = new Revision( [] );
300 $rev->setId( $input );
301 $this->assertSame( $expected, $rev->getId() );
304 public function provideSetUserIdAndName() {
305 yield
[ '123', 123, 'GOaT' ];
306 yield
[ 456, 456, 'GOaT' ];
310 * @dataProvider provideSetUserIdAndName
311 * @covers Revision::setUserIdAndName
313 public function testSetUserIdAndName( $inputId, $expectedId, $name ) {
314 $rev = new Revision( [] );
315 $rev->setUserIdAndName( $inputId, $name );
316 $this->assertSame( $expectedId, $rev->getUser( Revision
::RAW
) );
317 $this->assertEquals( $name, $rev->getUserText( Revision
::RAW
) );
320 public function provideGetTextId() {
322 yield
[ [ 'text_id' => '123' ], 123 ];
323 yield
[ [ 'text_id' => 456 ], 456 ];
327 * @dataProvider provideGetTextId
328 * @covers Revision::getTextId()
330 public function testGetTextId( $rowArray, $expected ) {
331 $rev = new Revision( $rowArray );
332 $this->assertSame( $expected, $rev->getTextId() );
335 public function provideGetParentId() {
337 yield
[ [ 'parent_id' => '123' ], 123 ];
338 yield
[ [ 'parent_id' => 456 ], 456 ];
342 * @dataProvider provideGetParentId
343 * @covers Revision::getParentId()
345 public function testGetParentId( $rowArray, $expected ) {
346 $rev = new Revision( $rowArray );
347 $this->assertSame( $expected, $rev->getParentId() );
351 * @covers Revision::getRevisionText
352 * @dataProvider provideGetRevisionText
354 public function testGetRevisionText( $expected, $rowData, $prefix = 'old_', $wiki = false ) {
357 Revision
::getRevisionText( (object)$rowData, $prefix, $wiki ) );
360 public function provideGetRevisionTextWithZlibExtension() {
361 yield
'Generic gzip test' => [
362 'This is a small goat of revision text.',
364 'old_flags' => 'gzip',
365 'old_text' => gzdeflate( 'This is a small goat of revision text.' ),
371 * @covers Revision::getRevisionText
372 * @dataProvider provideGetRevisionTextWithZlibExtension
374 public function testGetRevisionWithZlibExtension( $expected, $rowData ) {
375 $this->checkPHPExtension( 'zlib' );
376 $this->testGetRevisionText( $expected, $rowData );
379 public function provideGetRevisionTextWithLegacyEncoding() {
380 yield
'Utf8Native' => [
381 "Wiki est l'\xc3\xa9cole superieur !",
384 'old_flags' => 'utf-8',
385 'old_text' => "Wiki est l'\xc3\xa9cole superieur !",
388 yield
'Utf8Legacy' => [
389 "Wiki est l'\xc3\xa9cole superieur !",
393 'old_text' => "Wiki est l'\xe9cole superieur !",
399 * @covers Revision::getRevisionText
400 * @dataProvider provideGetRevisionTextWithLegacyEncoding
402 public function testGetRevisionWithLegacyEncoding( $expected, $encoding, $rowData ) {
403 $this->setMwGlobals( 'wgLegacyEncoding', $encoding );
404 $this->testGetRevisionText( $expected, $rowData );
407 public function provideGetRevisionTextWithGzipAndLegacyEncoding() {
410 * Do not set the external flag!
411 * Otherwise, getRevisionText will hit the live database (if ExternalStore is enabled)!
413 yield
'Utf8NativeGzip' => [
414 "Wiki est l'\xc3\xa9cole superieur !",
417 'old_flags' => 'gzip,utf-8',
418 'old_text' => gzdeflate( "Wiki est l'\xc3\xa9cole superieur !" ),
421 yield
'Utf8LegacyGzip' => [
422 "Wiki est l'\xc3\xa9cole superieur !",
425 'old_flags' => 'gzip',
426 'old_text' => gzdeflate( "Wiki est l'\xe9cole superieur !" ),
432 * @covers Revision::getRevisionText
433 * @dataProvider provideGetRevisionTextWithGzipAndLegacyEncoding
435 public function testGetRevisionWithGzipAndLegacyEncoding( $expected, $encoding, $rowData ) {
436 $this->checkPHPExtension( 'zlib' );
437 $this->setMwGlobals( 'wgLegacyEncoding', $encoding );
438 $this->testGetRevisionText( $expected, $rowData );
442 * @covers Revision::compressRevisionText
444 public function testCompressRevisionTextUtf8() {
446 $row->old_text
= "Wiki est l'\xc3\xa9cole superieur !";
447 $row->old_flags
= Revision
::compressRevisionText( $row->old_text
);
448 $this->assertTrue( false !== strpos( $row->old_flags
, 'utf-8' ),
449 "Flags should contain 'utf-8'" );
450 $this->assertFalse( false !== strpos( $row->old_flags
, 'gzip' ),
451 "Flags should not contain 'gzip'" );
452 $this->assertEquals( "Wiki est l'\xc3\xa9cole superieur !",
453 $row->old_text
, "Direct check" );
454 $this->assertEquals( "Wiki est l'\xc3\xa9cole superieur !",
455 Revision
::getRevisionText( $row ), "getRevisionText" );
459 * @covers Revision::compressRevisionText
461 public function testCompressRevisionTextUtf8Gzip() {
462 $this->checkPHPExtension( 'zlib' );
463 $this->setMwGlobals( 'wgCompressRevisions', true );
466 $row->old_text
= "Wiki est l'\xc3\xa9cole superieur !";
467 $row->old_flags
= Revision
::compressRevisionText( $row->old_text
);
468 $this->assertTrue( false !== strpos( $row->old_flags
, 'utf-8' ),
469 "Flags should contain 'utf-8'" );
470 $this->assertTrue( false !== strpos( $row->old_flags
, 'gzip' ),
471 "Flags should contain 'gzip'" );
472 $this->assertEquals( "Wiki est l'\xc3\xa9cole superieur !",
473 gzinflate( $row->old_text
), "Direct check" );
474 $this->assertEquals( "Wiki est l'\xc3\xa9cole superieur !",
475 Revision
::getRevisionText( $row ), "getRevisionText" );
478 public function provideFetchFromConds() {
480 yield
[ Revision
::READ_LOCKING
, [ 'FOR UPDATE' ] ];
484 * @dataProvider provideFetchFromConds
485 * @covers Revision::fetchFromConds
487 public function testFetchFromConds( $flags, array $options ) {
488 $this->setMwGlobals( 'wgCommentTableSchemaMigrationStage', MIGRATION_OLD
);
489 $conditions = [ 'conditionsArray' ];
491 $db = $this->getMock( IDatabase
::class );
492 $db->expects( $this->once() )
493 ->method( 'selectRow' )
495 $this->equalTo( [ 'revision', 'page', 'user' ] ),
496 // We don't really care about the fields are they come from the selectField methods
497 $this->isType( 'array' ),
498 $this->equalTo( $conditions ),
500 $this->equalTo( 'Revision::fetchFromConds' ),
501 $this->equalTo( $options ),
502 // We don't really care about the join conds are they come from the joinCond methods
503 $this->isType( 'array' )
505 ->willReturn( 'RETURNVALUE' );
507 $wrapper = TestingAccessWrapper
::newFromClass( Revision
::class );
508 $result = $wrapper->fetchFromConds( $db, $conditions, $flags );
510 $this->assertEquals( 'RETURNVALUE', $result );
513 public function provideDecompressRevisionText() {
514 yield
'(no legacy encoding), false in false out' => [ false, false, [], false ];
515 yield
'(no legacy encoding), empty in empty out' => [ false, '', [], '' ];
516 yield
'(no legacy encoding), empty in empty out' => [ false, 'A', [], 'A' ];
517 yield
'(no legacy encoding), string in with gzip flag returns string' => [
518 // gzip string below generated with gzdeflate( 'AAAABBAAA' )
519 false, "sttttr\002\022\000", [ 'gzip' ], 'AAAABBAAA',
521 yield
'(no legacy encoding), string in with object flag returns false' => [
522 // gzip string below generated with serialize( 'JOJO' )
523 false, "s:4:\"JOJO\";", [ 'object' ], false,
525 yield
'(no legacy encoding), serialized object in with object flag returns string' => [
527 // Using a TitleValue object as it has a getText method (which is needed)
528 serialize( new TitleValue( 0, 'HHJJDDFF' ) ),
532 yield
'(no legacy encoding), serialized object in with object & gzip flag returns string' => [
534 // Using a TitleValue object as it has a getText method (which is needed)
535 gzdeflate( serialize( new TitleValue( 0, '8219JJJ840' ) ) ),
536 [ 'object', 'gzip' ],
539 yield
'(ISO-8859-1 encoding), string in string out' => [
541 iconv( 'utf-8', 'ISO-8859-1', "1®Àþ1" ),
545 yield
'(ISO-8859-1 encoding), serialized object in with gzip flags returns string' => [
547 gzdeflate( iconv( 'utf-8', 'ISO-8859-1', "4®Àþ4" ) ),
551 yield
'(ISO-8859-1 encoding), serialized object in with object flags returns string' => [
553 serialize( new TitleValue( 0, iconv( 'utf-8', 'ISO-8859-1', "3®Àþ3" ) ) ),
557 yield
'(ISO-8859-1 encoding), serialized object in with object & gzip flags returns string' => [
559 gzdeflate( serialize( new TitleValue( 0, iconv( 'utf-8', 'ISO-8859-1', "2®Àþ2" ) ) ) ),
560 [ 'gzip', 'object' ],
566 * @dataProvider provideDecompressRevisionText
567 * @covers Revision::decompressRevisionText
569 * @param bool $legacyEncoding
571 * @param array $flags
572 * @param mixed $expected
574 public function testDecompressRevisionText( $legacyEncoding, $text, $flags, $expected ) {
575 $this->setMwGlobals( 'wgLegacyEncoding', $legacyEncoding );
576 $this->setMwGlobals( 'wgLanguageCode', 'en' );
579 Revision
::decompressRevisionText( $text, $flags )
584 * @covers Revision::getRevisionText
586 public function testGetRevisionText_returnsFalseWhenNoTextField() {
587 $this->assertFalse( Revision
::getRevisionText( new stdClass() ) );
590 public function provideTestGetRevisionText_returnsDecompressedTextFieldWhenNotExternal() {
591 yield
'Just text' => [
592 (object)[ 'old_text' => 'SomeText' ],
596 // gzip string below generated with gzdeflate( 'AAAABBAAA' )
597 yield
'gzip text' => [
599 'old_text' => "sttttr\002\022\000",
600 'old_flags' => 'gzip'
605 yield
'gzip text and different prefix' => [
607 'jojo_text' => "sttttr\002\022\000",
608 'jojo_flags' => 'gzip'
616 * @dataProvider provideTestGetRevisionText_returnsDecompressedTextFieldWhenNotExternal
617 * @covers Revision::getRevisionText
619 public function testGetRevisionText_returnsDecompressedTextFieldWhenNotExternal(
624 $this->assertSame( $expected, Revision
::getRevisionText( $row, $prefix ) );
627 public function provideTestGetRevisionText_external_returnsFalseWhenNotEnoughUrlParts() {
628 yield
'Just some text' => [ 'someNonUrlText' ];
629 yield
'No second URL part' => [ 'someProtocol://' ];
633 * @dataProvider provideTestGetRevisionText_external_returnsFalseWhenNotEnoughUrlParts
634 * @covers Revision::getRevisionText
636 public function testGetRevisionText_external_returnsFalseWhenNotEnoughUrlParts(
640 Revision
::getRevisionText(
643 'old_flags' => 'external',
650 * @covers Revision::getRevisionText
652 public function testGetRevisionText_external_noOldId() {
654 'ExternalStoreFactory',
655 new ExternalStoreFactory( [ 'ForTesting' ] )
659 Revision
::getRevisionText(
661 'old_text' => 'ForTesting://cluster1/12345',
662 'old_flags' => 'external,gzip',
669 * @covers Revision::getRevisionText
671 public function testGetRevisionText_external_oldId() {
672 $cache = new WANObjectCache( [ 'cache' => new HashBagOStuff() ] );
673 $this->setService( 'MainWANObjectCache', $cache );
675 'ExternalStoreFactory',
676 new ExternalStoreFactory( [ 'ForTesting' ] )
679 $cacheKey = $cache->makeKey( 'revisiontext', 'textid', '7777' );
683 Revision
::getRevisionText(
685 'old_text' => 'ForTesting://cluster1/12345',
686 'old_flags' => 'external,gzip',
691 $this->assertSame( 'AAAABBAAA', $cache->get( $cacheKey ) );
695 * @covers Revision::userJoinCond
697 public function testUserJoinCond() {
698 $this->hideDeprecated( 'Revision::userJoinCond' );
700 [ 'LEFT JOIN', [ 'rev_user != 0', 'user_id = rev_user' ] ],
701 Revision
::userJoinCond()
706 * @covers Revision::pageJoinCond
708 public function testPageJoinCond() {
709 $this->hideDeprecated( 'Revision::pageJoinCond' );
711 [ 'INNER JOIN', [ 'page_id = rev_page' ] ],
712 Revision
::pageJoinCond()
716 public function provideSelectFields() {
731 'rev_comment_text' => 'rev_comment',
732 'rev_comment_data' => 'NULL',
733 'rev_comment_cid' => 'NULL',
734 'rev_content_format',
752 'rev_comment_text' => 'rev_comment',
753 'rev_comment_data' => 'NULL',
754 'rev_comment_cid' => 'NULL',
760 * @dataProvider provideSelectFields
761 * @covers Revision::selectFields
762 * @todo a true unit test would mock CommentStore
764 public function testSelectFields( $contentHandlerUseDB, $expected ) {
765 $this->hideDeprecated( 'Revision::selectFields' );
766 $this->setMwGlobals( 'wgContentHandlerUseDB', $contentHandlerUseDB );
767 $this->setMwGlobals( 'wgCommentTableSchemaMigrationStage', MIGRATION_OLD
);
768 $this->assertEquals( $expected, Revision
::selectFields() );
771 public function provideSelectArchiveFields() {
788 'ar_comment_text' => 'ar_comment',
789 'ar_comment_data' => 'NULL',
790 'ar_comment_cid' => 'NULL',
811 'ar_comment_text' => 'ar_comment',
812 'ar_comment_data' => 'NULL',
813 'ar_comment_cid' => 'NULL',
819 * @dataProvider provideSelectArchiveFields
820 * @covers Revision::selectArchiveFields
821 * @todo a true unit test would mock CommentStore
823 public function testSelectArchiveFields( $contentHandlerUseDB, $expected ) {
824 $this->hideDeprecated( 'Revision::selectArchiveFields' );
825 $this->setMwGlobals( 'wgContentHandlerUseDB', $contentHandlerUseDB );
826 $this->setMwGlobals( 'wgCommentTableSchemaMigrationStage', MIGRATION_OLD
);
827 $this->assertEquals( $expected, Revision
::selectArchiveFields() );
831 * @covers Revision::selectTextFields
833 public function testSelectTextFields() {
834 $this->hideDeprecated( 'Revision::selectTextFields' );
840 Revision
::selectTextFields()
845 * @covers Revision::selectPageFields
847 public function testSelectPageFields() {
848 $this->hideDeprecated( 'Revision::selectPageFields' );
858 Revision
::selectPageFields()
863 * @covers Revision::selectUserFields
865 public function testSelectUserFields() {
866 $this->hideDeprecated( 'Revision::selectUserFields' );
871 Revision
::selectUserFields()
875 public function provideGetArchiveQueryInfo() {
876 yield
'wgContentHandlerUseDB false, wgCommentTableSchemaMigrationStage OLD' => [
878 'wgContentHandlerUseDB' => false,
879 'wgCommentTableSchemaMigrationStage' => MIGRATION_OLD
,
882 'tables' => [ 'archive' ],
897 'ar_comment_text' => 'ar_comment',
898 'ar_comment_data' => 'NULL',
899 'ar_comment_cid' => 'NULL',
904 yield
'wgContentHandlerUseDB true, wgCommentTableSchemaMigrationStage OLD' => [
906 'wgContentHandlerUseDB' => true,
907 'wgCommentTableSchemaMigrationStage' => MIGRATION_OLD
,
910 'tables' => [ 'archive' ],
925 'ar_comment_text' => 'ar_comment',
926 'ar_comment_data' => 'NULL',
927 'ar_comment_cid' => 'NULL',
934 yield
'wgContentHandlerUseDB false, wgCommentTableSchemaMigrationStage WRITE_BOTH' => [
936 'wgContentHandlerUseDB' => false,
937 'wgCommentTableSchemaMigrationStage' => MIGRATION_WRITE_BOTH
,
942 'comment_ar_comment' => 'comment',
958 'ar_comment_text' => 'COALESCE( comment_ar_comment.comment_text, ar_comment )',
959 'ar_comment_data' => 'comment_ar_comment.comment_data',
960 'ar_comment_cid' => 'comment_ar_comment.comment_id',
963 'comment_ar_comment' => [
965 'comment_ar_comment.comment_id = ar_comment_id',
970 yield
'wgContentHandlerUseDB false, wgCommentTableSchemaMigrationStage WRITE_NEW' => [
972 'wgContentHandlerUseDB' => false,
973 'wgCommentTableSchemaMigrationStage' => MIGRATION_WRITE_NEW
,
978 'comment_ar_comment' => 'comment',
994 'ar_comment_text' => 'COALESCE( comment_ar_comment.comment_text, ar_comment )',
995 'ar_comment_data' => 'comment_ar_comment.comment_data',
996 'ar_comment_cid' => 'comment_ar_comment.comment_id',
999 'comment_ar_comment' => [
1001 'comment_ar_comment.comment_id = ar_comment_id',
1006 yield
'wgContentHandlerUseDB false, wgCommentTableSchemaMigrationStage NEW' => [
1008 'wgContentHandlerUseDB' => false,
1009 'wgCommentTableSchemaMigrationStage' => MIGRATION_NEW
,
1014 'comment_ar_comment' => 'comment',
1030 'ar_comment_text' => 'comment_ar_comment.comment_text',
1031 'ar_comment_data' => 'comment_ar_comment.comment_data',
1032 'ar_comment_cid' => 'comment_ar_comment.comment_id',
1035 'comment_ar_comment' => [
1037 'comment_ar_comment.comment_id = ar_comment_id',
1045 * @covers Revision::getArchiveQueryInfo
1046 * @dataProvider provideGetArchiveQueryInfo
1048 public function testGetArchiveQueryInfo( $globals, $expected ) {
1049 $this->setMwGlobals( $globals );
1050 $this->assertEquals(
1052 Revision
::getArchiveQueryInfo()
1056 public function provideGetQueryInfo() {
1057 yield
'wgContentHandlerUseDB false, wgCommentTableSchemaMigrationStage OLD, opts none' => [
1059 'wgContentHandlerUseDB' => false,
1060 'wgCommentTableSchemaMigrationStage' => MIGRATION_OLD
,
1064 'tables' => [ 'revision' ],
1077 'rev_comment_text' => 'rev_comment',
1078 'rev_comment_data' => 'NULL',
1079 'rev_comment_cid' => 'NULL',
1084 yield
'wgContentHandlerUseDB false, wgCommentTableSchemaMigrationStage OLD, opts page' => [
1086 'wgContentHandlerUseDB' => false,
1087 'wgCommentTableSchemaMigrationStage' => MIGRATION_OLD
,
1091 'tables' => [ 'revision', 'page' ],
1104 'rev_comment_text' => 'rev_comment',
1105 'rev_comment_data' => 'NULL',
1106 'rev_comment_cid' => 'NULL',
1117 [ 'page_id = rev_page' ],
1122 yield
'wgContentHandlerUseDB false, wgCommentTableSchemaMigrationStage OLD, opts user' => [
1124 'wgContentHandlerUseDB' => false,
1125 'wgCommentTableSchemaMigrationStage' => MIGRATION_OLD
,
1129 'tables' => [ 'revision', 'user' ],
1142 'rev_comment_text' => 'rev_comment',
1143 'rev_comment_data' => 'NULL',
1144 'rev_comment_cid' => 'NULL',
1152 'user_id = rev_user',
1158 yield
'wgContentHandlerUseDB false, wgCommentTableSchemaMigrationStage OLD, opts text' => [
1160 'wgContentHandlerUseDB' => false,
1161 'wgCommentTableSchemaMigrationStage' => MIGRATION_OLD
,
1165 'tables' => [ 'revision', 'text' ],
1178 'rev_comment_text' => 'rev_comment',
1179 'rev_comment_data' => 'NULL',
1180 'rev_comment_cid' => 'NULL',
1187 [ 'rev_text_id=old_id' ],
1192 yield
'wgContentHandlerUseDB false, wgCommentTableSchemaMigrationStage OLD, opts 3' => [
1194 'wgContentHandlerUseDB' => false,
1195 'wgCommentTableSchemaMigrationStage' => MIGRATION_OLD
,
1197 [ 'text', 'page', 'user' ],
1199 'tables' => [ 'revision', 'page', 'user', 'text' ],
1212 'rev_comment_text' => 'rev_comment',
1213 'rev_comment_data' => 'NULL',
1214 'rev_comment_cid' => 'NULL',
1228 [ 'page_id = rev_page' ],
1234 'user_id = rev_user',
1239 [ 'rev_text_id=old_id' ],
1244 yield
'wgContentHandlerUseDB true, wgCommentTableSchemaMigrationStage OLD, opts none' => [
1246 'wgContentHandlerUseDB' => true,
1247 'wgCommentTableSchemaMigrationStage' => MIGRATION_OLD
,
1251 'tables' => [ 'revision' ],
1264 'rev_comment_text' => 'rev_comment',
1265 'rev_comment_data' => 'NULL',
1266 'rev_comment_cid' => 'NULL',
1267 'rev_content_format',
1268 'rev_content_model',
1273 yield
'wgContentHandlerUseDB false, wgCommentTableSchemaMigrationStage WRITE_BOTH, opts none' => [
1275 'wgContentHandlerUseDB' => false,
1276 'wgCommentTableSchemaMigrationStage' => MIGRATION_WRITE_BOTH
,
1282 'temp_rev_comment' => 'revision_comment_temp',
1283 'comment_rev_comment' => 'comment',
1297 'rev_comment_text' => 'COALESCE( comment_rev_comment.comment_text, rev_comment )',
1298 'rev_comment_data' => 'comment_rev_comment.comment_data',
1299 'rev_comment_cid' => 'comment_rev_comment.comment_id',
1302 'temp_rev_comment' => [
1304 'temp_rev_comment.revcomment_rev = rev_id',
1306 'comment_rev_comment' => [
1308 'comment_rev_comment.comment_id = temp_rev_comment.revcomment_comment_id',
1313 yield
'wgContentHandlerUseDB false, wgCommentTableSchemaMigrationStage WRITE_NEW, opts none' => [
1315 'wgContentHandlerUseDB' => false,
1316 'wgCommentTableSchemaMigrationStage' => MIGRATION_WRITE_NEW
,
1322 'temp_rev_comment' => 'revision_comment_temp',
1323 'comment_rev_comment' => 'comment',
1337 'rev_comment_text' => 'COALESCE( comment_rev_comment.comment_text, rev_comment )',
1338 'rev_comment_data' => 'comment_rev_comment.comment_data',
1339 'rev_comment_cid' => 'comment_rev_comment.comment_id',
1342 'temp_rev_comment' => [
1344 'temp_rev_comment.revcomment_rev = rev_id',
1346 'comment_rev_comment' => [
1348 'comment_rev_comment.comment_id = temp_rev_comment.revcomment_comment_id',
1353 yield
'wgContentHandlerUseDB false, wgCommentTableSchemaMigrationStage NEW, opts none' => [
1355 'wgContentHandlerUseDB' => false,
1356 'wgCommentTableSchemaMigrationStage' => MIGRATION_NEW
,
1362 'temp_rev_comment' => 'revision_comment_temp',
1363 'comment_rev_comment' => 'comment',
1377 'rev_comment_text' => 'comment_rev_comment.comment_text',
1378 'rev_comment_data' => 'comment_rev_comment.comment_data',
1379 'rev_comment_cid' => 'comment_rev_comment.comment_id',
1382 'temp_rev_comment' => [
1384 'temp_rev_comment.revcomment_rev = rev_id',
1386 'comment_rev_comment' => [
1388 'comment_rev_comment.comment_id = temp_rev_comment.revcomment_comment_id',
1396 * @covers Revision::getQueryInfo
1397 * @dataProvider provideGetQueryInfo
1399 public function testGetQueryInfo( $globals, $options, $expected ) {
1400 $this->setMwGlobals( $globals );
1401 $this->assertEquals(
1403 Revision
::getQueryInfo( $options )