5 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
6 * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
7 * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
8 * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
9 * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
10 * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
11 * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
12 * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
13 * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
14 * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
15 * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
17 * This software consists of voluntary contributions made by many individuals
18 * and is licensed under the MIT license. For more information, see
19 * <http://www.doctrine-project.org>.
22 namespace Doctrine\DBAL\Schema;
24 use Doctrine\DBAL\Event\SchemaIndexDefinitionEventArgs;
25 use Doctrine\DBAL\Events;
28 * IBM Db2 Schema Manager
30 * @license http://www.opensource.org/licenses/lgpl-license.php LGPL
31 * @link www.doctrine-project.com
34 * @author Benjamin Eberlei <kontakt@beberlei.de>
36 class DB2SchemaManager extends AbstractSchemaManager
39 * Return a list of all tables in the current database
41 * Apparently creator is the schema not the user who created it:
42 * {@link http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.sqlref/db2z_sysibmsystablestable.htm}
46 public function listTableNames()
48 $sql = $this->_platform->getListTablesSQL();
49 $sql .= " AND CREATOR = UPPER('".$this->_conn->getUsername()."')";
51 $tables = $this->_conn->fetchAll($sql);
53 return $this->_getPortableTablesList($tables);
58 * Get Table Column Definition
60 * @param array $tableColumn
63 protected function _getPortableTableColumnDefinition($tableColumn)
65 $tableColumn = array_change_key_case($tableColumn, \CASE_LOWER);
73 $type = $this->_platform->getDoctrineTypeMapping($tableColumn['typename']);
75 switch (strtolower($tableColumn['typename'])) {
77 $length = $tableColumn['length'];
81 $length = $tableColumn['length'];
85 $length = $tableColumn['length'];
90 $scale = $tableColumn['scale'];
91 $precision = $tableColumn['length'];
97 'unsigned' => (bool)$unsigned,
98 'fixed' => (bool)$fixed,
99 'default' => ($tableColumn['default'] == "NULL") ? null : $tableColumn['default'],
100 'notnull' => (bool) ($tableColumn['nulls'] == 'N'),
103 'platformOptions' => array(),
106 if ($scale !== null && $precision !== null) {
107 $options['scale'] = $scale;
108 $options['precision'] = $precision;
111 return new Column($tableColumn['colname'], \Doctrine\DBAL\Types\Type::getType($type), $options);
114 protected function _getPortableTablesList($tables)
116 $tableNames = array();
117 foreach ($tables as $tableRow) {
118 $tableRow = array_change_key_case($tableRow, \CASE_LOWER);
119 $tableNames[] = $tableRow['name'];
124 protected function _getPortableTableIndexesList($tableIndexes, $tableName=null)
126 $eventManager = $this->_platform->getEventManager();
129 foreach($tableIndexes as $indexKey => $data) {
130 $data = array_change_key_case($data, \CASE_LOWER);
131 $unique = ($data['uniquerule'] == "D") ? false : true;
132 $primary = ($data['uniquerule'] == "P");
134 $indexName = strtolower($data['name']);
136 $keyName = 'primary';
138 $keyName = $indexName;
142 'name' => $indexName,
143 'columns' => explode("+", ltrim($data['colnames'], '+')),
145 'primary' => $primary
149 $defaultPrevented = false;
151 if (null !== $eventManager && $eventManager->hasListeners(Events::onSchemaIndexDefinition)) {
152 $eventArgs = new SchemaIndexDefinitionEventArgs($data, $tableName, $this->_conn);
153 $eventManager->dispatchEvent(Events::onSchemaIndexDefinition, $eventArgs);
155 $defaultPrevented = $eventArgs->isDefaultPrevented();
156 $index = $eventArgs->getIndex();
159 if ( ! $defaultPrevented) {
160 $index = new Index($data['name'], $data['columns'], $data['unique'], $data['primary']);
164 $indexes[$indexKey] = $index;
171 protected function _getPortableTableForeignKeyDefinition($tableForeignKey)
173 $tableForeignKey = array_change_key_case($tableForeignKey, CASE_LOWER);
175 $tableForeignKey['deleterule'] = $this->_getPortableForeignKeyRuleDef($tableForeignKey['deleterule']);
176 $tableForeignKey['updaterule'] = $this->_getPortableForeignKeyRuleDef($tableForeignKey['updaterule']);
178 return new ForeignKeyConstraint(
179 array_map('trim', (array)$tableForeignKey['fkcolnames']),
180 $tableForeignKey['reftbname'],
181 array_map('trim', (array)$tableForeignKey['pkcolnames']),
182 $tableForeignKey['relname'],
184 'onUpdate' => $tableForeignKey['updaterule'],
185 'onDelete' => $tableForeignKey['deleterule'],
190 protected function _getPortableForeignKeyRuleDef($def)
194 } else if ($def == "N") {
200 protected function _getPortableViewDefinition($view)
202 $view = array_change_key_case($view, \CASE_LOWER);
203 // sadly this still segfaults on PDO_IBM, see http://pecl.php.net/bugs/bug.php?id=17199
204 //$view['text'] = (is_resource($view['text']) ? stream_get_contents($view['text']) : $view['text']);
205 if (!is_resource($view['text'])) {
206 $pos = strpos($view['text'], ' AS ');
207 $sql = substr($view['text'], $pos+4);
212 return new View($view['name'], $sql);