tests/phpunit/includes/libs/rdbms/database/DatabaseMssqlTest.php

   1 <?php
   2
   3 use Wikimedia\Rdbms\DatabaseMssql;
   4
   5 class DatabaseMssqlTest extends PHPUnit\Framework\TestCase {
   6
   7         use MediaWikiCoversValidator;
   8
   9         /**
  10          * @return PHPUnit_Framework_MockObject_MockObject|DatabaseMssql
  11          */
  12         private function getMockDb() {
  13                 return $this->getMockBuilder( DatabaseMssql::class )
  14                         ->disableOriginalConstructor()
  15                         ->setMethods( null )
  16                         ->getMock();
  17         }
  18
  19         public function provideBuildSubstring() {
  20                 yield [ 'someField', 1, 2, 'SUBSTRING(someField,1,2)' ];
  21                 yield [ 'someField', 1, null, 'SUBSTRING(someField,1,2147483647)' ];
  22                 yield [ 'someField', 1, 3333333333, 'SUBSTRING(someField,1,3333333333)' ];
  23         }
  24
  25         /**
  26          * @covers Wikimedia\Rdbms\DatabaseMssql::buildSubstring
  27          * @dataProvider provideBuildSubstring
  28          */
  29         public function testBuildSubstring( $input, $start, $length, $expected ) {
  30                 $mockDb = $this->getMockDb();
  31                 $output = $mockDb->buildSubstring( $input, $start, $length );
  32                 $this->assertSame( $expected, $output );
  33         }
  34
  35         public function provideBuildSubstring_invalidParams() {
  36                 yield [ -1, 1 ];
  37                 yield [ 1, -1 ];
  38                 yield [ 1, 'foo' ];
  39                 yield [ 'foo', 1 ];
  40                 yield [ null, 1 ];
  41                 yield [ 0, 1 ];
  42         }
  43
  44         /**
  45          * @covers Wikimedia\Rdbms\DatabaseMssql::buildSubstring
  46          * @dataProvider provideBuildSubstring_invalidParams
  47          */
  48         public function testBuildSubstring_invalidParams( $start, $length ) {
  49                 $mockDb = $this->getMockDb();
  50                 $this->setExpectedException( InvalidArgumentException::class );
  51                 $mockDb->buildSubstring( 'foo', $start, $length );
  52         }
  53
  54 }