MysqlDatabase::createStatement() - Code Metrics - Inspection of "Add MysqlDatabase Object" - starker-xp/database-checker - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( 54e98a...9c2bd3 )

by Guillaume

created 2018-03-20 00:25 UTC

MysqlDatabase::createStatement() A

↳ Parent: MysqlDatabase

Complexity

Conditions	1
Paths	1

Size

Total Lines	5
Code Lines	2

Duplication

Lines	0
Ratio	0 %

Importance

Changes

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

<?php

namespace Starkerxp\DatabaseChecker\Structure;


use Starkerxp\DatabaseChecker\Exception\DatabaseHasNotDefinedException;
use Starkerxp\DatabaseChecker\LoggerTrait;

class MysqlDatabase implements DatabaseInterface
{

    use LoggerTrait;

    /**
     * @var string
     */
    private $database;

    /**
     * @var string
     */
    private $engine;


    /**
     * @var string
     */
    private $collate;

    /**
     * @var MysqlDatabaseTable[]
     */
    private $tables = [];

    /**
     * DatabaseTableStructure constructor.
     *
     * @param $database
     *
     * @throws DatabaseHasNotDefinedException
     */
    public function __construct($database)
    {
        if (empty($database)) {
            $this->critical('You need to define name of your database');
            throw new DatabaseHasNotDefinedException('');
        }
        $this->database = $database;
    }

    public function addTable(MysqlDatabaseTable $table)
    {
        $table->setDatabase($this->getDatabase());
        if (null !== $this->getCollate()) {

            $table->setCollate($this->getCollate());
        }
        $this->tables[$table->getTable()] = $table;
    }

    /**
     * @return mixed
     */
    public function getDatabase()
    {
        return $this->database;
    }

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

    /**
     * @param string $collate
     */
    public function setCollate($collate)
    {
        $this->collate = $collate;
    }

    public function removeTable($tableName)
    {
        unset($this->tables[$tableName]);
    }

    public function toArray()
    {
        $export = [];
        $export['tables'] = [];
        $tables = $this->getTables();
        foreach ($tables as $table) {
            $arrayTable = $table->toArray();
            unset($arrayTable['table']);
            $export['tables'] = array_merge($export['tables'], $arrayTable);
        }
        $export['collate'] = $this->getCollate();
        $export = array_filter($export);

        return $export;
    }

    /**
     * @return MysqlDatabaseTable[]
     */
    public function getTables()
    {
        return $this->tables;
    }

    /**
     * @return array
     *
     */
    public function createStatement()
    {
        $modifications = [sprintf('CREATE DATABASE IF NOT EXISTS `%s`;', $this->getDatabase())];

        return $modifications;
    }

    /**
     * @return array
     *
     * @throws \RuntimeException
     */
    public function alterStatement()
    {
        $collateTmp = $this->getCollate();
        $collate = $collateTmp == '' ? '' : sprintf('CONVERT TO CHARACTER SET %s COLLATE %s', explode('_', $collateTmp)[0], $collateTmp);
        if ($collate == '') {
            return [];
        }
        return [
            sprintf('ALTER DATABASE %s CHARACTER SET %s COLLATE %s;', $this->database, explode('_', $collateTmp)[0], $collateTmp),
        ];
    }

    public function deleteStatement()
    {
        return [];
    }

}



1			<?php
2
3			namespace Starkerxp\DatabaseChecker\Structure;
4
5
6			use Starkerxp\DatabaseChecker\Exception\DatabaseHasNotDefinedException;
7			use Starkerxp\DatabaseChecker\LoggerTrait;
8
9			class MysqlDatabase implements DatabaseInterface
10			{
11
12			use LoggerTrait;
13
14			/**
15			* @var string
16			*/
17			private $database;
18
19			/**
20			* @var string
21			*/
22			private $engine;
			0 ignored issues – show introduced 2018-03-20 00:27 UTC by Report Bug Copy Issue Report The private property `$engine` is not used, and could be removed. Loading history...
23
24			/**
25			* @var string
26			*/
27			private $collate;
28
29			/**
30			* @var MysqlDatabaseTable[]
31			*/
32			private $tables = [];
33
34			/**
35			* DatabaseTableStructure constructor.
36			*
37			* @param $database
38			*
39			* @throws DatabaseHasNotDefinedException
40			*/
41			public function __construct($database)
42			{
43			if (empty($database)) {
44			$this->critical('You need to define name of your database');
45			throw new DatabaseHasNotDefinedException('');
46			}
47			$this->database = $database;
48			}
49
50			public function addTable(MysqlDatabaseTable $table)
51			{
52			$table->setDatabase($this->getDatabase());
53			if (null !== $this->getCollate()) {
			0 ignored issues – show introduced 2018-03-20 00:27 UTC by Report Bug Copy Issue Report The condition `null !== $this->getCollate()` is always `true`. Loading history...
54			$table->setCollate($this->getCollate());
55			}
56			$this->tables[$table->getTable()] = $table;
57			}
58
59			/**
60			* @return mixed
61			*/
62			public function getDatabase()
63			{
64			return $this->database;
65			}
66
67			/**
68			* @return string
69			*/
70			public function getCollate()
71			{
72			return $this->collate;
73			}
74
75			/**
76			* @param string $collate
77			*/
78			public function setCollate($collate)
79			{
80			$this->collate = $collate;
81			}
82
83			public function removeTable($tableName)
84			{
85			unset($this->tables[$tableName]);
86			}
87
88			public function toArray()
89			{
90			$export = [];
91			$export['tables'] = [];
92			$tables = $this->getTables();
93			foreach ($tables as $table) {
94			$arrayTable = $table->toArray();
95			unset($arrayTable['table']);
96			$export['tables'] = array_merge($export['tables'], $arrayTable);
97			}
98			$export['collate'] = $this->getCollate();
99			$export = array_filter($export);
100
101			return $export;
102			}
103
104			/**
105			* @return MysqlDatabaseTable[]
106			*/
107			public function getTables()
108			{
109			return $this->tables;
110			}
111
112			/**
113			* @return array
114			*
115			*/
116			public function createStatement()
117			{
118			$modifications = [sprintf('CREATE DATABASE IF NOT EXISTS `%s`;', $this->getDatabase())];
119
120			return $modifications;
121			}
122
123			/**
124			* @return array
125			*
126			* @throws \RuntimeException
127			*/
128			public function alterStatement()
129			{
130			$collateTmp = $this->getCollate();
131			$collate = $collateTmp == '' ? '' : sprintf('CONVERT TO CHARACTER SET %s COLLATE %s', explode('_', $collateTmp)[0], $collateTmp);
132			if ($collate == '') {
133			return [];
134			}
135			return [
136			sprintf('ALTER DATABASE %s CHARACTER SET %s COLLATE %s;', $this->database, explode('_', $collateTmp)[0], $collateTmp),
137			];
138			}
139
140			public function deleteStatement()
141			{
142			return [];
143			}
144
145			}
			0 ignored issues – show Coding Style introduced 2018-03-20 00:27 UTC by Report Bug Copy Issue Report As per coding style, files should not end with a newline character. This check marks files that end in a newline character, i.e. an empy line. Loading history...
146

starker-xp / database-checker

Push — master ( 54e98a...9c2bd3 )

MysqlDatabase::createStatement() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like