nextcloud / server

	 * @param string $uri

	 * @return int

	 */

	protected function getCardId($addressBookId, $uri) {

		$query = $this->db->getQueryBuilder();

		$query->select('id')->from($this->dbCardsTable)

			->where($query->expr()->eq('uri', $query->createNamedParameter($uri)))

			->andWhere($query->expr()->eq('addressbookid', $query->createNamedParameter($addressBookId)));

		$result = $query->execute();

		$cardIds = $result->fetch();

		$result->closeCursor();

		if (!isset($cardIds['id'])) {

			throw new \InvalidArgumentException('Card does not exists: ' . $uri);

		}

		return (int)$cardIds['id'];

	}

	/**

	 * For shared address books the sharee is set in the ACL of the address book

	 * @return string

	 * @throws \Exception

	 */

	public function getToken($url) {

		$hash = $this->hash($url);

		$query = $this->connection->getQueryBuilder();

		$query->select('token')->from($this->dbTable)

			->where($query->expr()->eq('url_hash', $query->createParameter('url_hash')))

			->setParameter('url_hash', $hash);

		$statement = $query->execute();

		$result = $statement->fetch();

		$statement->closeCursor();

		if (!isset($result['token'])) {

			throw new \Exception('No token found for: ' . $url);

		}

		return $result['token'];

	}

	/**

	 * add shared Secret to database

	 * @param string $uri

	 * @return int

	 */

	protected function getCalendarObjectId($calendarId, $uri) {

		$query = $this->db->getQueryBuilder();

		$query->select('id')->from('calendarobjects')

			->where($query->expr()->eq('uri', $query->createNamedParameter($uri)))

			->andWhere($query->expr()->eq('calendarid', $query->createNamedParameter($calendarId)));

		$result = $query->execute();

		$objectIds = $result->fetch();

		$result->closeCursor();

		if (!isset($objectIds['id'])) {

			throw new \InvalidArgumentException('Calendarobject does not exists: ' . $uri);

		}

		return (int)$objectIds['id'];

	}

	private function convertPrincipal($principalUri, $toV2) {

		if ($this->principalBackend->getPrincipalPrefix() === 'principals') {