mindplay\sql\exceptions\SQLException

Complexity

Total Complexity

5

Size/Duplication

Total Lines	33
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	0

Test Coverage

Coverage

100%

Importance

Changes	1
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	4	1
A	emulatedPrepare()	0	12	4

<?php

namespace mindplay\sql\exceptions;

use Exception;
use RuntimeException;

/**
 * This Exception-type represents an SQL error
 */
class SQLException extends RuntimeException
{
    /**
     * @param string         $sql    SQL statement (with ":name" placeholders)
     * @param array          $params map of parameter name/value pairs (to bind against placeholders in the statement)
     * @param string         $message
     * @param int            $code
     * @param Exception|null $previous
     */
    public function __construct($sql, $params = [], $message = 'SQL Error', $code = 0, Exception $previous = null)
    {
        parent::__construct("{$message}\n" . $this->emulatedPrepare($sql, $params), $code, $previous);
    }
    
    /**
     * @param string $sql
     * @param array  $params
     *
     * @return string SQL with emulated prepare (for diagnostic purposes only)
     */
    private function emulatedPrepare($sql, array $params)
    {
        foreach ($params as $name => $value) {
            $quoted_value = $value === null
                ? "NULL"
                : (is_numeric($value) ? $value : "'{$value}'");

            $sql = str_replace(":{$name}", $quoted_value, $sql);
        }

        return $sql;
    }
}