DSN::isSQLite() - Code Metrics - gamernetwork/yolk-database - Measure and Improve Code Quality continuously with Scrutinizer

DSN::isSQLite() A
last analyzed 2016-05-18 08:44 UTC

↳ Parent: DSN

Complexity

Conditions	1
Paths	1

Size

Total Lines	3
Code Lines	2

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

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

<?php
/*
 * This file is part of Yolk - Gamer Network's PHP Framework.
 *
 * Copyright (c) 2014 Gamer Network Ltd.
 * 
 * Distributed under the MIT License, a copy of which is available in the
 * LICENSE file that was bundled with this package, or online at:
 * https://github.com/gamernetwork/yolk-database
 */

namespace yolk\database;

use yolk\database\exceptions\ConfigurationException;

/**
 * Describes database connection details.
 *
 * @property-read string $type type of database being connected to
 * @property-read string $host hostname or ip address of database server
 * @property-read string $port network port to connect on
 * @property-read string $user user name used for authentication
 * @property-read string $pass password used for authentication
 * @property-read string $db   name of the database schema to use
 * @property-read array  $options array of database specific options
 */
class DSN {

	const TYPE_MYSQL  = 'mysql';
	const TYPE_PGSQL  = 'pgsql';
	const TYPE_SQLITE = 'sqlite';

	protected $config;

	public static function fromString( $config ) {

		// parse the string into some components
		$parts = parse_url(urldecode((string) $config));

		// no point continuing if it went wrong
		if( !$parts || empty($parts['scheme']) )
			throw new ConfigurationException('Invalid DSN string: '. $config);

		// use a closure to save loads of duplicate logic
		$select = function( $k, array $arr ) {
			return isset($arr[$k]) ? $arr[$k] : null;
		};

		// construct a well-formed array from the available components
		$config = array(
			'type'    => $select('scheme', $parts),
			'host'    => $select('host', $parts),
			'port'    => $select('port', $parts),
			'user'    => $select('user', $parts),
			'pass'    => $select('pass', $parts),
			'db'      => trim($select('path', $parts), '/'),
			'options' => [],
		);

		if( isset($parts['query']) ) {
			parse_str($parts['query'], $config['options']);
		}

		return new static($config);

	}

	public static function fromJSON( $config ) {

		$config = json_decode($config, true);

		if( !$config )
			throw new ConfigurationException('Invalid JSON configuration');

		return new static($config);

	}

	/**
	 * Create a DSN from an array of parameters.
	 * scheme - type of database (mysql, pgsql, sqlite) required
	 * host - hostname of database server
	 * port - network port to connect on
	 * user - user to connect as
	 * pass - user's password
	 * db - name of the database schema to connect to
	 * options - an array of database specific options
	 * @param array $dsn
/**
 * @param array $germany
 * @param array $island
 * @param array $italy
 */
function finale($germany, $island) {
    return "2:1";
}
	 */
	public function __construct( array $config ) {

		if( empty($config['type']) )
			throw new ConfigurationException('No database type specified');

		$config = $config + array(
			'host'    => 'localhost',
			'port'    => null,
			'user'    => null,
			'pass'    => null,
			'db'      => null,
			'options' => [],
		);

		$this->configure($config);

	}

	public function isMySQL() {
		return $this->config['type'] == static::TYPE_MYSQL;
	}

	public function isPgSQL() {
		return $this->config['type'] == static::TYPE_PGSQL;
	}

	public function isSQLite() {
		return $this->config['type'] == static::TYPE_SQLITE;
	}

	/**
	 * Dynamic property access.
	 * @param  string $key
	 * @return mixed
	 */
	public function __get( $key ) {
		return isset($this->config[$key]) ? $this->config[$key] : null;
	}

	/**
	 * Dynamic property access.
	 * @param  string  $key
	 * @return boolean
	 */
	public function __isset( $key ) {
		return isset($this->config[$key]);
	}

	/**
	 * Convert the DSN into a URI-type string.
	 * @return string
	 */
	public function toString() {

		$str = $this->config['type']. '://';

		if( $this->config['user'] ) {

			$str .= $this->config['user'];
			if( $this->config['pass'] )
				$str .= ':'. $this->config['pass'];
			$str .= '@';
		}

		if( $this->config['host'] ) {

			$str .= $this->config['host'];
			if( $this->config['port'] )
				$str .= ':'. $this->config['port'];
		}

		$str .= '/'. $this->config['db'];

		if( $this->config['options'] ) {
			$str .= '?';
			foreach( $this->config['options'] as $k => $v ) {
				$str .= "$k=>$v&";
			}
			$str = substr($str, 0, -1);
		}

		return $str;

	}

	/**
	 * Return a connection string for use by PDO.
	 * @return string
	 */
	public function getConnectionString() {
		return $this->config['pdo'];
	}

