owncloud / core

	 * @return array

	 * @throws \Exception

	 */

	public function getServerById($id) {

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

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

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

			->setParameter('id', $id);

		$query->execute();

		$result = $query->execute()->fetchAll();

		if (empty($result)) {

			throw new \Exception('No Server found with ID: ' . $id);

		}

		return $result[0];

	}

	/**

	 * get all trusted servers

	 * @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);

		$result = $query->execute()->fetch();

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

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

		}

		return $result['token'];

	}

	/**

	 * add shared Secret to database

	 * @param int $id

	 * @return string

	 */

	public function getCardUri($id) {

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

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

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

				->setParameter('id', $id);

		$result = $query->execute();

		$uri = $result->fetch();

		$result->closeCursor();

		if (!isset($uri['uri'])) {

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

		}

		return $uri['uri'];

	}

	/**

	 * return contact with the given URI