ConnectVariable::query() - Code Metrics - nystudio107/craft-connect - Measure and Improve Code Quality continuously with Scrutinizer

ConnectVariable::query() A
last analyzed 2022-10-05 19:13 UTC

↳ Parent: ConnectVariable

Complexity

Conditions	1
Paths	1

Size

Total Lines	4
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	4
rs	10
cc	1
nc	1
nop	1

<?php
/**
 * Connect plugin for Craft CMS 3.x
 *
 * Allows you to connect to external databases and perform db queries
 *
 * @link      https://nystudio107.com/

 * @copyright Copyright (c) 2018 nystudio107

 */


namespace nystudio107\connect\variables;

use nystudio107\connect\Connect;
use nystudio107\connect\db\Query;
use nystudio107\connect\models\Settings;

use Craft;

use yii\db\Connection;
use yii\db\Exception;

/**

 * @author    nystudio107

 * @package   Connect

 * @since     1.0.0

 */

class ConnectVariable
{
    // Public Methods
    // =========================================================================

    /**
     * Open a new database connection
     *
     * @param string $configName

     *
     * @return null|Connection
     */
    public function open(string $configName)
    {
        $connection = null;
        $config = $this->getDbConfig($configName);
        if (!empty($config)) {
            // Create a connection to the db
            $connection = new Connection($config);
            try {
                $connection->open();
            } catch (Exception $e) {
                Craft::error($e->getMessage(), __METHOD__);
            }
        }

        return $connection;
    }

    /**
     * Returns a new generic query.
     *
     * @param null|Connection $connection

     *
     * @return Query
     */
    public function query($connection = null): Query
    {
        return new Query([

            'db' => $connection,
        ]);
someFunctionCall(
    $firstArgument,
    $secondArgument,
    $thirdArgument
); // Closing parenthesis on a new line.
    }

    // Protected Methods
    // =========================================================================

    /**
     * Return a database config with the key $configName from the Settings
     *
     * @param string $configName

     *
     * @return array
     */
    protected function getDbConfig(string $configName): array
    {
        $config = [];
        /* @var Settings $settings */
        $settings = Connect::$plugin->getSettings();
        if ($settings !== null && !empty($settings->connections[$configName])) {
            $dbConnection = $settings->connections[$configName];
            $config = [
                'dsn' => "{$dbConnection['driver']}:"
                    ."host={$dbConnection['server']};"
                    ."dbname={$dbConnection['database']};"
                    ."port={$dbConnection['port']};",
                'username' => $dbConnection['user'],
                'password' => $dbConnection['password'],
                'tablePrefix' => $dbConnection['tablePrefix'],
            ];
        }

        return $config;
    }
}


1			<?php
2			/**
3			* Connect plugin for Craft CMS 3.x
4			*
5			* Allows you to connect to external databases and perform db queries
6			*
7			* @link https://nystudio107.com/
			0 ignored issues – show Coding Style introduced 2018-08-22 18:23 UTC by Report Bug Copy Issue Report The tag in position 1 should be the @copyright tag Loading history...
8			* @copyright Copyright (c) 2018 nystudio107
			0 ignored issues – show Coding Style introduced 2018-08-22 18:23 UTC by Report Bug Copy Issue Report @copyright tag must contain a year and the name of the copyright holder Loading history...
9			*/
			0 ignored issues – show Coding Style introduced 2018-08-22 18:23 UTC by Report Bug Copy Issue Report PHP version not specified Loading history... Coding Style introduced 2018-08-22 18:23 UTC by Report Bug Copy Issue Report Missing @category tag in file comment Loading history... Coding Style introduced 2018-08-22 18:23 UTC by Report Bug Copy Issue Report Missing @package tag in file comment Loading history... Coding Style introduced 2018-08-22 18:23 UTC by Report Bug Copy Issue Report Missing @author tag in file comment Loading history... Coding Style introduced 2018-08-22 18:23 UTC by Report Bug Copy Issue Report Missing @license tag in file comment Loading history...
