AbstractQuery::setFlag() - Code Metrics - Inspection of "join*() now support only named binding" - auraphp/Aura.SqlQuery - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — 3.x-named-placeholders-only ( 6a3d98...913a85 )

by Paul

created 2017-03-21 20:22 UTC

AbstractQuery::setFlag() A

↳ Parent: AbstractQuery

Complexity

Conditions	2
Paths	2

Size

Total Lines	8
Code Lines	5

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	6
CRAP Score	2

Importance

Changes

Metric	Value
dl	0
loc	8
c	0
b	0
f	0
ccs	6
cts	6
cp	1
rs	9.4285
cc	2
eloc	5
nc	2
nop	2
crap	2

<?php
/**
 *
 * This file is part of Aura for PHP.
 *
 * @license http://opensource.org/licenses/bsd-license.php BSD
 *
 */
namespace Aura\SqlQuery;

use Aura\SqlQuery\Common\SubselectInterface;
use Aura\SqlQuery\Common\QuoterInterface;

/**
 *
 * Abstract query object.
 *
 * @package Aura.SqlQuery
 *
 */
abstract class AbstractQuery
{
    /**
     *
     * Data to be bound to the query.
     *
     * @var array
     *
     */
    protected $bind_values = array();

    /**
     *
     * The list of WHERE conditions.
     *
     * @var array
     *
     */
    protected $where = array();

    /**
     *
     * ORDER BY these columns.
     *
     * @var array
     *
     */
    protected $order_by = array();

    /**
     *
     * The list of flags.
     *
     * @var array
     *
     */
    protected $flags = array();

    /**
     *
     * A helper for quoting identifier names.
     *
     * @var Quoter
     *
     */
    protected $quoter;

    /**
     *
     * Prefix to use on placeholders for "sequential" bound values; used for
     * deconfliction when merging bound values from sub-selects, etc.
     *
     * @var mixed
     *
     */
    protected $seq_bind_prefix = '';

    /**
     *
     * Constructor.
     *
     * @param Quoter $quoter A helper for quoting identifier names.
     *
     * @param string $seq_bind_prefix A prefix for rewritten sequential-binding
     * placeholders (@see getSeqPlaceholder()).
     *
     */
    public function __construct(QuoterInterface $quoter, $builder, $seq_bind_prefix = '')
    {
        $this->quoter = $quoter;

        $this->builder = $builder;
class MyClass { }

$x = new MyClass();
$x->foo = true;
        $this->seq_bind_prefix = $seq_bind_prefix;
    }

    /**
     *
     * Returns the prefix for rewritten sequential-binding placeholders
     * (@see getSeqPlaceholder()).
     *
     * @return string
     *
     */
    public function getSeqBindPrefix()
    {
        return $this->seq_bind_prefix;
    }

    /**
     *
     * Returns this query object as an SQL statement string.
     *
     * @return string
     *
     */
    public function __toString()
    {
        return $this->getStatement();
    }

    /**
     *
     * Returns this query object as an SQL statement string.
     *
     * @return string
     *
     */
    public function getStatement()
    {
        return $this->build();
    }

    /**
     *
     * Builds this query object into a string.
     *
     * @return string
     *
     */
    abstract protected function build();

    /**
     *
     * Returns the prefix to use when quoting identifier names.
     *
     * @return string
     *
     */
    public function getQuoteNamePrefix()
    {
        return $this->quoter->getQuoteNamePrefix();
    }

    /**
     *
     * Returns the suffix to use when quoting identifier names.
     *
     * @return string
     *
     */
    public function getQuoteNameSuffix()
    {
        return $this->quoter->getQuoteNameSuffix();
    }

    /**
     *
     * Binds multiple values to placeholders; merges with existing values.
     *
     * @param array $bind_values Values to bind to placeholders.
     *
     * @return $this
     *
     */
    public function bindValues(array $bind_values)
    {
        // array_merge() renumbers integer keys, which is bad for
        // question-mark placeholders
        foreach ($bind_values as $key => $val) {
            $this->bindValue($key, $val);
        }
        return $this;
    }

