Condition::parseValueQuery() - Code Metrics - bytic/database - Measure and Improve Code Quality continuously with Scrutinizer

Condition::parseValueQuery() A
last analyzed 2023-01-30 21:10 UTC

↳ Parent: Condition

Complexity

Conditions	1
Paths	1

Size

Total Lines	3
Code Lines	1

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	1
CRAP Score	1

Importance

Changes	2
Bugs	0	Features	0

Metric	Value
cc	1
eloc	1
c	2
b	0
f	0
nc	1
nop	1
dl	0
loc	3
ccs	1
cts	1
cp	1
crap	1
rs	10

<?php

namespace Nip\Database\Query\Condition;

use Nip\Database\Query\AbstractQuery as Query;

/**
 * Class Condition
 * @package Nip\Database\Query\Condition
 */
class Condition
{
    protected $_string;
    protected $_values;
    protected $_query;

    /**
     * @param string $string
     */
    public function __construct($string, $values = [])
    {
        $this->_string = $string;
        $this->_values = $values;
    }

    /**
     * @return string
     */
    public function __toString()
    {
        return $this->getString();
    }

    /**
     * @return string
     */
    public function getString()
    {
        return $this->parseString($this->_string, $this->_values);
    }

    /**
     * Parses $string and replaces all instances of "?" with corresponding $values.
     *
     * @param string $string
     * @param array  $values
     *
     * @return string
     */
    public function parseString($string, $values)
    {
        $positions = [];
        $pos = 0;

        $offset = 0;

        while (($pos = strpos($string, "?", $offset)) !== false) {
            $positions[] = $pos;
            $offset = $pos + 1;
        }

        $count = count($positions);

        if ($count == 1) {
            $values = [$values];
        }

        for ($i = 0; $i < $count; $i++) {
            $value = $values[$i];
            if ($value instanceof Query) {
                $value = $this->parseValueQuery($value);
            } elseif (is_array($value)) {
                foreach ($value as $key => $subvalue) {
                    if (trim($subvalue) != '') {
                        $value[$key] = is_numeric($subvalue) ? $subvalue : $this->getQuery()->getManager()->getAdapter()->quote($subvalue);
                    } else {
                        unset($value[$key]);
                    }
                }
                $value = '(' . implode(', ', $value) . ')';
            } elseif (is_int($value) || is_float($value)) {
            } else {
                $value = $this->getQuery()->getManager()->getAdapter()->quote($values[$i]);
            }
            $string = substr_replace($string, $value, strpos($string, '?'), 1);
        }

        return $string;

    }

