run VACUUM command to free disc space

davidspeijer · Oct 8, 2019 · b061210 · b061210
1 parent 0ea1b56
commit b061210
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;');
+        }
     }
 }