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.' )
26 * @dataProvider provideConstructFromArray
27 * @covers Revision::__construct
28 * @covers Revision::constructFromRowArray
30 public function testConstructFromArray( array $rowArray ) {
31 $rev = new Revision( $rowArray );
32 $this->assertNotNull( $rev->getContent(), 'no content object available' );
33 $this->assertEquals( CONTENT_MODEL_JAVASCRIPT
, $rev->getContent()->getModel() );
34 $this->assertEquals( CONTENT_MODEL_JAVASCRIPT
, $rev->getContentModel() );
37 public function provideConstructFromArray_userSetAsExpected() {
38 yield
'no user defaults to wgUser' => [
40 'content' => new JavaScriptContent( 'hello world.' ),
45 yield
'user text and id' => [
47 'content' => new JavaScriptContent( 'hello world.' ),
48 'user_text' => 'SomeTextUserName',
55 // Note: the below XXX test cases are odd and probably result in unexpected behaviour if used
56 // in production code.
57 yield
'XXX: user text only' => [
59 'content' => new JavaScriptContent( 'hello world.' ),
60 'user_text' => '111.111.111.111',
65 yield
'XXX: user id only' => [
67 'content' => new JavaScriptContent( 'hello world.' ),
76 * @dataProvider provideConstructFromArray_userSetAsExpected
77 * @covers Revision::__construct
78 * @covers Revision::constructFromRowArray
80 * @param array $rowArray
81 * @param mixed $expectedUserId null to expect the current wgUser ID
82 * @param mixed $expectedUserName null to expect the current wgUser name
84 public function testConstructFromArray_userSetAsExpected(
89 $testUser = $this->getTestUser()->getUser();
90 $this->setMwGlobals( 'wgUser', $testUser );
91 if ( $expectedUserId === null ) {
92 $expectedUserId = $testUser->getId();
94 if ( $expectedUserName === null ) {
95 $expectedUserName = $testUser->getName();
98 $rev = new Revision( $rowArray );
99 $this->assertEquals( $expectedUserId, $rev->getUser() );
100 $this->assertEquals( $expectedUserName, $rev->getUserText() );
103 public function provideConstructFromArrayThrowsExceptions() {
104 yield
'content and text_id both not empty' => [
106 'content' => new WikitextContent( 'GOAT' ),
107 'text_id' => 'someid',
109 new MWException( "Text already stored in external store (id someid), " .
110 "can't serialize content object" )
112 yield
'with bad content object (class)' => [
113 [ 'content' => new stdClass() ],
114 new MWException( '`content` field must contain a Content object.' )
116 yield
'with bad content object (string)' => [
117 [ 'content' => 'ImAGoat' ],
118 new MWException( '`content` field must contain a Content object.' )
120 yield
'bad row format' => [
121 'imastring, not a row',
122 new MWException( 'Revision constructor passed invalid row format.' )
127 * @dataProvider provideConstructFromArrayThrowsExceptions
128 * @covers Revision::__construct
129 * @covers Revision::constructFromRowArray
131 public function testConstructFromArrayThrowsExceptions( $rowArray, Exception
$expectedException ) {
132 $this->setExpectedException(
133 get_class( $expectedException ),
134 $expectedException->getMessage(),
135 $expectedException->getCode()
137 new Revision( $rowArray );
140 public function provideConstructFromRow() {
141 yield
'Full construction' => [
145 'rev_text_id' => '2',
146 'rev_timestamp' => '20171017114835',
147 'rev_user_text' => '127.0.0.1',
149 'rev_minor_edit' => '0',
150 'rev_deleted' => '0',
152 'rev_parent_id' => '1',
153 'rev_sha1' => 'rdqbbzs3pkhihgbs8qf2q9jsvheag5z',
154 'rev_comment_text' => 'Goat Comment!',
155 'rev_comment_data' => null,
156 'rev_comment_cid' => null,
157 'rev_content_format' => 'GOATFORMAT',
158 'rev_content_model' => 'GOATMODEL',
160 function ( RevisionTest
$testCase, Revision
$rev ) {
161 $testCase->assertSame( 2, $rev->getId() );
162 $testCase->assertSame( 1, $rev->getPage() );
163 $testCase->assertSame( 2, $rev->getTextId() );
164 $testCase->assertSame( '20171017114835', $rev->getTimestamp() );
165 $testCase->assertSame( '127.0.0.1', $rev->getUserText() );
166 $testCase->assertSame( 0, $rev->getUser() );
167 $testCase->assertSame( false, $rev->isMinor() );
168 $testCase->assertSame( false, $rev->isDeleted( Revision
::DELETED_TEXT
) );
169 $testCase->assertSame( 46, $rev->getSize() );
170 $testCase->assertSame( 1, $rev->getParentId() );
171 $testCase->assertSame( 'rdqbbzs3pkhihgbs8qf2q9jsvheag5z', $rev->getSha1() );
172 $testCase->assertSame( 'Goat Comment!', $rev->getComment() );
173 $testCase->assertSame( 'GOATFORMAT', $rev->getContentFormat() );
174 $testCase->assertSame( 'GOATMODEL', $rev->getContentModel() );
177 yield
'null fields' => [
181 'rev_text_id' => '2',
182 'rev_timestamp' => '20171017114835',
183 'rev_user_text' => '127.0.0.1',
185 'rev_minor_edit' => '0',
186 'rev_deleted' => '0',
187 'rev_comment_text' => 'Goat Comment!',
188 'rev_comment_data' => null,
189 'rev_comment_cid' => null,
191 function ( RevisionTest
$testCase, Revision
$rev ) {
192 $testCase->assertNull( $rev->getSize() );
193 $testCase->assertNull( $rev->getParentId() );
194 $testCase->assertNull( $rev->getSha1() );
195 $testCase->assertSame( 'text/x-wiki', $rev->getContentFormat() );
196 $testCase->assertSame( 'wikitext', $rev->getContentModel() );
202 * @dataProvider provideConstructFromRow
203 * @covers Revision::__construct
204 * @covers Revision::constructFromDbRowObject
206 public function testConstructFromRow( array $arrayData, $assertions ) {
207 $row = (object)$arrayData;
208 $rev = new Revision( $row );
209 $assertions( $this, $rev );
212 public function provideGetRevisionText() {
213 yield
'Generic test' => [
214 'This is a goat of revision text.',
217 'old_text' => 'This is a goat of revision text.',
222 public function provideGetId() {
234 * @dataProvider provideGetId
235 * @covers Revision::getId
237 public function testGetId( $rowArray, $expectedId ) {
238 $rev = new Revision( $rowArray );
239 $this->assertEquals( $expectedId, $rev->getId() );
242 public function provideSetId() {
243 yield
[ '123', 123 ];
248 * @dataProvider provideSetId
249 * @covers Revision::setId
251 public function testSetId( $input, $expected ) {
252 $rev = new Revision( [] );
253 $rev->setId( $input );
254 $this->assertSame( $expected, $rev->getId() );
257 public function provideSetUserIdAndName() {
258 yield
[ '123', 123, 'GOaT' ];
259 yield
[ 456, 456, 'GOaT' ];
263 * @dataProvider provideSetUserIdAndName
264 * @covers Revision::setUserIdAndName
266 public function testSetUserIdAndName( $inputId, $expectedId, $name ) {
267 $rev = new Revision( [] );
268 $rev->setUserIdAndName( $inputId, $name );
269 $this->assertSame( $expectedId, $rev->getUser( Revision
::RAW
) );
270 $this->assertEquals( $name, $rev->getUserText( Revision
::RAW
) );
273 public function provideGetTextId() {
275 yield
[ [ 'text_id' => '123' ], 123 ];
276 yield
[ [ 'text_id' => 456 ], 456 ];
280 * @dataProvider provideGetTextId
281 * @covers Revision::getTextId()
283 public function testGetTextId( $rowArray, $expected ) {
284 $rev = new Revision( $rowArray );
285 $this->assertSame( $expected, $rev->getTextId() );
288 public function provideGetParentId() {
290 yield
[ [ 'parent_id' => '123' ], 123 ];
291 yield
[ [ 'parent_id' => 456 ], 456 ];
295 * @dataProvider provideGetParentId
296 * @covers Revision::getParentId()
298 public function testGetParentId( $rowArray, $expected ) {
299 $rev = new Revision( $rowArray );
300 $this->assertSame( $expected, $rev->getParentId() );
304 * @covers Revision::getRevisionText
305 * @dataProvider provideGetRevisionText
307 public function testGetRevisionText( $expected, $rowData, $prefix = 'old_', $wiki = false ) {
310 Revision
::getRevisionText( (object)$rowData, $prefix, $wiki ) );
313 public function provideGetRevisionTextWithZlibExtension() {
314 yield
'Generic gzip test' => [
315 'This is a small goat of revision text.',
317 'old_flags' => 'gzip',
318 'old_text' => gzdeflate( 'This is a small goat of revision text.' ),
324 * @covers Revision::getRevisionText
325 * @dataProvider provideGetRevisionTextWithZlibExtension
327 public function testGetRevisionWithZlibExtension( $expected, $rowData ) {
328 $this->checkPHPExtension( 'zlib' );
329 $this->testGetRevisionText( $expected, $rowData );
332 public function provideGetRevisionTextWithLegacyEncoding() {
333 yield
'Utf8Native' => [
334 "Wiki est l'\xc3\xa9cole superieur !",
337 'old_flags' => 'utf-8',
338 'old_text' => "Wiki est l'\xc3\xa9cole superieur !",
341 yield
'Utf8Legacy' => [
342 "Wiki est l'\xc3\xa9cole superieur !",
346 'old_text' => "Wiki est l'\xe9cole superieur !",
352 * @covers Revision::getRevisionText
353 * @dataProvider provideGetRevisionTextWithLegacyEncoding
355 public function testGetRevisionWithLegacyEncoding( $expected, $encoding, $rowData ) {
356 $this->setMwGlobals( 'wgLegacyEncoding', $encoding );
357 $this->testGetRevisionText( $expected, $rowData );
360 public function provideGetRevisionTextWithGzipAndLegacyEncoding() {
363 * Do not set the external flag!
364 * Otherwise, getRevisionText will hit the live database (if ExternalStore is enabled)!
366 yield
'Utf8NativeGzip' => [
367 "Wiki est l'\xc3\xa9cole superieur !",
370 'old_flags' => 'gzip,utf-8',
371 'old_text' => gzdeflate( "Wiki est l'\xc3\xa9cole superieur !" ),
374 yield
'Utf8LegacyGzip' => [
375 "Wiki est l'\xc3\xa9cole superieur !",
378 'old_flags' => 'gzip',
379 'old_text' => gzdeflate( "Wiki est l'\xe9cole superieur !" ),
385 * @covers Revision::getRevisionText
386 * @dataProvider provideGetRevisionTextWithGzipAndLegacyEncoding
388 public function testGetRevisionWithGzipAndLegacyEncoding( $expected, $encoding, $rowData ) {
389 $this->checkPHPExtension( 'zlib' );
390 $this->setMwGlobals( 'wgLegacyEncoding', $encoding );
391 $this->testGetRevisionText( $expected, $rowData );
395 * @covers Revision::compressRevisionText
397 public function testCompressRevisionTextUtf8() {
399 $row->old_text
= "Wiki est l'\xc3\xa9cole superieur !";
400 $row->old_flags
= Revision
::compressRevisionText( $row->old_text
);
401 $this->assertTrue( false !== strpos( $row->old_flags
, 'utf-8' ),
402 "Flags should contain 'utf-8'" );
403 $this->assertFalse( false !== strpos( $row->old_flags
, 'gzip' ),
404 "Flags should not contain 'gzip'" );
405 $this->assertEquals( "Wiki est l'\xc3\xa9cole superieur !",
406 $row->old_text
, "Direct check" );
407 $this->assertEquals( "Wiki est l'\xc3\xa9cole superieur !",
408 Revision
::getRevisionText( $row ), "getRevisionText" );
412 * @covers Revision::compressRevisionText
414 public function testCompressRevisionTextUtf8Gzip() {
415 $this->checkPHPExtension( 'zlib' );
416 $this->setMwGlobals( 'wgCompressRevisions', true );
419 $row->old_text
= "Wiki est l'\xc3\xa9cole superieur !";
420 $row->old_flags
= Revision
::compressRevisionText( $row->old_text
);
421 $this->assertTrue( false !== strpos( $row->old_flags
, 'utf-8' ),
422 "Flags should contain 'utf-8'" );
423 $this->assertTrue( false !== strpos( $row->old_flags
, 'gzip' ),
424 "Flags should contain 'gzip'" );
425 $this->assertEquals( "Wiki est l'\xc3\xa9cole superieur !",
426 gzinflate( $row->old_text
), "Direct check" );
427 $this->assertEquals( "Wiki est l'\xc3\xa9cole superieur !",
428 Revision
::getRevisionText( $row ), "getRevisionText" );
431 public function provideFetchFromConds() {
433 yield
[ Revision
::READ_LOCKING
, [ 'FOR UPDATE' ] ];
437 * @dataProvider provideFetchFromConds
438 * @covers Revision::fetchFromConds
440 public function testFetchFromConds( $flags, array $options ) {
441 $this->setMwGlobals( 'wgCommentTableSchemaMigrationStage', MIGRATION_OLD
);
442 $conditions = [ 'conditionsArray' ];
444 $db = $this->getMock( IDatabase
::class );
445 $db->expects( $this->once() )
446 ->method( 'selectRow' )
448 $this->equalTo( [ 'revision', 'page', 'user' ] ),
449 // We don't really care about the fields are they come from the selectField methods
450 $this->isType( 'array' ),
451 $this->equalTo( $conditions ),
453 $this->equalTo( 'Revision::fetchFromConds' ),
454 $this->equalTo( $options ),
455 // We don't really care about the join conds are they come from the joinCond methods
456 $this->isType( 'array' )
458 ->willReturn( 'RETURNVALUE' );
460 $wrapper = TestingAccessWrapper
::newFromClass( Revision
::class );
461 $result = $wrapper->fetchFromConds( $db, $conditions, $flags );
463 $this->assertEquals( 'RETURNVALUE', $result );
466 public function provideDecompressRevisionText() {
467 yield
'(no legacy encoding), false in false out' => [ false, false, [], false ];
468 yield
'(no legacy encoding), empty in empty out' => [ false, '', [], '' ];
469 yield
'(no legacy encoding), empty in empty out' => [ false, 'A', [], 'A' ];
470 yield
'(no legacy encoding), string in with gzip flag returns string' => [
471 // gzip string below generated with gzdeflate( 'AAAABBAAA' )
472 false, "sttttr\002\022\000", [ 'gzip' ], 'AAAABBAAA',
474 yield
'(no legacy encoding), string in with object flag returns false' => [
475 // gzip string below generated with serialize( 'JOJO' )
476 false, "s:4:\"JOJO\";", [ 'object' ], false,
478 yield
'(no legacy encoding), serialized object in with object flag returns string' => [
480 // Using a TitleValue object as it has a getText method (which is needed)
481 serialize( new TitleValue( 0, 'HHJJDDFF' ) ),
485 yield
'(no legacy encoding), serialized object in with object & gzip flag returns string' => [
487 // Using a TitleValue object as it has a getText method (which is needed)
488 gzdeflate( serialize( new TitleValue( 0, '8219JJJ840' ) ) ),
489 [ 'object', 'gzip' ],
492 yield
'(ISO-8859-1 encoding), string in string out' => [
494 iconv( 'utf8', 'ISO-8859-1', "1®Àþ1" ),
498 yield
'(ISO-8859-1 encoding), serialized object in with gzip flags returns string' => [
500 gzdeflate( iconv( 'utf8', 'ISO-8859-1', "4®Àþ4" ) ),
504 yield
'(ISO-8859-1 encoding), serialized object in with object flags returns string' => [
506 serialize( new TitleValue( 0, iconv( 'utf8', 'ISO-8859-1', "3®Àþ3" ) ) ),
510 yield
'(ISO-8859-1 encoding), serialized object in with object & gzip flags returns string' => [
512 gzdeflate( serialize( new TitleValue( 0, iconv( 'utf8', 'ISO-8859-1', "2®Àþ2" ) ) ) ),
513 [ 'gzip', 'object' ],
519 * @dataProvider provideDecompressRevisionText
520 * @covers Revision::decompressRevisionText
522 * @param bool $legacyEncoding
524 * @param array $flags
525 * @param mixed $expected
527 public function testDecompressRevisionText( $legacyEncoding, $text, $flags, $expected ) {
528 $this->setMwGlobals( 'wgLegacyEncoding', $legacyEncoding );
529 $this->setMwGlobals( 'wgLanguageCode', 'en' );
532 Revision
::decompressRevisionText( $text, $flags )
537 * @covers Revision::getRevisionText
539 public function testGetRevisionText_returnsFalseWhenNoTextField() {
540 $this->assertFalse( Revision
::getRevisionText( new stdClass() ) );
543 public function provideTestGetRevisionText_returnsDecompressedTextFieldWhenNotExternal() {
544 yield
'Just text' => [
545 (object)[ 'old_text' => 'SomeText' ],
549 // gzip string below generated with gzdeflate( 'AAAABBAAA' )
550 yield
'gzip text' => [
552 'old_text' => "sttttr\002\022\000",
553 'old_flags' => 'gzip'
558 yield
'gzip text and different prefix' => [
560 'jojo_text' => "sttttr\002\022\000",
561 'jojo_flags' => 'gzip'
569 * @dataProvider provideTestGetRevisionText_returnsDecompressedTextFieldWhenNotExternal
570 * @covers Revision::getRevisionText
572 public function testGetRevisionText_returnsDecompressedTextFieldWhenNotExternal(
577 $this->assertSame( $expected, Revision
::getRevisionText( $row, $prefix ) );
580 public function provideTestGetRevisionText_external_returnsFalseWhenNotEnoughUrlParts() {
581 yield
'Just some text' => [ 'someNonUrlText' ];
582 yield
'No second URL part' => [ 'someProtocol://' ];
586 * @dataProvider provideTestGetRevisionText_external_returnsFalseWhenNotEnoughUrlParts
587 * @covers Revision::getRevisionText
589 public function testGetRevisionText_external_returnsFalseWhenNotEnoughUrlParts(
593 Revision
::getRevisionText(
596 'old_flags' => 'external',
603 * @covers Revision::getRevisionText
605 public function testGetRevisionText_external_noOldId() {
607 'ExternalStoreFactory',
608 new ExternalStoreFactory( [ 'ForTesting' ] )
612 Revision
::getRevisionText(
614 'old_text' => 'ForTesting://cluster1/12345',
615 'old_flags' => 'external,gzip',
622 * @covers Revision::getRevisionText
624 public function testGetRevisionText_external_oldId() {
625 $cache = new WANObjectCache( [ 'cache' => new HashBagOStuff() ] );
626 $this->setService( 'MainWANObjectCache', $cache );
628 'ExternalStoreFactory',
629 new ExternalStoreFactory( [ 'ForTesting' ] )
632 $cacheKey = $cache->makeKey( 'revisiontext', 'textid', '7777' );
636 Revision
::getRevisionText(
638 'old_text' => 'ForTesting://cluster1/12345',
639 'old_flags' => 'external,gzip',
644 $this->assertSame( 'AAAABBAAA', $cache->get( $cacheKey ) );
648 * @covers Revision::userJoinCond
650 public function testUserJoinCond() {
651 $this->hideDeprecated( 'Revision::userJoinCond' );
653 [ 'LEFT JOIN', [ 'rev_user != 0', 'user_id = rev_user' ] ],
654 Revision
::userJoinCond()
659 * @covers Revision::pageJoinCond
661 public function testPageJoinCond() {
662 $this->hideDeprecated( 'Revision::pageJoinCond' );
664 [ 'INNER JOIN', [ 'page_id = rev_page' ] ],
665 Revision
::pageJoinCond()
669 public function provideSelectFields() {
684 'rev_comment_text' => 'rev_comment',
685 'rev_comment_data' => 'NULL',
686 'rev_comment_cid' => 'NULL',
687 'rev_content_format',
705 'rev_comment_text' => 'rev_comment',
706 'rev_comment_data' => 'NULL',
707 'rev_comment_cid' => 'NULL',
713 * @dataProvider provideSelectFields
714 * @covers Revision::selectFields
715 * @todo a true unit test would mock CommentStore
717 public function testSelectFields( $contentHandlerUseDB, $expected ) {
718 $this->hideDeprecated( 'Revision::selectFields' );
719 $this->setMwGlobals( 'wgContentHandlerUseDB', $contentHandlerUseDB );
720 $this->setMwGlobals( 'wgCommentTableSchemaMigrationStage', MIGRATION_OLD
);
721 $this->assertEquals( $expected, Revision
::selectFields() );
724 public function provideSelectArchiveFields() {
741 'ar_comment_text' => 'ar_comment',
742 'ar_comment_data' => 'NULL',
743 'ar_comment_cid' => 'NULL',
764 'ar_comment_text' => 'ar_comment',
765 'ar_comment_data' => 'NULL',
766 'ar_comment_cid' => 'NULL',
772 * @dataProvider provideSelectArchiveFields
773 * @covers Revision::selectArchiveFields
774 * @todo a true unit test would mock CommentStore
776 public function testSelectArchiveFields( $contentHandlerUseDB, $expected ) {
777 $this->hideDeprecated( 'Revision::selectArchiveFields' );
778 $this->setMwGlobals( 'wgContentHandlerUseDB', $contentHandlerUseDB );
779 $this->setMwGlobals( 'wgCommentTableSchemaMigrationStage', MIGRATION_OLD
);
780 $this->assertEquals( $expected, Revision
::selectArchiveFields() );
784 * @covers Revision::selectTextFields
786 public function testSelectTextFields() {
787 $this->hideDeprecated( 'Revision::selectTextFields' );
793 Revision
::selectTextFields()
798 * @covers Revision::selectPageFields
800 public function testSelectPageFields() {
801 $this->hideDeprecated( 'Revision::selectPageFields' );
811 Revision
::selectPageFields()
816 * @covers Revision::selectUserFields
818 public function testSelectUserFields() {
819 $this->hideDeprecated( 'Revision::selectUserFields' );
824 Revision
::selectUserFields()
828 public function provideGetArchiveQueryInfo() {
829 yield
'wgContentHandlerUseDB false, wgCommentTableSchemaMigrationStage OLD' => [
831 'wgContentHandlerUseDB' => false,
832 'wgCommentTableSchemaMigrationStage' => MIGRATION_OLD
,
835 'tables' => [ 'archive' ],
850 'ar_comment_text' => 'ar_comment',
851 'ar_comment_data' => 'NULL',
852 'ar_comment_cid' => 'NULL',
857 yield
'wgContentHandlerUseDB true, wgCommentTableSchemaMigrationStage OLD' => [
859 'wgContentHandlerUseDB' => true,
860 'wgCommentTableSchemaMigrationStage' => MIGRATION_OLD
,
863 'tables' => [ 'archive' ],
878 'ar_comment_text' => 'ar_comment',
879 'ar_comment_data' => 'NULL',
880 'ar_comment_cid' => 'NULL',
887 yield
'wgContentHandlerUseDB false, wgCommentTableSchemaMigrationStage WRITE_BOTH' => [
889 'wgContentHandlerUseDB' => false,
890 'wgCommentTableSchemaMigrationStage' => MIGRATION_WRITE_BOTH
,
895 'comment_ar_comment' => 'comment',
911 'ar_comment_text' => 'COALESCE( comment_ar_comment.comment_text, ar_comment )',
912 'ar_comment_data' => 'comment_ar_comment.comment_data',
913 'ar_comment_cid' => 'comment_ar_comment.comment_id',
916 'comment_ar_comment' => [
918 'comment_ar_comment.comment_id = ar_comment_id',
923 yield
'wgContentHandlerUseDB false, wgCommentTableSchemaMigrationStage WRITE_NEW' => [
925 'wgContentHandlerUseDB' => false,
926 'wgCommentTableSchemaMigrationStage' => MIGRATION_WRITE_NEW
,
931 'comment_ar_comment' => 'comment',
947 'ar_comment_text' => 'COALESCE( comment_ar_comment.comment_text, ar_comment )',
948 'ar_comment_data' => 'comment_ar_comment.comment_data',
949 'ar_comment_cid' => 'comment_ar_comment.comment_id',
952 'comment_ar_comment' => [
954 'comment_ar_comment.comment_id = ar_comment_id',
959 yield
'wgContentHandlerUseDB false, wgCommentTableSchemaMigrationStage NEW' => [
961 'wgContentHandlerUseDB' => false,
962 'wgCommentTableSchemaMigrationStage' => MIGRATION_NEW
,
967 'comment_ar_comment' => 'comment',
983 'ar_comment_text' => 'comment_ar_comment.comment_text',
984 'ar_comment_data' => 'comment_ar_comment.comment_data',
985 'ar_comment_cid' => 'comment_ar_comment.comment_id',
988 'comment_ar_comment' => [
990 'comment_ar_comment.comment_id = ar_comment_id',
998 * @covers Revision::getArchiveQueryInfo
999 * @dataProvider provideGetArchiveQueryInfo
1001 public function testGetArchiveQueryInfo( $globals, $expected ) {
1002 $this->setMwGlobals( $globals );
1003 $this->assertEquals(
1005 Revision
::getArchiveQueryInfo()
1009 public function provideGetQueryInfo() {
1010 yield
'wgContentHandlerUseDB false, wgCommentTableSchemaMigrationStage OLD, opts none' => [
1012 'wgContentHandlerUseDB' => false,
1013 'wgCommentTableSchemaMigrationStage' => MIGRATION_OLD
,
1017 'tables' => [ 'revision' ],
1030 'rev_comment_text' => 'rev_comment',
1031 'rev_comment_data' => 'NULL',
1032 'rev_comment_cid' => 'NULL',
1037 yield
'wgContentHandlerUseDB false, wgCommentTableSchemaMigrationStage OLD, opts page' => [
1039 'wgContentHandlerUseDB' => false,
1040 'wgCommentTableSchemaMigrationStage' => MIGRATION_OLD
,
1044 'tables' => [ 'revision', 'page' ],
1057 'rev_comment_text' => 'rev_comment',
1058 'rev_comment_data' => 'NULL',
1059 'rev_comment_cid' => 'NULL',
1070 [ 'page_id = rev_page' ],
1075 yield
'wgContentHandlerUseDB false, wgCommentTableSchemaMigrationStage OLD, opts user' => [
1077 'wgContentHandlerUseDB' => false,
1078 'wgCommentTableSchemaMigrationStage' => MIGRATION_OLD
,
1082 'tables' => [ 'revision', 'user' ],
1095 'rev_comment_text' => 'rev_comment',
1096 'rev_comment_data' => 'NULL',
1097 'rev_comment_cid' => 'NULL',
1105 'user_id = rev_user',
1111 yield
'wgContentHandlerUseDB false, wgCommentTableSchemaMigrationStage OLD, opts text' => [
1113 'wgContentHandlerUseDB' => false,
1114 'wgCommentTableSchemaMigrationStage' => MIGRATION_OLD
,
1118 'tables' => [ 'revision', 'text' ],
1131 'rev_comment_text' => 'rev_comment',
1132 'rev_comment_data' => 'NULL',
1133 'rev_comment_cid' => 'NULL',
1140 [ 'rev_text_id=old_id' ],
1145 yield
'wgContentHandlerUseDB false, wgCommentTableSchemaMigrationStage OLD, opts 3' => [
1147 'wgContentHandlerUseDB' => false,
1148 'wgCommentTableSchemaMigrationStage' => MIGRATION_OLD
,
1150 [ 'text', 'page', 'user' ],
1152 'tables' => [ 'revision', 'page', 'user', 'text' ],
1165 'rev_comment_text' => 'rev_comment',
1166 'rev_comment_data' => 'NULL',
1167 'rev_comment_cid' => 'NULL',
1181 [ 'page_id = rev_page' ],
1187 'user_id = rev_user',
1192 [ 'rev_text_id=old_id' ],
1197 yield
'wgContentHandlerUseDB true, wgCommentTableSchemaMigrationStage OLD, opts none' => [
1199 'wgContentHandlerUseDB' => true,
1200 'wgCommentTableSchemaMigrationStage' => MIGRATION_OLD
,
1204 'tables' => [ 'revision' ],
1217 'rev_comment_text' => 'rev_comment',
1218 'rev_comment_data' => 'NULL',
1219 'rev_comment_cid' => 'NULL',
1220 'rev_content_format',
1221 'rev_content_model',
1226 yield
'wgContentHandlerUseDB false, wgCommentTableSchemaMigrationStage WRITE_BOTH, opts none' => [
1228 'wgContentHandlerUseDB' => false,
1229 'wgCommentTableSchemaMigrationStage' => MIGRATION_WRITE_BOTH
,
1235 'temp_rev_comment' => 'revision_comment_temp',
1236 'comment_rev_comment' => 'comment',
1250 'rev_comment_text' => 'COALESCE( comment_rev_comment.comment_text, rev_comment )',
1251 'rev_comment_data' => 'comment_rev_comment.comment_data',
1252 'rev_comment_cid' => 'comment_rev_comment.comment_id',
1255 'temp_rev_comment' => [
1257 'temp_rev_comment.revcomment_rev = rev_id',
1259 'comment_rev_comment' => [
1261 'comment_rev_comment.comment_id = temp_rev_comment.revcomment_comment_id',
1266 yield
'wgContentHandlerUseDB false, wgCommentTableSchemaMigrationStage WRITE_NEW, opts none' => [
1268 'wgContentHandlerUseDB' => false,
1269 'wgCommentTableSchemaMigrationStage' => MIGRATION_WRITE_NEW
,
1275 'temp_rev_comment' => 'revision_comment_temp',
1276 'comment_rev_comment' => 'comment',
1290 'rev_comment_text' => 'COALESCE( comment_rev_comment.comment_text, rev_comment )',
1291 'rev_comment_data' => 'comment_rev_comment.comment_data',
1292 'rev_comment_cid' => 'comment_rev_comment.comment_id',
1295 'temp_rev_comment' => [
1297 'temp_rev_comment.revcomment_rev = rev_id',
1299 'comment_rev_comment' => [
1301 'comment_rev_comment.comment_id = temp_rev_comment.revcomment_comment_id',
1306 yield
'wgContentHandlerUseDB false, wgCommentTableSchemaMigrationStage NEW, opts none' => [
1308 'wgContentHandlerUseDB' => false,
1309 'wgCommentTableSchemaMigrationStage' => MIGRATION_NEW
,
1315 'temp_rev_comment' => 'revision_comment_temp',
1316 'comment_rev_comment' => 'comment',
1330 'rev_comment_text' => 'comment_rev_comment.comment_text',
1331 'rev_comment_data' => 'comment_rev_comment.comment_data',
1332 'rev_comment_cid' => 'comment_rev_comment.comment_id',
1335 'temp_rev_comment' => [
1337 'temp_rev_comment.revcomment_rev = rev_id',
1339 'comment_rev_comment' => [
1341 'comment_rev_comment.comment_id = temp_rev_comment.revcomment_comment_id',
1349 * @covers Revision::getQueryInfo
1350 * @dataProvider provideGetQueryInfo
1352 public function testGetQueryInfo( $globals, $options, $expected ) {
1353 $this->setMwGlobals( $globals );
1354 $this->assertEquals(
1356 Revision
::getQueryInfo( $options )