mysqlims::query() - Code Metrics - Inspection of "Merge pull request #2649 from tperalta82/master" - MPOS/php-mpos - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — development ( 9628c3...2dfe17 )

by Sebastian

created 2017-12-29 06:45 UTC

mysqlims::query() B

↳ Parent: mysqlims

Complexity

Conditions	5
Paths	2

Size

Total Lines	10
Code Lines	7

Duplication

Lines	10
Ratio	100 %

Importance

Changes

Metric	Value
dl	10
loc	10
rs	8.8571
c	0
b	0
f	0
cc	5
eloc	7
nc	2
nop	2

<?php
/*
 * This class will run queries on master/slave servers depending on the query itself.
 */
class mysqlims extends mysqli
namespace YourVendor;

class YourClass { }
{
    private $mysqliW;
    private $mysqliR = null;
    private $slave = false;
    public $lastused = null;
    
    /*
     * Pass main and slave connection arrays to the constructor, and strict as true/false
     *
     * @param array $main
     * @param array $slave
     * @param boolean $strict
     *
     * @return void

     */
    public function __construct($main, $slave = false, $strict = false)
    {
        if ($strict) {
            $this->mysqliW = new mysqli_strict($main['host'],

                $main['user'], $main['pass'],
                $main['name'], $main['port']);
            if ($slave && is_array($slave) && isset($slave['enabled']) && $slave['enabled']

                === true) {
                $this->mysqliR = new mysqli_strict($slave['host'],

                    $slave['user'], $slave['pass'],
                    $slave['name'], $slave['port']);
                $this->slave = true;
            }
        } else {
            $this->mysqliW = new mysqli($main['host'],
                $main['user'], $main['pass'],
                $main['name'], $main['port']);
            if ($slave && is_array($slave) && isset($slave['enabled']) && $slave['enabled']

                === true) {
                $this->mysqliR = new mysqli($slave['host'],
                    $slave['user'], $slave['pass'],
                    $slave['name'], $slave['port']);
                $this->slave = true;
            }
        }

        if ($this->mysqliW->connect_errno) {
            throw new Exception("Failed to connect to MySQL: (".$this->mysqliW->connect_errno.") ".$this->mysqliW->connect_error);
        }

        if ($this->slave === true && $this->mysqliR->connect_errno) {
            throw new Exception("Failed to connect to MySQL: (".$this->mysqliR->connect_errno.") ".$this->mysqliR->connect_error);
        }
    }

    /*
     * Override standard mysqli_prepare to select master/slave server
     * @param $string query
     *
     * @return mysqli_stmt
     */
    public function prepare($query)

    {
        if (stripos($query, "SELECT") && stripos($query, "FOR UPDATE") === false && stripos($query, "INSERT") === false  && $this->slave !== false) {
            $this->lastused = $this->mysqliR;
            return $this->mysqliR->prepare($query);
        } else {
            $this->lastused = $this->mysqliW;
            return $this->mysqliW->prepare($query);
        }
    }

    /*
     * Override standard mysqli_query to select master/slave server
     * @param string $query
     * @param int $resultmode
     *
     * @return boolean
     * @return mixed
     */
    public function query($query, $resultmode = MYSQLI_STORE_RESULT)

    {
        if (stripos($query, "SELECT") && stripos($query, "FOR UPDATE") === false && stripos($query, "INSERT") === false && $this->slave !== false) {/* Use readonly server */
            $this->lastused = $this->mysqliR;
            return $this->mysqliR->query($query, $resultmode);
        } else {
            $this->lastused = $this->mysqliW;
            return $this->mysqliW->query($query, $resultmode);
        }
    }
}


1		<?php
2		/*
3		* This class will run queries on master/slave servers depending on the query itself.
4		*/
5		class mysqlims extends mysqli
		0 ignored issues – show Coding Style Compatibility introduced 2017-12-08 23:04 UTC by Report Bug Copy Issue Report PSR1 recommends that each class must be in a namespace of at least one level to avoid collisions. You can fix this by adding a namespace to your class: namespace YourVendor; class YourClass { } When choosing a vendor namespace, try to pick something that is not too generic to avoid conflicts with other libraries. Loading history...
