Failed Conditions
Push — master ( 656579...2742cd )
by Marco
11:55
created

DrizzleSchemaManager   A

Complexity

Total Complexity 11

Size/Duplication

Total Lines 89
Duplicated Lines 0 %

Test Coverage

Coverage 0%

Importance

Changes 0
Metric Value
wmc 11
dl 0
loc 89
ccs 0
cts 41
cp 0
rs 10
c 0
b 0
f 0

5 Methods

Rating   Name   Duplication   Size   Complexity  
A _getPortableTableForeignKeyDefinition() 0 20 3
A _getPortableTableIndexesList() 0 9 2
A _getPortableDatabaseDefinition() 0 3 1
A _getPortableTableDefinition() 0 3 1
B _getPortableTableColumnDefinition() 0 27 4
1
<?php
2
/*
3
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
4
 * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
5
 * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
6
 * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
7
 * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
8
 * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
9
 * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
10
 * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
11
 * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
12
 * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
13
 * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
14
 *
15
 * This software consists of voluntary contributions made by many individuals
16
 * and is licensed under the MIT license. For more information, see
17
 * <http://www.doctrine-project.org>.
18
 */
19
20
namespace Doctrine\DBAL\Schema;
21
22
use Doctrine\DBAL\Types\Type;
23
24
/**
25
 * Schema manager for the Drizzle RDBMS.
26
 *
27
 * @author Kim Hemsø Rasmussen <[email protected]>
28
 */
29
class DrizzleSchemaManager extends AbstractSchemaManager
30
{
31
    /**
32
     * {@inheritdoc}
33
     */
34
    protected function _getPortableTableColumnDefinition($tableColumn)
35
    {
36
        $dbType = strtolower($tableColumn['DATA_TYPE']);
37
38
        $type = $this->_platform->getDoctrineTypeMapping($dbType);
39
        $type = $this->extractDoctrineTypeFromComment($tableColumn['COLUMN_COMMENT'], $type);
40
        $tableColumn['COLUMN_COMMENT'] = $this->removeDoctrineTypeFromComment($tableColumn['COLUMN_COMMENT'], $type);
41
42
        $options = [
43
            'notnull' => !(bool) $tableColumn['IS_NULLABLE'],
44
            'length' => (int) $tableColumn['CHARACTER_MAXIMUM_LENGTH'],
45
            'default' => $tableColumn['COLUMN_DEFAULT'] ?? null,
46
            'autoincrement' => (bool) $tableColumn['IS_AUTO_INCREMENT'],
47
            'scale' => (int) $tableColumn['NUMERIC_SCALE'],
48
            'precision' => (int) $tableColumn['NUMERIC_PRECISION'],
49
            'comment' => isset($tableColumn['COLUMN_COMMENT']) && '' !== $tableColumn['COLUMN_COMMENT']
50
                ? $tableColumn['COLUMN_COMMENT']
51
                : null,
52
        ];
53
54
        $column = new Column($tableColumn['COLUMN_NAME'], Type::getType($type), $options);
55
56
        if ( ! empty($tableColumn['COLLATION_NAME'])) {
57
            $column->setPlatformOption('collation', $tableColumn['COLLATION_NAME']);
58
        }
59
60
        return $column;
61
    }
62
63
    /**
64
     * {@inheritdoc}
65
     */
66
    protected function _getPortableDatabaseDefinition($database)
67
    {
68
        return $database['SCHEMA_NAME'];
69
    }
70
71
    /**
72
     * {@inheritdoc}
73
     */
74
    protected function _getPortableTableDefinition($table)
75
    {
76
        return $table['TABLE_NAME'];
77
    }
78
79
    /**
80
     * {@inheritdoc}
81
     */
82
    public function _getPortableTableForeignKeyDefinition($tableForeignKey)
83
    {
84
        $columns = [];
85
        foreach (explode(',', $tableForeignKey['CONSTRAINT_COLUMNS']) as $value) {
86
            $columns[] = trim($value, ' `');
87
        }
88
89
        $refColumns = [];
90
        foreach (explode(',', $tableForeignKey['REFERENCED_TABLE_COLUMNS']) as $value) {
91
            $refColumns[] = trim($value, ' `');
92
        }
93
94
        return new ForeignKeyConstraint(
95
            $columns,
96
            $tableForeignKey['REFERENCED_TABLE_NAME'],
97
            $refColumns,
98
            $tableForeignKey['CONSTRAINT_NAME'],
99
            [
100
                'onUpdate' => $tableForeignKey['UPDATE_RULE'],
101
                'onDelete' => $tableForeignKey['DELETE_RULE'],
102
            ]
103
        );
104
    }
105
106
    /**
107
     * {@inheritdoc}
108
     */
109
    protected function _getPortableTableIndexesList($tableIndexes, $tableName = null)
110
    {
111
        $indexes = [];
112
        foreach ($tableIndexes as $k) {
113
            $k['primary'] = (boolean) $k['primary'];
114
            $indexes[] = $k;
115
        }
116
117
        return parent::_getPortableTableIndexesList($indexes, $tableName);
118
    }
119
}
120