Create drop table partition page

Signed-off-by: Maurício Meneghini Fauth <mauricio@fauth.dev>

1 files changed, 14 insertions, 0 deletions

diff --git a/libraries/classes/Table/Partition.php b/libraries/classes/Table/Partition.php
index c9f9912c18..2edb571f40 100644
--- a/libraries/classes/Table/Partition.php
+++ b/libraries/classes/Table/Partition.php
@@ -55,4 +55,18 @@ final class Partition
 
         return [$rows, $query];
     }
+
+    public function drop(string $db, string $table, string $partition): array
+    {
+        $query = sprintf(
+            'ALTER TABLE %s DROP PARTITION %s;',
+            Util::backquote($table),
+            Util::backquote($partition)
+        );
+
+        $this->dbi->selectDb($db);
+        $result = $this->dbi->tryQuery($query);
+
+        return [(bool) $result, $query];
+    }
 }