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