owncloud / core

	/**

	 * Outputs a report about storages with wrong path that need repairing in the file cache

	 */

	private function reportAffectedStoragesParentIdWrongPath(IOutput $out) {

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

		$qb->selectDistinct('fc.storage');

		$this->addQueryConditionsParentIdWrongPath($qb);

		// TODO: max results + paginate ?

		// TODO: join with oc_storages / oc_mounts to deliver user id ?

		$results = $qb->execute();

		$rows = $results->fetchAll();

		$results->closeCursor();

		$storageIds = [];

		foreach ($rows as $row) {

			$storageIds[] = $row['storage'];

		}

		if (!empty($storageIds)) {

			$out->warning('The file cache contains entries with invalid path values for the following storage numeric ids: ' . implode(' ', $storageIds));

			$out->warning('Please run `occ files:scan --all --repair` to repair'

			.'all affected storages or run `occ files:scan userid --repair for '

			.'each user with affected storages');

		}

	}

	/**

	 * Outputs a report about storages with non existing parents that need repairing in the file cache

	/**

	 * Outputs a report about storages with non existing parents that need repairing in the file cache

	 */

	private function reportAffectedStoragesNonExistingParentIdEntry(IOutput $out) {

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

		$qb->selectDistinct('fc.storage');

		$this->addQueryConditionsNonExistingParentIdEntry($qb);

		// TODO: max results + paginate ?

		// TODO: join with oc_storages / oc_mounts to deliver user id ?

		$results = $qb->execute();

		$rows = $results->fetchAll();

		$results->closeCursor();

		$storageIds = [];

		foreach ($rows as $row) {

			$storageIds[] = $row['storage'];

		}

		if (!empty($storageIds)) {

			$out->warning('The file cache contains entries where the parent id does not point to any existing entry for the following storage numeric ids: ' . implode(' ', $storageIds));

			$out->warning('Please run `occ files:scan --all --repair` to repair all affected storages');

		}

	}

	/**

	 * Repair all entries for which the parent entry exists but the path