DatabaseMssqlTest.php

Go to the documentation of this file.

<?php
 
use Wikimedia\Rdbms\DatabaseMssql;
 
class DatabaseMssqlTest extends PHPUnit\Framework\TestCase {
 
    use MediaWikiCoversValidator;
    use PHPUnit4And6Compat;
 
    private function getMockDb() {
        return $this->getMockBuilder( DatabaseMssql::class )
            ->disableOriginalConstructor()
            ->setMethods( null )
            ->getMock();
    }
 
    public function provideBuildSubstring() {
        yield [ 'someField', 1, 2, 'SUBSTRING(someField,1,2)' ];
        yield [ 'someField', 1, null, 'SUBSTRING(someField,1,2147483647)' ];
        yield [ 'someField', 1, 3333333333, 'SUBSTRING(someField,1,3333333333)' ];
    }
 
    public function testBuildSubstring( $input, $start, $length, $expected ) {
        $mockDb = $this->getMockDb();
        $output = $mockDb->buildSubstring( $input, $start, $length );
        $this->assertSame( $expected, $output );
    }
 
    public function provideBuildSubstring_invalidParams() {
        yield [ -1, 1 ];
        yield [ 1, -1 ];
        yield [ 1, 'foo' ];
        yield [ 'foo', 1 ];
        yield [ null, 1 ];
        yield [ 0, 1 ];
    }
 
    public function testBuildSubstring_invalidParams( $start, $length ) {
        $mockDb = $this->getMockDb();
        $this->setExpectedException( InvalidArgumentException::class );
        $mockDb->buildSubstring( 'foo', $start, $length );
    }
 
}