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

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