databases::admin_databases_test() - Code Metrics - Inspection of "Fix for includes from regular pages were not inclu..." - nazar-pc/CleverStyle-Framework - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( df8ec4...96358d )

by Nazar

created 2015-12-15 00:19 UTC

databases::admin_databases_test() B

↳ Parent: databases

Complexity

Conditions	4
Paths	3

Size

Total Lines	25
Code Lines	17

Duplication

Lines	0
Ratio	0 %

Importance

Changes	3
Bugs	0	Features	1

Metric	Value
c	3
b	0
f	1
dl	0
loc	25
rs	8.5806
cc	4
eloc	17
nc	3
nop	0

<?php
/**
 * @package    CleverStyle CMS
 * @subpackage System module
 * @category   modules
 * @author     Nazar Mokrynskyi <[email protected]>
 * @copyright  Copyright (c) 2015, Nazar Mokrynskyi
 * @license    MIT License, see license.txt
 */
namespace cs\modules\System\api\Controller\admin;
use
	cs\Config,
	cs\Core,
	cs\ExitException,
	cs\Language,
	cs\Page;
trait databases {
	/**
	 * Get array of databases
	 */
	static function admin_databases_get () {
		$Config       = Config::instance();
		$Core         = Core::instance();
		$databases    = $Config->db;
		$databases[0] = array_merge(
			isset($databases[0]) ? $databases[0] : [],
			[
				'host'    => $Core->db_host,
				'type'    => $Core->db_type,
				'prefix'  => $Core->db_prefix,
				'name'    => $Core->db_name,
				'user'    => '',
				'charset' => $Core->db_charset,
				'mirrors' => []
			]
		);
		foreach ($databases as $i => &$db) {
			$db['index'] = $i;
			foreach ($db['mirrors'] as $j => &$mirror) {
				$mirror['index'] = $j;
			}
			unset($j, $mirror);
			$db['mirrors'] = array_values($db['mirrors']);
		}
		unset($i, $db);
		Page::instance()->json(array_values($databases));
	}
	/**
	 * Update database or database mirror settings
	 *
	 * @param int[] $route_ids
	 *
	 * @throws ExitException
	 */
	static function admin_databases_patch ($route_ids) {
		if (
			!isset($route_ids[0], $_POST['host'], $_POST['type'], $_POST['prefix'], $_POST['name'], $_POST['user'], $_POST['password'], $_POST['charset']) ||
			!strlen($_POST['host']) ||
			!in_array($_POST['type'], static::admin_databases_get_engines())
		) {
			throw new ExitException(400);
		}
		$Config         = Config::instance();
		$databases      = &$Config->db;
		$database_index = $route_ids[0];
		if (!isset($databases[$database_index])) {
			throw new ExitException(404);
		}
		$database = &$databases[$database_index];
		// Maybe, we are changing database mirror
		if (isset($route_ids[1])) {
			if (!isset($database['mirrors'][$route_ids[1]])) {
				throw new ExitException(404);
			}
			$database = &$database['mirrors'][$route_ids[1]];
		} elseif ($database_index == 0) {
			throw new ExitException(400);
		}
		$database['host']     = $_POST['host'];
		$database['type']     = $_POST['type'];
		$database['prefix']   = $_POST['prefix'];
		$database['name']     = $_POST['name'];
		$database['user']     = $_POST['user'];
		$database['password'] = $_POST['password'];
		$database['charset']  = $_POST['charset'];
		if (!$Config->save()) {
			throw new ExitException(500);
		}
	}
	/**
	 * Create database or database mirror
	 *
	 * @param int[] $route_ids
	 *
	 * @throws ExitException
	 */
	static function admin_databases_post ($route_ids) {
		if (
			!isset($_POST['mirror'], $_POST['host'], $_POST['type'], $_POST['prefix'], $_POST['name'], $_POST['user'], $_POST['password'], $_POST['charset']) ||
			!strlen($_POST['host']) ||
			!in_array($_POST['type'], static::admin_databases_get_engines())
		) {
			throw new ExitException(400);
		}
		$Config    = Config::instance();
		$databases = &$Config->db;
		// Maybe, we are adding database mirror
		if (isset($route_ids[0])) {
			if (!isset($databases[$route_ids[0]])) {
				throw new ExitException(404);
			}
			$databases = &$databases[$route_ids[0]]['mirrors'];
		}
		$databases[] = [
			'mirror'   => $_POST['mirror'],
			'host'     => $_POST['host'],
			'type'     => $_POST['type'],
			'prefix'   => $_POST['prefix'],
			'name'     => $_POST['name'],
			'user'     => $_POST['user'],
			'password' => $_POST['password'],
			'charset'  => $_POST['charset']
		];
		if (!$Config->save()) {
			throw new ExitException(500);
		}
	}
	/**
	 * Delete database or database mirror
	 *
	 * @param int[] $route_ids
	 *
	 * @throws ExitException
	 */
	static function admin_databases_delete ($route_ids) {
		if (!isset($route_ids[0])) {
			throw new ExitException(400);
		}
		$Config         = Config::instance();
		$databases      = &$Config->db;
		$database_index = $route_ids[0];
		if (!isset($databases[$database_index])) {
			throw new ExitException(404);
		}
		// Maybe, we are deleting database mirror
		if (isset($route_ids[1])) {
			if (!isset($databases[$database_index]['mirrors'][$route_ids[1]])) {
				throw new ExitException(404);
			}
			unset($databases[$database_index]['mirrors'][$route_ids[1]]);
		} elseif ($database_index == 0) {
			throw new ExitException(400);
		} else {
			static::admin_databases_delete_check_usages($database_index);
			unset($databases[$database_index]);
		}
		if (!$Config->save()) {
			throw new ExitException(500);
		}
	}
	protected static function admin_databases_delete_check_usages ($database_index) {
		$Config  = Config::instance();
		$used_by = [];
		foreach ($Config->components['modules'] as $module => $module_data) {
			if (isset($module_data['db']) && is_array($module_data['db'])) {
				foreach ($module_data['db'] as $index) {
					if ($index == $database_index) {
						$used_by[] = $module;
					}
				}
			}
		}
		if ($used_by) {
			throw new ExitException(
				Language::instance()->db_used_by_modules.': '.implode(', ', $used_by),
				409
			);
		}
	}
	/**
	 * Get array of available database engines
	 */
	static function admin_databases_engines () {
		Page::instance()->json(
			static::admin_databases_get_engines()
		);
	}
	/**
	 * @return string[]
	 */
	protected static function admin_databases_get_engines () {
		return _mb_substr(get_files_list(ENGINES.'/DB', '/^[^_].*?\.php$/i', 'f'), 0, -4);
	}
	/**
	 * Test database connection
	 *
	 * @throws ExitException
	 */
	static function admin_databases_test () {
		$engines = static::admin_databases_get_engines();
		if (
			!isset($_POST['type'], $_POST['name'], $_POST['user'], $_POST['password'], $_POST['host'], $_POST['charset']) ||
			!in_array($_POST['type'], $engines, true)
		) {
			throw new ExitException(400);
		}
		errors_off();
		$engine_class = "\\cs\\DB\\$_POST[type]";
		/**
		 * @var \cs\DB\_Abstract $connection
		 */
		$connection = new $engine_class(
			$_POST['name'],
			$_POST['user'],
			$_POST['password'],
			$_POST['host'],
			$_POST['charset']
		);
		errors_on();
		if (!$connection->connected()) {
			throw new ExitException(500);
		}
	}
}


