Migration_Driver_Mysql_Versions

Complexity

Total Complexity

7

Size/Duplication

Total Lines	46
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	1

Test Coverage

Coverage

100%

Importance

Changes

0

6 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	4	1
A	init()	0	6	1
A	get()	0	10	2
A	set()	0	5	1
A	clear()	0	5	1
A	clear_all()	0	5	1

<?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;
	}
}