6 * @covers WatchedItemStore
8 class WatchedItemStoreUnitTest
extends PHPUnit_Framework_TestCase
{
11 * @return PHPUnit_Framework_MockObject_MockObject|IDatabase
13 private function getMockDb() {
14 return $this->getMock( IDatabase
::class );
18 * @return PHPUnit_Framework_MockObject_MockObject|LoadBalancer
20 private function getMockLoadBalancer( $mockDb, $expectedConnectionType = null ) {
21 $mock = $this->getMockBuilder( LoadBalancer
::class )
22 ->disableOriginalConstructor()
24 if ( $expectedConnectionType !== null ) {
25 $mock->expects( $this->any() )
26 ->method( 'getConnection' )
27 ->with( $expectedConnectionType )
28 ->will( $this->returnValue( $mockDb ) );
30 $mock->expects( $this->any() )
31 ->method( 'getConnection' )
32 ->will( $this->returnValue( $mockDb ) );
34 $mock->expects( $this->any() )
35 ->method( 'getReadOnlyReason' )
36 ->will( $this->returnValue( false ) );
41 * @return PHPUnit_Framework_MockObject_MockObject|HashBagOStuff
43 private function getMockCache() {
44 $mock = $this->getMockBuilder( HashBagOStuff
::class )
45 ->disableOriginalConstructor()
47 $mock->expects( $this->any() )
49 ->will( $this->returnCallback( function() {
50 return implode( ':', func_get_args() );
57 * @return PHPUnit_Framework_MockObject_MockObject|User
59 private function getMockNonAnonUserWithId( $id ) {
60 $mock = $this->getMock( User
::class );
61 $mock->expects( $this->any() )
63 ->will( $this->returnValue( false ) );
64 $mock->expects( $this->any() )
66 ->will( $this->returnValue( $id ) );
73 private function getAnonUser() {
74 return User
::newFromName( 'Anon_User' );
77 private function getFakeRow( array $rowValues ) {
78 $fakeRow = new stdClass();
79 foreach ( $rowValues as $valueName => $value ) {
80 $fakeRow->$valueName = $value;
85 public function testGetDefaultInstance() {
86 $instanceOne = WatchedItemStore
::getDefaultInstance();
87 $instanceTwo = WatchedItemStore
::getDefaultInstance();
88 $this->assertSame( $instanceOne, $instanceTwo );
91 public function testOverrideDefaultInstance() {
92 $instance = WatchedItemStore
::getDefaultInstance();
93 $scopedOverride = $instance->overrideDefaultInstance( null );
95 $this->assertNotSame( $instance, WatchedItemStore
::getDefaultInstance() );
97 unset( $scopedOverride );
99 $this->assertSame( $instance, WatchedItemStore
::getDefaultInstance() );
102 public function testCountWatchedItems() {
103 $user = $this->getMockNonAnonUserWithId( 1 );
105 $mockDb = $this->getMockDb();
106 $mockDb->expects( $this->exactly( 1 ) )
107 ->method( 'selectField' )
112 'wl_user' => $user->getId(),
114 $this->isType( 'string' )
116 ->will( $this->returnValue( 12 ) );
118 $mockCache = $this->getMockCache();
119 $mockCache->expects( $this->never() )->method( 'get' );
120 $mockCache->expects( $this->never() )->method( 'set' );
121 $mockCache->expects( $this->never() )->method( 'delete' );
123 $store = new WatchedItemStore(
124 $this->getMockLoadBalancer( $mockDb ),
128 $this->assertEquals( 12, $store->countWatchedItems( $user ) );
131 public function testCountWatchers() {
132 $titleValue = new TitleValue( 0, 'SomeDbKey' );
134 $mockDb = $this->getMockDb();
135 $mockDb->expects( $this->exactly( 1 ) )
136 ->method( 'selectField' )
141 'wl_namespace' => $titleValue->getNamespace(),
142 'wl_title' => $titleValue->getDBkey(),
144 $this->isType( 'string' )
146 ->will( $this->returnValue( 7 ) );
148 $mockCache = $this->getMockCache();
149 $mockCache->expects( $this->never() )->method( 'get' );
150 $mockCache->expects( $this->never() )->method( 'set' );
151 $mockCache->expects( $this->never() )->method( 'delete' );
153 $store = new WatchedItemStore(
154 $this->getMockLoadBalancer( $mockDb ),
158 $this->assertEquals( 7, $store->countWatchers( $titleValue ) );
161 public function testCountWatchersMultiple() {
163 new TitleValue( 0, 'SomeDbKey' ),
164 new TitleValue( 0, 'OtherDbKey' ),
165 new TitleValue( 1, 'AnotherDbKey' ),
168 $mockDb = $this->getMockDb();
171 $this->getFakeRow( [ 'wl_title' => 'SomeDbKey', 'wl_namespace' => 0, 'watchers' => 100 ] ),
172 $this->getFakeRow( [ 'wl_title' => 'OtherDbKey', 'wl_namespace' => 0, 'watchers' => 300 ] ),
173 $this->getFakeRow( [ 'wl_title' => 'AnotherDbKey', 'wl_namespace' => 1, 'watchers' => 500 ]
176 $mockDb->expects( $this->once() )
177 ->method( 'makeWhereFrom2d' )
179 [ [ 'SomeDbKey' => 1, 'OtherDbKey' => 1 ], [ 'AnotherDbKey' => 1 ] ],
180 $this->isType( 'string' ),
181 $this->isType( 'string' )
183 ->will( $this->returnValue( 'makeWhereFrom2d return value' ) );
184 $mockDb->expects( $this->once() )
188 [ 'wl_title', 'wl_namespace', 'watchers' => 'COUNT(*)' ],
189 [ 'makeWhereFrom2d return value' ],
190 $this->isType( 'string' ),
192 'GROUP BY' => [ 'wl_namespace', 'wl_title' ],
196 $this->returnValue( $dbResult )
199 $mockCache = $this->getMockCache();
200 $mockCache->expects( $this->never() )->method( 'get' );
201 $mockCache->expects( $this->never() )->method( 'set' );
202 $mockCache->expects( $this->never() )->method( 'delete' );
204 $store = new WatchedItemStore(
205 $this->getMockLoadBalancer( $mockDb ),
210 0 => [ 'SomeDbKey' => 100, 'OtherDbKey' => 300 ],
211 1 => [ 'AnotherDbKey' => 500 ],
213 $this->assertEquals( $expected, $store->countWatchersMultiple( $titleValues ) );
216 public function provideIntWithDbUnsafeVersion() {
219 [ "50; DROP TABLE watchlist;\n--" ],
224 * @dataProvider provideIntWithDbUnsafeVersion
226 public function testCountWatchersMultiple_withMinimumWatchers( $minWatchers ) {
228 new TitleValue( 0, 'SomeDbKey' ),
229 new TitleValue( 0, 'OtherDbKey' ),
230 new TitleValue( 1, 'AnotherDbKey' ),
233 $mockDb = $this->getMockDb();
236 $this->getFakeRow( [ 'wl_title' => 'SomeDbKey', 'wl_namespace' => 0, 'watchers' => 100 ] ),
237 $this->getFakeRow( [ 'wl_title' => 'OtherDbKey', 'wl_namespace' => 0, 'watchers' => 300 ] ),
238 $this->getFakeRow( [ 'wl_title' => 'AnotherDbKey', 'wl_namespace' => 1, 'watchers' => 500 ]
241 $mockDb->expects( $this->once() )
242 ->method( 'makeWhereFrom2d' )
244 [ [ 'SomeDbKey' => 1, 'OtherDbKey' => 1 ], [ 'AnotherDbKey' => 1 ] ],
245 $this->isType( 'string' ),
246 $this->isType( 'string' )
248 ->will( $this->returnValue( 'makeWhereFrom2d return value' ) );
249 $mockDb->expects( $this->once() )
253 [ 'wl_title', 'wl_namespace', 'watchers' => 'COUNT(*)' ],
254 [ 'makeWhereFrom2d return value' ],
255 $this->isType( 'string' ),
257 'GROUP BY' => [ 'wl_namespace', 'wl_title' ],
258 'HAVING' => 'COUNT(*) >= 50',
262 $this->returnValue( $dbResult )
265 $mockCache = $this->getMockCache();
266 $mockCache->expects( $this->never() )->method( 'get' );
267 $mockCache->expects( $this->never() )->method( 'set' );
268 $mockCache->expects( $this->never() )->method( 'delete' );
270 $store = new WatchedItemStore(
271 $this->getMockLoadBalancer( $mockDb ),
276 0 => [ 'SomeDbKey' => 100, 'OtherDbKey' => 300 ],
277 1 => [ 'AnotherDbKey' => 500 ],
281 $store->countWatchersMultiple( $titleValues, [ 'minimumWatchers' => $minWatchers ] )
285 public function testCountVisitingWatchers() {
286 $titleValue = new TitleValue( 0, 'SomeDbKey' );
288 $mockDb = $this->getMockDb();
289 $mockDb->expects( $this->exactly( 1 ) )
290 ->method( 'selectField' )
295 'wl_namespace' => $titleValue->getNamespace(),
296 'wl_title' => $titleValue->getDBkey(),
297 'wl_notificationtimestamp >= \'TS111TS\' OR wl_notificationtimestamp IS NULL',
299 $this->isType( 'string' )
301 ->will( $this->returnValue( 7 ) );
302 $mockDb->expects( $this->exactly( 1 ) )
303 ->method( 'addQuotes' )
304 ->will( $this->returnCallback( function( $value ) {
307 $mockDb->expects( $this->exactly( 1 ) )
308 ->method( 'timestamp' )
309 ->will( $this->returnCallback( function( $value ) {
310 return 'TS' . $value . 'TS';
313 $mockCache = $this->getMockCache();
314 $mockCache->expects( $this->never() )->method( 'set' );
315 $mockCache->expects( $this->never() )->method( 'get' );
316 $mockCache->expects( $this->never() )->method( 'delete' );
318 $store = new WatchedItemStore(
319 $this->getMockLoadBalancer( $mockDb ),
323 $this->assertEquals( 7, $store->countVisitingWatchers( $titleValue, '111' ) );
326 public function testCountVisitingWatchersMultiple() {
327 $titleValuesWithThresholds = [
328 [ new TitleValue( 0, 'SomeDbKey' ), '111' ],
329 [ new TitleValue( 0, 'OtherDbKey' ), '111' ],
330 [ new TitleValue( 1, 'AnotherDbKey' ), '123' ],
334 $this->getFakeRow( [ 'wl_title' => 'SomeDbKey', 'wl_namespace' => 0, 'watchers' => 100 ] ),
335 $this->getFakeRow( [ 'wl_title' => 'OtherDbKey', 'wl_namespace' => 0, 'watchers' => 300 ] ),
336 $this->getFakeRow( [ 'wl_title' => 'AnotherDbKey', 'wl_namespace' => 1, 'watchers' => 500 ] ),
338 $mockDb = $this->getMockDb();
339 $mockDb->expects( $this->exactly( 2 * 3 ) )
340 ->method( 'addQuotes' )
341 ->will( $this->returnCallback( function( $value ) {
344 $mockDb->expects( $this->exactly( 3 ) )
345 ->method( 'timestamp' )
346 ->will( $this->returnCallback( function( $value ) {
347 return 'TS' . $value . 'TS';
349 $mockDb->expects( $this->any() )
350 ->method( 'makeList' )
352 $this->isType( 'array' ),
353 $this->isType( 'int' )
355 ->will( $this->returnCallback( function( $a, $conj ) {
356 $sqlConj = $conj === LIST_AND ?
' AND ' : ' OR ';
357 return join( $sqlConj, array_map( function( $s ) {
358 return '(' . $s . ')';
362 $mockDb->expects( $this->never() )
363 ->method( 'makeWhereFrom2d' );
366 '((wl_namespace = 0) AND (' .
367 "(((wl_title = 'SomeDbKey') AND (" .
368 "(wl_notificationtimestamp >= 'TS111TS') OR (wl_notificationtimestamp IS NULL)" .
370 "(wl_title = 'OtherDbKey') AND (" .
371 "(wl_notificationtimestamp >= 'TS111TS') OR (wl_notificationtimestamp IS NULL)" .
373 ') OR ((wl_namespace = 1) AND (' .
374 "(((wl_title = 'AnotherDbKey') AND (".
375 "(wl_notificationtimestamp >= 'TS123TS') OR (wl_notificationtimestamp IS NULL)" .
377 $mockDb->expects( $this->once() )
381 [ 'wl_namespace', 'wl_title', 'watchers' => 'COUNT(*)' ],
383 $this->isType( 'string' ),
385 'GROUP BY' => [ 'wl_namespace', 'wl_title' ],
389 $this->returnValue( $dbResult )
392 $mockCache = $this->getMockCache();
393 $mockCache->expects( $this->never() )->method( 'get' );
394 $mockCache->expects( $this->never() )->method( 'set' );
395 $mockCache->expects( $this->never() )->method( 'delete' );
397 $store = new WatchedItemStore(
398 $this->getMockLoadBalancer( $mockDb ),
403 0 => [ 'SomeDbKey' => 100, 'OtherDbKey' => 300 ],
404 1 => [ 'AnotherDbKey' => 500 ],
408 $store->countVisitingWatchersMultiple( $titleValuesWithThresholds )
412 public function testCountVisitingWatchersMultiple_withMissingTargets() {
413 $titleValuesWithThresholds = [
414 [ new TitleValue( 0, 'SomeDbKey' ), '111' ],
415 [ new TitleValue( 0, 'OtherDbKey' ), '111' ],
416 [ new TitleValue( 1, 'AnotherDbKey' ), '123' ],
417 [ new TitleValue( 0, 'SomeNotExisitingDbKey' ), null ],
418 [ new TitleValue( 0, 'OtherNotExisitingDbKey' ), null ],
422 $this->getFakeRow( [ 'wl_title' => 'SomeDbKey', 'wl_namespace' => 0, 'watchers' => 100 ] ),
423 $this->getFakeRow( [ 'wl_title' => 'OtherDbKey', 'wl_namespace' => 0, 'watchers' => 300 ] ),
424 $this->getFakeRow( [ 'wl_title' => 'AnotherDbKey', 'wl_namespace' => 1, 'watchers' => 500 ] ),
426 [ 'wl_title' => 'SomeNotExisitingDbKey', 'wl_namespace' => 0, 'watchers' => 100 ]
429 [ 'wl_title' => 'OtherNotExisitingDbKey', 'wl_namespace' => 0, 'watchers' => 200 ]
432 $mockDb = $this->getMockDb();
433 $mockDb->expects( $this->exactly( 2 * 3 ) )
434 ->method( 'addQuotes' )
435 ->will( $this->returnCallback( function( $value ) {
438 $mockDb->expects( $this->exactly( 3 ) )
439 ->method( 'timestamp' )
440 ->will( $this->returnCallback( function( $value ) {
441 return 'TS' . $value . 'TS';
443 $mockDb->expects( $this->any() )
444 ->method( 'makeList' )
446 $this->isType( 'array' ),
447 $this->isType( 'int' )
449 ->will( $this->returnCallback( function( $a, $conj ) {
450 $sqlConj = $conj === LIST_AND ?
' AND ' : ' OR ';
451 return join( $sqlConj, array_map( function( $s ) {
452 return '(' . $s . ')';
456 $mockDb->expects( $this->once() )
457 ->method( 'makeWhereFrom2d' )
459 [ [ 'SomeNotExisitingDbKey' => 1, 'OtherNotExisitingDbKey' => 1 ] ],
460 $this->isType( 'string' ),
461 $this->isType( 'string' )
463 ->will( $this->returnValue( 'makeWhereFrom2d return value' ) );
466 '((wl_namespace = 0) AND (' .
467 "(((wl_title = 'SomeDbKey') AND (" .
468 "(wl_notificationtimestamp >= 'TS111TS') OR (wl_notificationtimestamp IS NULL)" .
470 "(wl_title = 'OtherDbKey') AND (" .
471 "(wl_notificationtimestamp >= 'TS111TS') OR (wl_notificationtimestamp IS NULL)" .
473 ') OR ((wl_namespace = 1) AND (' .
474 "(((wl_title = 'AnotherDbKey') AND (".
475 "(wl_notificationtimestamp >= 'TS123TS') OR (wl_notificationtimestamp IS NULL)" .
478 '(makeWhereFrom2d return value)';
479 $mockDb->expects( $this->once() )
483 [ 'wl_namespace', 'wl_title', 'watchers' => 'COUNT(*)' ],
485 $this->isType( 'string' ),
487 'GROUP BY' => [ 'wl_namespace', 'wl_title' ],
491 $this->returnValue( $dbResult )
494 $mockCache = $this->getMockCache();
495 $mockCache->expects( $this->never() )->method( 'get' );
496 $mockCache->expects( $this->never() )->method( 'set' );
497 $mockCache->expects( $this->never() )->method( 'delete' );
499 $store = new WatchedItemStore(
500 $this->getMockLoadBalancer( $mockDb ),
506 'SomeDbKey' => 100, 'OtherDbKey' => 300,
507 'SomeNotExisitingDbKey' => 100, 'OtherNotExisitingDbKey' => 200
509 1 => [ 'AnotherDbKey' => 500 ],
513 $store->countVisitingWatchersMultiple( $titleValuesWithThresholds )
518 * @dataProvider provideIntWithDbUnsafeVersion
520 public function testCountVisitingWatchersMultiple_withMinimumWatchers( $minWatchers ) {
521 $titleValuesWithThresholds = [
522 [ new TitleValue( 0, 'SomeDbKey' ), '111' ],
523 [ new TitleValue( 0, 'OtherDbKey' ), '111' ],
524 [ new TitleValue( 1, 'AnotherDbKey' ), '123' ],
527 $mockDb = $this->getMockDb();
528 $mockDb->expects( $this->any() )
529 ->method( 'makeList' )
530 ->will( $this->returnValue( 'makeList return value' ) );
531 $mockDb->expects( $this->once() )
535 [ 'wl_namespace', 'wl_title', 'watchers' => 'COUNT(*)' ],
536 'makeList return value',
537 $this->isType( 'string' ),
539 'GROUP BY' => [ 'wl_namespace', 'wl_title' ],
540 'HAVING' => 'COUNT(*) >= 50',
544 $this->returnValue( [] )
547 $mockCache = $this->getMockCache();
548 $mockCache->expects( $this->never() )->method( 'get' );
549 $mockCache->expects( $this->never() )->method( 'set' );
550 $mockCache->expects( $this->never() )->method( 'delete' );
552 $store = new WatchedItemStore(
553 $this->getMockLoadBalancer( $mockDb ),
558 0 => [ 'SomeDbKey' => 0, 'OtherDbKey' => 0 ],
559 1 => [ 'AnotherDbKey' => 0 ],
563 $store->countVisitingWatchersMultiple( $titleValuesWithThresholds, $minWatchers )
567 public function testCountUnreadNotifications() {
568 $user = $this->getMockNonAnonUserWithId( 1 );
570 $mockDb = $this->getMockDb();
571 $mockDb->expects( $this->exactly( 1 ) )
572 ->method( 'selectRowCount' )
577 "wl_notificationtimestamp IS NOT NULL",
580 $this->isType( 'string' )
582 ->will( $this->returnValue( 9 ) );
584 $mockCache = $this->getMockCache();
585 $mockCache->expects( $this->never() )->method( 'set' );
586 $mockCache->expects( $this->never() )->method( 'get' );
587 $mockCache->expects( $this->never() )->method( 'delete' );
589 $store = new WatchedItemStore(
590 $this->getMockLoadBalancer( $mockDb ),
594 $this->assertEquals( 9, $store->countUnreadNotifications( $user ) );
598 * @dataProvider provideIntWithDbUnsafeVersion
600 public function testCountUnreadNotifications_withUnreadLimit_overLimit( $limit ) {
601 $user = $this->getMockNonAnonUserWithId( 1 );
603 $mockDb = $this->getMockDb();
604 $mockDb->expects( $this->exactly( 1 ) )
605 ->method( 'selectRowCount' )
610 "wl_notificationtimestamp IS NOT NULL",
613 $this->isType( 'string' ),
616 ->will( $this->returnValue( 50 ) );
618 $mockCache = $this->getMockCache();
619 $mockCache->expects( $this->never() )->method( 'set' );
620 $mockCache->expects( $this->never() )->method( 'get' );
621 $mockCache->expects( $this->never() )->method( 'delete' );
623 $store = new WatchedItemStore(
624 $this->getMockLoadBalancer( $mockDb ),
630 $store->countUnreadNotifications( $user, $limit )
635 * @dataProvider provideIntWithDbUnsafeVersion
637 public function testCountUnreadNotifications_withUnreadLimit_underLimit( $limit ) {
638 $user = $this->getMockNonAnonUserWithId( 1 );
640 $mockDb = $this->getMockDb();
641 $mockDb->expects( $this->exactly( 1 ) )
642 ->method( 'selectRowCount' )
647 "wl_notificationtimestamp IS NOT NULL",
650 $this->isType( 'string' ),
653 ->will( $this->returnValue( 9 ) );
655 $mockCache = $this->getMockCache();
656 $mockCache->expects( $this->never() )->method( 'set' );
657 $mockCache->expects( $this->never() )->method( 'get' );
658 $mockCache->expects( $this->never() )->method( 'delete' );
660 $store = new WatchedItemStore(
661 $this->getMockLoadBalancer( $mockDb ),
667 $store->countUnreadNotifications( $user, $limit )
671 public function testDuplicateEntry_nothingToDuplicate() {
672 $mockDb = $this->getMockDb();
673 $mockDb->expects( $this->once() )
679 'wl_notificationtimestamp',
683 'wl_title' => 'Old_Title',
685 'WatchedItemStore::duplicateEntry',
688 ->will( $this->returnValue( new FakeResultWrapper( [] ) ) );
690 $store = new WatchedItemStore(
691 $this->getMockLoadBalancer( $mockDb ),
692 $this->getMockCache()
695 $store->duplicateEntry(
696 Title
::newFromText( 'Old_Title' ),
697 Title
::newFromText( 'New_Title' )
701 public function testDuplicateEntry_somethingToDuplicate() {
703 $this->getFakeRow( [ 'wl_user' => 1, 'wl_notificationtimestamp' => '20151212010101' ] ),
704 $this->getFakeRow( [ 'wl_user' => 2, 'wl_notificationtimestamp' => null ] ),
707 $mockDb = $this->getMockDb();
708 $mockDb->expects( $this->at( 0 ) )
714 'wl_notificationtimestamp',
718 'wl_title' => 'Old_Title',
721 ->will( $this->returnValue( new FakeResultWrapper( $fakeRows ) ) );
722 $mockDb->expects( $this->at( 1 ) )
723 ->method( 'replace' )
726 [ [ 'wl_user', 'wl_namespace', 'wl_title' ] ],
731 'wl_title' => 'New_Title',
732 'wl_notificationtimestamp' => '20151212010101',
737 'wl_title' => 'New_Title',
738 'wl_notificationtimestamp' => null,
741 $this->isType( 'string' )
744 $mockCache = $this->getMockCache();
745 $mockCache->expects( $this->never() )->method( 'get' );
746 $mockCache->expects( $this->never() )->method( 'delete' );
748 $store = new WatchedItemStore(
749 $this->getMockLoadBalancer( $mockDb ),
753 $store->duplicateEntry(
754 Title
::newFromText( 'Old_Title' ),
755 Title
::newFromText( 'New_Title' )
759 public function testDuplicateAllAssociatedEntries_nothingToDuplicate() {
760 $mockDb = $this->getMockDb();
761 $mockDb->expects( $this->at( 0 ) )
767 'wl_notificationtimestamp',
771 'wl_title' => 'Old_Title',
774 ->will( $this->returnValue( new FakeResultWrapper( [] ) ) );
775 $mockDb->expects( $this->at( 1 ) )
781 'wl_notificationtimestamp',
785 'wl_title' => 'Old_Title',
788 ->will( $this->returnValue( new FakeResultWrapper( [] ) ) );
790 $mockCache = $this->getMockCache();
791 $mockCache->expects( $this->never() )->method( 'get' );
792 $mockCache->expects( $this->never() )->method( 'delete' );
794 $store = new WatchedItemStore(
795 $this->getMockLoadBalancer( $mockDb ),
799 $store->duplicateAllAssociatedEntries(
800 Title
::newFromText( 'Old_Title' ),
801 Title
::newFromText( 'New_Title' )
805 public function testDuplicateAllAssociatedEntries_somethingToDuplicate() {
807 $this->getFakeRow( [ 'wl_user' => 1, 'wl_notificationtimestamp' => '20151212010101' ] ),
810 $mockDb = $this->getMockDb();
811 $mockDb->expects( $this->at( 0 ) )
817 'wl_notificationtimestamp',
821 'wl_title' => 'Old_Title',
824 ->will( $this->returnValue( new FakeResultWrapper( $fakeRows ) ) );
825 $mockDb->expects( $this->at( 1 ) )
826 ->method( 'replace' )
829 [ [ 'wl_user', 'wl_namespace', 'wl_title' ] ],
834 'wl_title' => 'New_Title',
835 'wl_notificationtimestamp' => '20151212010101',
838 $this->isType( 'string' )
840 $mockDb->expects( $this->at( 2 ) )
846 'wl_notificationtimestamp',
850 'wl_title' => 'Old_Title',
853 ->will( $this->returnValue( new FakeResultWrapper( $fakeRows ) ) );
854 $mockDb->expects( $this->at( 3 ) )
855 ->method( 'replace' )
858 [ [ 'wl_user', 'wl_namespace', 'wl_title' ] ],
863 'wl_title' => 'New_Title',
864 'wl_notificationtimestamp' => '20151212010101',
867 $this->isType( 'string' )
870 $mockCache = $this->getMockCache();
871 $mockCache->expects( $this->never() )->method( 'get' );
872 $mockCache->expects( $this->never() )->method( 'delete' );
874 $store = new WatchedItemStore(
875 $this->getMockLoadBalancer( $mockDb ),
879 $store->duplicateAllAssociatedEntries(
880 Title
::newFromText( 'Old_Title' ),
881 Title
::newFromText( 'New_Title' )
885 public function testAddWatch_nonAnonymousUser() {
886 $mockDb = $this->getMockDb();
887 $mockDb->expects( $this->once() )
895 'wl_title' => 'Some_Page',
896 'wl_notificationtimestamp' => null,
901 $mockCache = $this->getMockCache();
902 $mockCache->expects( $this->once() )
904 ->with( '0:Some_Page:1' );
906 $store = new WatchedItemStore(
907 $this->getMockLoadBalancer( $mockDb ),
912 $this->getMockNonAnonUserWithId( 1 ),
913 Title
::newFromText( 'Some_Page' )
917 public function testAddWatch_anonymousUser() {
918 $mockDb = $this->getMockDb();
919 $mockDb->expects( $this->never() )
920 ->method( 'insert' );
922 $mockCache = $this->getMockCache();
923 $mockCache->expects( $this->never() )
924 ->method( 'delete' );
926 $store = new WatchedItemStore(
927 $this->getMockLoadBalancer( $mockDb ),
932 $this->getAnonUser(),
933 Title
::newFromText( 'Some_Page' )
937 public function testAddWatchBatchForUser_nonAnonymousUser() {
938 $mockDb = $this->getMockDb();
939 $mockDb->expects( $this->once() )
947 'wl_title' => 'Some_Page',
948 'wl_notificationtimestamp' => null,
953 'wl_title' => 'Some_Page',
954 'wl_notificationtimestamp' => null,
959 $mockCache = $this->getMockCache();
960 $mockCache->expects( $this->exactly( 2 ) )
961 ->method( 'delete' );
962 $mockCache->expects( $this->at( 1 ) )
964 ->with( '0:Some_Page:1' );
965 $mockCache->expects( $this->at( 3 ) )
967 ->with( '1:Some_Page:1' );
969 $store = new WatchedItemStore(
970 $this->getMockLoadBalancer( $mockDb ),
974 $mockUser = $this->getMockNonAnonUserWithId( 1 );
977 $store->addWatchBatchForUser(
979 [ new TitleValue( 0, 'Some_Page' ), new TitleValue( 1, 'Some_Page' ) ]
984 public function testAddWatchBatchForUser_anonymousUsersAreSkipped() {
985 $mockDb = $this->getMockDb();
986 $mockDb->expects( $this->never() )
987 ->method( 'insert' );
989 $mockCache = $this->getMockCache();
990 $mockCache->expects( $this->never() )
991 ->method( 'delete' );
993 $store = new WatchedItemStore(
994 $this->getMockLoadBalancer( $mockDb ),
999 $store->addWatchBatchForUser(
1000 $this->getAnonUser(),
1001 [ new TitleValue( 0, 'Other_Page' ) ]
1006 public function testAddWatchBatchReturnsTrue_whenGivenEmptyList() {
1007 $user = $this->getMockNonAnonUserWithId( 1 );
1008 $mockDb = $this->getMockDb();
1009 $mockDb->expects( $this->never() )
1010 ->method( 'insert' );
1012 $mockCache = $this->getMockCache();
1013 $mockCache->expects( $this->never() )
1014 ->method( 'delete' );
1016 $store = new WatchedItemStore(
1017 $this->getMockLoadBalancer( $mockDb ),
1022 $store->addWatchBatchForUser( $user, [] )
1026 public function testLoadWatchedItem_existingItem() {
1027 $mockDb = $this->getMockDb();
1028 $mockDb->expects( $this->once() )
1029 ->method( 'selectRow' )
1032 'wl_notificationtimestamp',
1035 'wl_namespace' => 0,
1036 'wl_title' => 'SomeDbKey',
1039 ->will( $this->returnValue(
1040 $this->getFakeRow( [ 'wl_notificationtimestamp' => '20151212010101' ] )
1043 $mockCache = $this->getMockCache();
1044 $mockCache->expects( $this->once() )
1050 $store = new WatchedItemStore(
1051 $this->getMockLoadBalancer( $mockDb ),
1055 $watchedItem = $store->loadWatchedItem(
1056 $this->getMockNonAnonUserWithId( 1 ),
1057 new TitleValue( 0, 'SomeDbKey' )
1059 $this->assertInstanceOf( 'WatchedItem', $watchedItem );
1060 $this->assertEquals( 1, $watchedItem->getUser()->getId() );
1061 $this->assertEquals( 'SomeDbKey', $watchedItem->getLinkTarget()->getDBkey() );
1062 $this->assertEquals( 0, $watchedItem->getLinkTarget()->getNamespace() );
1065 public function testLoadWatchedItem_noItem() {
1066 $mockDb = $this->getMockDb();
1067 $mockDb->expects( $this->once() )
1068 ->method( 'selectRow' )
1071 'wl_notificationtimestamp',
1074 'wl_namespace' => 0,
1075 'wl_title' => 'SomeDbKey',
1078 ->will( $this->returnValue( [] ) );
1080 $mockCache = $this->getMockCache();
1081 $mockCache->expects( $this->never() )->method( 'get' );
1082 $mockCache->expects( $this->never() )->method( 'delete' );
1084 $store = new WatchedItemStore(
1085 $this->getMockLoadBalancer( $mockDb ),
1090 $store->loadWatchedItem(
1091 $this->getMockNonAnonUserWithId( 1 ),
1092 new TitleValue( 0, 'SomeDbKey' )
1097 public function testLoadWatchedItem_anonymousUser() {
1098 $mockDb = $this->getMockDb();
1099 $mockDb->expects( $this->never() )
1100 ->method( 'selectRow' );
1102 $mockCache = $this->getMockCache();
1103 $mockCache->expects( $this->never() )->method( 'get' );
1104 $mockCache->expects( $this->never() )->method( 'delete' );
1106 $store = new WatchedItemStore(
1107 $this->getMockLoadBalancer( $mockDb ),
1112 $store->loadWatchedItem(
1113 $this->getAnonUser(),
1114 new TitleValue( 0, 'SomeDbKey' )
1119 public function testRemoveWatch_existingItem() {
1120 $mockDb = $this->getMockDb();
1121 $mockDb->expects( $this->once() )
1122 ->method( 'delete' )
1127 'wl_namespace' => 0,
1128 'wl_title' => 'SomeDbKey',
1131 $mockDb->expects( $this->once() )
1132 ->method( 'affectedRows' )
1133 ->will( $this->returnValue( 1 ) );
1135 $mockCache = $this->getMockCache();
1136 $mockCache->expects( $this->never() )->method( 'get' );
1137 $mockCache->expects( $this->once() )
1138 ->method( 'delete' )
1139 ->with( '0:SomeDbKey:1' );
1141 $store = new WatchedItemStore(
1142 $this->getMockLoadBalancer( $mockDb ),
1147 $store->removeWatch(
1148 $this->getMockNonAnonUserWithId( 1 ),
1149 new TitleValue( 0, 'SomeDbKey' )
1154 public function testRemoveWatch_noItem() {
1155 $mockDb = $this->getMockDb();
1156 $mockDb->expects( $this->once() )
1157 ->method( 'delete' )
1162 'wl_namespace' => 0,
1163 'wl_title' => 'SomeDbKey',
1166 $mockDb->expects( $this->once() )
1167 ->method( 'affectedRows' )
1168 ->will( $this->returnValue( 0 ) );
1170 $mockCache = $this->getMockCache();
1171 $mockCache->expects( $this->never() )->method( 'get' );
1172 $mockCache->expects( $this->once() )
1173 ->method( 'delete' )
1174 ->with( '0:SomeDbKey:1' );
1176 $store = new WatchedItemStore(
1177 $this->getMockLoadBalancer( $mockDb ),
1182 $store->removeWatch(
1183 $this->getMockNonAnonUserWithId( 1 ),
1184 new TitleValue( 0, 'SomeDbKey' )
1189 public function testRemoveWatch_anonymousUser() {
1190 $mockDb = $this->getMockDb();
1191 $mockDb->expects( $this->never() )
1192 ->method( 'delete' );
1194 $mockCache = $this->getMockCache();
1195 $mockCache->expects( $this->never() )->method( 'get' );
1196 $mockCache->expects( $this->never() )
1197 ->method( 'delete' );
1199 $store = new WatchedItemStore(
1200 $this->getMockLoadBalancer( $mockDb ),
1205 $store->removeWatch(
1206 $this->getAnonUser(),
1207 new TitleValue( 0, 'SomeDbKey' )
1212 public function testGetWatchedItem_existingItem() {
1213 $mockDb = $this->getMockDb();
1214 $mockDb->expects( $this->once() )
1215 ->method( 'selectRow' )
1218 'wl_notificationtimestamp',
1221 'wl_namespace' => 0,
1222 'wl_title' => 'SomeDbKey',
1225 ->will( $this->returnValue(
1226 $this->getFakeRow( [ 'wl_notificationtimestamp' => '20151212010101' ] )
1229 $mockCache = $this->getMockCache();
1230 $mockCache->expects( $this->never() )->method( 'delete' );
1231 $mockCache->expects( $this->once() )
1236 ->will( $this->returnValue( null ) );
1237 $mockCache->expects( $this->once() )
1243 $store = new WatchedItemStore(
1244 $this->getMockLoadBalancer( $mockDb ),
1248 $watchedItem = $store->getWatchedItem(
1249 $this->getMockNonAnonUserWithId( 1 ),
1250 new TitleValue( 0, 'SomeDbKey' )
1252 $this->assertInstanceOf( 'WatchedItem', $watchedItem );
1253 $this->assertEquals( 1, $watchedItem->getUser()->getId() );
1254 $this->assertEquals( 'SomeDbKey', $watchedItem->getLinkTarget()->getDBkey() );
1255 $this->assertEquals( 0, $watchedItem->getLinkTarget()->getNamespace() );
1258 public function testGetWatchedItem_cachedItem() {
1259 $mockDb = $this->getMockDb();
1260 $mockDb->expects( $this->never() )
1261 ->method( 'selectRow' );
1263 $mockUser = $this->getMockNonAnonUserWithId( 1 );
1264 $linkTarget = new TitleValue( 0, 'SomeDbKey' );
1265 $cachedItem = new WatchedItem( $mockUser, $linkTarget, '20151212010101' );
1267 $mockCache = $this->getMockCache();
1268 $mockCache->expects( $this->never() )->method( 'delete' );
1269 $mockCache->expects( $this->never() )->method( 'set' );
1270 $mockCache->expects( $this->once() )
1275 ->will( $this->returnValue( $cachedItem ) );
1277 $store = new WatchedItemStore(
1278 $this->getMockLoadBalancer( $mockDb ),
1282 $this->assertEquals(
1284 $store->getWatchedItem(
1291 public function testGetWatchedItem_noItem() {
1292 $mockDb = $this->getMockDb();
1293 $mockDb->expects( $this->once() )
1294 ->method( 'selectRow' )
1297 'wl_notificationtimestamp',
1300 'wl_namespace' => 0,
1301 'wl_title' => 'SomeDbKey',
1304 ->will( $this->returnValue( [] ) );
1306 $mockCache = $this->getMockCache();
1307 $mockCache->expects( $this->never() )->method( 'set' );
1308 $mockCache->expects( $this->never() )->method( 'delete' );
1309 $mockCache->expects( $this->once() )
1311 ->with( '0:SomeDbKey:1' )
1312 ->will( $this->returnValue( false ) );
1314 $store = new WatchedItemStore(
1315 $this->getMockLoadBalancer( $mockDb ),
1320 $store->getWatchedItem(
1321 $this->getMockNonAnonUserWithId( 1 ),
1322 new TitleValue( 0, 'SomeDbKey' )
1327 public function testGetWatchedItem_anonymousUser() {
1328 $mockDb = $this->getMockDb();
1329 $mockDb->expects( $this->never() )
1330 ->method( 'selectRow' );
1332 $mockCache = $this->getMockCache();
1333 $mockCache->expects( $this->never() )->method( 'set' );
1334 $mockCache->expects( $this->never() )->method( 'get' );
1335 $mockCache->expects( $this->never() )->method( 'delete' );
1337 $store = new WatchedItemStore(
1338 $this->getMockLoadBalancer( $mockDb ),
1343 $store->getWatchedItem(
1344 $this->getAnonUser(),
1345 new TitleValue( 0, 'SomeDbKey' )
1350 public function testGetWatchedItemsForUser() {
1351 $mockDb = $this->getMockDb();
1352 $mockDb->expects( $this->once() )
1353 ->method( 'select' )
1356 [ 'wl_namespace', 'wl_title', 'wl_notificationtimestamp' ],
1359 ->will( $this->returnValue( [
1360 $this->getFakeRow( [
1361 'wl_namespace' => 0,
1362 'wl_title' => 'Foo1',
1363 'wl_notificationtimestamp' => '20151212010101',
1365 $this->getFakeRow( [
1366 'wl_namespace' => 1,
1367 'wl_title' => 'Foo2',
1368 'wl_notificationtimestamp' => null,
1372 $mockCache = $this->getMockCache();
1373 $mockCache->expects( $this->never() )->method( 'delete' );
1374 $mockCache->expects( $this->never() )->method( 'get' );
1375 $mockCache->expects( $this->never() )->method( 'set' );
1377 $store = new WatchedItemStore(
1378 $this->getMockLoadBalancer( $mockDb ),
1381 $user = $this->getMockNonAnonUserWithId( 1 );
1383 $watchedItems = $store->getWatchedItemsForUser( $user );
1385 $this->assertInternalType( 'array', $watchedItems );
1386 $this->assertCount( 2, $watchedItems );
1387 foreach ( $watchedItems as $watchedItem ) {
1388 $this->assertInstanceOf( 'WatchedItem', $watchedItem );
1390 $this->assertEquals(
1391 new WatchedItem( $user, new TitleValue( 0, 'Foo1' ), '20151212010101' ),
1394 $this->assertEquals(
1395 new WatchedItem( $user, new TitleValue( 1, 'Foo2' ), null ),
1400 public function provideDbTypes() {
1402 [ false, DB_SLAVE
],
1403 [ true, DB_MASTER
],
1408 * @dataProvider provideDbTypes
1410 public function testGetWatchedItemsForUser_optionsAndEmptyResult( $forWrite, $dbType ) {
1411 $mockDb = $this->getMockDb();
1412 $mockCache = $this->getMockCache();
1413 $mockLoadBalancer = $this->getMockLoadBalancer( $mockDb, $dbType );
1414 $user = $this->getMockNonAnonUserWithId( 1 );
1416 $mockDb->expects( $this->once() )
1417 ->method( 'select' )
1420 [ 'wl_namespace', 'wl_title', 'wl_notificationtimestamp' ],
1422 $this->isType( 'string' ),
1423 [ 'ORDER BY' => [ 'wl_namespace ASC', 'wl_title ASC' ] ]
1425 ->will( $this->returnValue( [] ) );
1427 $store = new WatchedItemStore(
1432 $watchedItems = $store->getWatchedItemsForUser(
1434 [ 'forWrite' => $forWrite, 'sort' => WatchedItemStore
::SORT_ASC
]
1436 $this->assertEquals( [], $watchedItems );
1439 public function testGetWatchedItemsForUser_badSortOptionThrowsException() {
1440 $store = new WatchedItemStore(
1441 $this->getMockLoadBalancer( $this->getMockDb() ),
1442 $this->getMockCache()
1445 $this->setExpectedException( 'InvalidArgumentException' );
1446 $store->getWatchedItemsForUser(
1447 $this->getMockNonAnonUserWithId( 1 ),
1452 public function testIsWatchedItem_existingItem() {
1453 $mockDb = $this->getMockDb();
1454 $mockDb->expects( $this->once() )
1455 ->method( 'selectRow' )
1458 'wl_notificationtimestamp',
1461 'wl_namespace' => 0,
1462 'wl_title' => 'SomeDbKey',
1465 ->will( $this->returnValue(
1466 $this->getFakeRow( [ 'wl_notificationtimestamp' => '20151212010101' ] )
1469 $mockCache = $this->getMockCache();
1470 $mockCache->expects( $this->never() )->method( 'delete' );
1471 $mockCache->expects( $this->once() )
1473 ->with( '0:SomeDbKey:1' )
1474 ->will( $this->returnValue( false ) );
1475 $mockCache->expects( $this->once() )
1481 $store = new WatchedItemStore(
1482 $this->getMockLoadBalancer( $mockDb ),
1488 $this->getMockNonAnonUserWithId( 1 ),
1489 new TitleValue( 0, 'SomeDbKey' )
1494 public function testIsWatchedItem_noItem() {
1495 $mockDb = $this->getMockDb();
1496 $mockDb->expects( $this->once() )
1497 ->method( 'selectRow' )
1500 'wl_notificationtimestamp',
1503 'wl_namespace' => 0,
1504 'wl_title' => 'SomeDbKey',
1507 ->will( $this->returnValue( [] ) );
1509 $mockCache = $this->getMockCache();
1510 $mockCache->expects( $this->never() )->method( 'set' );
1511 $mockCache->expects( $this->never() )->method( 'delete' );
1512 $mockCache->expects( $this->once() )
1514 ->with( '0:SomeDbKey:1' )
1515 ->will( $this->returnValue( false ) );
1517 $store = new WatchedItemStore(
1518 $this->getMockLoadBalancer( $mockDb ),
1524 $this->getMockNonAnonUserWithId( 1 ),
1525 new TitleValue( 0, 'SomeDbKey' )
1530 public function testIsWatchedItem_anonymousUser() {
1531 $mockDb = $this->getMockDb();
1532 $mockDb->expects( $this->never() )
1533 ->method( 'selectRow' );
1535 $mockCache = $this->getMockCache();
1536 $mockCache->expects( $this->never() )->method( 'set' );
1537 $mockCache->expects( $this->never() )->method( 'get' );
1538 $mockCache->expects( $this->never() )->method( 'delete' );
1540 $store = new WatchedItemStore(
1541 $this->getMockLoadBalancer( $mockDb ),
1547 $this->getAnonUser(),
1548 new TitleValue( 0, 'SomeDbKey' )
1553 public function testGetNotificationTimestampsBatch() {
1555 new TitleValue( 0, 'SomeDbKey' ),
1556 new TitleValue( 1, 'AnotherDbKey' ),
1559 $mockDb = $this->getMockDb();
1561 $this->getFakeRow( [
1562 'wl_namespace' => 0,
1563 'wl_title' => 'SomeDbKey',
1564 'wl_notificationtimestamp' => '20151212010101',
1568 'wl_namespace' => 1,
1569 'wl_title' => 'AnotherDbKey',
1570 'wl_notificationtimestamp' => null,
1575 $mockDb->expects( $this->once() )
1576 ->method( 'makeWhereFrom2d' )
1578 [ [ 'SomeDbKey' => 1 ], [ 'AnotherDbKey' => 1 ] ],
1579 $this->isType( 'string' ),
1580 $this->isType( 'string' )
1582 ->will( $this->returnValue( 'makeWhereFrom2d return value' ) );
1583 $mockDb->expects( $this->once() )
1584 ->method( 'select' )
1587 [ 'wl_namespace', 'wl_title', 'wl_notificationtimestamp' ],
1589 'makeWhereFrom2d return value',
1592 $this->isType( 'string' )
1594 ->will( $this->returnValue( $dbResult ) );
1596 $mockCache = $this->getMockCache();
1597 $mockCache->expects( $this->exactly( 2 ) )
1600 [ '0:SomeDbKey:1' ],
1601 [ '1:AnotherDbKey:1' ]
1603 ->will( $this->returnValue( null ) );
1604 $mockCache->expects( $this->never() )->method( 'set' );
1605 $mockCache->expects( $this->never() )->method( 'delete' );
1607 $store = new WatchedItemStore(
1608 $this->getMockLoadBalancer( $mockDb ),
1612 $this->assertEquals(
1614 0 => [ 'SomeDbKey' => '20151212010101', ],
1615 1 => [ 'AnotherDbKey' => null, ],
1617 $store->getNotificationTimestampsBatch( $this->getMockNonAnonUserWithId( 1 ), $targets )
1621 public function testGetNotificationTimestampsBatch_notWatchedTarget() {
1623 new TitleValue( 0, 'OtherDbKey' ),
1626 $mockDb = $this->getMockDb();
1628 $mockDb->expects( $this->once() )
1629 ->method( 'makeWhereFrom2d' )
1631 [ [ 'OtherDbKey' => 1 ] ],
1632 $this->isType( 'string' ),
1633 $this->isType( 'string' )
1635 ->will( $this->returnValue( 'makeWhereFrom2d return value' ) );
1636 $mockDb->expects( $this->once() )
1637 ->method( 'select' )
1640 [ 'wl_namespace', 'wl_title', 'wl_notificationtimestamp' ],
1642 'makeWhereFrom2d return value',
1645 $this->isType( 'string' )
1647 ->will( $this->returnValue( $this->getFakeRow( [] ) ) );
1649 $mockCache = $this->getMockCache();
1650 $mockCache->expects( $this->once() )
1652 ->with( '0:OtherDbKey:1' )
1653 ->will( $this->returnValue( null ) );
1654 $mockCache->expects( $this->never() )->method( 'set' );
1655 $mockCache->expects( $this->never() )->method( 'delete' );
1657 $store = new WatchedItemStore(
1658 $this->getMockLoadBalancer( $mockDb ),
1662 $this->assertEquals(
1664 0 => [ 'OtherDbKey' => false, ],
1666 $store->getNotificationTimestampsBatch( $this->getMockNonAnonUserWithId( 1 ), $targets )
1670 public function testGetNotificationTimestampsBatch_cachedItem() {
1672 new TitleValue( 0, 'SomeDbKey' ),
1673 new TitleValue( 1, 'AnotherDbKey' ),
1676 $user = $this->getMockNonAnonUserWithId( 1 );
1677 $cachedItem = new WatchedItem( $user, $targets[0], '20151212010101' );
1679 $mockDb = $this->getMockDb();
1681 $mockDb->expects( $this->once() )
1682 ->method( 'makeWhereFrom2d' )
1684 [ 1 => [ 'AnotherDbKey' => 1 ] ],
1685 $this->isType( 'string' ),
1686 $this->isType( 'string' )
1688 ->will( $this->returnValue( 'makeWhereFrom2d return value' ) );
1689 $mockDb->expects( $this->once() )
1690 ->method( 'select' )
1693 [ 'wl_namespace', 'wl_title', 'wl_notificationtimestamp' ],
1695 'makeWhereFrom2d return value',
1698 $this->isType( 'string' )
1700 ->will( $this->returnValue( [
1702 [ 'wl_namespace' => 1, 'wl_title' => 'AnotherDbKey', 'wl_notificationtimestamp' => null, ]
1706 $mockCache = $this->getMockCache();
1707 $mockCache->expects( $this->at( 1 ) )
1709 ->with( '0:SomeDbKey:1' )
1710 ->will( $this->returnValue( $cachedItem ) );
1711 $mockCache->expects( $this->at( 3 ) )
1713 ->with( '1:AnotherDbKey:1' )
1714 ->will( $this->returnValue( null ) );
1715 $mockCache->expects( $this->never() )->method( 'set' );
1716 $mockCache->expects( $this->never() )->method( 'delete' );
1718 $store = new WatchedItemStore(
1719 $this->getMockLoadBalancer( $mockDb ),
1723 $this->assertEquals(
1725 0 => [ 'SomeDbKey' => '20151212010101', ],
1726 1 => [ 'AnotherDbKey' => null, ],
1728 $store->getNotificationTimestampsBatch( $user, $targets )
1732 public function testGetNotificationTimestampsBatch_allItemsCached() {
1734 new TitleValue( 0, 'SomeDbKey' ),
1735 new TitleValue( 1, 'AnotherDbKey' ),
1738 $user = $this->getMockNonAnonUserWithId( 1 );
1740 new WatchedItem( $user, $targets[0], '20151212010101' ),
1741 new WatchedItem( $user, $targets[1], null ),
1743 $mockDb = $this->getMockDb();
1744 $mockDb->expects( $this->never() )->method( $this->anything() );
1746 $mockCache = $this->getMockCache();
1747 $mockCache->expects( $this->at( 1 ) )
1749 ->with( '0:SomeDbKey:1' )
1750 ->will( $this->returnValue( $cachedItems[0] ) );
1751 $mockCache->expects( $this->at( 3 ) )
1753 ->with( '1:AnotherDbKey:1' )
1754 ->will( $this->returnValue( $cachedItems[1] ) );
1755 $mockCache->expects( $this->never() )->method( 'set' );
1756 $mockCache->expects( $this->never() )->method( 'delete' );
1758 $store = new WatchedItemStore(
1759 $this->getMockLoadBalancer( $mockDb ),
1763 $this->assertEquals(
1765 0 => [ 'SomeDbKey' => '20151212010101', ],
1766 1 => [ 'AnotherDbKey' => null, ],
1768 $store->getNotificationTimestampsBatch( $user, $targets )
1772 public function testGetNotificationTimestampsBatch_anonymousUser() {
1774 new TitleValue( 0, 'SomeDbKey' ),
1775 new TitleValue( 1, 'AnotherDbKey' ),
1778 $mockDb = $this->getMockDb();
1779 $mockDb->expects( $this->never() )->method( $this->anything() );
1781 $mockCache = $this->getMockCache();
1782 $mockCache->expects( $this->never() )->method( $this->anything() );
1784 $store = new WatchedItemStore(
1785 $this->getMockLoadBalancer( $mockDb ),
1789 $this->assertEquals(
1791 0 => [ 'SomeDbKey' => false, ],
1792 1 => [ 'AnotherDbKey' => false, ],
1794 $store->getNotificationTimestampsBatch( $this->getAnonUser(), $targets )
1798 public function testResetNotificationTimestamp_anonymousUser() {
1799 $mockDb = $this->getMockDb();
1800 $mockDb->expects( $this->never() )
1801 ->method( 'selectRow' );
1803 $mockCache = $this->getMockCache();
1804 $mockCache->expects( $this->never() )->method( 'get' );
1805 $mockCache->expects( $this->never() )->method( 'set' );
1806 $mockCache->expects( $this->never() )->method( 'delete' );
1808 $store = new WatchedItemStore(
1809 $this->getMockLoadBalancer( $mockDb ),
1814 $store->resetNotificationTimestamp(
1815 $this->getAnonUser(),
1816 Title
::newFromText( 'SomeDbKey' )
1821 public function testResetNotificationTimestamp_noItem() {
1822 $mockDb = $this->getMockDb();
1823 $mockDb->expects( $this->once() )
1824 ->method( 'selectRow' )
1827 'wl_notificationtimestamp',
1830 'wl_namespace' => 0,
1831 'wl_title' => 'SomeDbKey',
1834 ->will( $this->returnValue( [] ) );
1836 $mockCache = $this->getMockCache();
1837 $mockCache->expects( $this->never() )->method( 'get' );
1838 $mockCache->expects( $this->never() )->method( 'set' );
1839 $mockCache->expects( $this->never() )->method( 'delete' );
1841 $store = new WatchedItemStore(
1842 $this->getMockLoadBalancer( $mockDb ),
1847 $store->resetNotificationTimestamp(
1848 $this->getMockNonAnonUserWithId( 1 ),
1849 Title
::newFromText( 'SomeDbKey' )
1854 public function testResetNotificationTimestamp_item() {
1855 $user = $this->getMockNonAnonUserWithId( 1 );
1856 $title = Title
::newFromText( 'SomeDbKey' );
1858 $mockDb = $this->getMockDb();
1859 $mockDb->expects( $this->once() )
1860 ->method( 'selectRow' )
1863 'wl_notificationtimestamp',
1866 'wl_namespace' => 0,
1867 'wl_title' => 'SomeDbKey',
1870 ->will( $this->returnValue(
1871 $this->getFakeRow( [ 'wl_notificationtimestamp' => '20151212010101' ] )
1874 $mockCache = $this->getMockCache();
1875 $mockCache->expects( $this->never() )->method( 'get' );
1876 $mockCache->expects( $this->once() )
1880 $this->isInstanceOf( WatchedItem
::class )
1882 $mockCache->expects( $this->once() )
1883 ->method( 'delete' )
1884 ->with( '0:SomeDbKey:1' );
1886 $store = new WatchedItemStore(
1887 $this->getMockLoadBalancer( $mockDb ),
1891 // Note: This does not actually assert the job is correct
1892 $callableCallCounter = 0;
1893 $mockCallback = function( $callable ) use ( &$callableCallCounter ) {
1894 $callableCallCounter++
;
1895 $this->assertInternalType( 'callable', $callable );
1897 $scopedOverride = $store->overrideDeferredUpdatesAddCallableUpdateCallback( $mockCallback );
1900 $store->resetNotificationTimestamp(
1905 $this->assertEquals( 1, $callableCallCounter );
1907 ScopedCallback
::consume( $scopedOverride );
1910 public function testResetNotificationTimestamp_noItemForced() {
1911 $user = $this->getMockNonAnonUserWithId( 1 );
1912 $title = Title
::newFromText( 'SomeDbKey' );
1914 $mockDb = $this->getMockDb();
1915 $mockDb->expects( $this->never() )
1916 ->method( 'selectRow' );
1918 $mockCache = $this->getMockCache();
1919 $mockDb->expects( $this->never() )
1921 $mockDb->expects( $this->never() )
1923 $mockDb->expects( $this->never() )
1924 ->method( 'delete' );
1926 $store = new WatchedItemStore(
1927 $this->getMockLoadBalancer( $mockDb ),
1931 // Note: This does not actually assert the job is correct
1932 $callableCallCounter = 0;
1933 $mockCallback = function( $callable ) use ( &$callableCallCounter ) {
1934 $callableCallCounter++
;
1935 $this->assertInternalType( 'callable', $callable );
1937 $scopedOverride = $store->overrideDeferredUpdatesAddCallableUpdateCallback( $mockCallback );
1940 $store->resetNotificationTimestamp(
1946 $this->assertEquals( 1, $callableCallCounter );
1948 ScopedCallback
::consume( $scopedOverride );
1955 * @return PHPUnit_Framework_MockObject_MockObject|Title
1957 private function getMockTitle( $text, $ns = 0 ) {
1958 $title = $this->getMock( Title
::class );
1959 $title->expects( $this->any() )
1960 ->method( 'getText' )
1961 ->will( $this->returnValue( str_replace( '_', ' ', $text ) ) );
1962 $title->expects( $this->any() )
1963 ->method( 'getDbKey' )
1964 ->will( $this->returnValue( str_replace( '_', ' ', $text ) ) );
1965 $title->expects( $this->any() )
1966 ->method( 'getNamespace' )
1967 ->will( $this->returnValue( $ns ) );
1971 public function testResetNotificationTimestamp_oldidSpecifiedLatestRevisionForced() {
1972 $user = $this->getMockNonAnonUserWithId( 1 );
1974 $title = $this->getMockTitle( 'SomeTitle' );
1975 $title->expects( $this->once() )
1976 ->method( 'getNextRevisionID' )
1978 ->will( $this->returnValue( false ) );
1980 $mockDb = $this->getMockDb();
1981 $mockDb->expects( $this->never() )
1982 ->method( 'selectRow' );
1984 $mockCache = $this->getMockCache();
1985 $mockDb->expects( $this->never() )
1987 $mockDb->expects( $this->never() )
1989 $mockDb->expects( $this->never() )
1990 ->method( 'delete' );
1992 $store = new WatchedItemStore(
1993 $this->getMockLoadBalancer( $mockDb ),
1997 // Note: This does not actually assert the job is correct
1998 $callableCallCounter = 0;
1999 $scopedOverride = $store->overrideDeferredUpdatesAddCallableUpdateCallback(
2000 function( $callable ) use ( &$callableCallCounter ) {
2001 $callableCallCounter++
;
2002 $this->assertInternalType( 'callable', $callable );
2007 $store->resetNotificationTimestamp(
2014 $this->assertEquals( 1, $callableCallCounter );
2016 ScopedCallback
::consume( $scopedOverride );
2019 public function testResetNotificationTimestamp_oldidSpecifiedNotLatestRevisionForced() {
2020 $user = $this->getMockNonAnonUserWithId( 1 );
2022 $title = $this->getMockTitle( 'SomeDbKey' );
2023 $title->expects( $this->once() )
2024 ->method( 'getNextRevisionID' )
2026 ->will( $this->returnValue( 33 ) );
2028 $mockDb = $this->getMockDb();
2029 $mockDb->expects( $this->once() )
2030 ->method( 'selectRow' )
2033 'wl_notificationtimestamp',
2036 'wl_namespace' => 0,
2037 'wl_title' => 'SomeDbKey',
2040 ->will( $this->returnValue(
2041 $this->getFakeRow( [ 'wl_notificationtimestamp' => '20151212010101' ] )
2044 $mockCache = $this->getMockCache();
2045 $mockDb->expects( $this->never() )
2047 $mockDb->expects( $this->never() )
2049 $mockDb->expects( $this->never() )
2050 ->method( 'delete' );
2052 $store = new WatchedItemStore(
2053 $this->getMockLoadBalancer( $mockDb ),
2057 // Note: This does not actually assert the job is correct
2058 $addUpdateCallCounter = 0;
2059 $scopedOverrideDeferred = $store->overrideDeferredUpdatesAddCallableUpdateCallback(
2060 function( $callable ) use ( &$addUpdateCallCounter ) {
2061 $addUpdateCallCounter++
;
2062 $this->assertInternalType( 'callable', $callable );
2066 $getTimestampCallCounter = 0;
2067 $scopedOverrideRevision = $store->overrideRevisionGetTimestampFromIdCallback(
2068 function( $titleParam, $oldidParam ) use ( &$getTimestampCallCounter, $title, $oldid ) {
2069 $getTimestampCallCounter++
;
2070 $this->assertEquals( $title, $titleParam );
2071 $this->assertEquals( $oldid, $oldidParam );
2076 $store->resetNotificationTimestamp(
2083 $this->assertEquals( 1, $addUpdateCallCounter );
2084 $this->assertEquals( 1, $getTimestampCallCounter );
2086 ScopedCallback
::consume( $scopedOverrideDeferred );
2087 ScopedCallback
::consume( $scopedOverrideRevision );
2090 public function testUpdateNotificationTimestamp_watchersExist() {
2091 $mockDb = $this->getMockDb();
2092 $mockDb->expects( $this->once() )
2093 ->method( 'select' )
2099 'wl_namespace' => 0,
2100 'wl_title' => 'SomeDbKey',
2101 'wl_notificationtimestamp IS NULL'
2105 $this->returnValue( [
2106 $this->getFakeRow( [ 'wl_user' => '2' ] ),
2107 $this->getFakeRow( [ 'wl_user' => '3' ] )
2110 $mockDb->expects( $this->once() )
2111 ->method( 'onTransactionIdle' )
2112 ->with( $this->isType( 'callable' ) )
2113 ->will( $this->returnCallback( function( $callable ) {
2116 $mockDb->expects( $this->once() )
2117 ->method( 'update' )
2120 [ 'wl_notificationtimestamp' => null ],
2122 'wl_user' => [ 2, 3 ],
2123 'wl_namespace' => 0,
2124 'wl_title' => 'SomeDbKey',
2128 $mockCache = $this->getMockCache();
2129 $mockCache->expects( $this->never() )->method( 'set' );
2130 $mockCache->expects( $this->never() )->method( 'get' );
2131 $mockCache->expects( $this->never() )->method( 'delete' );
2133 $store = new WatchedItemStore(
2134 $this->getMockLoadBalancer( $mockDb ),
2138 $this->assertEquals(
2140 $store->updateNotificationTimestamp(
2141 $this->getMockNonAnonUserWithId( 1 ),
2142 new TitleValue( 0, 'SomeDbKey' ),
2148 public function testUpdateNotificationTimestamp_noWatchers() {
2149 $mockDb = $this->getMockDb();
2150 $mockDb->expects( $this->once() )
2151 ->method( 'select' )
2157 'wl_namespace' => 0,
2158 'wl_title' => 'SomeDbKey',
2159 'wl_notificationtimestamp IS NULL'
2163 $this->returnValue( [] )
2165 $mockDb->expects( $this->never() )
2166 ->method( 'onTransactionIdle' );
2167 $mockDb->expects( $this->never() )
2168 ->method( 'update' );
2170 $mockCache = $this->getMockCache();
2171 $mockCache->expects( $this->never() )->method( 'set' );
2172 $mockCache->expects( $this->never() )->method( 'get' );
2173 $mockCache->expects( $this->never() )->method( 'delete' );
2175 $store = new WatchedItemStore(
2176 $this->getMockLoadBalancer( $mockDb ),
2180 $watchers = $store->updateNotificationTimestamp(
2181 $this->getMockNonAnonUserWithId( 1 ),
2182 new TitleValue( 0, 'SomeDbKey' ),
2185 $this->assertInternalType( 'array', $watchers );
2186 $this->assertEmpty( $watchers );
2189 public function testUpdateNotificationTimestamp_clearsCachedItems() {
2190 $user = $this->getMockNonAnonUserWithId( 1 );
2191 $titleValue = new TitleValue( 0, 'SomeDbKey' );
2193 $mockDb = $this->getMockDb();
2194 $mockDb->expects( $this->once() )
2195 ->method( 'selectRow' )
2196 ->will( $this->returnValue(
2197 $this->getFakeRow( [ 'wl_notificationtimestamp' => '20151212010101' ] )
2199 $mockDb->expects( $this->once() )
2200 ->method( 'select' )
2202 $this->returnValue( [
2203 $this->getFakeRow( [ 'wl_user' => '2' ] ),
2204 $this->getFakeRow( [ 'wl_user' => '3' ] )
2207 $mockDb->expects( $this->once() )
2208 ->method( 'onTransactionIdle' )
2209 ->with( $this->isType( 'callable' ) )
2210 ->will( $this->returnCallback( function( $callable ) {
2213 $mockDb->expects( $this->once() )
2214 ->method( 'update' );
2216 $mockCache = $this->getMockCache();
2217 $mockCache->expects( $this->once() )
2219 ->with( '0:SomeDbKey:1', $this->isType( 'object' ) );
2220 $mockCache->expects( $this->once() )
2222 ->with( '0:SomeDbKey:1' );
2223 $mockCache->expects( $this->once() )
2224 ->method( 'delete' )
2225 ->with( '0:SomeDbKey:1' );
2227 $store = new WatchedItemStore(
2228 $this->getMockLoadBalancer( $mockDb ),
2232 // This will add the item to the cache
2233 $store->getWatchedItem( $user, $titleValue );
2235 $store->updateNotificationTimestamp(
2236 $this->getMockNonAnonUserWithId( 1 ),