Mnabialek\LaravelSqlLogger\Objects\SqlQuery

Complexity

Total Complexity

10

Size/Duplication

Total Lines	109
Duplicated Lines	6.42 %

Coupling/Cohesion

Components	1
Dependencies	0

Importance

Changes

0

7 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	7	1
A	number()	0	4	1
A	raw()	0	4	1
A	bindings()	0	4	1
A	time()	0	4	1
A	get()	0	5	1
A	formatBindings()	7	12	4

<?php

namespace Mnabialek\LaravelSqlLogger\Objects;

use DateTime;

class SqlQuery
{
    /**
     * @var int
     */
    private $number;

    /**
     * @var string
     */
    private $sql;

    /**
     * @var array
     */
    private $bindings;

    /**
     * @var int
     */
    private $time;

    /**
     * SqlQuery constructor.
     *
     * @param int $number
     * @param string $sql
     * @param array $bindings
     * @param int $time
     */
    public function __construct($number, $sql, array $bindings, $time)
    {
        $this->sql = $sql;
        $this->bindings = $bindings;
        $this->time = $time;
        $this->number = $number;
    }

    /**
     * Get number of query.
     * 
     * @return int
     */
    public function number()
    {
        return $this->number;
    }

    /**
     * Get raw SQL (without bindings).
     * 
     * @return string
     */
    public function raw()
    {
        return $this->sql;
    }

    /**
     * Get bindings.
     * 
     * @return array
     */
    public function bindings()
    {
        return $this->bindings;
    }

    /**
     * Get time.
     * 
     * @return int
     */
    public function time()
    {
        return $this->time;
    }

    /**
     * Get full query with values from bindings inserted.
     *
     * @return string
     */
    public function get()
    {
        return vsprintf(str_replace(['%', '?', "\n"], ['%%', "'%s'", ' '], $this->sql),
            $this->formatBindings($this->bindings));
    }

    /**
     * Format bindings values.
     * 
     * @param array $bindings
     *
     * @return array
     */
    protected function formatBindings($bindings)
    {
        foreach ($bindings as $key => $binding) {

This code seems to be duplicated across your project.

            if ($binding instanceof DateTime) {
                $bindings[$key] = $binding->format('Y-m-d H:i:s');
            } elseif (is_string($binding)) {
                $bindings[$key] = str_replace("'", "\\'", $binding);
            }
        }

        return $bindings;
    }
}