nextcloud / circles

	 *

	 * @return IQueryBuilder

	 */

	protected function getMembersUpdateSql($circleId, Member $member) {

		$qb = $this->dbConnection->getQueryBuilder();

		$expr = $qb->expr();

		/** @noinspection PhpMethodParametersCountMismatchInspection */

		$qb->update(self::TABLE_MEMBERS)

		   ->where(

			   $expr->andX(

				   $expr->eq('circle_id', $qb->createNamedParameter($circleId)),

				   $expr->eq('user_id', $qb->createNamedParameter($member->getUserId())),

				   $expr->eq('user_type', $qb->createNamedParameter($member->getType()))

			   )

		   );

		return $qb;

	}

	/**

	 *

	 * @param Member $member

	 */

	public function removeSharesFromMember(Member $member) {

		$qb = $this->getSharesDeleteSql();

		$expr = $qb->expr();

		$andX = $expr->andX();

		$andX->add($expr->eq('share_with', $qb->createNamedParameter($member->getCircleId())));

		$andX->add($expr->eq('uid_initiator', $qb->createNamedParameter($member->getUserId())));

		$qb->andWhere($andX);

		$qb->execute();

	}

	/**