Blame view

pma/libraries/Partition.class.php 1.32 KB
a1684257   Administrator   first commit
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
  <?php
  /* vim: set expandtab sw=4 ts=4 sts=4: */
  /**
   * Library for extracting information about the partitions
   *
   * @package PhpMyAdmin
   */
  
  
  /**
   * base Partition Class
   * @package PhpMyAdmin
   */
  class PMA_Partition
  {
      /**
       * returns array of partition names for a specific db/table
       *
       * @access  public
       * @return  array   of partition names
       */
      static public function getPartitionNames($db, $table)
      {
          if (PMA_Partition::havePartitioning()) {
              return PMA_DBI_fetch_result("select `PARTITION_NAME` from `information_schema`.`PARTITIONS` where `TABLE_SCHEMA` = '" . $db . "' and `TABLE_NAME` = '" . $table . "'");
          } else {
              return array();
          }
      }
  
      /**
       * checks if MySQL server supports partitioning
       *
       * @static
       * @staticvar boolean $have_partitioning
       * @staticvar boolean $already_checked
       * @access  public
       * @return  boolean
       */
      static public function havePartitioning()
      {
          static $have_partitioning = false;
          static $already_checked = false;
  
          if (! $already_checked) {
              $have_partitioning = PMA_MYSQL_INT_VERSION >= 50100 && PMA_DBI_fetch_value("SHOW VARIABLES LIKE 'have_partitioning';");
              $already_checked = true;
          }
          return $have_partitioning;
      }
  
  }
  
  ?>