From 5bf66662a9bdd62c5bccab15e607cd95cfb8fcab Mon Sep 17 00:00:00 2001 From: Charles Cabergs Date: Mon, 27 Jul 2020 10:05:23 +0200 Subject: Removed wordpress and phpmyadmin, my server doesn't handle it well and it brings shame on my familly --- .../Database/DataDictionaryController.php | 156 --------------------- 1 file changed, 156 deletions(-) delete mode 100644 srcs/phpmyadmin/libraries/classes/Controllers/Database/DataDictionaryController.php (limited to 'srcs/phpmyadmin/libraries/classes/Controllers/Database/DataDictionaryController.php') diff --git a/srcs/phpmyadmin/libraries/classes/Controllers/Database/DataDictionaryController.php b/srcs/phpmyadmin/libraries/classes/Controllers/Database/DataDictionaryController.php deleted file mode 100644 index ba424b6..0000000 --- a/srcs/phpmyadmin/libraries/classes/Controllers/Database/DataDictionaryController.php +++ /dev/null @@ -1,156 +0,0 @@ -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, - ]); - } -} -- cgit