aboutsummaryrefslogtreecommitdiff
path: root/srcs/phpmyadmin/libraries/classes/Controllers/Table/StructureController.php
diff options
context:
space:
mode:
Diffstat (limited to 'srcs/phpmyadmin/libraries/classes/Controllers/Table/StructureController.php')
-rw-r--r--srcs/phpmyadmin/libraries/classes/Controllers/Table/StructureController.php1648
1 files changed, 0 insertions, 1648 deletions
diff --git a/srcs/phpmyadmin/libraries/classes/Controllers/Table/StructureController.php b/srcs/phpmyadmin/libraries/classes/Controllers/Table/StructureController.php
deleted file mode 100644
index 7f59013..0000000
--- a/srcs/phpmyadmin/libraries/classes/Controllers/Table/StructureController.php
+++ /dev/null
@@ -1,1648 +0,0 @@
-<?php
-/* vim: set expandtab sw=4 ts=4 sts=4: */
-/**
- * Holds the PhpMyAdmin\Controllers\Table\StructureController
- *
- * @package PhpMyAdmin\Controllers
- */
-declare(strict_types=1);
-
-namespace PhpMyAdmin\Controllers\Table;
-
-use PhpMyAdmin\CentralColumns;
-use PhpMyAdmin\Charsets;
-use PhpMyAdmin\CheckUserPrivileges;
-use PhpMyAdmin\Config\PageSettings;
-use PhpMyAdmin\Core;
-use PhpMyAdmin\CreateAddField;
-use PhpMyAdmin\DatabaseInterface;
-use PhpMyAdmin\Engines\Innodb;
-use PhpMyAdmin\Index;
-use PhpMyAdmin\Message;
-use PhpMyAdmin\ParseAnalyze;
-use PhpMyAdmin\Partition;
-use PhpMyAdmin\Relation;
-use PhpMyAdmin\Response;
-use PhpMyAdmin\Sql;
-use PhpMyAdmin\SqlParser\Context;
-use PhpMyAdmin\SqlParser\Parser;
-use PhpMyAdmin\SqlParser\Statements\CreateStatement;
-use PhpMyAdmin\StorageEngine;
-use PhpMyAdmin\Table;
-use PhpMyAdmin\TablePartitionDefinition;
-use PhpMyAdmin\Template;
-use PhpMyAdmin\Tracker;
-use PhpMyAdmin\Transformations;
-use PhpMyAdmin\Url;
-use PhpMyAdmin\Util;
-use stdClass;
-use Symfony\Component\DependencyInjection\ContainerBuilder;
-
-/**
- * Handles table structure logic
- *
- * @package PhpMyAdmin\Controllers
- */
-class StructureController extends AbstractController
-{
- /**
- * @var Table The table object
- */
- protected $table_obj;
- /**
- * @var string The URL query string
- */
- protected $_url_query;
- /**
- * @var bool DB is information_schema
- */
- protected $_db_is_system_schema;
- /**
- * @var bool Table is a view
- */
- protected $_tbl_is_view;
- /**
- * @var string Table storage engine
- */
- protected $_tbl_storage_engine;
- /**
- * @var int Number of rows
- */
- protected $_table_info_num_rows;
- /**
- * @var string Table collation
- */
- protected $_tbl_collation;
- /**
- * @var array Show table info
- */
- protected $_showtable;
-
- /**
- * @var CreateAddField
- */
- private $createAddField;
-
- /**
- * @var Relation
- */
- private $relation;
-
- /**
- * @var Transformations
- */
- private $transformations;
-
- /**
- * StructureController constructor
- *
- * @param Response $response Response object
- * @param DatabaseInterface $dbi DatabaseInterface object
- * @param Template $template Template object
- * @param string $db Database name
- * @param string $table Table name
- * @param bool $db_is_system_schema DB is information_schema
- * @param bool $tbl_is_view Table is a view
- * @param string $tbl_storage_engine Table storage engine
- * @param int $table_info_num_rows Number of rows
- * @param string $tbl_collation Table collation
- * @param array $showtable Show table info
- * @param Relation $relation Relation instance
- * @param Transformations $transformations Transformations instance
- * @param CreateAddField $createAddField CreateAddField instance
- */
- public function __construct(
- $response,
- $dbi,
- Template $template,
- $db,
- $table,
- $db_is_system_schema,
- $tbl_is_view,
- $tbl_storage_engine,
- $table_info_num_rows,
- $tbl_collation,
- $showtable,
- Relation $relation,
- Transformations $transformations,
- CreateAddField $createAddField
- ) {
- parent::__construct($response, $dbi, $template, $db, $table);
-
- $this->_db_is_system_schema = $db_is_system_schema;
- $this->_url_query = Url::getCommonRaw(['db' => $db, 'table' => $table]);
- $this->_tbl_is_view = $tbl_is_view;
- $this->_tbl_storage_engine = $tbl_storage_engine;
- $this->_table_info_num_rows = $table_info_num_rows;
- $this->_tbl_collation = $tbl_collation;
- $this->_showtable = $showtable;
- $this->table_obj = $this->dbi->getTable($this->db, $this->table);
-
- $this->createAddField = $createAddField;
- $this->relation = $relation;
- $this->transformations = $transformations;
- }
-
- /**
- * Index action
- *
- * @param ContainerBuilder $containerBuilder ContainerBuilder instance
- *
- * @return void
- */
- public function indexAction(ContainerBuilder $containerBuilder): void
- {
- global $sql_query;
-
- PageSettings::showGroup('TableStructure');
-
- $checkUserPrivileges = new CheckUserPrivileges($this->dbi);
- $checkUserPrivileges->getPrivileges();
-
- $this->response->getHeader()->getScripts()->addFiles(
- [
- 'table/structure.js',
- 'indexes.js',
- ]
- );
-
- /**
- * Handle column moving
- */
- if (isset($_POST['move_columns'])
- && is_array($_POST['move_columns'])
- && $this->response->isAjax()
- ) {
- $this->moveColumns();
- return;
- }
-
- /**
- * handle MySQL reserved words columns check
- */
- if (isset($_POST['reserved_word_check'])) {
- if ($GLOBALS['cfg']['ReservedWordDisableWarning'] === false) {
- $columns_names = $_POST['field_name'];
- $reserved_keywords_names = [];
- foreach ($columns_names as $column) {
- if (Context::isKeyword(trim($column), true)) {
- $reserved_keywords_names[] = trim($column);
- }
- }
- if (Context::isKeyword(trim($this->table), true)) {
- $reserved_keywords_names[] = trim($this->table);
- }
- if (count($reserved_keywords_names) === 0) {
- $this->response->setRequestStatus(false);
- }
- $this->response->addJSON(
- 'message',
- sprintf(
- _ngettext(
- 'The name \'%s\' is a MySQL reserved keyword.',
- 'The names \'%s\' are MySQL reserved keywords.',
- count($reserved_keywords_names)
- ),
- implode(',', $reserved_keywords_names)
- )
- );
- } else {
- $this->response->setRequestStatus(false);
- }
- return;
- }
- /**
- * A click on Change has been made for one column
- */
- if (isset($_GET['change_column'])) {
- $this->displayHtmlForColumnChange(null, 'tbl_structure.php', $containerBuilder);
- return;
- }
-
- /**
- * Adding or editing partitioning of the table
- */
- if (isset($_POST['edit_partitioning'])
- && ! isset($_POST['save_partitioning'])
- ) {
- $this->displayHtmlForPartitionChange();
- return;
- }
-
- /**
- * handle multiple field commands if required
- *
- * submit_mult_*_x comes from IE if <input type="img" ...> is used
- */
- $submit_mult = $this->getMultipleFieldCommandType();
-
- if (! empty($submit_mult)) {
- if (isset($_POST['selected_fld'])) {
- if ($submit_mult == 'browse') {
- // browsing the table displaying only selected columns
- $this->displayTableBrowseForSelectedColumns(
- $GLOBALS['goto'],
- $GLOBALS['pmaThemeImage']
- );
- } else {
- // handle multiple field commands
- // handle confirmation of deleting multiple columns
- $action = 'tbl_structure.php';
- $GLOBALS['selected'] = $_POST['selected_fld'];
- list(
- $what_ret, $query_type_ret, $is_unset_submit_mult,
- $mult_btn_ret, $centralColsError
- )
- = $this->getDataForSubmitMult(
- $submit_mult,
- $_POST['selected_fld'],
- $action,
- $containerBuilder
- );
- //update the existing variables
- // todo: refactor mult_submits.inc.php such as
- // below globals are not needed anymore
- if (isset($what_ret)) {
- $GLOBALS['what'] = $what_ret;
- global $what;
- }
- if (isset($query_type_ret)) {
- $GLOBALS['query_type'] = $query_type_ret;
- global $query_type;
- }
- if ($is_unset_submit_mult) {
- unset($submit_mult);
- }
- if (isset($mult_btn_ret)) {
- $GLOBALS['mult_btn'] = $mult_btn_ret;
- global $mult_btn;
- }
- include ROOT_PATH . 'libraries/mult_submits.inc.php';
- /**
- * if $submit_mult == 'change', execution will have stopped
- * at this point
- */
- if (empty($message)) {
- $message = Message::success();
- }
- $this->response->addHTML(
- Util::getMessage($message, $sql_query)
- );
- }
- } else {
- $this->response->setRequestStatus(false);
- $message = Message::error(__('No column selected.'));
- $this->response->addJSON('message', $message);
- }
- }
-
- /**
- * Modifications have been submitted -> updates the table
- */
- if (isset($_POST['do_save_data'])) {
- $regenerate = $this->updateColumns();
- if (! $regenerate) {
- // continue to show the table's structure
- unset($_POST['selected']);
- }
- }
-
- /**
- * Modifications to the partitioning have been submitted -> updates the table
- */
- if (isset($_POST['save_partitioning'])) {
- $this->updatePartitioning();
- }
-
- /**
- * Adding indexes
- */
- if (isset($_POST['add_key'])
- || isset($_POST['partition_maintenance'])
- ) {
- //todo: set some variables for sql.php include, to be eliminated
- //after refactoring sql.php
- $db = $this->db;
- $table = $this->table;
- $sql_query = $GLOBALS['sql_query'];
- $cfg = $GLOBALS['cfg'];
- $pmaThemeImage = $GLOBALS['pmaThemeImage'];
- include ROOT_PATH . 'sql.php';
- $GLOBALS['reload'] = true;
- }
-
- /**
- * Gets the relation settings
- */
- $cfgRelation = $this->relation->getRelationsParam();
-
- /**
- * Runs common work
- */
- // set db, table references, for require_once that follows
- // got to be eliminated in long run
- $db = &$this->db;
- $table = &$this->table;
- $url_params = [];
- include_once ROOT_PATH . 'libraries/tbl_common.inc.php';
- $this->_db_is_system_schema = $db_is_system_schema;
- $this->_url_query = Url::getCommonRaw([
- 'db' => $db,
- 'table' => $table,
- 'goto' => 'tbl_structure.php',
- 'back' => 'tbl_structure.php',
- ]);
- /* The url_params array is initialized in above include */
- $url_params['goto'] = 'tbl_structure.php';
- $url_params['back'] = 'tbl_structure.php';
-
- // 2. Gets table keys and retains them
- // @todo should be: $server->db($db)->table($table)->primary()
- $primary = Index::getPrimary($this->table, $this->db);
- $columns_with_index = $this->dbi
- ->getTable($this->db, $this->table)
- ->getColumnsWithIndex(
- Index::UNIQUE | Index::INDEX | Index::SPATIAL
- | Index::FULLTEXT
- );
- $columns_with_unique_index = $this->dbi
- ->getTable($this->db, $this->table)
- ->getColumnsWithIndex(Index::UNIQUE);
-
- // 3. Get fields
- $fields = (array) $this->dbi->getColumns(
- $this->db,
- $this->table,
- null,
- true
- );
-
- //display table structure
- $this->response->addHTML(
- $this->displayStructure(
- $cfgRelation,
- $columns_with_unique_index,
- $url_params,
- $primary,
- $fields,
- $columns_with_index
- )
- );
- }
-
- /**
- * Moves columns in the table's structure based on $_REQUEST
- *
- * @return void
- */
- protected function moveColumns()
- {
- $this->dbi->selectDb($this->db);
-
- /*
- * load the definitions for all columns
- */
- $columns = $this->dbi->getColumnsFull($this->db, $this->table);
- $column_names = array_keys($columns);
- $changes = [];
-
- // @see https://mariadb.com/kb/en/library/changes-improvements-in-mariadb-102/#information-schema
- $usesLiteralNull = $this->dbi->isMariaDB() && $this->dbi->getVersion() >= 100200;
- $defaultNullValue = $usesLiteralNull ? 'NULL' : null;
- // move columns from first to last
- for ($i = 0, $l = count($_POST['move_columns']); $i < $l; $i++) {
- $column = $_POST['move_columns'][$i];
- // is this column already correctly placed?
- if ($column_names[$i] == $column) {
- continue;
- }
-
- // it is not, let's move it to index $i
- $data = $columns[$column];
- $extracted_columnspec = Util::extractColumnSpec($data['Type']);
- if (isset($data['Extra'])
- && $data['Extra'] == 'on update CURRENT_TIMESTAMP'
- ) {
- $extracted_columnspec['attribute'] = $data['Extra'];
- unset($data['Extra']);
- }
- $current_timestamp = ($data['Type'] == 'timestamp'
- || $data['Type'] == 'datetime')
- && ($data['Default'] == 'CURRENT_TIMESTAMP'
- || $data['Default'] == 'current_timestamp()');
-
- // @see https://mariadb.com/kb/en/library/information-schema-columns-table/#examples
- if ($data['Null'] === 'YES' && in_array($data['Default'], [$defaultNullValue, null])) {
- $default_type = 'NULL';
- } elseif ($current_timestamp) {
- $default_type = 'CURRENT_TIMESTAMP';
- } elseif ($data['Default'] === null) {
- $default_type = 'NONE';
- } else {
- $default_type = 'USER_DEFINED';
- }
-
- $virtual = [
- 'VIRTUAL',
- 'PERSISTENT',
- 'VIRTUAL GENERATED',
- 'STORED GENERATED',
- ];
- $data['Virtuality'] = '';
- $data['Expression'] = '';
- if (isset($data['Extra']) && in_array($data['Extra'], $virtual)) {
- $data['Virtuality'] = str_replace(' GENERATED', '', $data['Extra']);
- $expressions = $this->table_obj->getColumnGenerationExpression($column);
- $data['Expression'] = $expressions[$column];
- }
-
- $changes[] = 'CHANGE ' . Table::generateAlter(
- $column,
- $column,
- mb_strtoupper($extracted_columnspec['type']),
- $extracted_columnspec['spec_in_brackets'],
- $extracted_columnspec['attribute'],
- isset($data['Collation']) ? $data['Collation'] : '',
- $data['Null'] === 'YES' ? 'YES' : 'NO',
- $default_type,
- $current_timestamp ? '' : $data['Default'],
- isset($data['Extra']) && $data['Extra'] !== '' ? $data['Extra']
- : false,
- isset($data['COLUMN_COMMENT']) && $data['COLUMN_COMMENT'] !== ''
- ? $data['COLUMN_COMMENT'] : false,
- $data['Virtuality'],
- $data['Expression'],
- $i === 0 ? '-first' : $column_names[$i - 1]
- );
- // update current column_names array, first delete old position
- for ($j = 0, $ll = count($column_names); $j < $ll; $j++) {
- if ($column_names[$j] == $column) {
- unset($column_names[$j]);
- }
- }
- // insert moved column
- array_splice($column_names, $i, 0, $column);
- }
- if (empty($changes) && ! isset($_REQUEST['preview_sql'])) { // should never happen
- $this->response->setRequestStatus(false);
- return;
- }
- // query for moving the columns
- $sql_query = sprintf(
- 'ALTER TABLE %s %s',
- Util::backquote($this->table),
- implode(', ', $changes)
- );
-
- if (isset($_REQUEST['preview_sql'])) { // preview sql
- $this->response->addJSON(
- 'sql_data',
- $this->template->render('preview_sql', [
- 'query_data' => $sql_query,
- ])
- );
- } else { // move column
- $this->dbi->tryQuery($sql_query);
- $tmp_error = $this->dbi->getError();
- if ($tmp_error) {
- $this->response->setRequestStatus(false);
- $this->response->addJSON('message', Message::error($tmp_error));
- } else {
- $message = Message::success(
- __('The columns have been moved successfully.')
- );
- $this->response->addJSON('message', $message);
- $this->response->addJSON('columns', $column_names);
- }
- }
- }
-
- /**
- * Displays HTML for changing one or more columns
- *
- * @param array $selected the selected columns
- * @param string $action target script to call
- * @param ContainerBuilder $containerBuilder Container builder instance (Used in tbl_columns_definition_form.inc.php)
- *
- * @return void
- */
- protected function displayHtmlForColumnChange($selected, $action, ContainerBuilder $containerBuilder)
- {
- // $selected comes from mult_submits.inc.php
- if (empty($selected)) {
- $selected[] = $_REQUEST['field'];
- $selected_cnt = 1;
- } else { // from a multiple submit
- $selected_cnt = count($selected);
- }
-
- /**
- * @todo optimize in case of multiple fields to modify
- */
- $fields_meta = [];
- for ($i = 0; $i < $selected_cnt; $i++) {
- $value = $this->dbi->getColumns(
- $this->db,
- $this->table,
- $this->dbi->escapeString($selected[$i]),
- true
- );
- if (count($value) === 0) {
- $message = Message::error(
- __('Failed to get description of column %s!')
- );
- $message->addParam($selected[$i]);
- $this->response->addHTML($message);
- } else {
- $fields_meta[] = $value;
- }
- }
- $num_fields = count($fields_meta);
- // set these globals because tbl_columns_definition_form.inc.php
- // verifies them
- // @todo: refactor tbl_columns_definition_form.inc.php so that it uses
- // protected function params
- $GLOBALS['action'] = $action;
- $GLOBALS['num_fields'] = $num_fields;
-
- /**
- * Form for changing properties.
- */
- $checkUserPrivileges = new CheckUserPrivileges($this->dbi);
- $checkUserPrivileges->getPrivileges();
-
- include ROOT_PATH . 'libraries/tbl_columns_definition_form.inc.php';
- }
-
- /**
- * Displays HTML for partition change
- *
- * @return void
- */
- protected function displayHtmlForPartitionChange()
- {
- $partitionDetails = null;
- if (! isset($_POST['partition_by'])) {
- $partitionDetails = $this->_extractPartitionDetails();
- }
-
- $partitionDetails = TablePartitionDefinition::getDetails($partitionDetails);
- $this->response->addHTML(
- $this->template->render('table/structure/partition_definition_form', [
- 'db' => $this->db,
- 'table' => $this->table,
- 'partition_details' => $partitionDetails,
- ])
- );
- }
-
- /**
- * Extracts partition details from CREATE TABLE statement
- *
- * @return array[]|null array of partition details
- */
- private function _extractPartitionDetails()
- {
- $createTable = (new Table($this->table, $this->db))->showCreate();
- if (! $createTable) {
- return null;
- }
-
- $parser = new Parser($createTable);
- /**
- * @var CreateStatement $stmt
- */
- $stmt = $parser->statements[0];
-
- $partitionDetails = [];
-
- $partitionDetails['partition_by'] = '';
- $partitionDetails['partition_expr'] = '';
- $partitionDetails['partition_count'] = '';
-
- if (! empty($stmt->partitionBy)) {
- $openPos = strpos($stmt->partitionBy, "(");
- $closePos = strrpos($stmt->partitionBy, ")");
-
- $partitionDetails['partition_by']
- = trim(substr($stmt->partitionBy, 0, $openPos));
- $partitionDetails['partition_expr']
- = trim(substr($stmt->partitionBy, $openPos + 1, $closePos - ($openPos + 1)));
- if (isset($stmt->partitionsNum)) {
- $count = $stmt->partitionsNum;
- } else {
- $count = count($stmt->partitions);
- }
- $partitionDetails['partition_count'] = $count;
- }
-
- $partitionDetails['subpartition_by'] = '';
- $partitionDetails['subpartition_expr'] = '';
- $partitionDetails['subpartition_count'] = '';
-
- if (! empty($stmt->subpartitionBy)) {
- $openPos = strpos($stmt->subpartitionBy, "(");
- $closePos = strrpos($stmt->subpartitionBy, ")");
-
- $partitionDetails['subpartition_by']
- = trim(substr($stmt->subpartitionBy, 0, $openPos));
- $partitionDetails['subpartition_expr']
- = trim(substr($stmt->subpartitionBy, $openPos + 1, $closePos - ($openPos + 1)));
- if (isset($stmt->subpartitionsNum)) {
- $count = $stmt->subpartitionsNum;
- } else {
- $count = count($stmt->partitions[0]->subpartitions);
- }
- $partitionDetails['subpartition_count'] = $count;
- }
-
- // Only LIST and RANGE type parameters allow subpartitioning
- $partitionDetails['can_have_subpartitions']
- = $partitionDetails['partition_count'] > 1
- && ($partitionDetails['partition_by'] == 'RANGE'
- || $partitionDetails['partition_by'] == 'RANGE COLUMNS'
- || $partitionDetails['partition_by'] == 'LIST'
- || $partitionDetails['partition_by'] == 'LIST COLUMNS');
-
- // Values are specified only for LIST and RANGE type partitions
- $partitionDetails['value_enabled'] = isset($partitionDetails['partition_by'])
- && ($partitionDetails['partition_by'] == 'RANGE'
- || $partitionDetails['partition_by'] == 'RANGE COLUMNS'
- || $partitionDetails['partition_by'] == 'LIST'
- || $partitionDetails['partition_by'] == 'LIST COLUMNS');
-
- $partitionDetails['partitions'] = [];
-
- for ($i = 0, $iMax = (int) $partitionDetails['partition_count']; $i < $iMax; $i++) {
- if (! isset($stmt->partitions[$i])) {
- $partitionDetails['partitions'][$i] = [
- 'name' => 'p' . $i,
- 'value_type' => '',
- 'value' => '',
- 'engine' => '',
- 'comment' => '',
- 'data_directory' => '',
- 'index_directory' => '',
- 'max_rows' => '',
- 'min_rows' => '',
- 'tablespace' => '',
- 'node_group' => '',
- ];
- } else {
- $p = $stmt->partitions[$i];
- $type = $p->type;
- $expr = trim((string) $p->expr, '()');
- if ($expr == 'MAXVALUE') {
- $type .= ' MAXVALUE';
- $expr = '';
- }
- $partitionDetails['partitions'][$i] = [
- 'name' => $p->name,
- 'value_type' => $type,
- 'value' => $expr,
- 'engine' => $p->options->has('ENGINE', true),
- 'comment' => trim((string) $p->options->has('COMMENT', true), "'"),
- 'data_directory' => trim((string) $p->options->has('DATA DIRECTORY', true), "'"),
- 'index_directory' => trim((string) $p->options->has('INDEX_DIRECTORY', true), "'"),
- 'max_rows' => $p->options->has('MAX_ROWS', true),
- 'min_rows' => $p->options->has('MIN_ROWS', true),
- 'tablespace' => $p->options->has('TABLESPACE', true),
- 'node_group' => $p->options->has('NODEGROUP', true),
- ];
- }
-
- $partition =& $partitionDetails['partitions'][$i];
- $partition['prefix'] = 'partitions[' . $i . ']';
-
- if ($partitionDetails['subpartition_count'] > 1) {
- $partition['subpartition_count'] = $partitionDetails['subpartition_count'];
- $partition['subpartitions'] = [];
-
- for ($j = 0, $jMax = (int) $partitionDetails['subpartition_count']; $j < $jMax; $j++) {
- if (! isset($stmt->partitions[$i]->subpartitions[$j])) {
- $partition['subpartitions'][$j] = [
- 'name' => $partition['name'] . '_s' . $j,
- 'engine' => '',
- 'comment' => '',
- 'data_directory' => '',
- 'index_directory' => '',
- 'max_rows' => '',
- 'min_rows' => '',
- 'tablespace' => '',
- 'node_group' => '',
- ];
- } else {
- $sp = $stmt->partitions[$i]->subpartitions[$j];
- $partition['subpartitions'][$j] = [
- 'name' => $sp->name,
- 'engine' => $sp->options->has('ENGINE', true),
- 'comment' => trim($sp->options->has('COMMENT', true), "'"),
- 'data_directory' => trim($sp->options->has('DATA DIRECTORY', true), "'"),
- 'index_directory' => trim($sp->options->has('INDEX_DIRECTORY', true), "'"),
- 'max_rows' => $sp->options->has('MAX_ROWS', true),
- 'min_rows' => $sp->options->has('MIN_ROWS', true),
- 'tablespace' => $sp->options->has('TABLESPACE', true),
- 'node_group' => $sp->options->has('NODEGROUP', true),
- ];
- }
-
- $subpartition =& $partition['subpartitions'][$j];
- $subpartition['prefix'] = 'partitions[' . $i . ']'
- . '[subpartitions][' . $j . ']';
- }
- }
- }
-
- return $partitionDetails;
- }
-
- /**
- * Update the table's partitioning based on $_REQUEST
- *
- * @return void
- */
- protected function updatePartitioning()
- {
- $sql_query = "ALTER TABLE " . Util::backquote($this->table) . " "
- . $this->createAddField->getPartitionsDefinition();
-
- // Execute alter query
- $result = $this->dbi->tryQuery($sql_query);
-
- if ($result !== false) {
- $message = Message::success(
- __('Table %1$s has been altered successfully.')
- );
- $message->addParam($this->table);
- $this->response->addHTML(
- Util::getMessage($message, $sql_query, 'success')
- );
- } else {
- $this->response->setRequestStatus(false);
- $this->response->addJSON(
- 'message',
- Message::rawError(
- __('Query error') . ':<br>' . $this->dbi->getError()
- )
- );
- }
- }
-
- /**
- * Function to get the type of command for multiple field handling
- *
- * @return string|null
- */
- protected function getMultipleFieldCommandType()
- {
- $types = [
- 'change',
- 'drop',
- 'primary',
- 'index',
- 'unique',
- 'spatial',
- 'fulltext',
- 'browse',
- ];
-
- foreach ($types as $type) {
- if (isset($_POST['submit_mult_' . $type . '_x'])) {
- return $type;
- }
- }
-
- if (isset($_POST['submit_mult'])) {
- return $_POST['submit_mult'];
- } elseif (isset($_POST['mult_btn'])
- && $_POST['mult_btn'] == __('Yes')
- ) {
- if (isset($_POST['selected'])) {
- $_POST['selected_fld'] = $_POST['selected'];
- }
- return 'row_delete';
- }
-
- return null;
- }
-
- /**
- * Function to display table browse for selected columns
- *
- * @param string $goto goto page url
- * @param string $pmaThemeImage URI of the pma theme image
- *
- * @return void
- */
- protected function displayTableBrowseForSelectedColumns($goto, $pmaThemeImage)
- {
- $GLOBALS['active_page'] = 'sql.php';
- $fields = [];
- foreach ($_POST['selected_fld'] as $sval) {
- $fields[] = Util::backquote($sval);
- }
- $sql_query = sprintf(
- 'SELECT %s FROM %s.%s',
- implode(', ', $fields),
- Util::backquote($this->db),
- Util::backquote($this->table)
- );
-
- // Parse and analyze the query
- $db = &$this->db;
- list(
- $analyzed_sql_results,
- $db,
- ) = ParseAnalyze::sqlQuery($sql_query, $db);
- // @todo: possibly refactor
- extract($analyzed_sql_results);
-
- $sql = new Sql();
- $this->response->addHTML(
- $sql->executeQueryAndGetQueryResponse(
- isset($analyzed_sql_results) ? $analyzed_sql_results : '',
- false, // is_gotofile
- $this->db, // db
- $this->table, // table
- null, // find_real_end
- null, // sql_query_for_bookmark
- null, // extra_data
- null, // message_to_show
- null, // message
- null, // sql_data
- $goto, // goto
- $pmaThemeImage, // pmaThemeImage
- null, // disp_query
- null, // disp_message
- null, // query_type
- $sql_query, // sql_query
- null, // selectedTables
- null // complete_query
- )
- );
- }
-
- /**
- * Update the table's structure based on $_REQUEST
- *
- * @return boolean true if error occurred
- *
- */
- protected function updateColumns()
- {
- $err_url = 'tbl_structure.php' . Url::getCommon(
- [
- 'db' => $this->db,
- 'table' => $this->table,
- ]
- );
- $regenerate = false;
- $field_cnt = count($_POST['field_name']);
- $changes = [];
- $adjust_privileges = [];
- $columns_with_index = $this->dbi
- ->getTable($this->db, $this->table)
- ->getColumnsWithIndex(
- Index::PRIMARY | Index::UNIQUE
- );
- for ($i = 0; $i < $field_cnt; $i++) {
- if (! $this->columnNeedsAlterTable($i)) {
- continue;
- }
-
- $changes[] = 'CHANGE ' . Table::generateAlter(
- Util::getValueByKey($_POST, "field_orig.${i}", ''),
- $_POST['field_name'][$i],
- $_POST['field_type'][$i],
- $_POST['field_length'][$i],
- $_POST['field_attribute'][$i],
- Util::getValueByKey($_POST, "field_collation.${i}", ''),
- Util::getValueByKey($_POST, "field_null.${i}", 'NO'),
- $_POST['field_default_type'][$i],
- $_POST['field_default_value'][$i],
- Util::getValueByKey($_POST, "field_extra.${i}", false),
- Util::getValueByKey($_POST, "field_comments.${i}", ''),
- Util::getValueByKey($_POST, "field_virtuality.${i}", ''),
- Util::getValueByKey($_POST, "field_expression.${i}", ''),
- Util::getValueByKey($_POST, "field_move_to.${i}", ''),
- $columns_with_index
- );
-
- // find the remembered sort expression
- $sorted_col = $this->table_obj->getUiProp(
- Table::PROP_SORTED_COLUMN
- );
- // if the old column name is part of the remembered sort expression
- if (mb_strpos(
- (string) $sorted_col,
- Util::backquote($_POST['field_orig'][$i])
- ) !== false) {
- // delete the whole remembered sort expression
- $this->table_obj->removeUiProp(Table::PROP_SORTED_COLUMN);
- }
-
- if (isset($_POST['field_adjust_privileges'][$i])
- && ! empty($_POST['field_adjust_privileges'][$i])
- && $_POST['field_orig'][$i] != $_POST['field_name'][$i]
- ) {
- $adjust_privileges[$_POST['field_orig'][$i]]
- = $_POST['field_name'][$i];
- }
- } // end for
-
- if (count($changes) > 0 || isset($_POST['preview_sql'])) {
- // Builds the primary keys statements and updates the table
- $key_query = '';
- /**
- * this is a little bit more complex
- *
- * @todo if someone selects A_I when altering a column we need to check:
- * - no other column with A_I