ActiveRecordModel::checkDb() - Code Metrics - Inspection of "made pass tests" - canax/database - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( 76c092...6f3180 )

by Mikael

created 2017-09-05 11:10 UTC

ActiveRecordModel::checkDb() A

↳ Parent: ActiveRecordModel

Complexity

Conditions	2
Paths	2

Size

Total Lines	6
Code Lines	3

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	6

Importance

Changes

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

<?php

namespace Anax\Database;

use \Anax\Database\DatabaseQueryBuilder;
use \Anax\Database\Exception\ActiveRecordException;

/**
 * An implementation of the Active Record pattern to be used as
 * base class for database driven models.
 */
class ActiveRecordModel
{
    /**
     * @var DatabaseQueryBuilder $db the object for persistent
     *                               storage.
     */
    protected $db = null;

    /**
     * @var string $tableName name of the database table.
     */
    protected $tableName = null;



    /**
     * Set the database object to use for accessing storage.
     *
     * @param DatabaseQueryBuilder $db as database access object.
     *
     * @return void
     */
    public function setDb(DatabaseQueryBuilder $db)
    {
        $this->db = $db;
    }



    /**
     * Check if database is injected or throw an exception.
     *
     * @throws ActiveRecordException when database is not set.
     *
     * @return void
     */
    protected function checkDb()
    {
        if (!$this->db) {
            throw new ActiveRecordException("Missing \$db, did you forget to inject/set is?");
        }
    }



    /**
     * Get essential object properties.
     *
     * @return array with object properties.
     */
    private function getProperties()
    {
        $properties = get_object_vars($this);
        unset($properties['tableName']);
        unset($properties['db']);
        unset($properties['di']);
        return $properties;
    }



    /**
     * Find and return first object found by search criteria and use
     * its data to populate this instance.
     *
     * @param string $column to use in where statement.
     * @param mixed  $value  to use in where statement.
     *
     * @return this
     */
    public function find($column, $value)
    {
        $this->checkDb();
        return $this->db->connect()
                        ->select()
                        ->from($this->tableName)
                        ->where("$column = ?")
                        ->execute([$value])
function acceptsInteger($int) { }

$x = '123'; // string "123"

// Instead of
acceptsInteger($x);

// we recommend to use
acceptsInteger((integer) $x);
                        ->fetchInto($this);
    }



    /**
     * Find and return all.
     *
     * @return array
     */
    public function findAll()
    {
        $this->checkDb();
        return $this->db->connect()
                        ->select()
                        ->from($this->tableName)
                        ->execute()
                        ->fetchAllClass(get_class($this));
function acceptsInteger($int) { }

$x = '123'; // string "123"

// Instead of
acceptsInteger($x);

// we recommend to use
acceptsInteger((integer) $x);
    }



    /**
     * Save current object/row, insert if id is missing and do an
     * update if the id exists.
     *
     * @return void
     */
    public function save()
    {
        if (isset($this->id)) {
            return $this->update();
        }

        return $this->create();
    }



    /**
     * Create new row.
     *
     * @return void
     */
    private function create()

