class StructureController extends AbstractController

Displays table structure infos like columns, indexes, size, rows and allows manipulation of indexes and columns.

Properties

protected Response $response from AbstractController
protected DatabaseInterface $dbi from AbstractController
protected Template $template from AbstractController
protected string $db from AbstractController
protected string $table from AbstractController
protected Table $table_obj
protected string $_url_query

Methods

__construct(Response $response, DatabaseInterface $dbi, Template $template, string $db, string $table, Relation $relation, Transformations $transformations, CreateAddField $createAddField)

No description

void
index()

No description

void
moveColumns()

Moves columns in the table's structure based on $_REQUEST

void
displayHtmlForColumnChange(array $selected, string $action)

Displays HTML for changing one or more columns

void
displayHtmlForPartitionChange()

Displays HTML for partition change

void
updatePartitioning()

Update the table's partitioning based on $_REQUEST

string|null
getMultipleFieldCommandType()

Function to get the type of command for multiple field handling

void
displayTableBrowseForSelectedColumns(string $goto, string $pmaThemeImage)

Function to display table browse for selected columns

bool
updateColumns()

Update the table's structure based on $_REQUEST

bool
adjustColumnPrivileges(array $adjust_privileges)

Adjusts the Privileges for all the columns whose names have changed

bool
columnNeedsAlterTable(int $i)

Verifies if some elements of a column have changed

string
displayStructure(array $cfgRelation, array $columns_with_unique_index, mixed $url_params, Index|false $primary_index, array $fields, array $columns_with_index)

Displays the table structure ('show table' works correct since 3.23.03)

string
getTableStats()

Get HTML snippet for display table statistics

string
getKeyForTablePrimary()

Gets table primary key

array
getDataForSubmitMult(string $submit_mult, array $selected, string $action)

Get List of information for Submit Mult

Details

at line 84
__construct(Response $response, DatabaseInterface $dbi, Template $template, string $db, string $table, Relation $relation, Transformations $transformations, CreateAddField $createAddField)

Parameters

Response $response Response object
DatabaseInterface $dbi DatabaseInterface object
Template $template Template that should be used
string $db Database name
string $table Table name
Relation $relation Relation instance
Transformations $transformations Transformations instance
CreateAddField $createAddField CreateAddField instance

at line 103
void index()

Return Value

void

at line 365
protected void moveColumns()

Moves columns in the table's structure based on $_REQUEST

Return Value

void

at line 495
protected void displayHtmlForColumnChange(array $selected, string $action)

Displays HTML for changing one or more columns

Parameters

array $selected the selected columns
string $action target script to call

Return Value

void

at line 556
protected void displayHtmlForPartitionChange()

Displays HTML for partition change

Return Value

void

at line 738
protected void updatePartitioning()

Update the table's partitioning based on $_REQUEST

Return Value

void

at line 770
protected string|null getMultipleFieldCommandType()

Function to get the type of command for multiple field handling

Return Value

string|null

at line 811
protected void displayTableBrowseForSelectedColumns(string $goto, string $pmaThemeImage)

Function to display table browse for selected columns

Parameters

string $goto goto page url
string $pmaThemeImage URI of the pma theme image

Return Value

void

at line 862
protected bool updateColumns()

Update the table's structure based on $_REQUEST

Return Value

bool true if error occurred

at line 1117
protected bool adjustColumnPrivileges(array $adjust_privileges)

Adjusts the Privileges for all the columns whose names have changed

Parameters

array $adjust_privileges assoc array of old col names mapped to new cols

Return Value

bool boolean whether at least one column privileges adjusted

at line 1162
protected bool columnNeedsAlterTable(int $i)

Verifies if some elements of a column have changed

Parameters

int $i column index in the request

Return Value

bool true if we need to generate ALTER TABLE

at line 1211
protected string displayStructure(array $cfgRelation, array $columns_with_unique_index, mixed $url_params, Index|false $primary_index, array $fields, array $columns_with_index)

Displays the table structure ('show table' works correct since 3.23.03)

Parameters

array $cfgRelation current relation parameters
array $columns_with_unique_index Columns with unique index
mixed $url_params Contains an associative array with url params
Index|false $primary_index primary index or false if no one exists
array $fields Fields
array $columns_with_index Columns with index

Return Value

string

at line 1378
protected string getTableStats()

Get HTML snippet for display table statistics

Return Value

string

at line 1513
protected string getKeyForTablePrimary()

Gets table primary key

Return Value

string

at line 1540
protected array getDataForSubmitMult(string $submit_mult, array $selected, string $action)

Get List of information for Submit Mult

Parameters

string $submit_mult mult_submit type
array $selected the selected columns
string $action action type

Return Value

array