public function delete(\Archive\Port\Adaptor\Data\School\Persons\Person $person)
{
$app = \App::getInstance();
$conn = $app->DB_CONNECT;
$params = [];
$qb = new \Archive\Port\Adaptor\Persistence\QueryBuilder($params);
$query = $qb->delete()->from()->t("resources")->where()->c("id")->eq()->val($person->getID())->fi();
$sth = $conn->prepare($query);
$sth->execute($params);
// delete person keys
$params = [];
$qb = new \Archive\Port\Adaptor\Persistence\QueryBuilder($params);
$query = $qb->delete()->from()->t("persons_keys")->where()->c("id")->eq()->val($person->getID())->fi();
$sth1 = $conn->prepare($query);
$sth1->execute($params);
// delete all person links
$params = [];
$sth2 = $conn->prepare("DELETE FROM `links` WHERE `source`=? OR `destination`=?;");
$sth2->execute($params);
return $person;
}
