phpmyadmin working

1 files changed, 182 insertions, 0 deletions

diff --git a/srcs/phpmyadmin/libraries/classes/SubPartition.php b/srcs/phpmyadmin/libraries/classes/SubPartition.php
new file mode 100644
index 0000000..a5eac8b
--- /dev/null
+++ b/srcs/phpmyadmin/libraries/classes/SubPartition.php
@@ -0,0 +1,182 @@
+<?php
+/* vim: set expandtab sw=4 ts=4 sts=4: */
+/**
+ * Library for extracting information about the sub-partitions
+ *
+ * @package PhpMyAdmin
+ */
+declare(strict_types=1);
+
+namespace PhpMyAdmin;
+
+/**
+ * Represents a sub partition of a table
+ *
+ * @package PhpMyAdmin
+ */
+class SubPartition
+{
+    /**
+     * @var string the database
+     */
+    protected $db;
+    /**
+     * @var string the table
+     */
+    protected $table;
+    /**
+     * @var string partition name
+     */
+    protected $name;
+    /**
+     * @var integer ordinal
+     */
+    protected $ordinal;
+    /**
+     * @var string partition method
+     */
+    protected $method;
+    /**
+     * @var string partition expression
+     */
+    protected $expression;
+    /**
+     * @var integer no of table rows in the partition
+     */
+    protected $rows;
+    /**
+     * @var integer data length
+     */
+    protected $dataLength;
+    /**
+     * @var integer index length
+     */
+    protected $indexLength;
+    /**
+     * @var string partition comment
+     */
+    protected $comment;
+
+    /**
+     * Constructs a partition
+     *
+     * @param array $row fetched row from information_schema.PARTITIONS
+     */
+    public function __construct(array $row)
+    {
+        $this->db = $row['TABLE_SCHEMA'];
+        $this->table = $row['TABLE_NAME'];
+        $this->loadData($row);
+    }
+
+    /**
+     * Loads data from the fetched row from information_schema.PARTITIONS
+     *
+     * @param array $row fetched row
+     *
+     * @return void
+     */
+    protected function loadData(array $row)
+    {
+        $this->name = $row['SUBPARTITION_NAME'];
+        $this->ordinal = $row['SUBPARTITION_ORDINAL_POSITION'];
+        $this->method = $row['SUBPARTITION_METHOD'];
+        $this->expression = $row['SUBPARTITION_EXPRESSION'];
+        $this->loadCommonData($row);
+    }
+
+    /**
+     * Loads some data that is common to both partitions and sub partitions
+     *
+     * @param array $row fetched row
+     *
+     * @return void
+     */
+    protected function loadCommonData(array $row)
+    {
+        $this->rows = $row['TABLE_ROWS'];
+        $this->dataLength = $row['DATA_LENGTH'];
+        $this->indexLength = $row['INDEX_LENGTH'];
+        $this->comment = $row['PARTITION_COMMENT'];
+    }
+
+    /**
+     * Return the partition name
+     *
+     * @return string partition name
+     */
+    public function getName()
+    {
+        return $this->name;
+    }
+
+    /**
+     * Return the ordinal of the partition
+     *
+     * @return int the ordinal
+     */
+    public function getOrdinal()
+    {
+        return $this->ordinal;
+    }
+
+    /**
+     * Returns the partition method
+     *
+     * @return string partition method
+     */
+    public function getMethod()
+    {
+        return $this->method;
+    }
+
+    /**
+     * Returns the partition expression
+     *
+     * @return string partition expression
+     */
+    public function getExpression()
+    {
+        return $this->expression;
+    }
+
+    /**
+     * Returns the number of data rows
+     *
+     * @return integer number of rows
+     */
+    public function getRows()
+    {
+        return $this->rows;
+    }
+
+    /**
+     * Returns the data length
+     *
+     * @return integer data length
+     */
+    public function getDataLength()
+    {
+        return $this->dataLength;
+    }
+
+    /**
+     * Returns the index length
+     *
+     * @return integer index length
+     */
+    public function getIndexLength()
+    {
+        return $this->indexLength;
+    }
+
+    /**
+     * Returns the partition comment
+     *
+     * @return string partition comment
+     */
+    public function getComment()
+    {
+        return $this->comment;
+    }
+}