    /**
     *
     * Binds a single value to the query.
     *
     * @param string $name The placeholder name or number.
     *
     * @param mixed $value The value to bind to the placeholder.
     *
     * @return $this
     *
     */
    public function bindValue($name, $value)
    {
        $this->bind_values[$name] = $value;
        return $this;
    }

    /**
     *
     * Gets the values to bind to placeholders.
     *
     * @return array
     *
     */
    public function getBindValues()
    {
        return $this->bind_values;
    }

    /**
     *
     * Reset all values bound to named placeholders.
     *
     * @return $this
     *
     */
    public function resetBindValues()
    {
        $this->bind_values = array();
        return $this;
    }

    /**
     *
     * Sets or unsets specified flag.
     *
     * @param string $flag Flag to set or unset
     *
     * @param bool $enable Flag status - enabled or not (default true)
     *
     * @return null
     *
     */
    protected function setFlag($flag, $enable = true)
    {
        if ($enable) {
            $this->flags[$flag] = true;
        } else {
            unset($this->flags[$flag]);
        }
    }

    /**
     *
     * Returns true if the specified flag was enabled by setFlag().
     *
     * @param string $flag Flag to check
     *
     * @return bool
     *
     */
    protected function hasFlag($flag)
    {
        return isset($this->flags[$flag]);
    }

    /**
     *
     * Reset all query flags.
     *
     * @return $this
     *
     */
    public function resetFlags()
    {
        $this->flags = array();
        return $this;
    }

    /**
     *
     * Adds conditions and binds values to a clause.
     *
     * @param string $clause The clause to work with, typically 'where' or
     * 'having'.
     *
     * @param string $andor Add the condition using this operator, typically
     * 'AND' or 'OR'.
     *
     * @param string $cond The WHERE condition.
     *
     * @param array $bind arguments to bind to placeholders
     *
     * @return null
     *
     */
    protected function addClauseCondWithBind($clause, $andor, $cond, $bind)
    {
        $cond = $this->quoter->quoteNamesIn($cond);

        $clause =& $this->$clause;
        if ($clause) {
            $clause[] = "$andor $cond";
        } else {
            $clause[] = $cond;
        }

        foreach ($bind as $key => $val) {
            $this->bindValue($key, $val);
        }
    }

    /**
     *
     * Gets the current sequential placeholder name.
     *
     * @return string
     *
     */
    protected function getSeqPlaceholder()
    {
        $i = count($this->bind_values) + 1;
        return $this->seq_bind_prefix . "_{$i}_";
    }

    /**
     *
     * Adds a column order to the query.
     *
     * @param array $spec The columns and direction to order by.
     *
     * @return $this
     *
     */
    protected function addOrderBy(array $spec)
    {
        foreach ($spec as $col) {
            $this->order_by[] = $this->quoter->quoteNamesIn($col);
        }
        return $this;
    }
}