    /**
     * @param Query $value
     */
    protected function parseValueQuery($value)
    {
        return "(" . $value->assemble() . ")";
class A
{
    function getObject()
    {
        return null;
    }

}

$a = new A();
if ($a->getObject()) {
    }

    /**
     * @return Query
     */
    public function getQuery()
    {
        return $this->_query;
    }

    /**
     * @param Query $query
     * @return $this
     */
    public function setQuery($query)
    {
        $this->_query = $query;

        return $this;
    }

    /**
     * @param Condition $condition
     */
    public function and_($condition)
    {
        return new AndCondition($this, $condition);
    }

    /**
     * @param Condition $condition
     */
    public function or_($condition)
    {
        return new OrCondition($this, $condition);
    }

    public function protectCondition($condition)
    {
        return strpos($condition, ' AND ') || strpos($condition, ' OR ') ? '(' . $condition . ')' : $condition;
    }
}


1		<?php
2
3		namespace Nip\Database\Query\Condition;
4
5		use Nip\Database\Query\AbstractQuery as Query;
6
7		/**
8		* Class Condition
9		* @package Nip\Database\Query\Condition
10		*/
11		class Condition
12		{
13		protected $_string;
14		protected $_values;
15		protected $_query;
16
17	13	/**
18		* @param string $string
19	13	*/
20	13	public function __construct($string, $values = [])
21	13	{
22		$this->_string = $string;
23	6	$this->_values = $values;
24		}
25	6
26		/**
27		* @return string
28	12	*/
29		public function __toString()
30	12	{
31		return $this->getString();
32		}
33
34		/**
35		* @return string
36		*/
37		public function getString()
38		{
39		return $this->parseString($this->_string, $this->_values);
40	12	}
41
42	12	/**
43	12	* Parses $string and replaces all instances of "?" with corresponding $values.
44	12	*
45		* @param string $string
46	12	* @param array $values
47	3	*
48	3	* @return string
49		*/
50		public function parseString($string, $values)
51	12	{
52		$positions = [];
53	12	$pos = 0;
		0 ignored issues – show Unused Code introduced 2020-11-18 19:17 UTC by Report Bug Copy Issue Report The assignment to `$pos` is dead and can be removed. Loading history...
54	3	$offset = 0;
55
56		while (($pos = strpos($string, "?", $offset)) !== false) {
57	12	$positions[] = $pos;
58	3	$offset = $pos + 1;
59	3	}
60	1
61	2	$count = count($positions);
62	1
63	1	if ($count == 1) {
64	1	$values = [$values];
65		}
66	1
67		for ($i = 0; $i < $count; $i++) {
68		$value = $values[$i];
69	1	if ($value instanceof Query) {
70	1	$value = $this->parseValueQuery($value);
71		} elseif (is_array($value)) {
72	1	foreach ($value as $key => $subvalue) {
73		if (trim($subvalue) != '') {
74	3	$value[$key] = is_numeric($subvalue) ? $subvalue : $this->getQuery()->getManager()->getAdapter()->quote($subvalue);
75		} else {
76		unset($value[$key]);
77	12	}
78		}
79		$value = '(' . implode(', ', $value) . ')';
80		} elseif (is_int($value) \|\| is_float($value)) {
81		} else {
82		$value = $this->getQuery()->getManager()->getAdapter()->quote($values[$i]);
83	1	}
84		$string = substr_replace($string, $value, strpos($string, '?'), 1);
85	1	}
86
87		return $string;
		0 ignored issues – show Bug Best Practice introduced 2021-02-10 07:12 UTC by Report Bug Copy Issue Report The expression `return $string` also could return the type `array` which is incompatible with the documented return type `string`. Loading history...
88		}
89
90		/**
91	1	* @param Query $value
92		*/
93	1	protected function parseValueQuery($value)
94		{
95		return "(" . $value->assemble() . ")";
		0 ignored issues – show Bug introduced 2020-11-18 19:17 UTC by Report Bug Copy Issue Report Are you sure the usage of `$value->assemble()` targeting `Nip\Database\Query\AbstractQuery::assemble()` seems to always return null. This check looks for function or method calls that always return null and whose return value is used. class A { function getObject() { return null; } } $a = new A(); if ($a->getObject()) { The method `getObject()` can return nothing but null, so it makes no sense to use the return value. The reason is most likely that a function or method is imcomplete or has been reduced for debug purposes. Loading history...
96		}
97
98		/**
99		* @return Query
100	13	*/
101		public function getQuery()
102	13	{
103		return $this->_query;
104	13	}
105
106		/**
107		* @param Query $query
108		* @return $this
109		*/
110	5	public function setQuery($query)
111		{
112	5	$this->_query = $query;
113
114		return $this;
115		}
116
117		/**
118	4	* @param Condition $condition
119		*/
120	4	public function and_($condition)
121		{
122		return new AndCondition($this, $condition);
123	7	}
124
125	7	/**
126		* @param Condition $condition
127		*/
128		public function or_($condition)
129		{
130		return new OrCondition($this, $condition);
131		}
132
133		public function protectCondition($condition)
134		{
135		return strpos($condition, ' AND ') \|\| strpos($condition, ' OR ') ? '(' . $condition . ')' : $condition;
136		}
137		}
138

bytic / database

Condition::parseValueQuery() A last analyzed 2023-01-30 21:10 UTC

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like

Condition::parseValueQuery() A
last analyzed 2023-01-30 21:10 UTC