libraries/Partition.class.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * Library for extracting information about the partitions
   5  *
   6  * @package PhpMyAdmin
   7  */
   8 if (! defined('PHPMYADMIN')) {
   9     exit;
  10 }
  11
  12 /**
  13  * base Partition Class
  14  *
  15  * @package PhpMyAdmin
  16  */
  17 class PMA_Partition
  18 {
  19     /**
  20      * returns array of partition names for a specific db/table
  21      *
  22      * @param string $db    database name
  23      * @param string $table table name
  24      *
  25      * @access  public
  26      * @return array   of partition names
  27      */
  28     static public function getPartitionNames($db, $table)
  29     {
  30         if (PMA_Partition::havePartitioning()) {
  31             return $GLOBALS['dbi']->fetchResult(
  32                 "SELECT `PARTITION_NAME` FROM `information_schema`.`PARTITIONS`"
  33                 . " WHERE `TABLE_SCHEMA` = '" . $db
  34                 . "' AND `TABLE_NAME` = '" . $table . "'"
  35             );
  36         } else {
  37             return array();
  38         }
  39     }
  40
  41     /**
  42      * checks if MySQL server supports partitioning
  43      *
  44      * @static
  45      * @staticvar boolean $have_partitioning
  46      * @staticvar boolean $already_checked
  47      * @access  public
  48      * @return boolean
  49      */
  50     static public function havePartitioning()
  51     {
  52         static $have_partitioning = false;
  53         static $already_checked = false;
  54
  55         if (! $already_checked) {
  56             if (PMA_MYSQL_INT_VERSION < 50600) {
  57                 if ($GLOBALS['dbi']->fetchValue(
  58                     "SHOW VARIABLES LIKE 'have_partitioning';"
  59                 )) {
  60                     $have_partitioning = true;
  61                 }
  62             } else {
  63                 // see http://dev.mysql.com/doc/refman/5.6/en/partitioning.html
  64                 $plugins = $GLOBALS['dbi']->fetchResult("SHOW PLUGINS");
  65                 foreach ($plugins as $value) {
  66                     if ($value['Name'] == 'partition') {
  67                         $have_partitioning = true;
  68                         break;
  69                     }
  70                 }
  71             }
  72             $already_checked = true;
  73         }
  74         return $have_partitioning;
  75     }
  76 }
  77 ?>