DbStorage::setValue() - Code Metrics - Inspection of "Upload Scrutinizer coverage" - LAV45/yii2-settings - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( f4169b...5ce74f )

by Loban

created 2024-11-23 17:03 UTC

DbStorage::setValue() A

↳ Parent: DbStorage

Complexity

Conditions	3
Paths	4

Size

Total Lines	20
Code Lines	14

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	9
CRAP Score	3.2621

Importance

Changes	3
Bugs	0	Features	0

Metric	Value
cc	3
eloc	14
nc	4
nop	2
dl	0
loc	20
ccs	9
cts	13
cp	0.6923
crap	3.2621
rs	9.7998
c	3
b	0
f	0

<?php
/**
 * @link https://github.com/lav45/yii2-settings
 * @copyright Copyright (c) 2016 LAV45
 * @author Alexey Loban <[email protected]>
 * @license http://opensource.org/licenses/BSD-3-Clause
 */

namespace lav45\settings\storage;

use Yii;
use yii\db\Query;
use yii\db\Connection;
use yii\di\Instance;
use yii\base\BaseObject;

/**
 * Class DbStorage
 * @package lav45\settings\storage
 */
class DbStorage extends BaseObject implements StorageInterface
{
    /**
     * @var Connection|array|string
     */
    public $db = 'db';
    /**
     * @var string
     */
    public $tableName = '{{%settings}}';

    /**
     * Initializes the application component.
     */
    public function init()
    {
        parent::init();
        $this->db = Instance::ensure($this->db, Connection::class);
    }

    /**
     * @param string $key
     * @return false|null|string
     */
    public function getValue($key)
    {
        return (new Query())
            ->select(['data'])
            ->from($this->tableName)
            ->where(['id' => $key])
            ->limit(1)
            ->createCommand($this->db)
            ->queryScalar();
    }

    /**
     * @param string $key
     * @param string $value
     * @return bool
     */
    public function setValue($key, $value)
    {
        $exists = (new Query())
            ->from($this->tableName)
            ->where(['id' => $key])
            ->exists($this->db);

        $query = (new Query())->createCommand($this->db);

        try {
            if ($exists) {
                $query->update($this->tableName, ['data' => $value], ['id' => $key])->execute();
            } else {
                $query->insert($this->tableName, ['id' => $key, 'data' => $value])->execute();
            }
        } catch (\Exception $e) {
            Yii::error(get_class($e) . '[' . $e->getCode() . '] ' . $e->getMessage());
            return false;
        }
        return true;
    }

    /**
     * @param string $key
     * @return bool
     */
    public function deleteValue($key)
    {
        $result = (new Query())->createCommand($this->db)
            ->delete($this->tableName, ['id' => $key])
            ->execute();

        return $result > 0;
    }
}


1		<?php
2		/**
3		* @link https://github.com/lav45/yii2-settings
4		* @copyright Copyright (c) 2016 LAV45
5		* @author Alexey Loban <[email protected]>
6		* @license http://opensource.org/licenses/BSD-3-Clause
7		*/
8
9		namespace lav45\settings\storage;
10
11		use Yii;
12		use yii\db\Query;
13		use yii\db\Connection;
14		use yii\di\Instance;
15		use yii\base\BaseObject;
16
17		/**
18		* Class DbStorage
19		* @package lav45\settings\storage
20		*/
21		class DbStorage extends BaseObject implements StorageInterface
22		{
23		/**
24		* @var Connection\|array\|string
25		*/
26		public $db = 'db';
27		/**
28		* @var string
29		*/
30		public $tableName = '{{%settings}}';
31
32		/**
33		* Initializes the application component.
34		*/
35	1	public function init()
36		{
37	1	parent::init();
38	1	$this->db = Instance::ensure($this->db, Connection::class);
39	1	}
40
41		/**
42		* @param string $key
43		* @return false\|null\|string
44		*/
45	1	public function getValue($key)
46		{
47	1	return (new Query())
48	1	->select(['data'])
49	1	->from($this->tableName)
50	1	->where(['id' => $key])
51	1	->limit(1)
52	1	->createCommand($this->db)
53	1	->queryScalar();
54		}
55
56		/**
57		* @param string $key
58		* @param string $value
59		* @return bool
60		*/
61	1	public function setValue($key, $value)
62		{
63	1	$exists = (new Query())
64	1	->from($this->tableName)
65	1	->where(['id' => $key])
66	1	->exists($this->db);
67
68	1	$query = (new Query())->createCommand($this->db);
69
70		try {
71	1	if ($exists) {
72		$query->update($this->tableName, ['data' => $value], ['id' => $key])->execute();
73		} else {
74	1	$query->insert($this->tableName, ['id' => $key, 'data' => $value])->execute();
75		}
76		} catch (\Exception $e) {
77		Yii::error(get_class($e) . '[' . $e->getCode() . '] ' . $e->getMessage());
78		return false;
79		}
80	1	return true;
81		}
82
83		/**
84		* @param string $key
85		* @return bool
86		*/
87	1	public function deleteValue($key)
88		{
89	1	$result = (new Query())->createCommand($this->db)
90	1	->delete($this->tableName, ['id' => $key])
91	1	->execute();
92
93	1	return $result > 0;
94		}
95		}
96

LAV45 / yii2-settings

Push — master ( f4169b...5ce74f )

DbStorage::setValue() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like