DbSqlPrepare::build() - Code Metrics - Inspection of "DBAL-feat-41a7.42: Working on DB Abstraction Layer" - supernova-ws/SuperNova - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — work-fleets ( 98be23...4e14e1 )

by SuperNova.WS

created 2016-05-22 23:51 UTC

DbSqlPrepare::build() A

↳ Parent: DbSqlPrepare

Complexity

Conditions	1
Paths	1

Size

Total Lines	3
Code Lines	2

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	2
CRAP Score	1

Importance

Changes	1
Bugs	0	Features	0

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

<?php

/**
 * Class DbSqlPrepare
 */
class DbSqlPrepare {
  const COMMENT_PLACEHOLDER = ':__COMMENT__';
  const PARAM_PREG = '#(\:.+?\b)#im';

  public $query = '';
  public $values = array();

  public $comment = '';

  public $queryPrepared = '';
  public $paramsPrepared = array();
  public $valuesPrepared = array();
  public $valueTypesPrepared = '';
  /**
   * @var mysqli_stmt $statement
   */
  public $statement;

//  /**
//   * @var ReflectionMethod
//   */
//  public static $bindParamMethod;

  /**
   * @var self[]
   */
  protected static $statements = array();

  /**
   * DbSqlPrepare constructor.
   *
   * @param string $statement
   * @param array  $values
   */
  public function __construct($statement, $values = array()) {
//    if(empty(static::$bindParamMethod)) {

//      $ref = new ReflectionClass('mysqli_stmt');
//      static::$bindParamMethod = $ref->getMethod("bind_param");
//    }

    $this->query = trim($statement);
    $this->values = $values;
  }

  /**
   * @param string $statement
   * @param array  $values
   *
   * @return static
   *
   */
  public static function build($statement, $values = array()) {
    return new static($statement, $values);
  }


  public function setQuery($query) {
    $this->query = $query;

    return $this;
  }

  public function commentRemove() {
    if (!empty($this->values[static::COMMENT_PLACEHOLDER])) {
      unset($this->values[static::COMMENT_PLACEHOLDER]);
      $this->query = str_replace(' ' . static::COMMENT_PLACEHOLDER, '', $this->query);
    }
  }

  public function commentAdd($comment) {
    if (empty($this->values[static::COMMENT_PLACEHOLDER])) {
      $this->query .= ' ' . static::COMMENT_PLACEHOLDER;
    }
    $this->values[static::COMMENT_PLACEHOLDER] = $comment;
  }

  /**
   * @param string $comment
   */
  public function comment($comment) {
    if (empty($comment)) {
      $this->commentRemove();
    } else {
      $this->commentAdd($comment);
    }

    return $this;
  }

  public function __toString() {
//    $result = str_replace(array_keys($this->tables), $this->tables, $this->query);

    $result = str_replace(array_keys($this->values), $this->values, $this->query);

    return $result;
  }

  public function compileMySqlI() {
//    print($this->statement);


    $this->queryPrepared = $this->query;
    $this->paramsPrepared = array();
    $this->valuesPrepared = array();
    $this->valueTypesPrepared = '';

    if ($variableCount = preg_match_all(self::PARAM_PREG, $this->query, $matches, PREG_PATTERN_ORDER)) {
$myVar = 'Value';
$higher = false;

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}
      $this->paramsPrepared = $matches[0];
      if (in_array(static::COMMENT_PLACEHOLDER, $this->paramsPrepared)) {
        // Removing comment placeholder from statement
        $this->queryPrepared = str_replace(static::COMMENT_PLACEHOLDER, $this->comment, $this->queryPrepared);
        // Removing comment value from values list
        $this->paramsPrepared = array_filter($this->paramsPrepared, function ($value) { return $value != DbSqlPrepare::COMMENT_PLACEHOLDER; });
        // TODO - Add comment value directly to statement
      }

//      pdump($this->valuesUsed, '$this->valuesUsed0');


      // Using $matches array as keys for used values array

//     $this->valuesUsed = array_combine($matches, array_fill(0, count($matches), null));

      // Now filling found parms with it values
      // We can't use param names as keys 'cause same param can be met twice
      // So one key would overwrite another and total number of valuesUsed will be less then actual values used
      foreach ($this->paramsPrepared as $key => &$value) {
        if (!key_exists($value, $this->values)) {
          // Throw exception if not key found in statement values list
          throw new Exception('DbSqlPrepare::compile() - values array has no match for statement params');
        }
//        $value = array(

//          'param' => $value,
//          'value' => $this->values[$value],
//        );
        // Reference need for call mysqli::bind_param later in execute() method
        $this->valuesPrepared[$key] = &$this->values[$value];

        // i corresponding variable has type integer
        // d corresponding variable has type double
        // s corresponding variable has type string
        // b corresponding variable is a blob and will be sent in packets
        if (is_int($this->values[$value])) {
          $this->valueTypesPrepared .= 'i';
        } elseif (is_double($this->values[$value])) {
          $this->valueTypesPrepared .= 'd';
        } else {
          $this->valueTypesPrepared .= 's';
        }
      }


//      foreach ($this->valuesUsed as $key => &$value) {

//        if (!key_exists($key, $this->values)) {
//          // Throw exception if not key found in statement values list
//          throw new Exception('DbSqlPrepare::compile() - values array has no match for statement params');
//        }
//        $value = $this->values[$key];
//      }
//


//      pdump($matches, '$matches0');

//      $this->valuesUsed = array_intersect_key($this->values, $matches);
//      pdump($matches, '$matches2 ');

      // Replacing actual param names with '?' - for mysqli_prepare
      $this->queryPrepared = preg_replace(self::PARAM_PREG, '?', $this->queryPrepared);

//      pdump($this->paramsPrepared, '$this->paramsUsed');

//      pdump($this->valuesPrepared, '$this->valuesPrepared');
//      pdump($this->valueTypesPrepared, '$valueTypes');
//
//      print($this->queryPrepared);
//      print($questioned);
    };

//    pdie();

