Issues in Query.php (master) - Issues in master - smi2/phpClickHouse - Measure and Improve Code Quality continuously with Scrutinizer

Issues (2354)

src/Query/Query.php (96 issues)

Labels

Severity

<?php


namespace ClickHouseDB\Query;

use ClickHouseDB\Exception\QueryException;
use function sizeof;


class Query
{
    /**

     * @var string
     */
    protected $sql;

    /**

     * @var string|null
     */
    protected $format = null;

    /**

     * @var array

     */
    private $degenerations = [];

    private $supportFormats=[

        "FORMAT\\s+TSVRaw",
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
        "FORMAT\\s+TSVWithNamesAndTypes",
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
        "FORMAT\\s+TSVWithNames",
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
        "FORMAT\\s+TSV",
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
        "FORMAT\\s+Vertical",
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
        "FORMAT\\s+JSONCompact",
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
        "FORMAT\\s+JSONEachRow",
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
        "FORMAT\\s+TSKV",
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
        "FORMAT\\s+TabSeparatedWithNames",
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
        "FORMAT\\s+TabSeparatedWithNamesAndTypes",
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
        "FORMAT\\s+TabSeparatedRaw",
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
        "FORMAT\\s+BlockTabSeparated",
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
        "FORMAT\\s+CSVWithNames",
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
        "FORMAT\\s+CSV",
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
        "FORMAT\\s+JSON",
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
        "FORMAT\\s+TabSeparated"
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
    ];

    /**
     * Query constructor.

     * @param string $sql

     * @param array $degenerations

     */
    public function __construct($sql, $degenerations = [])

    {
        if (!trim($sql))

        {
            throw new QueryException('Empty Query');
        }
        $this->sql = $sql;
$a = "a";
$ab = "ab";
$abc = "abc";
        $this->degenerations = $degenerations;
    }

    /**
     * @param string|null $format
     */
    public function setFormat($format)

    {
        $this->format = $format;
    }



    private function applyFormatQuery()

    {
        // FORMAT\s(\w)*$
        if (null === $this->format) {

            return false;
        }
        $supportFormats = implode("|",$this->supportFormats);
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;

        $this->sql = trim($this->sql);

        if (substr($this->sql, -1) == ';') {

            $this->sql = substr($this->sql, 0, -1);

        }

        $matches = [];
        if (preg_match_all('%(' . $supportFormats . ')%ius', $this->sql, $matches)) {


            // skip add "format json"
            if (isset($matches[0]))
            {


                $this->format = trim(str_ireplace('format', '', $matches[0][0]));
                $this->format = trim(/** @scrutinizer ignore-type */ str_ireplace('format', '', $matches[0][0]));


            }
        } else {
            $this->sql = $this->sql . ' FORMAT ' . $this->format;

        }







    }


    /**
     * @return null|string

     */
    public function getFormat()

    {
        return $this->format;
    }

    public function isUseInUrlBindingsParams():bool

    {
        //  'query=select {p1:UInt8} + {p2:UInt8}' -F "param_p1=3" -F "param_p2=4"
        return preg_match('#{[\w+]+:[\w+()]+}#',$this->sql);


    }

    public function getUrlBindingsParams():array

    {
        $out=[];

        if (sizeof($this->degenerations)) {

            foreach ($this->degenerations as $degeneration) {
                if ($degeneration instanceof Degeneration) {
                    $params=$degeneration->getBind();

                    break;
                    // need first response
                }
            }
        }
        if (sizeof($params)) {

            foreach ($params as $key=>$value)

            {
                $out['param_'.$key]=$value;

            }
        }
        return $out;

    }

    public function toSql()

    {
        if ($this->format !== null) {
            $this->applyFormatQuery();
        }

        if (sizeof($this->degenerations))

        {
            foreach ($this->degenerations as $degeneration)
            {
                if ($degeneration instanceof Degeneration) {

                    $this->sql = $degeneration->process($this->sql);
                }
            }
        }

        return $this->sql;
    }

    /**
     * @return string
     */
    public function __toString()

    {
        return $this->toSql();
    }
}

smi2 / phpClickHouse

Issues (2354)

src/Query/Query.php (96 issues)

Labels

Severity

Introduced By

Duplication Side-by-Side

Filter issues like
