You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
93 lines
2.7 KiB
93 lines
2.7 KiB
<?php |
|
|
|
declare(strict_types=1); |
|
|
|
namespace PhpMyAdmin\Controllers\Table\Maintenance; |
|
|
|
use PhpMyAdmin\Config; |
|
use PhpMyAdmin\Controllers\Table\AbstractController; |
|
use PhpMyAdmin\Dbal\DatabaseName; |
|
use PhpMyAdmin\Dbal\TableName; |
|
use PhpMyAdmin\Html\Generator; |
|
use PhpMyAdmin\Http\ServerRequest; |
|
use PhpMyAdmin\Message; |
|
use PhpMyAdmin\ResponseRenderer; |
|
use PhpMyAdmin\Table\Maintenance; |
|
use PhpMyAdmin\Template; |
|
use Webmozart\Assert\Assert; |
|
use Webmozart\Assert\InvalidArgumentException; |
|
|
|
use function __; |
|
use function count; |
|
|
|
final class AnalyzeController extends AbstractController |
|
{ |
|
/** @var Maintenance */ |
|
private $model; |
|
|
|
/** @var Config */ |
|
private $config; |
|
|
|
public function __construct( |
|
ResponseRenderer $response, |
|
Template $template, |
|
string $db, |
|
string $table, |
|
Maintenance $model, |
|
Config $config |
|
) { |
|
parent::__construct($response, $template, $db, $table); |
|
$this->model = $model; |
|
$this->config = $config; |
|
} |
|
|
|
public function __invoke(ServerRequest $request): void |
|
{ |
|
$selectedTablesParam = $request->getParsedBodyParam('selected_tbl'); |
|
|
|
try { |
|
Assert::isArray($selectedTablesParam); |
|
Assert::notEmpty($selectedTablesParam); |
|
Assert::allStringNotEmpty($selectedTablesParam); |
|
} catch (InvalidArgumentException $exception) { |
|
$this->response->setRequestStatus(false); |
|
$this->response->addJSON('message', __('No table selected.')); |
|
|
|
return; |
|
} |
|
|
|
try { |
|
$database = DatabaseName::fromValue($request->getParam('db')); |
|
$selectedTables = []; |
|
foreach ($selectedTablesParam as $table) { |
|
$selectedTables[] = TableName::fromValue($table); |
|
} |
|
} catch (InvalidArgumentException $exception) { |
|
$message = Message::error($exception->getMessage()); |
|
$this->response->setRequestStatus(false); |
|
$this->response->addJSON('message', $message->getDisplay()); |
|
|
|
return; |
|
} |
|
|
|
if ($this->config->get('DisableMultiTableMaintenance') && count($selectedTables) > 1) { |
|
$this->response->setRequestStatus(false); |
|
$this->response->addJSON('message', __('Maintenance operations on multiple tables are disabled.')); |
|
|
|
return; |
|
} |
|
|
|
[$rows, $query] = $this->model->getAnalyzeTableRows($database, $selectedTables); |
|
|
|
$message = Generator::getMessage( |
|
__('Your SQL query has been executed successfully.'), |
|
$query, |
|
'success' |
|
); |
|
|
|
$this->render('table/maintenance/analyze', [ |
|
'message' => $message, |
|
'rows' => $rows, |
|
]); |
|
} |
|
}
|
|
|