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; }