    return $this;
  }

  public function getResult() {
    return $this->statement->get_result();
  }

  /**
   * @param db_mysql $db
   *
   * @return DbSqlPrepare
   * @throws Exception
   */
  public function statementGet($db) {
    $md5 = md5($this->queryPrepared);

    if (empty(static::$statements[$md5])) {
      if (!(static::$statements[$md5] = $db->db_prepare($this->queryPrepared))) {
        throw new Exception('doQueryPhase1 - can not prepare statement');
      }
      if (count($this->valuesPrepared)) {
        $params = array_merge(array(&$this->valueTypesPrepared), $this->valuesPrepared);
        // static::$bindParamMethod->invokeArgs($this->statement, $params);

        call_user_func_array(array(static::$statements[$md5], 'bind_param'), $params);
      }
    }
    $this->statement = static::$statements[$md5];
class Id
{
    public $id;

    public function __construct($id)
    {
        $this->id = $id;
    }

}

class Account
{
    /** @var  Id $id */
    public $id;
}

$account_id = false;

if (starsAreRight()) {
    $account_id = new Id(42);
}

$account = new Account();
if ($account instanceof Id)
{
    $account->id = $account_id;
}

    return $this;
  }

  /**
   * @return $this
   */
  public function execute() {
//pdump($this->valuesPrepared);

//    if (count($this->valuesPrepared)) {
//      $params = array_merge(array(&$this->valueTypesPrepared), $this->valuesPrepared);
////      static::$bindParamMethod->invokeArgs($this->statement, $params);
//      call_user_func_array(array($this->statement, 'bind_param'), $params);
//    }

    $this->statement->execute();

    return $this;
  }

}