6		{
7		private $mysqliW;
8		private $mysqliR = null;
9		private $slave = false;
10		public $lastused = null;
11
12		/*
13		* Pass main and slave connection arrays to the constructor, and strict as true/false
14		*
15		* @param array $main
16		* @param array $slave
17		* @param boolean $strict
18		*
19		* @return void
		0 ignored issues – show Comprehensibility Best Practice introduced 2017-12-08 23:04 UTC by Report Bug Copy Issue Report Adding a `@return` annotation to constructors is generally not recommended as a constructor does not have a meaningful return value. Adding a `@return` annotation to a constructor is not recommended, since a constructor does not have a meaningful return value. Please refer to the PHP core documentation on constructors. Loading history...
20		*/
21		public function __construct($main, $slave = false, $strict = false)
22		{
23		if ($strict) {
24		$this->mysqliW = new mysqli_strict($main['host'],
		0 ignored issues – show Unused Code introduced 2017-12-08 23:04 UTC by Report Bug Copy Issue Report The call to `mysqli_strict::__construct()` has too many arguments starting with `$main['host']`. This check compares calls to functions or methods with their respective definitions. If the call has more arguments than are defined, it raises an issue. If a function is defined several times with a different number of parameters, the check may pick up the wrong definition and report false positives. One codebase where this has been known to happen is Wordpress. In this case you can add the `@ignore` PhpDoc annotation to the duplicate definition and it will be ignored. Loading history...
25		$main['user'], $main['pass'],
26		$main['name'], $main['port']);
27	View Code Duplication	if ($slave && is_array($slave) && isset($slave['enabled']) && $slave['enabled']
		0 ignored issues – show Duplication introduced 2017-12-08 23:04 UTC by Report Bug Copy Issue Report This code seems to be duplicated across your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
28		=== true) {
29		$this->mysqliR = new mysqli_strict($slave['host'],
		0 ignored issues – show Unused Code introduced 2017-12-08 23:04 UTC by Report Bug Copy Issue Report The call to `mysqli_strict::__construct()` has too many arguments starting with `$slave['host']`. This check compares calls to functions or methods with their respective definitions. If the call has more arguments than are defined, it raises an issue. If a function is defined several times with a different number of parameters, the check may pick up the wrong definition and report false positives. One codebase where this has been known to happen is Wordpress. In this case you can add the `@ignore` PhpDoc annotation to the duplicate definition and it will be ignored. Loading history...
30		$slave['user'], $slave['pass'],
31		$slave['name'], $slave['port']);
32		$this->slave = true;
33		}
34		} else {
35		$this->mysqliW = new mysqli($main['host'],
36		$main['user'], $main['pass'],
37		$main['name'], $main['port']);
38	View Code Duplication	if ($slave && is_array($slave) && isset($slave['enabled']) && $slave['enabled']
		0 ignored issues – show Duplication introduced 2017-12-08 23:04 UTC by Report Bug Copy Issue Report This code seems to be duplicated across your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
39		=== true) {
40		$this->mysqliR = new mysqli($slave['host'],
41		$slave['user'], $slave['pass'],
42		$slave['name'], $slave['port']);
43		$this->slave = true;
44		}
45		}
46
47		if ($this->mysqliW->connect_errno) {
48		throw new Exception("Failed to connect to MySQL: (".$this->mysqliW->connect_errno.") ".$this->mysqliW->connect_error);
49		}
50
51		if ($this->slave === true && $this->mysqliR->connect_errno) {
52		throw new Exception("Failed to connect to MySQL: (".$this->mysqliR->connect_errno.") ".$this->mysqliR->connect_error);
53		}
54		}
55
56		/*
57		* Override standard mysqli_prepare to select master/slave server
58		* @param $string query
59		*
60		* @return mysqli_stmt
61		*/
62	View Code Duplication	public function prepare($query)
		0 ignored issues – show Duplication introduced 2017-12-08 23:04 UTC by Report Bug Copy Issue Report This method seems to be duplicated in your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
63		{
64		if (stripos($query, "SELECT") && stripos($query, "FOR UPDATE") === false && stripos($query, "INSERT") === false && $this->slave !== false) {
65		$this->lastused = $this->mysqliR;
66		return $this->mysqliR->prepare($query);
67		} else {
68		$this->lastused = $this->mysqliW;
69		return $this->mysqliW->prepare($query);
70		}
71		}
72
73		/*
74		* Override standard mysqli_query to select master/slave server
75		* @param string $query
76		* @param int $resultmode
77		*
78		* @return boolean
79		* @return mixed
80		*/
81	View Code Duplication	public function query($query, $resultmode = MYSQLI_STORE_RESULT)
		0 ignored issues – show Duplication introduced 2017-12-08 23:04 UTC by Report Bug Copy Issue Report This method seems to be duplicated in your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
82		{
83		if (stripos($query, "SELECT") && stripos($query, "FOR UPDATE") === false && stripos($query, "INSERT") === false && $this->slave !== false) {/* Use readonly server */
84		$this->lastused = $this->mysqliR;
85		return $this->mysqliR->query($query, $resultmode);
86		} else {
87		$this->lastused = $this->mysqliW;
88		return $this->mysqliW->query($query, $resultmode);
89		}
90		}
91		}
92

MPOS / php-mpos

Push — development ( 9628c3...2dfe17 )

mysqlims::query() B

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like