	/**
	 * Ensure the dsn configuration is valid.
	 * @param  array  $config
	 * @return void
	 */
	protected function configure( array $config ) {

		if( !$config['db'] )
			throw new ConfigurationException('No database schema specified');

		switch( $config['type'] ) {

			case static::TYPE_MYSQL:
				$this->config = $this->configureMySQL($config);
				break;

			case static::TYPE_PGSQL:
				$this->config = $this->configureMySQL($config);
				break;

			case static::TYPE_SQLITE:
				$this->config = $this->configureMySQL($config);
				break;

			default:
				throw new ConfigurationException('Invalid database type: '. $config['type']);

		}

	}

	/**
	 * Configure a MySQL DSN.
	 * @param  array  $config
	 * @return array
	 */
	protected function configureMySQL( array $config ) {

		
		if( !$config['port'] )
			$config['port'] = 3306;

		// construct a MySQL PDO connection string
		$config['pdo'] = sprintf(
			"mysql:host=%s;port=%s;dbname=%s",
			$config['host'],
			$config['port'],
			$config['db']
		);

		return $config;

	}

	/**
	 * Configure a PostgreSQL DSN.
	 * @param  array  $config
	 * @return array
	 */
	protected function configurePgSQL( array $config ) {

		
		if( !$config['port'] )
			$config['port'] = 5432;

		// construct a PgSQL PDO connection string
		$config['pdo'] = sprintf(
			"pgsql:host=%s;port=%s;dbname=%s",
			$config['host'],
			$config['port'],
			$config['db']
		);

		return $config;

	}

	/**
	 * Configure a SQLite DSN.
	 * @param  array  $config
	 * @return array
	 */
	protected function configureSQLite( array $config ) {

		// these should always be null as they're invalid for SQLite connections
		$config['host'] = 'localhost';
		$config['port'] = null;
		$config['user'] = null;
		$config['pass'] = null;

		// construct a SQLite PDO connection string
		$config['pdo'] = sprintf(
			'sqlite::%s',
			$config['db']
		);

		return $config;

	}

}

// EOF

