MySqlDatabase::createDatabase() - Code Metrics - Inspection of "2.0" - byjg/migration - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Pull Request — master (#2)

by Joao

created 2017-05-27 20:50 UTC

MySqlDatabase::createDatabase() A

↳ Parent: MySqlDatabase

Complexity

Conditions	1
Paths	1

Size

Total Lines	7
Code Lines	4

Duplication

Lines	7
Ratio	100 %

Importance

Changes

Metric	Value
c	0
b	0
f	0
dl	7
loc	7
rs	9.4285
cc	1
eloc	4
nc	1
nop	0

<?php

namespace ByJG\DbMigration\Database;

use ByJG\AnyDataset\Factory;
use ByJG\Util\Uri;

class MySqlDatabase extends AbstractDatabase
{

    public static function prepareEnvironment(Uri $uri)

    {
        $database = preg_replace('~^/~', '', $uri->getPath());

        $customUri = new Uri($uri->__toString());

        $dbDriver = Factory::getDbRelationalInstance($customUri->withPath('/')->__toString());
        $dbDriver->execute("CREATE SCHEMA IF NOT EXISTS `$database` DEFAULT CHARACTER SET utf8 ;");
    }

    public function createDatabase()

    {
        $database = preg_replace('~^/~', '', $this->getDbDriver()->getUri()->getPath());

        $this->getDbDriver()->execute("CREATE SCHEMA IF NOT EXISTS `$database` DEFAULT CHARACTER SET utf8 ;");
        $this->getDbDriver()->execute("USE `$database`");
    }

    public function dropDatabase()
    {
        $database = preg_replace('~^/~', '', $this->getDbDriver()->getUri()->getPath());

        $this->getDbDriver()->execute("drop database `$database`");
    }

    public function createVersion()
    {
        $this->getDbDriver()->execute('CREATE TABLE IF NOT EXISTS migration_version (version int, status varchar(20))');
        $this->checkExistsVersion();
    }

    public function executeSql($sql)
    {
        $this->getDbDriver()->execute($sql);
    }
}


1		<?php
2
3		namespace ByJG\DbMigration\Database;
4
5		use ByJG\AnyDataset\Factory;
6		use ByJG\Util\Uri;
7
8		class MySqlDatabase extends AbstractDatabase
9		{
10
11	View Code Duplication	public static function prepareEnvironment(Uri $uri)
		0 ignored issues – show Duplication introduced 2017-05-02 21:36 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...
12		{
13		$database = preg_replace('~^/~', '', $uri->getPath());
14
15		$customUri = new Uri($uri->__toString());
16
17		$dbDriver = Factory::getDbRelationalInstance($customUri->withPath('/')->__toString());
18		$dbDriver->execute("CREATE SCHEMA IF NOT EXISTS `$database` DEFAULT CHARACTER SET utf8 ;");
19		}
20
21	View Code Duplication	public function createDatabase()
		0 ignored issues – show Duplication introduced 2017-05-02 21:36 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...
22		{
23		$database = preg_replace('~^/~', '', $this->getDbDriver()->getUri()->getPath());
24
25		$this->getDbDriver()->execute("CREATE SCHEMA IF NOT EXISTS `$database` DEFAULT CHARACTER SET utf8 ;");
26		$this->getDbDriver()->execute("USE `$database`");
27		}
28
29		public function dropDatabase()
30		{
31		$database = preg_replace('~^/~', '', $this->getDbDriver()->getUri()->getPath());
32
33		$this->getDbDriver()->execute("drop database `$database`");
34		}
35
36		public function createVersion()
37		{
38		$this->getDbDriver()->execute('CREATE TABLE IF NOT EXISTS migration_version (version int, status varchar(20))');
39		$this->checkExistsVersion();
40		}
41
42		public function executeSql($sql)
43		{
44		$this->getDbDriver()->execute($sql);
45		}
46		}
47

byjg / migration

Pull Request — master (#2)

MySqlDatabase::createDatabase() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like