bin/cleandb


1
2
3
4
5
6
7
8
9
10
11
12
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();