1		<?php
2		/*
3		* This file is part of Yolk - Gamer Network's PHP Framework.
4		*
5		* Copyright (c) 2014 Gamer Network Ltd.
6		*
7		* Distributed under the MIT License, a copy of which is available in the
8		* LICENSE file that was bundled with this package, or online at:
9		* https://github.com/gamernetwork/yolk-database
10		*/
11
12		namespace yolk\database;
13
14		use yolk\database\exceptions\ConfigurationException;
15
16		/**
17		* Describes database connection details.
18		*
19		* @property-read string $type type of database being connected to
20		* @property-read string $host hostname or ip address of database server
21		* @property-read string $port network port to connect on
22		* @property-read string $user user name used for authentication
23		* @property-read string $pass password used for authentication
24		* @property-read string $db name of the database schema to use
25		* @property-read array $options array of database specific options
26		*/
27		class DSN {
28
29		const TYPE_MYSQL = 'mysql';
30		const TYPE_PGSQL = 'pgsql';
31		const TYPE_SQLITE = 'sqlite';
32
33		protected $config;
34
35		public static function fromString( $config ) {
36
37		// parse the string into some components
38		$parts = parse_url(urldecode((string) $config));
39
40		// no point continuing if it went wrong
41		if( !$parts \|\| empty($parts['scheme']) )
42		throw new ConfigurationException('Invalid DSN string: '. $config);
43
44		// use a closure to save loads of duplicate logic
45		$select = function( $k, array $arr ) {
46		return isset($arr[$k]) ? $arr[$k] : null;
47		};
48
49		// construct a well-formed array from the available components
50		$config = array(
51		'type' => $select('scheme', $parts),
52		'host' => $select('host', $parts),
53		'port' => $select('port', $parts),
54		'user' => $select('user', $parts),
55		'pass' => $select('pass', $parts),
56		'db' => trim($select('path', $parts), '/'),
57		'options' => [],
58		);
59
60		if( isset($parts['query']) ) {
61		parse_str($parts['query'], $config['options']);
62		}
63
64		return new static($config);
65
66		}
67
68		public static function fromJSON( $config ) {
69
70		$config = json_decode($config, true);
71
72		if( !$config )
73		throw new ConfigurationException('Invalid JSON configuration');
74
75		return new static($config);
76
77		}
78
79		/**
80		* Create a DSN from an array of parameters.
81		* scheme - type of database (mysql, pgsql, sqlite) required
82		* host - hostname of database server
83		* port - network port to connect on
84		* user - user to connect as
85		* pass - user's password
86		* db - name of the database schema to connect to
87		* options - an array of database specific options
88		* @param array $dsn
		0 ignored issues – show Bug introduced 2016-02-25 17:13 UTC by Report Bug Copy Issue Report There is no parameter named `$dsn`. Was it maybe removed? This check looks for PHPDoc comments describing methods or function parameters that do not exist on the corresponding method or function. Consider the following example. The parameter `$italy` is not defined by the method `finale(...)`. /** * @param array $germany * @param array $island * @param array $italy */ function finale($germany, $island) { return "2:1"; } The most likely cause is that the parameter was removed, but the annotation was not. Loading history...
89		*/
90		public function __construct( array $config ) {
91
92		if( empty($config['type']) )
93		throw new ConfigurationException('No database type specified');
94
95		$config = $config + array(
96		'host' => 'localhost',
97		'port' => null,
98		'user' => null,
99		'pass' => null,
100		'db' => null,
101		'options' => [],
102		);
103
104		$this->configure($config);
105
106		}
107
108		public function isMySQL() {
109		return $this->config['type'] == static::TYPE_MYSQL;
110		}
111
112		public function isPgSQL() {
113		return $this->config['type'] == static::TYPE_PGSQL;
114		}
115
116		public function isSQLite() {
117		return $this->config['type'] == static::TYPE_SQLITE;
118		}
119
120		/**
121		* Dynamic property access.
122		* @param string $key
123		* @return mixed
124		*/
125		public function __get( $key ) {
126		return isset($this->config[$key]) ? $this->config[$key] : null;
127		}
128
129		/**
130		* Dynamic property access.
131		* @param string $key
132		* @return boolean
133		*/
134		public function __isset( $key ) {
135		return isset($this->config[$key]);
136		}
137
138		/**
139		* Convert the DSN into a URI-type string.
140		* @return string
141		*/
142		public function toString() {
143
144		$str = $this->config['type']. '://';
145
146	View Code Duplication	if( $this->config['user'] ) {
		0 ignored issues – show Duplication introduced 2016-02-25 17:13 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...
147		$str .= $this->config['user'];
148		if( $this->config['pass'] )
149		$str .= ':'. $this->config['pass'];
150		$str .= '@';
151		}
152
153	View Code Duplication	if( $this->config['host'] ) {
		0 ignored issues – show Duplication introduced 2016-02-25 17:13 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...
154		$str .= $this->config['host'];
155		if( $this->config['port'] )
156		$str .= ':'. $this->config['port'];
157		}
158
159		$str .= '/'. $this->config['db'];
160
161		if( $this->config['options'] ) {
162		$str .= '?';
163		foreach( $this->config['options'] as $k => $v ) {
164		$str .= "$k=>$v&";
165		}
166		$str = substr($str, 0, -1);
167		}
168
169		return $str;
170
171		}
172
173		/**
174		* Return a connection string for use by PDO.
175		* @return string
176		*/
177		public function getConnectionString() {
178		return $this->config['pdo'];
179		}
180
181		/**
182		* Ensure the dsn configuration is valid.
183		* @param array $config
184		* @return void
185		*/
186		protected function configure( array $config ) {
187
188		if( !$config['db'] )
189		throw new ConfigurationException('No database schema specified');
190
191		switch( $config['type'] ) {
192
193		case static::TYPE_MYSQL:
194		$this->config = $this->configureMySQL($config);
195		break;
196
197		case static::TYPE_PGSQL:
198		$this->config = $this->configureMySQL($config);
199		break;
200
201		case static::TYPE_SQLITE:
202		$this->config = $this->configureMySQL($config);
203		break;
204
205		default:
206		throw new ConfigurationException('Invalid database type: '. $config['type']);
207
208		}
209
210		}
211
212		/**
213		* Configure a MySQL DSN.
214		* @param array $config
215		* @return array
216		*/
217	View Code Duplication	protected function configureMySQL( array $config ) {
		0 ignored issues – show Duplication introduced 2016-02-25 17:13 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...
218
219		if( !$config['port'] )
220		$config['port'] = 3306;
221
222		// construct a MySQL PDO connection string
223		$config['pdo'] = sprintf(
224		"mysql:host=%s;port=%s;dbname=%s",
225		$config['host'],
226		$config['port'],
227		$config['db']
228		);
229
230		return $config;
231
232		}
233
234		/**
235		* Configure a PostgreSQL DSN.
236		* @param array $config
237		* @return array
238		*/
239	View Code Duplication	protected function configurePgSQL( array $config ) {
		0 ignored issues – show Duplication introduced 2016-02-25 17:13 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...
240
241		if( !$config['port'] )
242		$config['port'] = 5432;
243
244		// construct a PgSQL PDO connection string
245		$config['pdo'] = sprintf(
246		"pgsql:host=%s;port=%s;dbname=%s",
247		$config['host'],
248		$config['port'],
249		$config['db']
250		);
251
252		return $config;
253
254		}
255
256		/**
257		* Configure a SQLite DSN.
258		* @param array $config
259		* @return array
260		*/
261		protected function configureSQLite( array $config ) {
262
263		// these should always be null as they're invalid for SQLite connections
264		$config['host'] = 'localhost';
265		$config['port'] = null;
266		$config['user'] = null;
267		$config['pass'] = null;
268
269		// construct a SQLite PDO connection string
270		$config['pdo'] = sprintf(
271		'sqlite::%s',
272		$config['db']
273		);
274
275		return $config;
276
277		}
278
279		}
280
281		// EOF

gamernetwork / yolk-database

DSN::isSQLite() A last analyzed 2016-05-18 08:44 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

DSN::isSQLite() A
last analyzed 2016-05-18 08:44 UTC