src/DbTableExists.php

   1 <?php
   2
   3 declare(strict_types=1);
   4
   5 namespace PhpMyAdmin;
   6
   7 use PhpMyAdmin\Identifiers\DatabaseName;
   8 use PhpMyAdmin\Identifiers\TableName;
   9
  10 use function in_array;
  11 use function sprintf;
  12
  13 final class DbTableExists
  14 {
  15     /** @psalm-var list<non-empty-string> */
  16     private array $tables = [];
  17
  18     public function __construct(private readonly DatabaseInterface $dbi)
  19     {
  20     }
  21
  22     public function selectDatabase(DatabaseName $databaseName): bool
  23     {
  24         return $this->dbi->selectDb($databaseName);
  25     }
  26
  27     /**
  28      * Check if a table exists in the given database.
  29      * It will return true if the table exists, regardless if it's temporary or permanent.
  30      */
  31     public function hasTable(DatabaseName $database, TableName $table): bool
  32     {
  33         if (in_array($database->getName() . '.' . $table->getName(), $this->tables, true)) {
  34             return true;
  35         }
  36
  37         if ($this->tableExists($database, $table)) {
  38             $this->tables[] = $database->getName() . '.' . $table->getName();
  39
  40             return true;
  41         }
  42
  43         return false;
  44     }
  45
  46     private function tableExists(DatabaseName $database, TableName $table): bool
  47     {
  48         // SHOW TABLES doesn't show temporary tables, so try select.
  49         return $this->dbi->tryQuery(sprintf(
  50             'SELECT 1 FROM %s.%s LIMIT 1;',
  51             Util::backquote($database),
  52             Util::backquote($table),
  53         )) !== false;
  54     }
  55 }