1		<?php
2
3		/**
4		* Class DbSqlPrepare
5		*/
6		class DbSqlPrepare {
7		const COMMENT_PLACEHOLDER = ':__COMMENT__';
8		const PARAM_PREG = '#(\:.+?\b)#im';
9
10		public $query = '';
11		public $values = array();
12
13		public $comment = '';
14
15		public $queryPrepared = '';
16		public $paramsPrepared = array();
17		public $valuesPrepared = array();
18		public $valueTypesPrepared = '';
19		/**
20		* @var mysqli_stmt $statement
21		*/
22		public $statement;
23
24		// /**
25		// * @var ReflectionMethod
26		// */
27		// public static $bindParamMethod;
28
29		/**
30		* @var self[]
31		*/
32		protected static $statements = array();
33
34		/**
35		* DbSqlPrepare constructor.
36		*
37		* @param string $statement
38		* @param array $values
39		*/
40	1	public function __construct($statement, $values = array()) {
41		// if(empty(static::$bindParamMethod)) {
		0 ignored issues – show Unused Code Comprehensibility introduced 2016-05-22 23:56 UTC by Report Bug Copy Issue Report `61%` of this comment could be valid code. Did you maybe forget this after debugging? Sometimes obsolete code just ends up commented out instead of removed. In this case it is better to remove the code once you have checked you do not need it. The code might also have been commented out for debugging purposes. In this case it is vital that someone uncomments it again or your project may behave in very unexpected ways in production. This check looks for comments that seem to be mostly valid code and reports them. Loading history...
42		// $ref = new ReflectionClass('mysqli_stmt');
43		// static::$bindParamMethod = $ref->getMethod("bind_param");
44		// }
45
46	1	$this->query = trim($statement);
47	1	$this->values = $values;
48	1	}
49
50		/**
51		* @param string $statement
52		* @param array $values
53		*
54		* @return static
55		*
56		*/
57	1	public static function build($statement, $values = array()) {
58	1	return new static($statement, $values);
59		}
60
61
62		public function setQuery($query) {
63		$this->query = $query;
64
65		return $this;
66		}
67
68		public function commentRemove() {
69		if (!empty($this->values[static::COMMENT_PLACEHOLDER])) {
70		unset($this->values[static::COMMENT_PLACEHOLDER]);
71		$this->query = str_replace(' ' . static::COMMENT_PLACEHOLDER, '', $this->query);
72		}
73		}
74
75		public function commentAdd($comment) {
76		if (empty($this->values[static::COMMENT_PLACEHOLDER])) {
77		$this->query .= ' ' . static::COMMENT_PLACEHOLDER;
78		}
79		$this->values[static::COMMENT_PLACEHOLDER] = $comment;
80		}
81
82		/**
83		* @param string $comment
84		*/
85		public function comment($comment) {
86		if (empty($comment)) {
87		$this->commentRemove();
88		} else {
89		$this->commentAdd($comment);
90		}
91
92		return $this;
93		}
94
95	1	public function __toString() {
96		// $result = str_replace(array_keys($this->tables), $this->tables, $this->query);
		0 ignored issues – show Unused Code Comprehensibility introduced 2016-05-22 23:56 UTC by Report Bug Copy Issue Report `57%` of this comment could be valid code. Did you maybe forget this after debugging? Sometimes obsolete code just ends up commented out instead of removed. In this case it is better to remove the code once you have checked you do not need it. The code might also have been commented out for debugging purposes. In this case it is vital that someone uncomments it again or your project may behave in very unexpected ways in production. This check looks for comments that seem to be mostly valid code and reports them. Loading history...
97	1	$result = str_replace(array_keys($this->values), $this->values, $this->query);
98
99	1	return $result;
100		}
101
102		public function compileMySqlI() {
103		// print($this->statement);
		0 ignored issues – show Unused Code Comprehensibility introduced 2016-05-22 23:56 UTC by Report Bug Copy Issue Report `75%` of this comment could be valid code. Did you maybe forget this after debugging? Sometimes obsolete code just ends up commented out instead of removed. In this case it is better to remove the code once you have checked you do not need it. The code might also have been commented out for debugging purposes. In this case it is vital that someone uncomments it again or your project may behave in very unexpected ways in production. This check looks for comments that seem to be mostly valid code and reports them. Loading history...
104
105		$this->queryPrepared = $this->query;
106		$this->paramsPrepared = array();
107		$this->valuesPrepared = array();
108		$this->valueTypesPrepared = '';
109
110		if ($variableCount = preg_match_all(self::PARAM_PREG, $this->query, $matches, PREG_PATTERN_ORDER)) {
		0 ignored issues – show Unused Code introduced 2016-05-22 23:56 UTC by Report Bug Copy Issue Report `$variableCount` is not used, you could remove the assignment. This check looks for variable assignements that are either overwritten by other assignments or where the variable is not used subsequently. $myVar = 'Value'; $higher = false; if (rand(1, 6) > 3) { $higher = true; } else { $higher = false; } Both the `$myVar` assignment in line 1 and the `$higher` assignment in line 2 are dead. The first because `$myVar` is never used and the second because `$higher` is always overwritten for every possible time line. Loading history...
111		$this->paramsPrepared = $matches[0];
112		if (in_array(static::COMMENT_PLACEHOLDER, $this->paramsPrepared)) {
113		// Removing comment placeholder from statement
114		$this->queryPrepared = str_replace(static::COMMENT_PLACEHOLDER, $this->comment, $this->queryPrepared);
115		// Removing comment value from values list
116		$this->paramsPrepared = array_filter($this->paramsPrepared, function ($value) { return $value != DbSqlPrepare::COMMENT_PLACEHOLDER; });
117		// TODO - Add comment value directly to statement
118		}
119
120		// pdump($this->valuesUsed, '$this->valuesUsed0');
		0 ignored issues – show Unused Code Comprehensibility introduced 2016-05-22 23:56 UTC by Report Bug Copy Issue Report `64%` of this comment could be valid code. Did you maybe forget this after debugging? Sometimes obsolete code just ends up commented out instead of removed. In this case it is better to remove the code once you have checked you do not need it. The code might also have been commented out for debugging purposes. In this case it is vital that someone uncomments it again or your project may behave in very unexpected ways in production. This check looks for comments that seem to be mostly valid code and reports them. Loading history...
121
122		// Using $matches array as keys for used values array
		0 ignored issues – show Unused Code Comprehensibility introduced 2016-05-22 23:56 UTC by Report Bug Copy Issue Report `46%` of this comment could be valid code. Did you maybe forget this after debugging? Sometimes obsolete code just ends up commented out instead of removed. In this case it is better to remove the code once you have checked you do not need it. The code might also have been commented out for debugging purposes. In this case it is vital that someone uncomments it again or your project may behave in very unexpected ways in production. This check looks for comments that seem to be mostly valid code and reports them. Loading history...
123		// $this->valuesUsed = array_combine($matches, array_fill(0, count($matches), null));
124
125		// Now filling found parms with it values
126		// We can't use param names as keys 'cause same param can be met twice
127		// So one key would overwrite another and total number of valuesUsed will be less then actual values used
128		foreach ($this->paramsPrepared as $key => &$value) {
129		if (!key_exists($value, $this->values)) {
130		// Throw exception if not key found in statement values list
131		throw new Exception('DbSqlPrepare::compile() - values array has no match for statement params');
132		}
133		// $value = array(
		0 ignored issues – show Unused Code Comprehensibility introduced 2016-05-22 23:56 UTC by Report Bug Copy Issue Report `54%` of this comment could be valid code. Did you maybe forget this after debugging? Sometimes obsolete code just ends up commented out instead of removed. In this case it is better to remove the code once you have checked you do not need it. The code might also have been commented out for debugging purposes. In this case it is vital that someone uncomments it again or your project may behave in very unexpected ways in production. This check looks for comments that seem to be mostly valid code and reports them. Loading history...
134		// 'param' => $value,
135		// 'value' => $this->values[$value],
136		// );
137		// Reference need for call mysqli::bind_param later in execute() method
138		$this->valuesPrepared[$key] = &$this->values[$value];
139
140		// i corresponding variable has type integer
141		// d corresponding variable has type double
142		// s corresponding variable has type string
143		// b corresponding variable is a blob and will be sent in packets
144		if (is_int($this->values[$value])) {
145		$this->valueTypesPrepared .= 'i';
146		} elseif (is_double($this->values[$value])) {
147		$this->valueTypesPrepared .= 'd';
148		} else {
149		$this->valueTypesPrepared .= 's';
150		}
151		}
152
153
154		// foreach ($this->valuesUsed as $key => &$value) {
		0 ignored issues – show Unused Code Comprehensibility introduced 2016-05-22 23:56 UTC by Report Bug Copy Issue Report `54%` of this comment could be valid code. Did you maybe forget this after debugging? Sometimes obsolete code just ends up commented out instead of removed. In this case it is better to remove the code once you have checked you do not need it. The code might also have been commented out for debugging purposes. In this case it is vital that someone uncomments it again or your project may behave in very unexpected ways in production. This check looks for comments that seem to be mostly valid code and reports them. Loading history...
155		// if (!key_exists($key, $this->values)) {
156		// // Throw exception if not key found in statement values list
157		// throw new Exception('DbSqlPrepare::compile() - values array has no match for statement params');
158		// }
159		// $value = $this->values[$key];
160		// }
161		//
162
163
164		// pdump($matches, '$matches0');
		0 ignored issues – show Unused Code Comprehensibility introduced 2016-05-22 23:56 UTC by Report Bug Copy Issue Report `57%` of this comment could be valid code. Did you maybe forget this after debugging? Sometimes obsolete code just ends up commented out instead of removed. In this case it is better to remove the code once you have checked you do not need it. The code might also have been commented out for debugging purposes. In this case it is vital that someone uncomments it again or your project may behave in very unexpected ways in production. This check looks for comments that seem to be mostly valid code and reports them. Loading history...
165		// $this->valuesUsed = array_intersect_key($this->values, $matches);
166		// pdump($matches, '$matches2 ');
167
168		// Replacing actual param names with '?' - for mysqli_prepare
169		$this->queryPrepared = preg_replace(self::PARAM_PREG, '?', $this->queryPrepared);
170
171		// pdump($this->paramsPrepared, '$this->paramsUsed');
		0 ignored issues – show Unused Code Comprehensibility introduced 2016-05-22 23:56 UTC by Report Bug Copy Issue Report `62%` of this comment could be valid code. Did you maybe forget this after debugging? Sometimes obsolete code just ends up commented out instead of removed. In this case it is better to remove the code once you have checked you do not need it. The code might also have been commented out for debugging purposes. In this case it is vital that someone uncomments it again or your project may behave in very unexpected ways in production. This check looks for comments that seem to be mostly valid code and reports them. Loading history...
172		// pdump($this->valuesPrepared, '$this->valuesPrepared');
173		// pdump($this->valueTypesPrepared, '$valueTypes');
174		//
175		// print($this->queryPrepared);
176		// print($questioned);
177		};
178
179		// pdie();
180
181		return $this;
182		}
183
184		public function getResult() {
185		return $this->statement->get_result();
186		}
187
188		/**
189		* @param db_mysql $db
190		*
191		* @return DbSqlPrepare
192		* @throws Exception
193		*/
194		public function statementGet($db) {
195		$md5 = md5($this->queryPrepared);
196
197		if (empty(static::$statements[$md5])) {
198		if (!(static::$statements[$md5] = $db->db_prepare($this->queryPrepared))) {
199		throw new Exception('doQueryPhase1 - can not prepare statement');
200		}
201		if (count($this->valuesPrepared)) {
202		$params = array_merge(array(&$this->valueTypesPrepared), $this->valuesPrepared);
203		// static::$bindParamMethod->invokeArgs($this->statement, $params);
		0 ignored issues – show Unused Code Comprehensibility introduced 2016-05-22 23:56 UTC by Report Bug Copy Issue Report `74%` of this comment could be valid code. Did you maybe forget this after debugging? Sometimes obsolete code just ends up commented out instead of removed. In this case it is better to remove the code once you have checked you do not need it. The code might also have been commented out for debugging purposes. In this case it is vital that someone uncomments it again or your project may behave in very unexpected ways in production. This check looks for comments that seem to be mostly valid code and reports them. Loading history...
204		call_user_func_array(array(static::$statements[$md5], 'bind_param'), $params);
205		}
206		}
207		$this->statement = static::$statements[$md5];
		0 ignored issues – show Documentation Bug introduced 2016-05-22 23:56 UTC by Report Bug Copy Issue Report It seems like `static::$statements[$md5]` can also be of type `boolean` or `object<DbSqlPrepare>`. However, the property `$statement` is declared as type `object<mysqli_stmt>`. Maybe add an additional type check? Our type inference engine has found a suspicous assignment of a value to a property. This check raises an issue when a value that can be of a mixed type is assigned to a property that is type hinted more strictly. For example, imagine you have a variable `$accountId` that can either hold an Id object or false (if there is no account id yet). Your code now assigns that value to the `id` property of an instance of the `Account` class. This class holds a proper account, so the id value must no longer be false. Either this assignment is in error or a type check should be added for that assignment. class Id { public $id; public function __construct($id) { $this->id = $id; } } class Account { /** @var Id $id */ public $id; } $account_id = false; if (starsAreRight()) { $account_id = new Id(42); } $account = new Account(); if ($account instanceof Id) { $account->id = $account_id; } Loading history...
208
209		return $this;
210		}
211
212		/**
213		* @return $this
214		*/
215		public function execute() {
216		//pdump($this->valuesPrepared);
		0 ignored issues – show Unused Code Comprehensibility introduced 2016-05-22 23:56 UTC by Report Bug Copy Issue Report `60%` of this comment could be valid code. Did you maybe forget this after debugging? Sometimes obsolete code just ends up commented out instead of removed. In this case it is better to remove the code once you have checked you do not need it. The code might also have been commented out for debugging purposes. In this case it is vital that someone uncomments it again or your project may behave in very unexpected ways in production. This check looks for comments that seem to be mostly valid code and reports them. Loading history...
217		// if (count($this->valuesPrepared)) {
218		// $params = array_merge(array(&$this->valueTypesPrepared), $this->valuesPrepared);
219		//// static::$bindParamMethod->invokeArgs($this->statement, $params);
220		// call_user_func_array(array($this->statement, 'bind_param'), $params);
221		// }
222
223		$this->statement->execute();
224
225		return $this;
226		}
227
228		}
229

supernova-ws / SuperNova

Push — work-fleets ( 98be23...4e14e1 )

DbSqlPrepare::build() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like