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;

	}

	/**

	}

	private function swapToShortenUniqueIdInShares($circleId, $shortenUniqueId) {

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

		$expr = $qb->expr();

		/** @noinspection PhpMethodParametersCountMismatchInspection */

		$qb->update('share')

		   ->where(

			   $expr->andX(

				   $expr->eq(

					   'share_type', $qb->createNamedParameter(Share::SHARE_TYPE_CIRCLE)

				   ),

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

			   )

		   );

		$qb->set('share_with', $qb->createNamedParameter($shortenUniqueId));

		$qb->execute();

	}

}

	 * @param Circle $circle

	 * @param Member $member

	 */

	public function removeSharesFromMember(Circle $circle, Member $member) {

		$qb = $this->getSharesDeleteSql();

		$expr = $qb->expr();

		$andX = $expr->andX();

		$andX->add($expr->eq('share_with', $qb->createNamedParameter($circle->getUniqueId())));

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

		$qb->andWhere($andX);

		$qb->execute();

	}

}