QueryObject::interpolateQuery() - Code Metrics - gin0115/pixie-wpdb - Measure and Improve Code Quality continuously with Scrutinizer

QueryObject::interpolateQuery() A
last analyzed 2022-04-15 15:47 UTC

↳ Parent: QueryObject

Complexity

Conditions	3
Paths	4

Size

Total Lines	6
Code Lines	2

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
eloc	2
c	1
b	0
f	0
dl	0
loc	6
rs	10
cc	3
nc	4
nop	2

<?php

namespace Pixie\QueryBuilder;

use wpdb;

class QueryObject
{
    /**
     * @var string
     */
    protected $sql;

    /**
     * @var mixed[]
     */
    protected $bindings = [];

    /**
     * @var wpdb
     */
    protected $dbInstance;

    /**
     * @param string $sql
     * @param mixed[] $bindings
     * @param wpdb $dbInstance
     */
    public function __construct(string $sql, array $bindings, wpdb $dbInstance)
    {
        $this->sql        = (string)$sql;
        $this->bindings   = $bindings;
        $this->dbInstance = $dbInstance;
    }

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

    /**
     * @return mixed[]
     */
    public function getBindings()
    {
        return $this->bindings;
    }

    /**
     * Get the raw/bound sql
     *
     * @return string
     */
    public function getRawSql()
    {
        return $this->interpolateQuery($this->sql, $this->bindings);
    }

    /**
     * Uses WPDB::prepare() to interpolate the query passed.

     *
     * @param string $query  The sql query with parameter placeholders
     * @param mixed[]  $params The array of substitution parameters
     *
     * @return string The interpolated query
     */
    protected function interpolateQuery($query, $params): string
    {
        // Only call this when we have valid params (avoids wpdb::prepare() incorrectly called error)
        $value = empty($params) ? $query : $this->dbInstance->prepare($query, $params);

        return is_string($value) ? $value : '';

    }
}


1			<?php
2
3			namespace Pixie\QueryBuilder;
4
5			use wpdb;
6
7			class QueryObject
8			{
9			/**
10			* @var string
11			*/
12			protected $sql;
13
14			/**
15			* @var mixed[]
16			*/
17			protected $bindings = [];
18
19			/**
20			* @var wpdb
21			*/
22			protected $dbInstance;
23
24			/**
25			* @param string $sql
26			* @param mixed[] $bindings
27			* @param wpdb $dbInstance
28			*/
29			public function __construct(string $sql, array $bindings, wpdb $dbInstance)
30			{
31			$this->sql = (string)$sql;
32			$this->bindings = $bindings;
33			$this->dbInstance = $dbInstance;
34			}
35
36			/**
37			* @return string
38			*/
39			public function getSql()
40			{
41			return $this->sql;
42			}
43
44			/**
45			* @return mixed[]
46			*/
47			public function getBindings()
48			{
49			return $this->bindings;
50			}
51
52			/**
53			* Get the raw/bound sql
54			*
55			* @return string
56			*/
57			public function getRawSql()
58			{
59			return $this->interpolateQuery($this->sql, $this->bindings);
60			}
61
62			/**
63			* Uses WPDB::prepare() to interpolate the query passed.
64
65			*
66			* @param string $query The sql query with parameter placeholders
67			* @param mixed[] $params The array of substitution parameters
68			*
69			* @return string The interpolated query
70			*/
71			protected function interpolateQuery($query, $params): string
72			{
73			// Only call this when we have valid params (avoids wpdb::prepare() incorrectly called error)
74			$value = empty($params) ? $query : $this->dbInstance->prepare($query, $params);
75
76			return is_string($value) ? $value : '';
			0 ignored issues – show introduced 2022-01-19 09:23 UTC by Report Bug Copy Issue Report The condition `is_string($value)` is always `true`. Loading history...
77			}
78			}
79

gin0115 / pixie-wpdb

QueryObject::interpolateQuery() A last analyzed 2022-04-15 15:47 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

QueryObject::interpolateQuery() A
last analyzed 2022-04-15 15:47 UTC