nextcloud / circles

	 *

	 * @return \OCP\DB\QueryBuilder\IQueryBuilder

	 */

	protected function getBaseDeleteSql() {

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

		$expr = $qb->expr();

		$qb->delete('share')

		   ->where($expr->eq('share_type', $qb->createNamedParameter(Share::SHARE_TYPE_CIRCLE)));

		return $qb;

	}

	/**

	 *

	 * @return \OCP\DB\QueryBuilder\IQueryBuilder

	 */

	protected function getBaseUpdateSql() {

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

		$expr = $qb->expr();

		$qb->update('share')

		   ->where($expr->eq('share_type', $qb->createNamedParameter(Share::SHARE_TYPE_CIRCLE)));

		return $qb;

	}

}

	 *

	 * @return IQueryBuilder

	 */

	protected function getCirclesUpdateSql($circleId) {

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

		$qb->update('circles_circles')

		   ->where(

			   $qb->expr()

				  ->eq('id', $qb->createNamedParameter($circleId))

		   );

		return $qb;

	}

	/**

	 *

	 * @return IQueryBuilder

	 */

	protected function getGroupsDeleteSql($groupId) {

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

		$expr = $qb->expr();

		$qb->delete(self::TABLE_GROUPS)

		   ->where($expr->eq('group_id', $qb->createNamedParameter($groupId)));

		return $qb;

	}

}