SQLSrvException.php 1.14 KB
Newer Older
1 2 3 4
<?php

namespace Doctrine\DBAL\Driver\SQLSrv;

5
use Doctrine\DBAL\Driver\AbstractDriverException;
6 7 8
use const SQLSRV_ERR_ERRORS;
use function rtrim;
use function sqlsrv_errors;
9 10

class SQLSrvException extends AbstractDriverException
11 12 13 14
{
    /**
     * Helper method to turn sql server errors into exception.
     *
Benjamin Morel's avatar
Benjamin Morel committed
15
     * @return \Doctrine\DBAL\Driver\SQLSrv\SQLSrvException
16
     */
17
    public static function fromSqlSrvErrors()
18
    {
19 20 21
        $errors    = sqlsrv_errors(SQLSRV_ERR_ERRORS);
        $message   = '';
        $sqlState  = null;
22 23
        $errorCode = null;

24
        foreach ($errors as $error) {
25
            $message .= 'SQLSTATE [' . $error['SQLSTATE'] . ', ' . $error['code'] . ']: ' . $error['message'] . "\n";
26

27
            if ($sqlState === null) {
28 29 30
                $sqlState = $error['SQLSTATE'];
            }

31 32
            if ($errorCode !== null) {
                continue;
33
            }
34 35

            $errorCode = $error['code'];
36
        }
37 38
        if (! $message) {
            $message = 'SQL Server error occurred but no error message was retrieved from driver.';
39 40
        }

41
        return new self(rtrim($message), $sqlState, $errorCode);
42 43
    }
}