Migration_Driver_Mysql_Versions::get() - Code Metrics - OpenBuildings/timestamped-migrations - Measure and Improve Code Quality continuously with Scrutinizer

Migration_Driver_Mysql_Versions::get() A
last analyzed 2017-11-14 23:04 UTC

↳ Parent: Migration_Driver_Mysql_Versions

Complexity

Conditions	2
Paths	2

Size

Total Lines	10
Code Lines	5

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	5
CRAP Score	2

Importance

Changes

Metric	Value
dl	0
loc	10
ccs	5
cts	5
cp	1
rs	9.4285
c	0
b	0
f	0
cc	2
eloc	5
nc	2
nop	0
crap	2

<?php defined('SYSPATH') OR die('No direct script access.');

class Migration_Driver_Mysql_Versions extends Migration_Driver_Versions
{
	public $pdo;
	const SCHEMA_TABLE = 'schema_version';

	public function __construct($pdo)
	{
		$this->pdo = $pdo;
	}

	public function init()
	{
		$this->pdo->exec('CREATE TABLE IF NOT EXISTS `'.self::SCHEMA_TABLE.'` (version INT)');

		return $this;
	}

	public function get()
	{
		$migrations = array();
		foreach($this->pdo->query('SELECT version FROM `'.self::SCHEMA_TABLE.'` ORDER BY version ASC') as $result)
		{
			$migrations[] = intval($result['version']);
		}

		return $migrations;
	}

	public function set($version)
	{
		$this->pdo->prepare('INSERT INTO `'.self::SCHEMA_TABLE.'` SET version = ?')->execute(array($version));
		return $this;
	}

	public function clear($version)
	{
		$this->pdo->prepare('DELETE FROM `'.self::SCHEMA_TABLE.'` WHERE version = ?')->execute(array($version));
		return $this;
	}

	public function clear_all()
	{
		$this->pdo->exec('DELETE FROM `'.self::SCHEMA_TABLE.'`');
		return $this;
	}
}


1		<?php defined('SYSPATH') OR die('No direct script access.');
2
3		class Migration_Driver_Mysql_Versions extends Migration_Driver_Versions
4		{
5		public $pdo;
6		const SCHEMA_TABLE = 'schema_version';
7
8		public function __construct($pdo)
9		{
10		$this->pdo = $pdo;
11		}
12
13		public function init()
14		{
15		$this->pdo->exec('CREATE TABLE IF NOT EXISTS `'.self::SCHEMA_TABLE.'` (version INT)');
16
17	54	return $this;
18		}
19	54
20	54	public function get()
21		{
22	1	$migrations = array();
23		foreach($this->pdo->query('SELECT version FROM `'.self::SCHEMA_TABLE.'` ORDER BY version ASC') as $result)
24	1	{
25		$migrations[] = intval($result['version']);
26	1	}
27
28		return $migrations;
29	1	}
30
31	1	public function set($version)
32	1	{
33		$this->pdo->prepare('INSERT INTO `'.self::SCHEMA_TABLE.'` SET version = ?')->execute(array($version));
34	1	return $this;
35	1	}
36
37	1	public function clear($version)
38		{
39		$this->pdo->prepare('DELETE FROM `'.self::SCHEMA_TABLE.'` WHERE version = ?')->execute(array($version));
40	1	return $this;
41		}
42	1
43	1	public function clear_all()
44		{
45		$this->pdo->exec('DELETE FROM `'.self::SCHEMA_TABLE.'`');
46	1	return $this;
47		}
48		}
49

OpenBuildings / timestamped-migrations

Migration_Driver_Mysql_Versions::get() A last analyzed 2017-11-14 23:04 UTC

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like

Migration_Driver_Mysql_Versions::get() A
last analyzed 2017-11-14 23:04 UTC