    {
        $this->checkDb();
        $properties = $this->getProperties();
        unset($properties['id']);
        $columns = array_keys($properties);
        $values  = array_values($properties);

        $this->db->connect()
                 ->insert($this->tableName, $columns)
                 ->execute($values);
function acceptsInteger($int) { }

$x = '123'; // string "123"

// Instead of
acceptsInteger($x);

// we recommend to use
acceptsInteger((integer) $x);

        $this->id = $this->db->lastInsertId();
class MyClass { }

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



    /**
     * Update row.
     *
     * @return void
     */
    private function update()

    {
        $this->checkDb();
        $properties = $this->getProperties();
        unset($properties['id']);
        $columns = array_keys($properties);
        $values  = array_values($properties);
        $values[] = $this->id;

        $this->db->connect()
                 ->update($this->tableName, $columns)
                 ->where("id = ?")
                 ->execute($values);
function acceptsInteger($int) { }

$x = '123'; // string "123"

// Instead of
acceptsInteger($x);

// we recommend to use
acceptsInteger((integer) $x);
    }



    /**
     * Delete row.
     *
     * @param integer $id to delete or use $this->id as default.
     *
     * @return void
     */
    public function delete($id = null)
    {
        $this->checkDb();
        $id = $id ?: $this->id;

        $this->db->connect()
                 ->deleteFrom($this->tableName)
                 ->where("id = ?")
                 ->execute([$id]);
function acceptsInteger($int) { }

$x = '123'; // string "123"

// Instead of
acceptsInteger($x);

// we recommend to use
acceptsInteger((integer) $x);

        $this->id = null;
    }
}


1		<?php
2
3		namespace Anax\Database;
4
5		use \Anax\Database\DatabaseQueryBuilder;
6		use \Anax\Database\Exception\ActiveRecordException;
7
8		/**
9		* An implementation of the Active Record pattern to be used as
10		* base class for database driven models.
11		*/
12		class ActiveRecordModel
13		{
14		/**
15		* @var DatabaseQueryBuilder $db the object for persistent
16		* storage.
17		*/
18		protected $db = null;
19
20		/**
21		* @var string $tableName name of the database table.
22		*/
23		protected $tableName = null;
24
25
26
27		/**
28		* Set the database object to use for accessing storage.
29		*
30		* @param DatabaseQueryBuilder $db as database access object.
31		*
32		* @return void
33		*/
34		public function setDb(DatabaseQueryBuilder $db)
35		{
36		$this->db = $db;
37		}
38
39
40
41		/**
42		* Check if database is injected or throw an exception.
43		*
44		* @throws ActiveRecordException when database is not set.
45		*
46		* @return void
47		*/
48		protected function checkDb()
49		{
50		if (!$this->db) {
51		throw new ActiveRecordException("Missing \$db, did you forget to inject/set is?");
52		}
53		}
54
55
56
57		/**
58		* Get essential object properties.
59		*
60		* @return array with object properties.
61		*/
62		private function getProperties()
63		{
64		$properties = get_object_vars($this);
65		unset($properties['tableName']);
66		unset($properties['db']);
67		unset($properties['di']);
68		return $properties;
69		}
70
71
72
73		/**
74		* Find and return first object found by search criteria and use
75		* its data to populate this instance.
76		*
77		* @param string $column to use in where statement.
78		* @param mixed $value to use in where statement.
79		*
80		* @return this
81		*/
82		public function find($column, $value)
83		{
84		$this->checkDb();
85		return $this->db->connect()
86		->select()
87		->from($this->tableName)
88		->where("$column = ?")
89		->execute([$value])
		0 ignored issues – show Documentation introduced 2017-09-05 11:11 UTC by Report Bug Copy Issue Report `array($value)` is of type `array<integer,,{"0":""}>`, but the function expects a `string\|null`. It seems like the type of the argument is not accepted by the function/method which you are calling. In some cases, in particular if PHP’s automatic type-juggling kicks in this might be fine. In other cases, however this might be a bug. We suggest to add an explicit type cast like in the following example: function acceptsInteger($int) { } $x = '123'; // string "123" // Instead of acceptsInteger($x); // we recommend to use acceptsInteger((integer) $x); Loading history...
90		->fetchInto($this);
91		}
92
93
94
95		/**
96		* Find and return all.
97		*
98		* @return array
99		*/
100		public function findAll()
101		{
102		$this->checkDb();
103		return $this->db->connect()
104		->select()
105		->from($this->tableName)
106		->execute()
107		->fetchAllClass(get_class($this));
		0 ignored issues – show Documentation introduced 2017-09-05 11:11 UTC by Report Bug Copy Issue Report `get_class($this)` is of type `string`, but the function expects a `object`. It seems like the type of the argument is not accepted by the function/method which you are calling. In some cases, in particular if PHP’s automatic type-juggling kicks in this might be fine. In other cases, however this might be a bug. We suggest to add an explicit type cast like in the following example: function acceptsInteger($int) { } $x = '123'; // string "123" // Instead of acceptsInteger($x); // we recommend to use acceptsInteger((integer) $x); Loading history...
108		}
109
110
111
112		/**
113		* Save current object/row, insert if id is missing and do an
114		* update if the id exists.
115		*
116		* @return void
117		*/
118		public function save()
119		{
120		if (isset($this->id)) {
121		return $this->update();
122		}
123
124		return $this->create();
125		}
126
127
128
129		/**
130		* Create new row.
131		*
132		* @return void
133		*/
134	View Code Duplication	private function create()
		0 ignored issues – show Duplication introduced 2017-08-30 06:06 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...
135		{
136		$this->checkDb();
137		$properties = $this->getProperties();
138		unset($properties['id']);
139		$columns = array_keys($properties);
140		$values = array_values($properties);
141
142		$this->db->connect()
143		->insert($this->tableName, $columns)
144		->execute($values);
		0 ignored issues – show Documentation introduced 2017-09-05 11:11 UTC by Report Bug Copy Issue Report `$values` is of type `array<integer,?>`, but the function expects a `string\|null`. It seems like the type of the argument is not accepted by the function/method which you are calling. In some cases, in particular if PHP’s automatic type-juggling kicks in this might be fine. In other cases, however this might be a bug. We suggest to add an explicit type cast like in the following example: function acceptsInteger($int) { } $x = '123'; // string "123" // Instead of acceptsInteger($x); // we recommend to use acceptsInteger((integer) $x); Loading history...
145
146		$this->id = $this->db->lastInsertId();
		0 ignored issues – show Bug introduced 2017-08-30 06:06 UTC by Report Bug Copy Issue Report The property `id` 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...
147		}
148
149
150
151		/**
152		* Update row.
153		*
154		* @return void
155		*/
156	View Code Duplication	private function update()
		0 ignored issues – show Duplication introduced 2017-09-05 11:11 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...
157		{
158		$this->checkDb();
159		$properties = $this->getProperties();
160		unset($properties['id']);
161		$columns = array_keys($properties);
162		$values = array_values($properties);
163		$values[] = $this->id;
164
165		$this->db->connect()
166		->update($this->tableName, $columns)
167		->where("id = ?")
168		->execute($values);
		0 ignored issues – show Documentation introduced 2017-09-05 11:11 UTC by Report Bug Copy Issue Report `$values` is of type `array<integer,?>`, but the function expects a `string\|null`. It seems like the type of the argument is not accepted by the function/method which you are calling. In some cases, in particular if PHP’s automatic type-juggling kicks in this might be fine. In other cases, however this might be a bug. We suggest to add an explicit type cast like in the following example: function acceptsInteger($int) { } $x = '123'; // string "123" // Instead of acceptsInteger($x); // we recommend to use acceptsInteger((integer) $x); Loading history...
169		}
170
171
172
173		/**
174		* Delete row.
175		*
176		* @param integer $id to delete or use $this->id as default.
177		*
178		* @return void
179		*/
180		public function delete($id = null)
181		{
182		$this->checkDb();
183		$id = $id ?: $this->id;
184
185		$this->db->connect()
186		->deleteFrom($this->tableName)
187		->where("id = ?")
188		->execute([$id]);
		0 ignored issues – show Documentation introduced 2017-09-05 11:11 UTC by Report Bug Copy Issue Report `array($id)` is of type `array<integer,?,{"0":"?"}>`, but the function expects a `string\|null`. It seems like the type of the argument is not accepted by the function/method which you are calling. In some cases, in particular if PHP’s automatic type-juggling kicks in this might be fine. In other cases, however this might be a bug. We suggest to add an explicit type cast like in the following example: function acceptsInteger($int) { } $x = '123'; // string "123" // Instead of acceptsInteger($x); // we recommend to use acceptsInteger((integer) $x); Loading history...
189
190		$this->id = null;
191		}
192		}
193

canax / database

Push — master ( 76c092...6f3180 )

ActiveRecordModel::checkDb() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like