Page MenuHomeWickedGov Phorge
Files F5977683

NukeQueryBuilderTest.php
No OneTemporary
Actions

Size
6 KB
Referenced Files
None
Subscribers
None

NukeQueryBuilderTest.php
View Options

<?php
namespace MediaWiki\Extension\Nuke\Test\Unit;
use LogicException;
use MediaWiki\Extension\Nuke\NukeQueryBuilder;
use MediaWiki\Extension\Nuke\Test\NukeIntegrationTest;
use MediaWikiIntegrationTestCase;
/**
* Tests for the {@link NukeQueryBuilder} class.
*
* @group Database
* @covers \MediaWiki\Extension\Nuke\NukeQueryBuilder
*/
class NukeQueryBuilderTest extends MediaWikiIntegrationTestCase {
use NukeIntegrationTest;
private function newQueryBuilder( string $table ) {
$serviceContainer = $this->getServiceContainer();
$dbr = $serviceContainer->getConnectionProvider()->getReplicaDatabase();
$config = $serviceContainer->getMainConfig();
$namespaceInfo = $serviceContainer->getNamespaceInfo();
$contentLanguage = $serviceContainer->getContentLanguage();
return new NukeQueryBuilder( $dbr, $config, $namespaceInfo, $contentLanguage, $table );
}
public function testConstructRevision() {
$this->expectNotToPerformAssertions();
$this->newQueryBuilder( NukeQueryBuilder::TABLE_REVISION );
}
public function testConstructRecentchanges() {
$this->expectNotToPerformAssertions();
$this->newQueryBuilder( NukeQueryBuilder::TABLE_RECENTCHANGES );
}
public function testConstructUnknownTable() {
$this->expectException( LogicException::class );
$this->newQueryBuilder( 'archive' );
}
public function testFilterActor() {
$user1 = $this->getMutableTestUser();
$user2 = $this->getMutableTestUser();
$this->editPage(
'Page1',
'',
'',
NS_MAIN,
$user1->getAuthority()
);
$this->editPage(
'Page2',
'',
'',
NS_MAIN,
$user2->getAuthority()
);
$rows = $this->newQueryBuilder( NukeQueryBuilder::TABLE_REVISION )
->filterActor( $user1->getAuthority() )
->build()
->caller( __METHOD__ )
->fetchResultSet();
$this->assertCount( 1, $rows );
$row = $rows->fetchObject();
$this->assertSame( 'Page1', $row->page_title );
// Calling this with an actor string array should return the same result
$rows = $this->newQueryBuilder( NukeQueryBuilder::TABLE_REVISION )
->filterActor( [ $user1->getAuthority() ] )
->build()
->caller( __METHOD__ )
->fetchResultSet();
$this->assertCount( 1, $rows );
$row = $rows->fetchObject();
$this->assertSame( 'Page1', $row->page_title );
}
public function testFilterToTimestamp() {
$time = time();
$this->editPageAtTime( 'Page1', '', '', $time - 86400 * 2 );
$this->editPage( 'Page2', '' );
$rows = $this->newQueryBuilder( NukeQueryBuilder::TABLE_REVISION )
->filterToTimestamp( time() - 86400 )
->build()
->caller( __METHOD__ )
->fetchResultSet();
$this->assertCount( 1, $rows );
$row = $rows->fetchObject();
$this->assertSame( 'Page1', $row->page_title );
// Rebuild recent changes before doing recentchanges table queries
$this->rebuildRecentChanges();
$rows = $this->newQueryBuilder( NukeQueryBuilder::TABLE_RECENTCHANGES )
->filterToTimestamp( time() - 86400 )
->build()
->caller( __METHOD__ )
->fetchResultSet();
$this->assertCount( 1, $rows );
$row = $rows->fetchObject();
$this->assertSame( 'Page1', $row->page_title );
}
public function testFilterByMinPageSize() {
$user = $this->getMutableTestUser();
// 4 bytes content
$this->editPage( 'SmallPage', 'test', 'test', NS_MAIN, $user->getAuthority() );
// 9 bytes content
$this->editPage( 'MediumPage', 'test test', 'test test', NS_MAIN, $user->getAuthority() );
// 14 bytes content
$this->editPage( 'LargePage', 'test test test', 'test test test', NS_MAIN, $user->getAuthority() );
$rows = $this->newQueryBuilder( NukeQueryBuilder::TABLE_REVISION )
->filterByMinPageSize( 10 )
->build()
->caller( __METHOD__ )
->fetchResultSet();
$this->assertCount( 1, $rows );
$row = $rows->fetchObject();
$this->assertSame( 'LargePage', $row->page_title );
}
public function testFilterByMaxPageSize() {
$user = $this->getMutableTestUser();
// 4 bytes content
$this->editPage( 'SmallPage', 'test', 'test', NS_MAIN, $user->getAuthority() );
// 9 bytes content
$this->editPage( 'MediumPage', 'test test', 'test test', NS_MAIN, $user->getAuthority() );
// 14 bytes content
$this->editPage( 'LargePage', 'test test test', 'test test test', NS_MAIN, $user->getAuthority() );
$rows = $this->newQueryBuilder( NukeQueryBuilder::TABLE_REVISION )
->filterByMaxPageSize( 9 )
->build()
->caller( __METHOD__ )
->fetchResultSet();
$this->assertCount( 2, $rows );
$titles = [];
foreach ( $rows as $row ) {
$titles[] = $row->page_title;
}
$this->assertContains( 'SmallPage', $titles );
$this->assertContains( 'MediumPage', $titles );
$this->assertNotContains( 'LargePage', $titles );
}
public function testFilterByMinMaxPageSize() {
$user = $this->getMutableTestUser();
// 2 bytes content
$this->editPage( 'TinyPage', 'te', 'te', NS_MAIN, $user->getAuthority() );
// 4 bytes content
$this->editPage( 'SmallPage', 'test', 'test', NS_MAIN, $user->getAuthority() );
// 9 bytes content
$this->editPage( 'MediumPage', 'test test', 'test test', NS_MAIN, $user->getAuthority() );
// 14 bytes content
$this->editPage( 'LargePage', 'test test test', 'test test test', NS_MAIN, $user->getAuthority() );
// 19 bytes content
$this->editPage( 'HugePage', 'test test test test', 'test test test test', NS_MAIN, $user->getAuthority() );
$rows = $this->newQueryBuilder( NukeQueryBuilder::TABLE_REVISION )
->filterByMinPageSize( 5 )
->filterByMaxPageSize( 15 )
->build()
->caller( __METHOD__ )
->fetchResultSet();
$this->assertCount( 2, $rows );
$titles = [];
foreach ( $rows as $row ) {
$titles[] = $row->page_title;
}
$this->assertNotContains( 'TinyPage', $titles );
$this->assertNotContains( 'SmallPage', $titles );
$this->assertContains( 'MediumPage', $titles );
$this->assertContains( 'LargePage', $titles );
$this->assertNotContains( 'HugePage', $titles );
}
public function testIgnoresNegativeMinMax() {
$user = $this->getMutableTestUser();
// 4 bytes content
$this->editPage( 'SmallPage', 'test', 'test', NS_MAIN, $user->getAuthority() );
// 9 bytes content
$this->editPage( 'MediumPage', 'test test', 'test test', NS_MAIN, $user->getAuthority() );
// 14 bytes content
$this->editPage( 'LargePage', 'test test test', 'test test test', NS_MAIN, $user->getAuthority() );
$rows = $this->newQueryBuilder( NukeQueryBuilder::TABLE_REVISION )
->filterByMinPageSize( -1 )
->filterByMaxPageSize( -1 )
->build()
->caller( __METHOD__ )
->fetchResultSet();
$this->assertCount( 3, $rows );
}
}

File Metadata

Mime Type
text/x-php
Expires
Sat, Oct 3, 20:02 (4 d, 12 h ago)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
c4/0a/8cbf88e8272e806ad06c90b657e4
Default Alt Text
NukeQueryBuilderTest.php (6 KB)

Event Timeline