Pgsql::genDsn() - Code Metrics - drmvc/database - Measure and Improve Code Quality continuously with Scrutinizer

Pgsql::genDsn() A
last analyzed 2018-07-18 10:28 UTC

↳ Parent: Pgsql

Complexity

Conditions	3
Paths	3

Size

Total Lines	14
Code Lines	6

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
eloc	6
dl	0
loc	14
c	0
b	0
f	0
rs	10
cc	3
nc	3
nop	1

<?php

namespace DrMVC\Database\Drivers;

/**
 * Wrapper of PDO for work with PgSQL databases
 *
 * @package DrMVC\Database\Drivers
 * @since   3.0
 */
class Pgsql extends SQL
{
    const DEFAULT_HOST = '127.0.0.1';
    const DEFAULT_PORT = '5432';

    /**
     * @link https://secure.php.net/manual/en/ref.pdo-pgsql.connection.php
     * @link https://www.postgresql.org/docs/8.3/static/libpq-connect.html
     *
     * The PDO_PGSQL Data Source Name (DSN) is composed of the following elements:
     */
    const AVAILABLE_OPTIONS = [
        'host',
        'hostaddr',
        'port',
        'dbname',

        /**
         * These two parameters below is not needed, because we can put user/pass
         * as parameters of PDO class, you can read more by link
         * @link https://secure.php.net/manual/en/pdo.construct.php
         */
        //'user',
        //'password',

        'passfile',
        'connect_timeout',
        'client_encoding',
        'options',
        'application_name',
        'fallback_application_name',
        'keepalives',
        'keepalives_idle',
        'keepalives_interval',
        'keepalives_count',
        'tty',
        'sslmode',
        'requiressl',
        'sslcompression',
        'sslcert',
        'sslkey',
        'sslrootcert',
        'sslcrl',
        'requirepeer',
        'krbsrvname',
        'gsslib',
        'service',
        'target_session_attrs'
    ];

    /**
     * Generate DSN by parameters in config
     *
     * @param   array $config
     * @return  string
     */
    public function genDsn($config): string
    {
        // Parse config
        $dsn = '';
        foreach ($config as $key => $value) {
            if (\in_array($key, self::AVAILABLE_OPTIONS, false)) {
                $dsn .= "$key=$value;";
            }
        }

        // Get driver of connection
        $driver = strtolower($config['driver']);

        return "$driver:$dsn";
    }
}


1			<?php
2
3			namespace DrMVC\Database\Drivers;
4
5			/**
6			* Wrapper of PDO for work with PgSQL databases
7			*
8			* @package DrMVC\Database\Drivers
9			* @since 3.0
10			*/
11			class Pgsql extends SQL
12			{
13			const DEFAULT_HOST = '127.0.0.1';
14			const DEFAULT_PORT = '5432';
15
16			/**
17			* @link https://secure.php.net/manual/en/ref.pdo-pgsql.connection.php
18			* @link https://www.postgresql.org/docs/8.3/static/libpq-connect.html
19			*
20			* The PDO_PGSQL Data Source Name (DSN) is composed of the following elements:
21			*/
22			const AVAILABLE_OPTIONS = [
23			'host',
24			'hostaddr',
25			'port',
26			'dbname',
27
28			/**
29			* These two parameters below is not needed, because we can put user/pass
30			* as parameters of PDO class, you can read more by link
31			* @link https://secure.php.net/manual/en/pdo.construct.php
32			*/
33			//'user',
34			//'password',
35
36			'passfile',
37			'connect_timeout',
38			'client_encoding',
39			'options',
40			'application_name',
41			'fallback_application_name',
42			'keepalives',
43			'keepalives_idle',
44			'keepalives_interval',
45			'keepalives_count',
46			'tty',
47			'sslmode',
48			'requiressl',
49			'sslcompression',
50			'sslcert',
51			'sslkey',
52			'sslrootcert',
53			'sslcrl',
54			'requirepeer',
55			'krbsrvname',
56			'gsslib',
57			'service',
58			'target_session_attrs'
59			];
60
61			/**
62			* Generate DSN by parameters in config
63			*
64			* @param array $config
65			* @return string
66			*/
67			public function genDsn($config): string
68			{
69			// Parse config
70			$dsn = '';
71			foreach ($config as $key => $value) {
72			if (\in_array($key, self::AVAILABLE_OPTIONS, false)) {
73			$dsn .= "$key=$value;";
74			}
75			}
76
77			// Get driver of connection
78			$driver = strtolower($config['driver']);
79
80			return "$driver:$dsn";
81			}
82			}
83

drmvc / database

Pgsql::genDsn() A last analyzed 2018-07-18 10:28 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

Pgsql::genDsn() A
last analyzed 2018-07-18 10:28 UTC