1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78
|
<?php
declare(strict_types=1);
namespace Doctrine\DBAL\Tests\Functional\Driver\PDO\SQLSrv;
use Doctrine\DBAL\Driver as DriverInterface;
use Doctrine\DBAL\Driver\PDO\SQLSrv\Connection;
use Doctrine\DBAL\Driver\PDO\SQLSrv\Driver;
use Doctrine\DBAL\Tests\Functional\Driver\AbstractDriverTestCase;
use Doctrine\DBAL\Tests\TestUtil;
use PDO;
use PHPUnit\Framework\Attributes\RequiresPhpExtension;
use function array_merge;
use function array_replace;
#[RequiresPhpExtension('pdo_sqlsrv')]
class DriverTest extends AbstractDriverTestCase
{
protected function setUp(): void
{
parent::setUp();
if (TestUtil::isDriverOneOf('pdo_sqlsrv')) {
return;
}
self::markTestSkipped('This test requires the pdo_sqlsrv driver.');
}
protected function createDriver(): DriverInterface
{
return new Driver();
}
protected static function getDatabaseNameForConnectionWithoutDatabaseNameParameter(): ?string
{
return 'master';
}
/** @param int[]|string[] $driverOptions */
private function getConnection(array $driverOptions): Connection
{
$params = TestUtil::getConnectionParams();
if (isset($params['driverOptions'])) {
$driverOptions = array_replace($params['driverOptions'], $driverOptions);
}
return (new Driver())->connect(
array_merge(
$params,
['driverOptions' => $driverOptions],
),
);
}
public function testConnectionOptions(): void
{
$connection = $this->getConnection(['APP' => 'APP_NAME']);
$result = $connection->query('SELECT APP_NAME()')->fetchOne();
self::assertSame('APP_NAME', $result);
}
public function testDriverOptions(): void
{
$connection = $this->getConnection([PDO::ATTR_CASE => PDO::CASE_UPPER]);
self::assertSame(
PDO::CASE_UPPER,
$connection
->getNativeConnection()
->getAttribute(PDO::ATTR_CASE),
);
}
}
|