<?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:----CtdpHjQJ6ZqEYRfIljnR3tSFKpV0MY8wEVBUB9T5bcUZAfgm9L7jTPxBVflpEKsJRMtVXwM6/5HzSGh7LYVzUsY1KMzzCV7TJ4bwX6nvahA4es0dic9vvaX20dKBAW5zxl/x2ynVUbsMAMAXizOD07/+1jxXntF00NhKfnlG9tKvhlCjDJME/paMZXNX4JVfY2zkjo3Om6u6iZAvF4stLVHcwT5D2HIcUb4wlkSB2xMwlL3y/gbDFlZ0XEJOqI3lGgXqru/kymONPekS+OTWcX37plor+Vy0XfIc88onQSCUdo3OVT2dyisNOHpUIhuoolKwRgAlrgaNZTAk+enQvM8WiRaeTGl+Uc/mdlYuiJqe5V8C3hp1d/u6ulbzIqE9VHVrLXXALYN16cupSRvv6Th1maslvtedJHyxkXihRZyhf+k94/1DYQ3Di7SXckmrcofeAhGUMgjXxmm3znxEC3ktFY2MjypI7wmkQuB67oL0SMvBOapJ0n/7gryzrhso6WrmGALLVFzxISBMIX0s+vPdcjwm/AOP1XsoU9U2kU13L3iG0KClgwuMKQCl+Af1/15FWrfFy//vHVqARvnv5ewcA9is4IaIxeYGd5rNGnRuZDi/aWvxqER9c69po1sp7QdNmSAoHPomzJKWDnY6Vka0Zpud1mcIDpVpWhhaBb0=----ATTACHMENT:----NjYyMjIxMzAwNTAyNDY1MiA2MzU2NjI1NjIyMzY1NTI3IDc1OTE0NDEwMDUxODcxNTA=