Server IP : 85.214.239.14 / Your IP : 3.138.101.51 Web Server : Apache/2.4.62 (Debian) System : Linux h2886529.stratoserver.net 4.9.0 #1 SMP Tue Jan 9 19:45:01 MSK 2024 x86_64 User : www-data ( 33) PHP Version : 7.4.18 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /var/www/wordpress/phpMyAdmin/libraries/classes/Controllers/Database/ |
Upload File : |
<?php /* vim: set expandtab sw=4 ts=4 sts=4: */ /** * Holds the PhpMyAdmin\Controllers\Database\DataDictionaryController * * @package PhpMyAdmin\Controllers */ declare(strict_types=1); namespace PhpMyAdmin\Controllers\Database; use PhpMyAdmin\DatabaseInterface; use PhpMyAdmin\Index; use PhpMyAdmin\Relation; use PhpMyAdmin\Response; use PhpMyAdmin\Template; use PhpMyAdmin\Transformations; use PhpMyAdmin\Util; /** * Class DataDictionaryController * @package PhpMyAdmin\Controllers\Database */ class DataDictionaryController extends AbstractController { /** * @var Relation */ private $relation; /** * @var Transformations */ private $transformations; /** * DataDictionaryController constructor. * * @param Response $response Response instance * @param DatabaseInterface $dbi DatabaseInterface instance * @param Template $template Template object * @param string $db Database name * @param Relation $relation Relation instance * @param Transformations $transformations Transformations instance */ public function __construct($response, $dbi, Template $template, $db, $relation, $transformations) { parent::__construct($response, $dbi, $template, $db); $this->relation = $relation; $this->transformations = $transformations; } /** * @return string HTML */ public function index(): string { $cfgRelation = $this->relation->getRelationsParam(); $comment = $this->relation->getDbComment($this->db); $this->dbi->selectDb($this->db); $tablesNames = $this->dbi->getTables($this->db); $tables = []; foreach ($tablesNames as $tableName) { $showComment = (string) $this->dbi->getTable( $this->db, $tableName )->getStatusInfo('TABLE_COMMENT'); list(, $primaryKeys, , ) = Util::processIndexData( $this->dbi->getTableIndexes($this->db, $tableName) ); list($foreigners, $hasRelation) = $this->relation->getRelationsAndStatus( ! empty($cfgRelation['relation']), $this->db, $tableName ); $columnsComments = $this->relation->getComments($this->db, $tableName); $columns = $this->dbi->getColumns($this->db, $tableName); $rows = []; foreach ($columns as $row) { $extractedColumnSpec = Util::extractColumnSpec($row['Type']); $relation = ''; if ($hasRelation) { $foreigner = $this->relation->searchColumnInForeigners( $foreigners, $row['Field'] ); if ($foreigner !== false && $foreigner !== []) { $relation = $foreigner['foreign_table']; $relation .= ' -> '; $relation .= $foreigner['foreign_field']; } } $mime = ''; if ($cfgRelation['mimework']) { $mimeMap = $this->transformations->getMime( $this->db, $tableName, true ); if (isset($mimeMap[$row['Field']])) { $mime = str_replace( '_', '/', $mimeMap[$row['Field']]['mimetype'] ); } } $rows[$row['Field']] = [ 'name' => $row['Field'], 'has_primary_key' => isset($primaryKeys[$row['Field']]), 'type' => $extractedColumnSpec['type'], 'print_type' => $extractedColumnSpec['print_type'], 'is_nullable' => $row['Null'] !== '' && $row['Null'] !== 'NO', 'default' => $row['Default'] ?? null, 'comment' => $columnsComments[$row['Field']] ?? '', 'mime' => $mime, 'relation' => $relation, ]; } $indexesTable = ''; if (count(Index::getFromTable($tableName, $this->db)) > 0) { $indexesTable = Index::getHtmlForIndexes( $tableName, $this->db, true ); } $tables[$tableName] = [ 'name' => $tableName, 'comment' => $showComment, 'has_relation' => $hasRelation, 'has_mime' => $cfgRelation['mimework'], 'columns' => $rows, 'indexes_table' => $indexesTable, ]; } return $this->template->render('database/data_dictionary/index', [ 'database' => $this->db, 'comment' => $comment, 'tables' => $tables, ]); } }