FM / Schema

/usr/share/phpmyadmin/libraries/classes/Plugins/Schema/

/usr/share/phpmyadmin/libraries/classes/Plugins/Schema

Name	Size	Mode	Actions
Dia/	-	0755	rm
Eps/	-	0755	rm
Pdf/	-	0755	rm
Svg/	-	0755	rm
ExportRelationSchema.php	7089	0644	edit dl rm
RelationStats.php	3285	0644	edit dl rm
SchemaDia.php	2588	0644	edit dl rm
SchemaEps.php	2676	0644	edit dl rm
SchemaPdf.php	3563	0644	edit dl rm
SchemaSvg.php	2317	0644	edit dl rm
TableStats.php	6193	0644	edit dl rm

Edit: /usr/share/phpmyadmin/libraries/classes/Plugins/Schema/TableStats.php (6193B)

<?php
/**
 * Contains abstract class to hold table preferences/statistics
 */

declare(strict_types=1);

namespace PhpMyAdmin\Plugins\Schema;

use PhpMyAdmin\DatabaseInterface;
use PhpMyAdmin\Font;
use PhpMyAdmin\Index;
use PhpMyAdmin\Relation;
use PhpMyAdmin\Util;
use function array_flip;
use function array_keys;
use function array_merge;
use function rawurldecode;
use function sprintf;

/**
 * Table preferences/statistics
 *
 * This class preserves the table co-ordinates,fields
 * and helps in drawing/generating the tables.
 *
 * @abstract
 */
abstract class TableStats
{
    /** @var Dia\Dia|Eps\Eps|Pdf\Pdf|Svg\Svg */
    protected $diagram;

/** @var string */
    protected $db;

/** @var int */
    protected $pageNumber;

/** @var string */
    protected $tableName;

/** @var bool */
    protected $showKeys;

/** @var bool */
    protected $tableDimension;

/** @var mixed */
    public $displayfield;

/** @var array */
    public $fields = [];

/** @var array */
    public $primary = [];

/** @var int|float */
    public $x;

/** @var int|float */
    public $y;

/** @var int */
    public $width = 0;

/** @var int */
    public $heightCell = 0;

/** @var bool */
    protected $offline;

/** @var Relation */
    protected $relation;

/** @var Font */
    protected $font;

/**
     * @param Pdf\Pdf|Svg\Svg|Eps\Eps|Dia\Dia|Pdf\Pdf $diagram        schema diagram
     * @param string                                  $db             current db name
     * @param int                                     $pageNumber     current page number (from the
     *                                                                $cfg['Servers'][$i]['table_coords'] table)
     * @param string                                  $tableName      table name
     * @param bool                                    $showKeys       whether to display keys or not
     * @param bool                                    $tableDimension whether to display table position or not
     * @param bool                                    $offline        whether the coordinates are sent
     *                                                                from the browser
     */
    public function __construct(
        $diagram,
        $db,
        $pageNumber,
        $tableName,
        $showKeys,
        $tableDimension,
        $offline
    ) {
        global $dbi;

$this->diagram    = $diagram;
        $this->db         = $db;
        $this->pageNumber = $pageNumber;
        $this->tableName  = $tableName;

$this->showKeys   = $showKeys;
        $this->tableDimension   = $tableDimension;

$this->offline    = $offline;

$this->relation = new Relation($dbi);
        $this->font = new Font();

// checks whether the table exists
        // and loads fields
        $this->validateTableAndLoadFields();
        // load table coordinates
        $this->loadCoordinates();
        // loads display field
        $this->loadDisplayField();
        // loads primary keys
        $this->loadPrimaryKey();
    }

/**
     * Validate whether the table exists.
     *
     * @return void
     */
    protected function validateTableAndLoadFields()
    {
        global $dbi;

$sql = 'DESCRIBE ' . Util::backquote($this->tableName);
        $result = $dbi->tryQuery(
            $sql,
            DatabaseInterface::CONNECT_USER,
            DatabaseInterface::QUERY_STORE
        );
        if (! $result || ! $dbi->numRows($result)) {
            $this->showMissingTableError();
        }

if ($this->showKeys) {
            $indexes = Index::getFromTable($this->tableName, $this->db);
            $all_columns = [];
            foreach ($indexes as $index) {
                $all_columns = array_merge(
                    $all_columns,
                    array_flip(array_keys($index->getColumns()))
                );
            }
            $this->fields = array_keys($all_columns);
        } else {
            while ($row = $dbi->fetchRow($result)) {
                $this->fields[] = $row[0];
            }
        }
    }

/**
     * Displays an error when the table cannot be found.
     *
     * @return void
     *
     * @abstract
     */
    abstract protected function showMissingTableError();

/**
     * Loads coordinates of a table
     *
     * @return void
     */
    protected function loadCoordinates()
    {
        if (! isset($_POST['t_h'])) {
            return;
        }

foreach ($_POST['t_h'] as $key => $value) {
            $db = rawurldecode($_POST['t_db'][$key]);
            $tbl = rawurldecode($_POST['t_tbl'][$key]);
            if ($this->db . '.' . $this->tableName === $db . '.' . $tbl) {
                $this->x = (float) $_POST['t_x'][$key];
                $this->y = (float) $_POST['t_y'][$key];
                break;
            }
        }
    }

/**
     * Loads the table's display field
     *
     * @return void
     */
    protected function loadDisplayField()
    {
        $this->displayfield = $this->relation->getDisplayField($this->db, $this->tableName);
    }

/**
     * Loads the PRIMARY key.
     *
     * @return void
     */
    protected function loadPrimaryKey()
    {
        global $dbi;

$result = $dbi->query(
            'SHOW INDEX FROM ' . Util::backquote($this->tableName) . ';',
            DatabaseInterface::CONNECT_USER,
            DatabaseInterface::QUERY_STORE
        );
        if ($dbi->numRows($result) <= 0) {
            return;
        }

while ($row = $dbi->fetchAssoc($result)) {
            if ($row['Key_name'] !== 'PRIMARY') {
                continue;
            }

$this->primary[] = $row['Column_name'];
        }
    }

/**
     * Returns title of the current table,
     * title can have the dimensions/co-ordinates of the table
     *
     * @return string title of the current table
     */
    protected function getTitle()
    {
        return ($this->tableDimension
            ? sprintf('%.0fx%0.f', $this->width, $this->heightCell)
            : ''
        )
        . ' ' . $this->tableName;
    }
}

