MySqlCommand::createDatabase() - Code Metrics - Inspection of "Added the SqliteCommand and examples for migrate u..." - byjg/migration - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( f5a493...f6c233 )

by Joao

created 2016-06-10 04:32 UTC

MySqlCommand::createDatabase() A

↳ Parent: MySqlCommand

Complexity

Conditions	1
Paths	1

Size

Total Lines	7
Code Lines	4

Duplication

Lines	0
Ratio	0 %

Importance

Changes	3
Bugs	1	Features	2

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

<?php

namespace ByJG\DbMigration\Commands;

use ByJG\AnyDataset\ConnectionManagement;
use ByJG\AnyDataset\Repository\DBDataset;

class MySqlCommand extends AbstractCommand
{

    public static function prepareEnvironment(ConnectionManagement $connection)
    {
        $database = $connection->getDatabase();

        $newConnection = new ConnectionManagement(str_replace("/$database", "/", $connection->getDbConnectionString()));
        $dbDataset = new DBDataset($newConnection->getDbConnectionString());
        $dbDataset->execSQL("CREATE SCHEMA IF NOT EXISTS `$database` DEFAULT CHARACTER SET utf8 ;");
    }

    public function createDatabase()
    {
        $database = $this->getDbDataset()->getConnectionManagement()->getDatabase();

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

    public function dropDatabase()
    {
        $database = $this->getDbDataset()->getConnectionManagement()->getDatabase();

        $this->getDbDataset()->execSQL("drop database `$database`");
    }

    public function createVersion()
    {
        $this->getDbDataset()->execSQL('CREATE TABLE IF NOT EXISTS migration_version (version int)');
        $this->checkExistsVersion();
    }

    public function executeSql($sql)
    {
        $this->getDbDataset()->execSQL($sql);
    }
}


1			<?php
2
3			namespace ByJG\DbMigration\Commands;
4
5			use ByJG\AnyDataset\ConnectionManagement;
6			use ByJG\AnyDataset\Repository\DBDataset;
7
8			class MySqlCommand extends AbstractCommand
9			{
10
11			public static function prepareEnvironment(ConnectionManagement $connection)
12			{
13			$database = $connection->getDatabase();
14
15			$newConnection = new ConnectionManagement(str_replace("/$database", "/", $connection->getDbConnectionString()));
16			$dbDataset = new DBDataset($newConnection->getDbConnectionString());
17			$dbDataset->execSQL("CREATE SCHEMA IF NOT EXISTS `$database` DEFAULT CHARACTER SET utf8 ;");
18			}
19
20			public function createDatabase()
21			{
22			$database = $this->getDbDataset()->getConnectionManagement()->getDatabase();
23
24			$this->getDbDataset()->execSQL("CREATE SCHEMA IF NOT EXISTS `$database` DEFAULT CHARACTER SET utf8 ;");
25			$this->getDbDataset()->execSQL("USE `$database`");
26			}
27
28			public function dropDatabase()
29			{
30			$database = $this->getDbDataset()->getConnectionManagement()->getDatabase();
31
32			$this->getDbDataset()->execSQL("drop database `$database`");
33			}
34
35			public function createVersion()
36			{
37			$this->getDbDataset()->execSQL('CREATE TABLE IF NOT EXISTS migration_version (version int)');
38			$this->checkExistsVersion();
39			}
40
41			public function executeSql($sql)
42			{
43			$this->getDbDataset()->execSQL($sql);
44			}
45			}
46

byjg / migration

Push — master ( f5a493...f6c233 )

MySqlCommand::createDatabase() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like