tests/phpunit/maintenance/DeleteAutoPatrolLogsTest.php

   1 <?php
   2
   3 namespace MediaWiki\Tests\Maintenance;
   4
   5 use DeleteAutoPatrolLogs;
   6
   7 /**
   8  * @group Database
   9  * @covers \DeleteAutoPatrolLogs
  10  */
  11 class DeleteAutoPatrolLogsTest extends MaintenanceBaseTestCase {
  12
  13         public function getMaintenanceClass() {
  14                 return DeleteAutoPatrolLogs::class;
  15         }
  16
  17         protected function setUp(): void {
  18                 parent::setUp();
  19
  20                 $this->insertLoggingData();
  21         }
  22
  23         private function insertLoggingData() {
  24                 $dbw = $this->getDb();
  25                 $logs = [];
  26
  27                 $comment = \MediaWiki\MediaWikiServices::getInstance()->getCommentStore()
  28                         ->createComment( $dbw, '' );
  29
  30                 // Manual patrolling
  31                 $logs[] = [
  32                         'log_type' => 'patrol',
  33                         'log_action' => 'patrol',
  34                         'log_actor' => 7251,
  35                         'log_params' => '',
  36                         'log_timestamp' => $dbw->timestamp( '20041223210426' ),
  37                         'log_namespace' => NS_MAIN,
  38                         'log_title' => 'DeleteAutoPatrolLogs',
  39                         'log_comment_id' => $comment->id,
  40                 ];
  41
  42                 // Autopatrol #1
  43                 $logs[] = [
  44                         'log_type' => 'patrol',
  45                         'log_action' => 'autopatrol',
  46                         'log_actor' => 7252,
  47                         'log_params' => '',
  48                         'log_timestamp' => $dbw->timestamp( '20051223210426' ),
  49                         'log_namespace' => NS_MAIN,
  50                         'log_title' => 'DeleteAutoPatrolLogs',
  51                         'log_comment_id' => $comment->id,
  52                 ];
  53
  54                 // Block
  55                 $logs[] = [
  56                         'log_type' => 'block',
  57                         'log_action' => 'block',
  58                         'log_actor' => 7253,
  59                         'log_params' => '',
  60                         'log_timestamp' => $dbw->timestamp( '20061223210426' ),
  61                         'log_namespace' => NS_MAIN,
  62                         'log_title' => 'DeleteAutoPatrolLogs',
  63                         'log_comment_id' => $comment->id,
  64                 ];
  65
  66                 // Very old/ invalid patrol
  67                 $logs[] = [
  68                         'log_type' => 'patrol',
  69                         'log_action' => 'patrol',
  70                         'log_actor' => 7253,
  71                         'log_params' => 'nanana',
  72                         'log_timestamp' => $dbw->timestamp( '20061223210426' ),
  73                         'log_namespace' => NS_MAIN,
  74                         'log_title' => 'DeleteAutoPatrolLogs',
  75                         'log_comment_id' => $comment->id,
  76                 ];
  77
  78                 // Autopatrol #2
  79                 $logs[] = [
  80                         'log_type' => 'patrol',
  81                         'log_action' => 'autopatrol',
  82                         'log_actor' => 7254,
  83                         'log_params' => '',
  84                         'log_timestamp' => $dbw->timestamp( '20071223210426' ),
  85                         'log_namespace' => NS_MAIN,
  86                         'log_title' => 'DeleteAutoPatrolLogs',
  87                         'log_comment_id' => $comment->id,
  88                 ];
  89
  90                 // Autopatrol #3 old way
  91                 $logs[] = [
  92                         'log_type' => 'patrol',
  93                         'log_action' => 'patrol',
  94                         'log_actor' => 7255,
  95                         'log_params' => serialize( [ '6::auto' => true ] ),
  96                         'log_timestamp' => $dbw->timestamp( '20081223210426' ),
  97                         'log_namespace' => NS_MAIN,
  98                         'log_title' => 'DeleteAutoPatrolLogs',
  99                         'log_comment_id' => $comment->id,
 100                 ];
 101
 102                 // Manual patrol #2 old way
 103                 $logs[] = [
 104                         'log_type' => 'patrol',
 105                         'log_action' => 'patrol',
 106                         'log_actor' => 7256,
 107                         'log_params' => serialize( [ '6::auto' => false ] ),
 108                         'log_timestamp' => $dbw->timestamp( '20091223210426' ),
 109                         'log_namespace' => NS_MAIN,
 110                         'log_title' => 'DeleteAutoPatrolLogs',
 111                         'log_comment_id' => $comment->id,
 112                 ];
 113
 114                 // Autopatrol #4 very old way
 115                 $logs[] = [
 116                         'log_type' => 'patrol',
 117                         'log_action' => 'patrol',
 118                         'log_actor' => 7257,
 119                         'log_params' => "9227851\n0\n1",
 120                         'log_timestamp' => $dbw->timestamp( '20081223210426' ),
 121                         'log_namespace' => NS_MAIN,
 122                         'log_title' => 'DeleteAutoPatrolLogs',
 123                         'log_comment_id' => $comment->id,
 124                 ];
 125
 126                 // Manual patrol #3 very old way
 127                 $logs[] = [
 128                         'log_type' => 'patrol',
 129                         'log_action' => 'patrol',
 130                         'log_actor' => 7258,
 131                         'log_params' => "9227851\n0\n0",
 132                         'log_timestamp' => $dbw->timestamp( '20091223210426' ),
 133                         'log_namespace' => NS_MAIN,
 134                         'log_title' => 'DeleteAutoPatrolLogs',
 135                         'log_comment_id' => $comment->id,
 136                 ];
 137
 138                 $dbw->newInsertQueryBuilder()
 139                         ->insertInto( 'logging' )
 140                         ->rows( $logs )
 141                         ->caller( __METHOD__ )
 142                         ->execute();
 143         }
 144
 145         public static function runProvider() {
 146                 $allRows = [
 147                         (object)[
 148                                 'log_type' => 'patrol',
 149                                 'log_action' => 'patrol',
 150                                 'log_actor' => '7251',
 151                         ],
 152                         (object)[
 153                                 'log_type' => 'patrol',
 154                                 'log_action' => 'autopatrol',
 155                                 'log_actor' => '7252',
 156                         ],
 157                         (object)[
 158                                 'log_type' => 'block',
 159                                 'log_action' => 'block',
 160                                 'log_actor' => '7253',
 161                         ],
 162                         (object)[
 163                                 'log_type' => 'patrol',
 164                                 'log_action' => 'patrol',
 165                                 'log_actor' => '7253',
 166                         ],
 167                         (object)[
 168                                 'log_type' => 'patrol',
 169                                 'log_action' => 'autopatrol',
 170                                 'log_actor' => '7254',
 171                         ],
 172                         (object)[
 173                                 'log_type' => 'patrol',
 174                                 'log_action' => 'patrol',
 175                                 'log_actor' => '7255',
 176                         ],
 177                         (object)[
 178                                 'log_type' => 'patrol',
 179                                 'log_action' => 'patrol',
 180                                 'log_actor' => '7256',
 181                         ],
 182                         (object)[
 183                                 'log_type' => 'patrol',
 184                                 'log_action' => 'patrol',
 185                                 'log_actor' => '7257',
 186                         ],
 187                         (object)[
 188                                 'log_type' => 'patrol',
 189                                 'log_action' => 'patrol',
 190                                 'log_actor' => '7258',
 191                         ],
 192                 ];
 193
 194                 $cases = [
 195                         'dry run' => [
 196                                 $allRows,
 197                                 [ '--sleep', '0', '--dry-run', '-q' ]
 198                         ],
 199                         'basic run' => [
 200                                 [
 201                                         $allRows[0],
 202                                         $allRows[2],
 203                                         $allRows[3],
 204                                         $allRows[5],
 205                                         $allRows[6],
 206                                         $allRows[7],
 207                                         $allRows[8],
 208                                 ],
 209                                 [ '--sleep', '0', '-q' ]
 210                         ],
 211                         'run with before' => [
 212                                 [
 213                                         $allRows[0],
 214                                         $allRows[2],
 215                                         $allRows[3],
 216                                         $allRows[4],
 217                                         $allRows[5],
 218                                         $allRows[6],
 219                                         $allRows[7],
 220                                         $allRows[8],
 221                                 ],
 222                                 [ '--sleep', '0', '--before', '20060123210426', '-q' ]
 223                         ],
 224                         'run with check-old' => [
 225                                 [
 226                                         $allRows[0],
 227                                         $allRows[1],
 228                                         $allRows[2],
 229                                         $allRows[3],
 230                                         $allRows[4],
 231                                         $allRows[6],
 232                                         $allRows[8],
 233                                 ],
 234                                 [ '--sleep', '0', '--check-old', '-q' ]
 235                         ],
 236                 ];
 237
 238                 foreach ( $cases as $key => $case ) {
 239                         yield $key . '-batch-size-1' => [
 240                                 $case[0],
 241                                 array_merge( $case[1], [ '--batch-size', '1' ] )
 242                         ];
 243                         yield $key . '-batch-size-5' => [
 244                                 $case[0],
 245                                 array_merge( $case[1], [ '--batch-size', '5' ] )
 246                         ];
 247                         yield $key . '-batch-size-1000' => [
 248                                 $case[0],
 249                                 array_merge( $case[1], [ '--batch-size', '1000' ] )
 250                         ];
 251                 }
 252         }
 253
 254         /**
 255          * @dataProvider runProvider
 256          */
 257         public function testRun( $expected, $args ) {
 258                 $this->maintenance->loadWithArgv( $args );
 259
 260                 $this->maintenance->execute();
 261
 262                 $remainingLogs = $this->getDb()->newSelectQueryBuilder()
 263                         ->select( [ 'log_type', 'log_action', 'log_actor' ] )
 264                         ->from( 'logging' )
 265                         ->orderBy( 'log_id' )
 266                         ->caller( __METHOD__ )->fetchResultSet();
 267
 268                 $this->assertEquals( $expected, iterator_to_array( $remainingLogs, false ) );
 269         }
 270
 271         public function testFromId() {
 272                 $fromId = $this->getDb()->newSelectQueryBuilder()
 273                         ->select( 'log_id' )
 274                         ->from( 'logging' )
 275                         ->where( [ 'log_params' => 'nanana' ] )
 276                         ->fetchField();
 277
 278                 $this->maintenance->loadWithArgv( [ '--sleep', '0', '--from-id', strval( $fromId ), '-q' ] );
 279
 280                 $this->maintenance->execute();
 281
 282                 $remainingLogs = $this->getDb()->newSelectQueryBuilder()
 283                         ->select( [ 'log_type', 'log_action', 'log_actor' ] )
 284                         ->from( 'logging' )
 285                         ->orderBy( 'log_id' )
 286                         ->caller( __METHOD__ )->fetchResultSet();
 287
 288                 $deleted = [
 289                         'log_type' => 'patrol',
 290                         'log_action' => 'autopatrol',
 291                         'log_actor' => '7254',
 292                 ];
 293                 $notDeleted = [
 294                         'log_type' => 'patrol',
 295                         'log_action' => 'autopatrol',
 296                         'log_actor' => '7252',
 297                 ];
 298
 299                 $remainingLogs = array_map(
 300                         static function ( $val ) {
 301                                 return (array)$val;
 302                         },
 303                         iterator_to_array( $remainingLogs, false )
 304                 );
 305
 306                 $this->assertNotContains( $deleted, $remainingLogs );
 307                 $this->assertContains( $notDeleted, $remainingLogs );
 308         }
 309
 310 }