Driver.php 2.75 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
<?php
/*
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
 * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
 * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
 * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
 * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
 * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
 * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
 * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
 * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
 * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
 * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 *
 * This software consists of voluntary contributions made by many individuals
Benjamin Eberlei's avatar
Benjamin Eberlei committed
16
 * and is licensed under the MIT license. For more information, see
17 18 19 20 21 22
 * <http://www.doctrine-project.org>.
 */

namespace Doctrine\DBAL\Driver\SQLSrv;

/**
Benjamin Morel's avatar
Benjamin Morel committed
23
 * Driver for ext/sqlsrv.
24 25 26
 */
class Driver implements \Doctrine\DBAL\Driver
{
Benjamin Morel's avatar
Benjamin Morel committed
27 28 29
    /**
     * {@inheritdoc}
     */
30 31 32 33 34
    public function connect(array $params, $username = null, $password = null, array $driverOptions = array())
    {
        if (!isset($params['host'])) {
            throw new SQLSrvException("Missing 'host' in configuration for sqlsrv driver.");
        }
35 36 37 38
        if (!isset($params['dbname'])) {
            throw new SQLSrvException("Missing 'dbname' in configuration for sqlsrv driver.");
        }

39 40 41 42 43 44 45
        $serverName = $params['host'];
        if (isset($params['port'])) {
            $serverName .= ', ' . $params['port'];
        }
        $driverOptions['Database'] = $params['dbname'];
        $driverOptions['UID'] = $username;
        $driverOptions['PWD'] = $password;
46

47 48 49 50 51 52 53
        if (!isset($driverOptions['ReturnDatesAsStrings'])) {
            $driverOptions['ReturnDatesAsStrings'] = 1;
        }

        return new SQLSrvConnection($serverName, $driverOptions);
    }

Benjamin Morel's avatar
Benjamin Morel committed
54 55 56
    /**
     * {@inheritdoc}
     */
57 58 59 60 61
    public function getDatabasePlatform()
    {
        return new \Doctrine\DBAL\Platforms\SQLServer2008Platform();
    }

Benjamin Morel's avatar
Benjamin Morel committed
62 63 64
    /**
     * {@inheritdoc}
     */
65 66 67 68 69
    public function getSchemaManager(\Doctrine\DBAL\Connection $conn)
    {
        return new \Doctrine\DBAL\Schema\SQLServerSchemaManager($conn);
    }

Benjamin Morel's avatar
Benjamin Morel committed
70 71 72
    /**
     * {@inheritdoc}
     */
73 74 75 76 77
    public function getName()
    {
        return 'sqlsrv';
    }

Benjamin Morel's avatar
Benjamin Morel committed
78 79 80
    /**
     * {@inheritdoc}
     */
81 82 83 84 85
    public function getDatabase(\Doctrine\DBAL\Connection $conn)
    {
        $params = $conn->getParams();
        return $params['dbname'];
    }
86 87 88 89 90 91 92 93

    /**
     * {@inheritdoc}
     */
    public function convertExceptionCode(\Exception $exception)
    {
        return 0;
    }
94
}