���� JFIF �� � ( %"1"%)+...383,7(-.-
![]() Server : Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.4.20 System : Linux st2.domain.com 3.10.0-1127.10.1.el7.x86_64 #1 SMP Wed Jun 3 14:28:03 UTC 2020 x86_64 User : apache ( 48) PHP Version : 7.4.20 Disable Function : NONE Directory : /proc/self/root/usr/share/phpMyAdmin/libraries/classes/Table/ |
<?php declare(strict_types=1); namespace PhpMyAdmin\Table; use PhpMyAdmin\DatabaseInterface; use PhpMyAdmin\Util; use function sprintf; final class Partition { /** @var DatabaseInterface */ private $dbi; public function __construct(DatabaseInterface $dbi) { $this->dbi = $dbi; } public function analyze(string $db, string $table, string $partition): array { $query = sprintf( 'ALTER TABLE %s ANALYZE PARTITION %s;', Util::backquote($table), Util::backquote($partition) ); $this->dbi->selectDb($db); $result = $this->dbi->fetchResult($query); $rows = []; foreach ($result as $row) { $rows[$row['Table']][] = $row; } return [$rows, $query]; } public function check(string $db, string $table, string $partition): array { $query = sprintf( 'ALTER TABLE %s CHECK PARTITION %s;', Util::backquote($table), Util::backquote($partition) ); $this->dbi->selectDb($db); $result = $this->dbi->fetchResult($query); $rows = []; foreach ($result as $row) { $rows[$row['Table']][] = $row; } return [$rows, $query]; } public function drop(string $db, string $table, string $partition): array { $query = sprintf( 'ALTER TABLE %s DROP PARTITION %s;', Util::backquote($table), Util::backquote($partition) ); $this->dbi->selectDb($db); $result = $this->dbi->tryQuery($query); return [(bool) $result, $query]; } public function optimize(string $db, string $table, string $partition): array { $query = sprintf( 'ALTER TABLE %s OPTIMIZE PARTITION %s;', Util::backquote($table), Util::backquote($partition) ); $this->dbi->selectDb($db); $result = $this->dbi->fetchResult($query); $rows = []; foreach ($result as $row) { $rows[$row['Table']][] = $row; } return [$rows, $query]; } public function rebuild(string $db, string $table, string $partition): array { $query = sprintf( 'ALTER TABLE %s REBUILD PARTITION %s;', Util::backquote($table), Util::backquote($partition) ); $this->dbi->selectDb($db); $result = $this->dbi->tryQuery($query); return [(bool) $result, $query]; } public function repair(string $db, string $table, string $partition): array { $query = sprintf( 'ALTER TABLE %s REPAIR PARTITION %s;', Util::backquote($table), Util::backquote($partition) ); $this->dbi->selectDb($db); $result = $this->dbi->fetchResult($query); $rows = []; foreach ($result as $row) { $rows[$row['Table']][] = $row; } return [$rows, $query]; } public function truncate(string $db, string $table, string $partition): array { $query = sprintf( 'ALTER TABLE %s TRUNCATE PARTITION %s;', Util::backquote($table), Util::backquote($partition) ); $this->dbi->selectDb($db); $result = $this->dbi->tryQuery($query); return [(bool) $result, $query]; } }