<?php return array('ignore_table_names' => array(Config::get('migrations.table', 'migration')), 'ignore_table_name_regex' => '', 'functions' => array('mod_comment' => function ($comment, $column_name, $table_name) { /* @var $dd \Dbdocs\Dbdocs */ $dd = Dbdocs::instance('default'); if (0 < preg_match('/^[0-9a-zA-Z_]+\\.[0-9a-zA-Z_]+$/', $comment)) { list($c_table_name, $c_column_name) = explode('.', $comment); $comment = "<a href=\"table_{$c_table_name}.html#_column_{$c_column_name}\">" . $comment . '</a>' . "\n<span class=\"_foreign_key\" title=\"{$comment}\" ><i class=\"icon-question-sign\"></i></span>"; } return $comment; }, 'mod_foreign_key' => function ($column_name, $table_name) { $ret = array(); /* @var $dd \Dbdocs\Dbdocs */ $dd = Dbdocs::instance('default'); if (isset($dd->fuel_relations[$table_name]['belongs_to'])) { foreach ($dd->fuel_relations[$table_name]['belongs_to'] as $belongs_to) { if ($belongs_to['key_from'] == $column_name) { $ret['table_name'] = $belongs_to['table_to']; $ret['column_name'] = $belongs_to['key_to']; break; } } } if (empty($ret) and 0 < preg_match('/^.+_id$/', $column_name)) { $table_name = str_replace('_id', '', $column_name); if (in_array(Inflector::singularize($table_name), $dd->sm->listTableNames())) { $ret['table_name'] = Inflector::singularize($table_name); $ret['column_name'] = 'id'; } else { if (in_array(Inflector::pluralize($table_name), $dd->sm->listTableNames())) { $ret['table_name'] = Inflector::pluralize($table_name);
public function view() { /* @var $table \Doctrine\DBAL\Schema\Table */ $table = $this->__table; $this->table_name = $table->getName(); $this->columns = array(); $indexes = $table->getIndexes(); $foreign_keys = $table->getForeignKeys(); $functions = \Config::get('dbdocs.functions'); foreach ($table->getColumns() as $column) { /* @var $column \Doctrine\DBAL\Schema\Column */ $comment = \Security::htmlentities($column->getComment()); if (is_callable($functions['mod_comment'])) { $comment = $functions['mod_comment']($comment, $column->getName(), $table->getName()); } $this->columns[$column->getName()] = array('type' => $column->getType()->getName(), 'length' => $column->getLength(), 'null' => !$column->getNotnull(), 'default' => $column->getDefault(), 'comment' => $comment, 'extras' => array()); foreach ($indexes as $index) { if (in_array($column->getName(), $index->getColumns())) { if ($index->isPrimary()) { $this->columns[$column->getName()]['extras'][] = 'PK'; } else { if ($index->isUnique()) { $this->columns[$column->getName()]['extras'][] = 'UI'; } else { if ($index->isSimpleIndex()) { $this->columns[$column->getName()]['extras'][] = 'I'; } } } } } $column->getAutoincrement() and $this->columns[$column->getName()]['extras'][] = 'AI'; $column->getUnsigned() and $this->columns[$column->getName()]['extras'][] = 'UN'; foreach ($foreign_keys as $foreign_key) { /* @var $foreign_key \Doctrine\DBAL\Schema\ForeignKeyConstraint */ if (in_array($column->getName(), $foreign_key->getColumns())) { $flip = array_flip($this->columns[$column->getName()]['extras']); if (isset($flip['I'])) { unset($flip['I']); $this->columns[$column->getName()]['extras'] = array_flip($flip); } $this->columns[$column->getName()]['extras'][] = 'FK'; $this->columns[$column->getName()]['foreign_key']['table_name'] = $foreign_key->getForeignTableName(); $foreign_key_columns = $foreign_key->getForeignColumns(); $this->columns[$column->getName()]['foreign_key']['column_name'] = $foreign_key_columns[0]; } } if (!isset($this->columns[$column->getName()]['foreign_key'])) { if (is_callable($functions['mod_foreign_key'])) { $this->columns[$column->getName()]['foreign_key'] = $functions['mod_foreign_key']($column->getName(), $table->getName()); } } } /** * get real information of columns */ $dd = Dbdocs::instance('default'); $platform = $dd->conn->getDatabasePlatform()->getName(); switch ($platform) { case 'mysql': $rows = $dd->conn->executeQuery(' select * from information_schema.columns where table_schema = :table_schema and table_name = :table_name order by ordinal_position', array('table_name' => $this->table_name, 'table_schema' => $dd->conn->getDatabase()))->fetchAll(); foreach ($rows as $row) { $real_columns[$row['COLUMN_NAME']] = array('type' => $row['DATA_TYPE'], 'length' => $row['CHARACTER_MAXIMUM_LENGTH'], 'default' => $row['COLUMN_DEFAULT']); } break; default: $real_columns = array(); break; } $this->set('columns', \Arr::merge($this->columns, $real_columns), false); $this->indexes = static::merge_indexes_and_foreign_keys($indexes, $foreign_keys, $table); }