/** * Deletes an entire addressbook and all its contents * * @param mixed $addressBookId * @return void */ function deleteAddressBook($addressBookId) { $query = $this->db->getQueryBuilder(); $query->delete('cards')->where($query->expr()->eq('addressbookid', $query->createParameter('addressbookid')))->setParameter('addressbookid', $addressBookId)->execute(); $query->delete('addressbookchanges')->where($query->expr()->eq('addressbookid', $query->createParameter('addressbookid')))->setParameter('addressbookid', $addressBookId)->execute(); $query->delete('addressbooks')->where($query->expr()->eq('id', $query->createParameter('id')))->setParameter('id', $addressBookId)->execute(); $this->sharingBackend->deleteAllShares($addressBookId); $query->delete($this->dbCardsPropertiesTable)->where($query->expr()->eq('addressbookid', $query->createNamedParameter($addressBookId)))->execute(); }
/** * Delete a calendar and all it's objects * * @param mixed $calendarId * @return void */ function deleteCalendar($calendarId) { $stmt = $this->db->prepare('DELETE FROM `*PREFIX*calendarobjects` WHERE `calendarid` = ?'); $stmt->execute([$calendarId]); $stmt = $this->db->prepare('DELETE FROM `*PREFIX*calendars` WHERE `id` = ?'); $stmt->execute([$calendarId]); $stmt = $this->db->prepare('DELETE FROM `*PREFIX*calendarchanges` WHERE `calendarid` = ?'); $stmt->execute([$calendarId]); $this->sharingBackend->deleteAllShares($calendarId); }