123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107 |
- <?php
- namespace Doctrine\DBAL\Driver\PDOSqlsrv;
- use Doctrine\DBAL\Driver\AbstractSQLServerDriver;
- use Doctrine\DBAL\Driver\AbstractSQLServerDriver\Exception\PortWithoutHost;
- use Doctrine\DBAL\Driver\PDO;
- use Doctrine\Deprecations\Deprecation;
- use function is_int;
- use function sprintf;
- /**
- * The PDO-based Sqlsrv driver.
- *
- * @deprecated Use {@link PDO\SQLSrv\Driver} instead.
- */
- class Driver extends AbstractSQLServerDriver
- {
- /**
- * {@inheritdoc}
- */
- public function connect(array $params, $username = null, $password = null, array $driverOptions = [])
- {
- $pdoOptions = $dsnOptions = [];
- foreach ($driverOptions as $option => $value) {
- if (is_int($option)) {
- $pdoOptions[$option] = $value;
- } else {
- $dsnOptions[$option] = $value;
- }
- }
- return new PDO\SQLSrv\Connection(
- $this->_constructPdoDsn($params, $dsnOptions),
- $username,
- $password,
- $pdoOptions
- );
- }
- /**
- * Constructs the Sqlsrv PDO DSN.
- *
- * @param mixed[] $params
- * @param string[] $connectionOptions
- *
- * @return string The DSN.
- */
- private function _constructPdoDsn(array $params, array $connectionOptions)
- {
- $dsn = 'sqlsrv:server=';
- if (isset($params['host'])) {
- $dsn .= $params['host'];
- if (isset($params['port'])) {
- $dsn .= ',' . $params['port'];
- }
- } elseif (isset($params['port'])) {
- throw PortWithoutHost::new();
- }
- if (isset($params['dbname'])) {
- $connectionOptions['Database'] = $params['dbname'];
- }
- if (isset($params['MultipleActiveResultSets'])) {
- $connectionOptions['MultipleActiveResultSets'] = $params['MultipleActiveResultSets'] ? 'true' : 'false';
- }
- return $dsn . $this->getConnectionOptionsDsn($connectionOptions);
- }
- /**
- * Converts a connection options array to the DSN
- *
- * @param string[] $connectionOptions
- */
- private function getConnectionOptionsDsn(array $connectionOptions): string
- {
- $connectionOptionsDsn = '';
- foreach ($connectionOptions as $paramName => $paramValue) {
- $connectionOptionsDsn .= sprintf(';%s=%s', $paramName, $paramValue);
- }
- return $connectionOptionsDsn;
- }
- /**
- * {@inheritdoc}
- *
- * @deprecated
- */
- public function getName()
- {
- Deprecation::trigger(
- 'doctrine/dbal',
- 'https://github.com/doctrine/dbal/issues/3580',
- 'Driver::getName() is deprecated'
- );
- return 'pdo_sqlsrv';
- }
- }
|