script to permadelete deleted objects

1 files changed, 13 insertions, 0 deletions

diff --git a/bin/cleandb b/bin/cleandb
new file mode 100755
index 0000000..94873bf
--- /dev/null
+++ b/bin/cleandb
@@ -0,0 +1,13 @@
+#!/usr/bin/env php
+<?php
+
+require __DIR__ . '/../vendor/autoload.php';
+
+$db = Digitigrade\Db::getInstance()->getPdo();
+$db->beginTransaction();
+$db->exec(<<<END
+DELETE FROM actor WHERE deleted = true;
+DELETE FROM note WHERE deleted = true;
+DELETE FROM interaction WHERE deleted = true;
+END);
+$db->commit();
\ No newline at end of file