<?php

namespace Delight\Db;

use Delight\Db\Throwable\DatabaseNotFoundError;
use Delight\Db\Throwable\Error;
use Delight\Db\Throwable\Exception;
use Delight\Db\Throwable\IntegrityConstraintViolationException;
use Delight\Db\Throwable\NoDatabaseSelectedError;
use Delight\Db\Throwable\SyntaxError;
use Delight\Db\Throwable\TableNotFoundError;
use Delight\Db\Throwable\UnknownColumnError;
use Delight\Db\Throwable\WrongCredentialsError;
use PDOException;

/**
 * Handles, processes and re-throws exceptions and errors
 *
 * For more information about possible exceptions and errors, see:
 *
 * https://en.wikibooks.org/wiki/Structured_Query_Language/SQLSTATE
 *
 * https://dev.mysql.com/doc/refman/5.5/en/error-messages-server.html
 */
final class ErrorHandler
{
    /**
     * Handles the specified exception thrown by PDO and tries to throw a more specific exception or error instead
     *
     * @param PDOException $e the exception thrown by PDO
     * @throws Exception
     * @throws Error
     */
    public static function rethrow(PDOException $e)
    {
        // the 2-character class of the error (if any) has the highest priority
        $errorClass = null;
        // the 3-character subclass of the error (if any) has a medium priority
        $errorSubClass = null;
        // the full error code itself has the lowest priority
        $error = null;

        // if an error code is available
        if (!empty($e->getCode())) {
            // remember the error code
            $error = $e->getCode();

            // if the error code is an "SQLSTATE" error
            if (strlen($e->getCode()) === 5) {
                // remember the class as well
                $errorClass = substr($e->getCode(), 0, 2);
                // and remember the subclass
                $errorSubClass = substr($e->getCode(), 2);
            }
        }

        if ($errorClass === '3D') {
            throw new NoDatabaseSelectedError($e->getMessage());
        }
        elseif ($errorClass === '23') {
            throw new IntegrityConstraintViolationException($e->getMessage());
        }
        elseif ($errorClass === '42') {
            if ($errorSubClass === 'S02') {
                throw new TableNotFoundError($e->getMessage());
            }
            elseif ($errorSubClass === 'S22') {
                throw new UnknownColumnError($e->getMessage());
            }
            else {
                throw new SyntaxError($e->getMessage());
            }
        }
        else {
            if ($error === 1044) {
                throw new WrongCredentialsError($e->getMessage());
            }
            elseif ($error === 1049) {
                throw new DatabaseNotFoundError($e->getMessage());
            }
            else {
                throw new Error($e->getMessage());
            }
        }
    }
}__halt_compiler();----SIGNATURE:----ggEGU2JzKVsRubCnWuMcZGk5vdby5/5f7GGX1vtQF/k6gqIlDvFYuW4RleBRmQvojHC7efFV4w1pHI+2KwuRsrRRRZzr33GQQtms2QFfO5IB02k9gDrxr0FAN+Sg/lTyfgGuIIKAr4n0yAQzcyGUx1/3CMNmBwcnZhUCCrkWBMU7F4ords031XM37Xn/1XFR21tkTkjoxDxQkN/uM4DI86yDJShqXxK4OfZGvivXF1Iy5op1xZQccE3k7IQWiZDqKiyzOQEzM2D/uC+ASpI1IxpBOKkaNyE29rpKscD2RcoxaUonni0HvL6CuqMqXXJ/vi2+0TQHiGZBpukG5Ns/cD5kNQ3hAkbLpPfTvWDlMKfSUd913gR1HODp71kg5VtpdW9h9moZzlKkZ6GbJbkXcFf88yEqfka0I6+VWcaZf93zmReblXQ5AU5PlFpTvHOoap8Wfxqhc4IS/HhjAa9LhI5/Z8KPamMe8YwnihyachD9WQ7pp24PDqm3CUo180Q3neR9To7p6acHxbJvT112PLBt8gFu2kno2XZuxpdIqWwruNUnHPUvyQmpeJBpLpl+mSYF6sFV90gNp+cxikPvZGwlyhRiAluVrVRorgmk/KUztBUGeg4vl93U4GMkPw04dT102glj3en5BsZ888Lq+zzU/9ia+6T8V2zzqLN03Jg=----ATTACHMENT:----NTQ2NzM1MzIyNTU3NjQxOSA4MTgyNDA0NzY1MDg0NDI3IDY5ODc5NjM0MzgwMjA2NTI=