diagram = $diagram; $this->db = $db; $this->pageNumber = $pageNumber; $this->tableName = $tableName; $this->showKeys = $showKeys; $this->tableDimension = $tableDimension; $this->offline = $offline; $this->relation = new Relation($dbi); $this->font = new Font(); // checks whether the table exists // and loads fields $this->validateTableAndLoadFields(); // load table coordinates $this->loadCoordinates(); // loads display field $this->loadDisplayField(); // loads primary keys $this->loadPrimaryKey(); } /** * Validate whether the table exists. * * @return void */ protected function validateTableAndLoadFields() { global $dbi; $sql = 'DESCRIBE ' . Util::backquote($this->tableName); $result = $dbi->tryQuery( $sql, DatabaseInterface::CONNECT_USER, DatabaseInterface::QUERY_STORE ); if (! $result || ! $dbi->numRows($result)) { $this->showMissingTableError(); } if ($this->showKeys) { $indexes = Index::getFromTable($this->tableName, $this->db); $all_columns = []; foreach ($indexes as $index) { $all_columns = array_merge( $all_columns, array_flip(array_keys($index->getColumns())) ); } $this->fields = array_keys($all_columns); } else { while ($row = $dbi->fetchRow($result)) { $this->fields[] = $row[0]; } } } /** * Displays an error when the table cannot be found. * * @return void * * @abstract */ abstract protected function showMissingTableError(); /** * Loads coordinates of a table * * @return void */ protected function loadCoordinates() { if (! isset($_POST['t_h'])) { return; } foreach ($_POST['t_h'] as $key => $value) { $db = rawurldecode($_POST['t_db'][$key]); $tbl = rawurldecode($_POST['t_tbl'][$key]); if ($this->db . '.' . $this->tableName === $db . '.' . $tbl) { $this->x = (float) $_POST['t_x'][$key]; $this->y = (float) $_POST['t_y'][$key]; break; } } } /** * Loads the table's display field * * @return void */ protected function loadDisplayField() { $this->displayfield = $this->relation->getDisplayField($this->db, $this->tableName); } /** * Loads the PRIMARY key. * * @return void */ protected function loadPrimaryKey() { global $dbi; $result = $dbi->query( 'SHOW INDEX FROM ' . Util::backquote($this->tableName) . ';', DatabaseInterface::CONNECT_USER, DatabaseInterface::QUERY_STORE ); if ($dbi->numRows($result) <= 0) { return; } while ($row = $dbi->fetchAssoc($result)) { if ($row['Key_name'] !== 'PRIMARY') { continue; } $this->primary[] = $row['Column_name']; } } /** * Returns title of the current table, * title can have the dimensions/co-ordinates of the table * * @return string title of the current table */ protected function getTitle() { return ($this->tableDimension ? sprintf('%.0fx%0.f', $this->width, $this->heightCell) : '' ) . ' ' . $this->tableName; } }