Merge pull request #702 from davalb/vacuum

run VACUUM command to free disc space
cakephp · Oct 9, 2019 · 684016c · 684016c
2 parents 0ea1b56 + b061210
commit 684016c
Showing 1 changed file with 6 additions and 0 deletions.
diff --git a/src/Model/Table/RequestsTable.php b/src/Model/Table/RequestsTable.php
@@ -13,6 +13,7 @@
 namespace DebugKit\Model\Table;
 
 use Cake\Core\Configure;
+use Cake\Database\Driver\Sqlite;
 use Cake\ORM\Query;
 use Cake\ORM\Table;
 use DebugKit\Model\Entity\Request;
@@ -108,5 +109,10 @@ public function gc()
 
         $statement = $query->execute();
         $statement->closeCursor();
+
+        $conn = $this->getConnection();
+        if ($conn->getDriver() instanceof Sqlite) {
+            $conn->execute('VACUUM;');
+        }
     }
 }