-
Notifications
You must be signed in to change notification settings - Fork 10
/
CrateSchemaManager.php
112 lines (97 loc) · 3.58 KB
/
CrateSchemaManager.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
<?php
/**
* Licensed to CRATE Technology GmbH("Crate") under one or more contributor
* license agreements. See the NOTICE file distributed with this work for
* additional information regarding copyright ownership. Crate licenses
* this file to you under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License. You may
* obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
* WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
* License for the specific language governing permissions and limitations
* under the License.
*
* However, if you have executed another commercial license agreement
* with Crate these terms will supersede the license and you may use the
* software solely pursuant to the terms of the relevant commercial agreement.
*/
namespace Crate\DBAL\Schema;
use Doctrine\DBAL\DBALException;
use Doctrine\DBAL\Schema\AbstractSchemaManager;
use Doctrine\DBAL\Schema\Column;
use Doctrine\DBAL\Schema\Table;
class CrateSchemaManager extends AbstractSchemaManager
{
/**
* {@inheritDoc}
*/
public function listTableDetails($tableName)
{
$columns = $this->listTableColumns($tableName);
$foreignKeys = array();
$indexes = array();
return new Table($tableName, $columns, $indexes, $foreignKeys);
}
/**
* {@inheritDoc}
*/
public function listTableIndexes($table)
{
throw DBALException::notSupported(__METHOD__);
}
/**
* {@inheritDoc}
*/
public function listTableColumns($table, $database = null)
{
$tableColumns = $this->_conn->fetchAll($this->_platform->getListTableColumnsSQL($table));
$tableConstraints = $this->_conn->fetchAll($this->_platform->getListTableConstraintsSQL($table));
$columns = array();
foreach ($tableColumns as $tableColumn) {
$tableColumn['primary'] = in_array($tableColumn['column_name'], $tableConstraints[0]['constraint_name']);
$columns[] = $tableColumn;
}
return $this->_getPortableTableColumnList($table, $database, $columns);
}
/**
* {@inheritDoc}
*/
protected function _getPortableTableColumnDefinition($tableColumn)
{
$tableColumn = array_change_key_case($tableColumn, CASE_LOWER);
if (!isset($tableColumn['column_name'])) {
$tableColumn['column_name'] = '';
}
$dbType = strtolower($tableColumn['data_type']);
$type = $this->_platform->getDoctrineTypeMapping($dbType);
$options = array(
'length' => null,
'notnull' => false,
'default' => null,
'primary' => $tableColumn['primary'],
'precision' => null,
'scale' => null,
'fixed' => null,
'unsigned' => false,
'autoincrement' => false,
'comment' => '',
);
return new Column($tableColumn['column_name'], \Doctrine\DBAL\Types\Type::getType($type), $options);
}
/**
* {@inheritDoc}
*/
protected function _getPortableTablesList($tables)
{
$tableNames = array();
foreach ($tables as $tableRow) {
$tableRow = array_change_key_case($tableRow, \CASE_LOWER);
$tableNames[] = $tableRow['table_name']; // ignore schema for now
}
return $tableNames;
}
}