<?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:----ylVRHVCaCRgHAfTJqevrBkXb+C93IGNK2kirkSNQNL6i8KKMFu/P5mkgEIYm0rMsqc8zWeKXSEqzmyebp4eOsFgJJdhAh8MqEnHSglQBssg5p2zmUAhN+/J92TwsID3FS0vOCE4fuLqtk4Mf/V7UT9R9Y/qNyeNSVpI5SmJZnMBNNN7cBv/5TjB+cj9fbl5v84YNpwxKF13D0MXtiHYWGlcjFqu8udMEB0e2HTypJW78GL8z7xeyiOwQXh0RH1t4RsaHhtnBV1zrtH7+iZeEeuceQkGfOwwrpjz8yFoPmkN4El8nF2hbqoN6fO0HU7aCuxwlMfBJXM7Ya8Rgtil1OKTIs0mNqBWWkoF0H+UWnRTFta03sdhvHenUUwcaFix0WTfPl8Z7TO2uDmV2aUj9H1QWO5lwH5kVXZ7KV1f6xVNOAe3SowF8yAPyVBpnBvc6gHaQT7gxs5vyJeV8ks7AprslI0iopG96r72ypIH+zH1Hu6PqMbi1Rj6uh8yE/Xg3OrqkwwXda0yGdN74SsrdKtkSHSG6MHP3bKAfFayrCVdHnQGjqhDN+8B01a9YFIJwLwUUdNrYoFdwzJEWt41hV6Hk3zojZLarCCDO8b6bcMLB63Y7bSFSt3EkezBGEgUJmJNNXXwks2qz1WyY31s3XOcUY9AkLhUVUQXcJ+qle7Y=----ATTACHMENT:----ODU2MDM0NTIyNDUxNTkzMSA2NTcxMDkwMjkwNTgxNDAyIDc5MDA4NTE3NzI2OTU1ODM=