ByJG\DbMigration\Database\AbstractDatabase

Complexity

Total Complexity

11

Size/Duplication

Total Lines	109
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	5

Importance

Changes

0

7 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	5	1
A	getMigrationTable()	0	4	1
A	getDbDriver()	0	7	2
A	getVersion()	0	17	3
A	setVersion()	0	10	1
A	checkExistsVersion()	0	8	2
A	updateVersionTable()	0	7	1

<?php

namespace ByJG\DbMigration\Database;

use ByJG\AnyDataset\DbDriverInterface;
use ByJG\AnyDataset\Factory;
use ByJG\DbMigration\Exception\DatabaseNotVersionedException;
use ByJG\DbMigration\Exception\OldVersionSchemaException;
use Psr\Http\Message\UriInterface;

abstract class AbstractDatabase implements DatabaseInterface
{
    /**
     * @var DbDriverInterface
     */
    private $dbDriver;

    /**
     * @var \Psr\Http\Message\UriInterface
     */
    private $uri;
    /**
     * @var string
     */
    private $migrationTable;

    /**
     * Command constructor.
     *
     * @param UriInterface $uri
     * @param string $migrationTable
     */
    public function __construct(UriInterface $uri, $migrationTable = 'migration_version')
    {
        $this->uri = $uri;
        $this->migrationTable = $migrationTable;
    }

    /**
     * @return string
     */
    public function getMigrationTable()
    {
        return $this->migrationTable;
    }

    /**
     * @return DbDriverInterface
     */
    public function getDbDriver()
    {
        if (is_null($this->dbDriver)) {
            $this->dbDriver = Factory::getDbRelationalInstance($this->uri->__toString());
        }
        return $this->dbDriver;
    }

    /**
     * @return array
     * @throws \ByJG\DbMigration\Exception\DatabaseNotVersionedException
     * @throws \ByJG\DbMigration\Exception\OldVersionSchemaException
     */
    public function getVersion()
    {
        $result = [];
        try {
            $result['version'] = $this->getDbDriver()->getScalar('SELECT version FROM ' . $this->getMigrationTable());
        } catch (\Exception $ex) {
            throw new DatabaseNotVersionedException('This database does not have a migration version. Please use "migrate reset" or "migrate install" to create one.');
        }

        try {
            $result['status'] = $this->getDbDriver()->getScalar('SELECT status FROM ' . $this->getMigrationTable());
        } catch (\Exception $ex) {
            throw new OldVersionSchemaException('This database does not have a migration version. Please use "migrate install" for update it.');
        }

        return $result;
    }

    /**
     * @param $version
     * @param $status
     */
    public function setVersion($version, $status)
    {
        $this->getDbDriver()->execute(
            'UPDATE ' . $this->getMigrationTable() . ' SET version = :version, status = :status',
            [
                'version' => $version,
                'status' => $status,
            ]
        );
    }

    /**
     * @throws \ByJG\DbMigration\Exception\DatabaseNotVersionedException
     * @throws \ByJG\DbMigration\Exception\OldVersionSchemaException
     */
    protected function checkExistsVersion()
    {
        // Get the version to check if exists
        $versionInfo = $this->getVersion();
        if (empty($versionInfo['version'])) {
            $this->getDbDriver()->execute("insert into " . $this->getMigrationTable() . " values(0, 'unknow')");
        }
    }

    /**
     *
     */
    public function updateVersionTable()
    {
        $currentVersion = $this->getDbDriver()->getScalar('select version from ' . $this->getMigrationTable());
        $this->getDbDriver()->execute('drop table ' . $this->getMigrationTable());
        $this->createVersion();
        $this->setVersion($currentVersion, 'unknow');
    }
}