lib/Command/TroubleshootTransferOwnership.php

280 		$query = $this->connection->getQueryBuilder();
282 		$query->selectDistinct('uid_initiator')
284 			->andWhere($query->expr()->orX(
285 				$query->expr()->eq('item_type', $query->createNamedParameter('file')),
286 				$query->expr()->eq('item_type', $query->createNamedParameter('folder'))
289 		$query->andWhere($query->expr()->neq('uid_initiator', 'uid_owner'));
291 		$cursor = $query->execute();
309 		$query = $this->connection->getQueryBuilder();
311 		$query->select('*')
313 			->andWhere($query->expr()->orX(
314 				$query->expr()->eq('item_type', $query->createNamedParameter('file')),
315 				$query->expr()->eq('item_type', $query->createNamedParameter('folder'))
318 		$query->andWhere($query->expr()->orX(
319 			$query->expr()->eq('share_type', $query->createNamedParameter(\OCP\Share::SHARE_TYPE_USER)),
320 			$query->expr()->eq('share_type', $query->createNamedParameter(\OCP\Share::SHARE_TYPE_GROUP)),
321 			$query->expr()->eq('share_type', $query->createNamedParameter(\OCP\Share::SHARE_TYPE_LINK)),
322 			$query->expr()->eq('share_type', $query->createNamedParameter(\OCP\Share::SHARE_TYPE_REMOTE))
325 		$query->andWhere($query->expr()->neq('uid_initiator', 'uid_owner'));
326 		$query->andWhere($query->expr()->eq('uid_initiator', $query->createNamedParameter($userId)));
328 		$cursor = $query->execute();
343 		$query = $this->connection->getQueryBuilder();
346 			$concatFunction = $query->createFunction("CONCAT('$storageType', s.uid_owner)");
348 			$concatFunction = $query->createFunction("('$storageType' || s.`uid_owner`)");
351 …$query->select('s.id', 's.file_source', 's.share_type', 's.parent', 'st.id', 's.uid_owner', 's.uid…
361 			->join('s', 'filecache', 'f', $query->expr()->eq('s.file_source', 'f.fileid'))
362 			->join('f', 'storages', 'st', $query->expr()->eq('st.numeric_id', 'f.storage'))
363 			->andWhere($query->expr()->orX(
364 				$query->expr()->like('st.id', $query->createNamedParameter("$storageType%"))
366 			->andWhere($query->expr()->orX(
367 				$query->expr()->eq('s.share_type', $query->createNamedParameter(\OCP\Share::SHARE_TYPE_USER)),
368 				$query->expr()->eq('s.share_type', $query->createNamedParameter(\OCP\Share::SHARE_TYPE_GROUP)),
369 				$query->expr()->eq('s.share_type', $query->createNamedParameter(\OCP\Share::SHARE_TYPE_LINK)),
370 				$query->expr()->eq('s.share_type', $query->createNamedParameter(\OCP\Share::SHARE_TYPE_REMOTE))
372 			->andWhere($query->expr()->orX(
373 				$query->expr()->eq('s.item_type', $query->createNamedParameter('file')),
374 				$query->expr()->eq('s.item_type', $query->createNamedParameter('folder'))
376 			->andWhere($query->expr()->neq(
382 			$query->andWhere($query->expr()->eq('s.uid_owner', $query->createNamedParameter($scopeUid)));
385 		$cursor = $query->execute();
400 		$query = $this->connection->getQueryBuilder();
403 		$query->update('share')
404 			->set('uid_initiator', $query->createParameter('uid_initiator'))
406 				$query->expr()->andX(
407 					$query->expr()->eq('id', $query->createParameter('shareid')),
408 					$query->expr()->orX(
409 						$query->expr()->eq('item_type', $query->createNamedParameter('file')),
410 						$query->expr()->eq('item_type', $query->createNamedParameter('folder'))
415 		$query->setParameter('shareid', $shareId);
416 		$query->setParameter('uid_initiator', $newUidInitiator);
418 		return $query->execute();
430 		$query = $this->connection->getQueryBuilder();
432 		$query->update('share')
433 			->set('uid_owner', $query->createParameter('uid_owner'))
435 				$query->expr()->andX(
436 					$query->expr()->eq('id', $query->createParameter('shareid')),
437 					$query->expr()->orX(
438 						$query->expr()->eq('item_type', $query->createNamedParameter('file')),
439 						$query->expr()->eq('item_type', $query->createNamedParameter('folder'))
449 			$query->orWhere(
450 				$query->expr()->andX(
451 					$query->expr()->eq('parent', $query->createParameter('shareid')),
452 					$query->expr()->orX(
453 						$query->expr()->eq('item_type', $query->createNamedParameter('file')),
454 						$query->expr()->eq('item_type', $query->createNamedParameter('folder'))
460 		$query->setParameter('shareid', $shareId);
461 		$query->setParameter('uid_owner', $newUidOwner);
463 		return $query->execute();