3 declare(strict_types
=1);
5 namespace PhpMyAdmin\Partitioning
;
7 use PhpMyAdmin\DatabaseInterface
;
8 use PhpMyAdmin\Identifiers\DatabaseName
;
9 use PhpMyAdmin\Identifiers\TableName
;
10 use PhpMyAdmin\Table\Table
;
16 final class Maintenance
18 public function __construct(private DatabaseInterface
$dbi)
22 /** @return mixed[] */
23 public function analyze(DatabaseName
$db, TableName
$table, string $partition): array
26 'ALTER TABLE %s ANALYZE PARTITION %s;',
27 Util
::backquote($table->getName()),
28 Util
::backquote($partition),
31 $this->dbi
->selectDb($db);
32 $result = $this->dbi
->fetchResult($query);
35 foreach ($result as $row) {
36 $rows[$row['Table']][] = $row;
39 return [$rows, $query];
42 /** @return mixed[] */
43 public function check(DatabaseName
$db, TableName
$table, string $partition): array
46 'ALTER TABLE %s CHECK PARTITION %s;',
47 Util
::backquote($table->getName()),
48 Util
::backquote($partition),
51 $this->dbi
->selectDb($db);
52 $result = $this->dbi
->fetchResult($query);
55 foreach ($result as $row) {
56 $rows[$row['Table']][] = $row;
59 return [$rows, $query];
62 /** @return mixed[] */
63 public function drop(DatabaseName
$db, TableName
$table, string $partition): array
66 'ALTER TABLE %s DROP PARTITION %s;',
67 Util
::backquote($table->getName()),
68 Util
::backquote($partition),
71 $this->dbi
->selectDb($db);
72 $result = $this->dbi
->tryQuery($query);
74 return [(bool) $result, $query];
77 /** @return mixed[] */
78 public function optimize(DatabaseName
$db, TableName
$table, string $partition): array
81 'ALTER TABLE %s OPTIMIZE PARTITION %s;',
82 Util
::backquote($table->getName()),
83 Util
::backquote($partition),
86 $this->dbi
->selectDb($db);
87 $result = $this->dbi
->fetchResult($query);
90 foreach ($result as $row) {
91 $rows[$row['Table']][] = $row;
94 return [$rows, $query];
98 * @return array<int, bool|string>
99 * @psalm-return array{bool, string}
101 public function rebuild(DatabaseName
$db, TableName
$table, string $partition): array
104 'ALTER TABLE %s REBUILD PARTITION %s;',
105 Util
::backquote($table->getName()),
106 Util
::backquote($partition),
109 $this->dbi
->selectDb($db);
110 $result = $this->dbi
->tryQuery($query);
112 return [(bool) $result, $query];
115 /** @return mixed[] */
116 public function repair(DatabaseName
$db, TableName
$table, string $partition): array
119 'ALTER TABLE %s REPAIR PARTITION %s;',
120 Util
::backquote($table->getName()),
121 Util
::backquote($partition),
124 $this->dbi
->selectDb($db);
125 $result = $this->dbi
->fetchResult($query);
128 foreach ($result as $row) {
129 $rows[$row['Table']][] = $row;
132 return [$rows, $query];
136 * @return array<int, bool|string>
137 * @psalm-return array{bool, string}
139 public function truncate(DatabaseName
$db, TableName
$table, string $partition): array
141 if (Table
::get($table->getName(), $db->getName(), $this->dbi
)->isView()) {
142 return [false, __('This table is a view, it can not be truncated.')];
146 'ALTER TABLE %s TRUNCATE PARTITION %s;',
147 Util
::backquote($table->getName()),
148 Util
::backquote($partition),
151 $this->dbi
->selectDb($db);
152 $result = $this->dbi
->tryQuery($query);
154 return [(bool) $result, $query];