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  * @version $Id$
   7  * @package phpMyAdmin
   8  */
   9
  10
  11 /**
  12  * base Partition Class
  13  * @package phpMyAdmin
  14  */
  15 class PMA_Partition
  16 {
  17     /**
  18      * returns array of partition names for a specific db/table
  19      *
  20      * @access  public
  21      * @uses    PMA_DBI_fetch_result()
  22      * @return  array   of partition names
  23      */
  24     static public function getPartitionNames($db, $table)
  25     {
  26         if (PMA_Partition::havePartitioning()) {
  27             return PMA_DBI_fetch_result("select `PARTITION_NAME` from `information_schema`.`PARTITIONS` where `TABLE_SCHEMA` = '" . $db . "' and `TABLE_NAME` = '" . $table . "'");
  28         } else {
  29             return array();
  30         }
  31     }
  32
  33     /**
  34      * checks if MySQL server supports partitioning
  35      *
  36      * @static
  37      * @staticvar boolean $have_partitioning
  38      * @staticvar boolean $already_checked
  39      * @access  public
  40      * @uses    PMA_DBI_fetch_result()
  41      * @return  boolean
  42      */
  43     static public function havePartitioning()
  44     {
  45         static $have_partitioning = false;
  46         static $already_checked = false;
  47
  48         if (! $already_checked) {
  49             $have_partitioning = PMA_MYSQL_INT_VERSION >= 50100 && PMA_DBI_fetch_value("SHOW VARIABLES LIKE 'have_partitioning';");
  50             $already_checked = true;
  51         }
  52         return $have_partitioning;
  53     }
  54
  55 }
  56
  57 ?>