nextcloud / notifications

	 * @param string $pushTokenHash

	 * @return bool If the entry was updated

	 */

	protected function updatePushToken(IUser $user, IToken $token, $devicePublicKey, $pushTokenHash) {

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

		$query->update('notifications_pushtokens')

			->set('pushtokenhash', $query->createNamedParameter($pushTokenHash))

			->where($query->expr()->eq('uid', $query->createNamedParameter($user->getUID())))

			->andWhere($query->expr()->eq('token', $query->createNamedParameter($token->getId(), IQueryBuilder::PARAM_INT)))

			->andWhere($query->expr()->eq('devicepublickey', $query->createNamedParameter($devicePublicKey)));

		return $query->execute() > 0;

	}

	/**

	 * @param IUser $user

	 * @param string $devicePublicKey

	 * @return bool If the entry was deleted

	 */

	protected function deletePushToken(IUser $user, IToken $token, $devicePublicKey) {

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

		$query->delete('notifications_pushtokens')

			->where($query->expr()->eq('uid', $query->createNamedParameter($user->getUID())))

			->andWhere($query->expr()->eq('token', $query->createNamedParameter($token->getId(), IQueryBuilder::PARAM_INT)))

			->andWhere($query->expr()->eq('devicepublickey', $query->createNamedParameter($devicePublicKey)));

		return $query->execute() > 0;

	}

}