1		<?php
2		/**
3		*
4		* This file is part of Aura for PHP.
5		*
6		* @license http://opensource.org/licenses/bsd-license.php BSD
7		*
8		*/
9		namespace Aura\SqlQuery;
10
11		use Aura\SqlQuery\Common\SubselectInterface;
12		use Aura\SqlQuery\Common\QuoterInterface;
13
14		/**
15		*
16		* Abstract query object.
17		*
18		* @package Aura.SqlQuery
19		*
20		*/
21		abstract class AbstractQuery
22		{
23		/**
24		*
25		* Data to be bound to the query.
26		*
27		* @var array
28		*
29		*/
30		protected $bind_values = array();
31
32		/**
33		*
34		* The list of WHERE conditions.
35		*
36		* @var array
37		*
38		*/
39		protected $where = array();
40
41		/**
42		*
43		* ORDER BY these columns.
44		*
45		* @var array
46		*
47		*/
48		protected $order_by = array();
49
50		/**
51		*
52		* The list of flags.
53		*
54		* @var array
55		*
56		*/
57		protected $flags = array();
58
59		/**
60		*
61		* A helper for quoting identifier names.
62		*
63		* @var Quoter
64		*
65		*/
66		protected $quoter;
67
68		/**
69		*
70		* Prefix to use on placeholders for "sequential" bound values; used for
71		* deconfliction when merging bound values from sub-selects, etc.
72		*
73		* @var mixed
74		*
75		*/
76		protected $seq_bind_prefix = '';
77
78		/**
79		*
80		* Constructor.
81		*
82		* @param Quoter $quoter A helper for quoting identifier names.
83		*
84		* @param string $seq_bind_prefix A prefix for rewritten sequential-binding
85		* placeholders (@see getSeqPlaceholder()).
86		*
87		*/
88	398	public function __construct(QuoterInterface $quoter, $builder, $seq_bind_prefix = '')
89		{
90	398	$this->quoter = $quoter;
		0 ignored issues – show Documentation Bug introduced 2017-03-19 15:33 UTC by Report Bug Copy Issue Report It seems like `$quoter` of type `object<Aura\SqlQuery\Common\QuoterInterface>` is incompatible with the declared type `object<Aura\SqlQuery\Quoter>` of property `$quoter`. Our type inference engine has found an assignment to a property that is incompatible with the declared type of that property. Either this assignment is in error or the assigned type should be added to the documentation/type hint for that property.. Loading history...
91	398	$this->builder = $builder;
		0 ignored issues – show Bug introduced 2017-03-17 16:53 UTC by Report Bug Copy Issue Report The property `builder` does not exist. Did you maybe forget to declare it? In PHP it is possible to write to properties without declaring them. For example, the following is perfectly valid PHP code: class MyClass { } $x = new MyClass(); $x->foo = true; Generally, it is a good practice to explictly declare properties to avoid accidental typos and provide IDE auto-completion: class MyClass { public $foo; } $x = new MyClass(); $x->foo = true; Loading history...
92	398	$this->seq_bind_prefix = $seq_bind_prefix;
93	398	}
94
95		/**
96		*
97		* Returns the prefix for rewritten sequential-binding placeholders
98		* (@see getSeqPlaceholder()).
99		*
100		* @return string
101		*
102		*/
103	1	public function getSeqBindPrefix()
104		{
105	1	return $this->seq_bind_prefix;
106		}
107
108		/**
109		*
110		* Returns this query object as an SQL statement string.
111		*
112		* @return string
113		*
114		*/
115	238	public function __toString()
116		{
117	238	return $this->getStatement();
118		}
119
120		/**
121		*
122		* Returns this query object as an SQL statement string.
123		*
124		* @return string
125		*
126		*/
127	69	public function getStatement()
128		{
129	69	return $this->build();
130		}
131
132		/**
133		*
134		* Builds this query object into a string.
135		*
136		* @return string
137		*
138		*/
139		abstract protected function build();
140
141		/**
142		*
143		* Returns the prefix to use when quoting identifier names.
144		*
145		* @return string
146		*
147		*/
148	247	public function getQuoteNamePrefix()
149		{
150	247	return $this->quoter->getQuoteNamePrefix();
151		}
152
153		/**
154		*
155		* Returns the suffix to use when quoting identifier names.
156		*
157		* @return string
158		*
159		*/
160	247	public function getQuoteNameSuffix()
161		{
162	247	return $this->quoter->getQuoteNameSuffix();
163		}
164
165		/**
166		*
167		* Binds multiple values to placeholders; merges with existing values.
168		*
169		* @param array $bind_values Values to bind to placeholders.
170		*
171		* @return $this
172		*
173		*/
174	31	public function bindValues(array $bind_values)
175		{
176		// array_merge() renumbers integer keys, which is bad for
177		// question-mark placeholders
178	31	foreach ($bind_values as $key => $val) {
179	31	$this->bindValue($key, $val);
180	31	}
181	31	return $this;
182		}
183
184		/**
185		*
186		* Binds a single value to the query.
187		*
188		* @param string $name The placeholder name or number.
189		*
190		* @param mixed $value The value to bind to the placeholder.
191		*
192		* @return $this
193		*
194		*/
195	131	public function bindValue($name, $value)
196		{
197	131	$this->bind_values[$name] = $value;
198	131	return $this;
199		}
200
201		/**
202		*
203		* Gets the values to bind to placeholders.
204		*
205		* @return array
206		*
207		*/
208	116	public function getBindValues()
209		{
210	116	return $this->bind_values;
211		}
212
213		/**
214		*
215		* Reset all values bound to named placeholders.
216		*
217		* @return $this
218		*
219		*/
220	15	public function resetBindValues()
221		{
222	15	$this->bind_values = array();
223	15	return $this;
224		}
225
226		/**
227		*
228		* Sets or unsets specified flag.
229		*
230		* @param string $flag Flag to set or unset
231		*
232		* @param bool $enable Flag status - enabled or not (default true)
233		*
234		* @return null
235		*
236		*/
237	43	protected function setFlag($flag, $enable = true)
238		{
239	43	if ($enable) {
240	43	$this->flags[$flag] = true;
241	43	} else {
242	5	unset($this->flags[$flag]);
243		}
244	43	}
245
246		/**
247		*
248		* Returns true if the specified flag was enabled by setFlag().
249		*
250		* @param string $flag Flag to check
251		*
252		* @return bool
253		*
254		*/
255	10	protected function hasFlag($flag)
256		{
257	10	return isset($this->flags[$flag]);
258		}
259
260		/**
261		*
262		* Reset all query flags.
263		*
264		* @return $this
265		*
266		*/
267	20	public function resetFlags()
268		{
269	20	$this->flags = array();
270	20	return $this;
271		}
272
273		/**
274		*
275		* Adds conditions and binds values to a clause.
276		*
277		* @param string $clause The clause to work with, typically 'where' or
278		* 'having'.
279		*
280		* @param string $andor Add the condition using this operator, typically
281		* 'AND' or 'OR'.
282		*
283		* @param string $cond The WHERE condition.
284		*
285		* @param array $bind arguments to bind to placeholders
286		*
287		* @return null
288		*
289		*/
290	60	protected function addClauseCondWithBind($clause, $andor, $cond, $bind)
291		{
292	60	$cond = $this->quoter->quoteNamesIn($cond);
293
294	60	$clause =& $this->$clause;
295	60	if ($clause) {
296	44	$clause[] = "$andor $cond";
297	44	} else {
298	60	$clause[] = $cond;
299		}
300
301	60	foreach ($bind as $key => $val) {
302	60	$this->bindValue($key, $val);
303	60	}
304	60	}
305
306		/**
307		*
308		* Gets the current sequential placeholder name.
309		*
310		* @return string
311		*
312		*/
313		protected function getSeqPlaceholder()
314		{
315		$i = count($this->bind_values) + 1;
316		return $this->seq_bind_prefix . "_{$i}_";
317		}
318
319		/**
320		*
321		* Adds a column order to the query.
322		*
323		* @param array $spec The columns and direction to order by.
324		*
325		* @return $this
326		*
327		*/
328	9	protected function addOrderBy(array $spec)
329		{
330	9	foreach ($spec as $col) {
331	9	$this->order_by[] = $this->quoter->quoteNamesIn($col);
332	9	}
333	9	return $this;
334		}
335		}
336

auraphp / Aura.SqlQuery

Push — 3.x-named-placeholders-only ( 6a3d98...913a85 )

AbstractQuery::setFlag() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like