10
11			namespace nystudio107\connect\variables;
12
13			use nystudio107\connect\Connect;
14			use nystudio107\connect\db\Query;
15			use nystudio107\connect\models\Settings;
16
17			use Craft;
18
19			use yii\db\Connection;
20			use yii\db\Exception;
21
22			/**
			0 ignored issues – show Coding Style introduced 2018-08-22 18:23 UTC by Report Bug Copy Issue Report Missing short description in doc comment Loading history...
23			* @author nystudio107
			0 ignored issues – show Coding Style introduced 2018-08-22 18:23 UTC by Report Bug Copy Issue Report The tag in position 1 should be the @package tag Loading history... Coding Style introduced 2018-08-22 18:23 UTC by Report Bug Copy Issue Report Content of the @author tag must be in the form "Display Name <[email protected]>" Loading history... Coding Style introduced 2019-08-21 03:08 UTC by Report Bug Copy Issue Report Tag value for @author tag indented incorrectly; expected 2 spaces but found 4 Loading history...
24			* @package Connect
			0 ignored issues – show Coding Style introduced 2019-08-21 03:08 UTC by Report Bug Copy Issue Report Tag value for @package tag indented incorrectly; expected 1 spaces but found 3 Loading history...
25			* @since 1.0.0
			0 ignored issues – show Coding Style introduced 2018-08-22 18:23 UTC by Report Bug Copy Issue Report The tag in position 3 should be the @author tag Loading history... Coding Style introduced 2019-08-21 03:08 UTC by Report Bug Copy Issue Report Tag value for @since tag indented incorrectly; expected 3 spaces but found 5 Loading history...
26			*/
			0 ignored issues – show Coding Style introduced 2018-08-22 18:23 UTC by Report Bug Copy Issue Report Missing @category tag in class comment Loading history... Coding Style introduced 2018-08-22 18:23 UTC by Report Bug Copy Issue Report Missing @license tag in class comment Loading history... Coding Style introduced 2018-08-22 18:23 UTC by Report Bug Copy Issue Report Missing @link tag in class comment Loading history...
27			class ConnectVariable
28			{
29			// Public Methods
30			// =========================================================================
31
32			/**
33			* Open a new database connection
34			*
35			* @param string $configName
			0 ignored issues – show Coding Style introduced 2018-08-22 18:23 UTC by Report Bug Copy Issue Report Missing parameter comment Loading history...
36			*
37			* @return null\|Connection
38			*/
39			public function open(string $configName)
40			{
41			$connection = null;
42			$config = $this->getDbConfig($configName);
43			if (!empty($config)) {
44			// Create a connection to the db
45			$connection = new Connection($config);
46			try {
47			$connection->open();
48			} catch (Exception $e) {
49			Craft::error($e->getMessage(), __METHOD__);
50			}
51			}
52
53			return $connection;
54			}
55
56			/**
57			* Returns a new generic query.
58			*
59			* @param null\|Connection $connection
			0 ignored issues – show Coding Style introduced 2018-08-22 18:23 UTC by Report Bug Copy Issue Report Missing parameter comment Loading history...
60			*
61			* @return Query
62			*/
63			public function query($connection = null): Query
64			{
65			return new Query([
			0 ignored issues – show Coding Style introduced 2018-08-22 18:23 UTC by Report Bug Copy Issue Report The opening parenthesis of a multi-line function call should be the last content on the line. Loading history...
66			'db' => $connection,
67			]);
			0 ignored issues – show Coding Style introduced 2018-08-22 18:23 UTC by Report Bug Copy Issue Report For multi-line function calls, the closing parenthesis should be on a new line. If a function call spawns multiple lines, the coding standard suggests to move the closing parenthesis to a new line: someFunctionCall( $firstArgument, $secondArgument, $thirdArgument ); // Closing parenthesis on a new line. Loading history...
68			}
69
70			// Protected Methods
71			// =========================================================================
72
73			/**
74			* Return a database config with the key $configName from the Settings
75			*
76			* @param string $configName
			0 ignored issues – show Coding Style introduced 2018-08-22 18:23 UTC by Report Bug Copy Issue Report Missing parameter comment Loading history...
77			*
78			* @return array
79			*/
80			protected function getDbConfig(string $configName): array
81			{
82			$config = [];
83			/* @var Settings $settings */
84			$settings = Connect::$plugin->getSettings();
85			if ($settings !== null && !empty($settings->connections[$configName])) {
86			$dbConnection = $settings->connections[$configName];
87			$config = [
88			'dsn' => "{$dbConnection['driver']}:"
89			."host={$dbConnection['server']};"
90			."dbname={$dbConnection['database']};"
91			."port={$dbConnection['port']};",
92			'username' => $dbConnection['user'],
93			'password' => $dbConnection['password'],
94			'tablePrefix' => $dbConnection['tablePrefix'],
95			];
96			}
97
98			return $config;
99			}
100			}
101

nystudio107 / craft-connect

ConnectVariable::query() A last analyzed 2022-10-05 19:13 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

ConnectVariable::query() A
last analyzed 2022-10-05 19:13 UTC