123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106 |
- <?php
- namespace Doctrine\DBAL\Driver\PDOSqlsrv;
- use Doctrine\DBAL\Driver\AbstractSQLServerDriver;
- use function is_int;
- use function sprintf;
- /**
- * The PDO-based Sqlsrv driver.
- */
- class Driver extends AbstractSQLServerDriver
- {
- /**
- * {@inheritdoc}
- */
- public function connect(array $params, $username = null, $password = null, array $driverOptions = [])
- {
- [$driverOptions, $connectionOptions] = $this->splitOptions($driverOptions);
- return new Connection(
- $this->_constructPdoDsn($params, $connectionOptions),
- $username,
- $password,
- $driverOptions
- );
- }
- /**
- * 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']) && ! empty($params['port'])) {
- $dsn .= ',' . $params['port'];
- }
- if (isset($params['dbname'])) {
- $connectionOptions['Database'] = $params['dbname'];
- }
- if (isset($params['MultipleActiveResultSets'])) {
- $connectionOptions['MultipleActiveResultSets'] = $params['MultipleActiveResultSets'] ? 'true' : 'false';
- }
- return $dsn . $this->getConnectionOptionsDsn($connectionOptions);
- }
- /**
- * Separates a connection options from a driver options
- *
- * @param int[]|string[] $options
- *
- * @return int[][]|string[][]
- */
- private function splitOptions(array $options) : array
- {
- $driverOptions = [];
- $connectionOptions = [];
- foreach ($options as $optionKey => $optionValue) {
- if (is_int($optionKey)) {
- $driverOptions[$optionKey] = $optionValue;
- } else {
- $connectionOptions[$optionKey] = $optionValue;
- }
- }
- return [$driverOptions, $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}
- */
- public function getName()
- {
- return 'pdo_sqlsrv';
- }
- }
|