1			<?php
2			/**
3			* @package CleverStyle CMS
4			* @subpackage System module
5			* @category modules
6			* @author Nazar Mokrynskyi <[email protected]>
7			* @copyright Copyright (c) 2015, Nazar Mokrynskyi
8			* @license MIT License, see license.txt
9			*/
10			namespace cs\modules\System\api\Controller\admin;
11			use
12			cs\Config,
13			cs\Core,
14			cs\ExitException,
15			cs\Language,
16			cs\Page;
17			trait databases {
18			/**
19			* Get array of databases
20			*/
21			static function admin_databases_get () {
22			$Config = Config::instance();
23			$Core = Core::instance();
24			$databases = $Config->db;
25			$databases[0] = array_merge(
26			isset($databases[0]) ? $databases[0] : [],
27			[
28			'host' => $Core->db_host,
29			'type' => $Core->db_type,
30			'prefix' => $Core->db_prefix,
31			'name' => $Core->db_name,
32			'user' => '',
33			'charset' => $Core->db_charset,
34			'mirrors' => []
35			]
36			);
37			foreach ($databases as $i => &$db) {
38			$db['index'] = $i;
39			foreach ($db['mirrors'] as $j => &$mirror) {
40			$mirror['index'] = $j;
41			}
42			unset($j, $mirror);
43			$db['mirrors'] = array_values($db['mirrors']);
44			}
45			unset($i, $db);
46			Page::instance()->json(array_values($databases));
47			}
48			/**
49			* Update database or database mirror settings
50			*
51			* @param int[] $route_ids
52			*
53			* @throws ExitException
54			*/
55			static function admin_databases_patch ($route_ids) {
56			if (
57			!isset($route_ids[0], $_POST['host'], $_POST['type'], $_POST['prefix'], $_POST['name'], $_POST['user'], $_POST['password'], $_POST['charset']) \|\|
58			!strlen($_POST['host']) \|\|
59			!in_array($_POST['type'], static::admin_databases_get_engines())
60			) {
61			throw new ExitException(400);
62			}
63			$Config = Config::instance();
64			$databases = &$Config->db;
65			$database_index = $route_ids[0];
66			if (!isset($databases[$database_index])) {
67			throw new ExitException(404);
68			}
69			$database = &$databases[$database_index];
70			// Maybe, we are changing database mirror
71			if (isset($route_ids[1])) {
72			if (!isset($database['mirrors'][$route_ids[1]])) {
73			throw new ExitException(404);
74			}
75			$database = &$database['mirrors'][$route_ids[1]];
76			} elseif ($database_index == 0) {
77			throw new ExitException(400);
78			}
79			$database['host'] = $_POST['host'];
80			$database['type'] = $_POST['type'];
81			$database['prefix'] = $_POST['prefix'];
82			$database['name'] = $_POST['name'];
83			$database['user'] = $_POST['user'];
84			$database['password'] = $_POST['password'];
85			$database['charset'] = $_POST['charset'];
86			if (!$Config->save()) {
87			throw new ExitException(500);
88			}
89			}
90			/**
91			* Create database or database mirror
92			*
93			* @param int[] $route_ids
94			*
95			* @throws ExitException
96			*/
97			static function admin_databases_post ($route_ids) {
98			if (
99			!isset($_POST['mirror'], $_POST['host'], $_POST['type'], $_POST['prefix'], $_POST['name'], $_POST['user'], $_POST['password'], $_POST['charset']) \|\|
100			!strlen($_POST['host']) \|\|
101			!in_array($_POST['type'], static::admin_databases_get_engines())
102			) {
103			throw new ExitException(400);
104			}
105			$Config = Config::instance();
106			$databases = &$Config->db;
107			// Maybe, we are adding database mirror
108			if (isset($route_ids[0])) {
109			if (!isset($databases[$route_ids[0]])) {
110			throw new ExitException(404);
111			}
112			$databases = &$databases[$route_ids[0]]['mirrors'];
113			}
114			$databases[] = [
115			'mirror' => $_POST['mirror'],
116			'host' => $_POST['host'],
117			'type' => $_POST['type'],
118			'prefix' => $_POST['prefix'],
119			'name' => $_POST['name'],
120			'user' => $_POST['user'],
121			'password' => $_POST['password'],
122			'charset' => $_POST['charset']
123			];
124			if (!$Config->save()) {
125			throw new ExitException(500);
126			}
127			}
128			/**
129			* Delete database or database mirror
130			*
131			* @param int[] $route_ids
132			*
133			* @throws ExitException
134			*/
135			static function admin_databases_delete ($route_ids) {
136			if (!isset($route_ids[0])) {
137			throw new ExitException(400);
138			}
139			$Config = Config::instance();
140			$databases = &$Config->db;
141			$database_index = $route_ids[0];
142			if (!isset($databases[$database_index])) {
143			throw new ExitException(404);
144			}
145			// Maybe, we are deleting database mirror
146			if (isset($route_ids[1])) {
147			if (!isset($databases[$database_index]['mirrors'][$route_ids[1]])) {
148			throw new ExitException(404);
149			}
150			unset($databases[$database_index]['mirrors'][$route_ids[1]]);
151			} elseif ($database_index == 0) {
152			throw new ExitException(400);
153			} else {
154			static::admin_databases_delete_check_usages($database_index);
155			unset($databases[$database_index]);
156			}
157			if (!$Config->save()) {
158			throw new ExitException(500);
159			}
160			}
161			protected static function admin_databases_delete_check_usages ($database_index) {
162			$Config = Config::instance();
163			$used_by = [];
164			foreach ($Config->components['modules'] as $module => $module_data) {
165			if (isset($module_data['db']) && is_array($module_data['db'])) {
166			foreach ($module_data['db'] as $index) {
167			if ($index == $database_index) {
168			$used_by[] = $module;
169			}
170			}
171			}
172			}
173			if ($used_by) {
174			throw new ExitException(
175			Language::instance()->db_used_by_modules.': '.implode(', ', $used_by),
176			409
177			);
178			}
179			}
180			/**
181			* Get array of available database engines
182			*/
183			static function admin_databases_engines () {
184			Page::instance()->json(
185			static::admin_databases_get_engines()
186			);
187			}
188			/**
189			* @return string[]
190			*/
191			protected static function admin_databases_get_engines () {
192			return _mb_substr(get_files_list(ENGINES.'/DB', '/^[^_].*?\.php$/i', 'f'), 0, -4);
193			}
194			/**
195			* Test database connection
196			*
197			* @throws ExitException
198			*/
199			static function admin_databases_test () {
200			$engines = static::admin_databases_get_engines();
201			if (
202			!isset($_POST['type'], $_POST['name'], $_POST['user'], $_POST['password'], $_POST['host'], $_POST['charset']) \|\|
203			!in_array($_POST['type'], $engines, true)
204			) {
205			throw new ExitException(400);
206			}
207			errors_off();
208			$engine_class = "\\cs\\DB\\$_POST[type]";
209			/**
210			* @var \cs\DB\_Abstract $connection
211			*/
212			$connection = new $engine_class(
213			$_POST['name'],
214			$_POST['user'],
215			$_POST['password'],
216			$_POST['host'],
217			$_POST['charset']
218			);
219			errors_on();
220			if (!$connection->connected()) {
221			throw new ExitException(500);
222			}
223			}
224			}
225

nazar-pc / CleverStyle-Framework

Push — master ( df8ec4...96358d )

databases::admin_databases_test() B

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like