Code Duplication - nextcloud/server - Measure and Improve Code Quality continuously with Scrutinizer

Code Duplication Length = 7-10 lines in 15 locations

apps/twofactor_backupcodes/lib/Db/BackupCodeMapper.php 1 location


	/**
	 * @param string $uid
	 */
	public function deleteCodesByUserId($uid) {
		/* @var IQueryBuilder $qb */
		$qb = $this->db->getQueryBuilder();

		$qb->delete('twofactor_backupcodes')
			->where($qb->expr()->eq('user_id', $qb->createNamedParameter($uid)));
		$qb->execute();
	}

}


apps/oauth2/lib/Db/AccessTokenMapper.php 1 location


	 *
	 * @param int $id
	 */
	public function deleteByClientId($id) {
		$qb = $this->db->getQueryBuilder();
		$qb
			->delete($this->tableName)
			->where($qb->expr()->eq('client_id', $qb->createNamedParameter($id, IQueryBuilder::PARAM_INT)));
		$qb->execute();
	}
}


lib/private/Accounts/AccountManager.php 1 location


	 *
	 * @param IUser $user
	 */
	public function deleteUser(IUser $user) {
		$uid = $user->getUID();
		$query = $this->connection->getQueryBuilder();
		$query->delete($this->table)
			->where($query->expr()->eq('uid', $query->createNamedParameter($uid)))
			->execute();
	}

	/**
	 * get stored data from a given user

apps/federatedfilesharing/lib/FederatedShareProvider.php 1 location


	 * @param int $shareId
	 * @param string $token
	 */
	protected function updateSuccessfulReShare($shareId, $token) {
		$query = $this->dbConnection->getQueryBuilder();
		$query->update('share')
			->where($query->expr()->eq('id', $query->createNamedParameter($shareId)))
			->set('token', $query->createNamedParameter($token))
			->execute();
	}

	/**
	 * store remote ID in federated reShare table

apps/dav/lib/CalDAV/CalDavBackend.php 1 location


	 * @param int $calendarId
	 * @param int $objectId
	 */
	protected function purgeProperties($calendarId, $objectId) {
		$query = $this->db->getQueryBuilder();
		$query->delete($this->dbObjectPropertiesTable)
			->where($query->expr()->eq('objectid', $query->createNamedParameter($objectId)))
			->andWhere($query->expr()->eq('calendarid', $query->createNamedParameter($calendarId)));
		$query->execute();
	}

	/**
	 * get ID from a given calendar object

lib/private/Files/Config/UserMountCache.php 2 locations


	 *
	 * @param IUser $user
	 */
	public function removeUserMounts(IUser $user) {
		$builder = $this->connection->getQueryBuilder();

		$query = $builder->delete('mounts')
			->where($builder->expr()->eq('user_id', $builder->createNamedParameter($user->getUID())));
		$query->execute();
	}

	public function removeUserStorageMount($storageId, $userId) {
		$builder = $this->connection->getQueryBuilder();

		$query->execute();
	}

	public function remoteStorageMounts($storageId) {
		$builder = $this->connection->getQueryBuilder();

		$query = $builder->delete('mounts')
			->where($builder->expr()->eq('storage_id', $builder->createNamedParameter($storageId, IQueryBuilder::PARAM_INT)));
		$query->execute();
	}

	/**
	 * @param array $users

lib/private/SubAdmin.php 2 locations


	 * @param IUser $user
	 * @return boolean
	 */
	private function post_deleteUser($user) {
		$qb = $this->dbConn->getQueryBuilder();

		$qb->delete('group_admin')
			->where($qb->expr()->eq('uid', $qb->createNamedParameter($user->getUID())))
			->execute();

		return true;
	}

	/**
	 * delete all SubAdmins by $group

	 * @param IGroup $group
	 * @return boolean
	 */
	private function post_deleteGroup($group) {
		$qb = $this->dbConn->getQueryBuilder();

		$qb->delete('group_admin')
			->where($qb->expr()->eq('gid', $qb->createNamedParameter($group->getGID())))
			->execute();

		return true;
	}
}


apps/federatedfilesharing/lib/Controller/RequestHandlerController.php 1 location


	 * @param IShare $share
	 * @param int $permissions
	 */
	protected function updatePermissionsInDatabase(IShare $share, $permissions) {
		$query = $this->connection->getQueryBuilder();
		$query->update('share')
			->where($query->expr()->eq('id', $query->createNamedParameter($share->getId())))
			->set('permissions', $query->createNamedParameter($permissions))
			->execute();
	}

	/**
	 * @NoCSRFRequired

apps/dav/lib/DAV/Sharing/Backend.php 2 locations


	/**
	 * @param $resourceId
	 */
	public function deleteAllShares($resourceId) {
		$query = $this->db->getQueryBuilder();
		$query->delete('dav_shares')
			->where($query->expr()->eq('resourceid', $query->createNamedParameter($resourceId)))
			->andWhere($query->expr()->eq('type', $query->createNamedParameter($this->resourceType)))
			->execute();
	}

	public function deleteAllSharesByUser($principaluri) {
		$query = $this->db->getQueryBuilder();

			->execute();
	}

	public function deleteAllSharesByUser($principaluri) {
		$query = $this->db->getQueryBuilder();
		$query->delete('dav_shares')
			->where($query->expr()->eq('principaluri', $query->createNamedParameter($principaluri)))
			->andWhere($query->expr()->eq('type', $query->createNamedParameter($this->resourceType)))
			->execute();
	}

	/**
	 * @param IShareable $shareable

apps/dav/lib/Db/DirectMapper.php 1 location


		return Direct::fromRow($data);
	}

	public function deleteExpired(int $expiration) {
		$qb = $this->db->getQueryBuilder();

		$qb->delete('directlink')
			->where(
				$qb->expr()->lt('expiration', $qb->createNamedParameter($expiration))
			);

		$qb->execute();
	}
}


lib/public/AppFramework/Db/QBMapper.php 1 location


	 * @return Entity the deleted entity
	 * @since 14.0.0
	 */
	public function delete(Entity $entity): Entity {
		$qb = $this->db->getQueryBuilder();

		$qb->delete($this->tableName)
			->where(
				$qb->expr()->eq('id', $qb->createNamedParameter($entity->getId()))
			);
		$qb->execute();
		return $entity;
	}


	/**

lib/private/Authentication/Token/DefaultTokenMapper.php 1 location


	 *
	 * @param string $token
	 */
	public function invalidate(string $token) {
		/* @var $qb IQueryBuilder */
		$qb = $this->db->getQueryBuilder();
		$qb->delete('authtoken')
			->where($qb->expr()->eq('token', $qb->createParameter('token')))
			->setParameter('token', $token)
			->execute();
	}

	/**
	 * @param int $olderThan

		@@ 66-73 (lines=8) @@
63		/**
64		* @param string $uid
65		*/
66		public function deleteCodesByUserId($uid) {
67		/* @var IQueryBuilder $qb */
68		$qb = $this->db->getQueryBuilder();
69
70		$qb->delete('twofactor_backupcodes')
71		->where($qb->expr()->eq('user_id', $qb->createNamedParameter($uid)));
72		$qb->execute();
73		}
74
75		}
76

		@@ 63-69 (lines=7) @@
60		*
61		* @param int $id
62		*/
63		public function deleteByClientId($id) {
64		$qb = $this->db->getQueryBuilder();
65		$qb
66		->delete($this->tableName)
67		->where($qb->expr()->eq('client_id', $qb->createNamedParameter($id, IQueryBuilder::PARAM_INT)));
68		$qb->execute();
69		}
70		}
71

		@@ 125-131 (lines=7) @@
122		*
123		* @param IUser $user
124		*/
125		public function deleteUser(IUser $user) {
126		$uid = $user->getUID();
127		$query = $this->connection->getQueryBuilder();
128		$query->delete($this->table)
129		->where($query->expr()->eq('uid', $query->createNamedParameter($uid)))
130		->execute();
131		}
132
133		/**
134		* get stored data from a given user

		@@ 422-428 (lines=7) @@
419		* @param int $shareId
420		* @param string $token
421		*/
422		protected function updateSuccessfulReShare($shareId, $token) {
423		$query = $this->dbConnection->getQueryBuilder();
424		$query->update('share')
425		->where($query->expr()->eq('id', $query->createNamedParameter($shareId)))
426		->set('token', $query->createNamedParameter($token))
427		->execute();
428		}
429
430		/**
431		* store remote ID in federated reShare table

		@@ 2317-2323 (lines=7) @@
2314		* @param int $calendarId
2315		* @param int $objectId
2316		*/
2317		protected function purgeProperties($calendarId, $objectId) {
2318		$query = $this->db->getQueryBuilder();
2319		$query->delete($this->dbObjectPropertiesTable)
2320		->where($query->expr()->eq('objectid', $query->createNamedParameter($objectId)))
2321		->andWhere($query->expr()->eq('calendarid', $query->createNamedParameter($calendarId)));
2322		$query->execute();
2323		}
2324
2325		/**
2326		* get ID from a given calendar object

		@@ 329-335 (lines=7) @@
326		*
327		* @param IUser $user
328		*/
329		public function removeUserMounts(IUser $user) {
330		$builder = $this->connection->getQueryBuilder();
331
332		$query = $builder->delete('mounts')
333		->where($builder->expr()->eq('user_id', $builder->createNamedParameter($user->getUID())));
334		$query->execute();
335		}
336
337		public function removeUserStorageMount($storageId, $userId) {
338		$builder = $this->connection->getQueryBuilder();
		@@ 346-352 (lines=7) @@
343		$query->execute();
344		}
345
346		public function remoteStorageMounts($storageId) {
347		$builder = $this->connection->getQueryBuilder();
348
349		$query = $builder->delete('mounts')
350		->where($builder->expr()->eq('storage_id', $builder->createNamedParameter($storageId, IQueryBuilder::PARAM_INT)));
351		$query->execute();
352		}
353
354		/**
355		* @param array $users

		@@ 274-282 (lines=9) @@
271		* @param IUser $user
272		* @return boolean
273		*/
274		private function post_deleteUser($user) {
275		$qb = $this->dbConn->getQueryBuilder();
276
277		$qb->delete('group_admin')
278		->where($qb->expr()->eq('uid', $qb->createNamedParameter($user->getUID())))
279		->execute();
280
281		return true;
282		}
283
284		/**
285		* delete all SubAdmins by $group
		@@ 289-297 (lines=9) @@
286		* @param IGroup $group
287		* @return boolean
288		*/
289		private function post_deleteGroup($group) {
290		$qb = $this->dbConn->getQueryBuilder();
291
292		$qb->delete('group_admin')
293		->where($qb->expr()->eq('gid', $qb->createNamedParameter($group->getGID())))
294		->execute();
295
296		return true;
297		}
298		}
299

		@@ 644-650 (lines=7) @@
641		* @param IShare $share
642		* @param int $permissions
643		*/
644		protected function updatePermissionsInDatabase(IShare $share, $permissions) {
645		$query = $this->connection->getQueryBuilder();
646		$query->update('share')
647		->where($query->expr()->eq('id', $query->createNamedParameter($share->getId())))
648		->set('permissions', $query->createNamedParameter($permissions))
649		->execute();
650		}
651
652		/**
653		* @NoCSRFRequired

		@@ 134-140 (lines=7) @@
131		/**
132		* @param $resourceId
133		*/
134		public function deleteAllShares($resourceId) {
135		$query = $this->db->getQueryBuilder();
136		$query->delete('dav_shares')
137		->where($query->expr()->eq('resourceid', $query->createNamedParameter($resourceId)))
138		->andWhere($query->expr()->eq('type', $query->createNamedParameter($this->resourceType)))
139		->execute();
140		}
141
142		public function deleteAllSharesByUser($principaluri) {
143		$query = $this->db->getQueryBuilder();
		@@ 142-148 (lines=7) @@
139		->execute();
140		}
141
142		public function deleteAllSharesByUser($principaluri) {
143		$query = $this->db->getQueryBuilder();
144		$query->delete('dav_shares')
145		->where($query->expr()->eq('principaluri', $query->createNamedParameter($principaluri)))
146		->andWhere($query->expr()->eq('type', $query->createNamedParameter($this->resourceType)))
147		->execute();
148		}
149
150		/**
151		* @param IShareable $shareable

		@@ 62-71 (lines=10) @@
59		return Direct::fromRow($data);
60		}
61
62		public function deleteExpired(int $expiration) {
63		$qb = $this->db->getQueryBuilder();
64
65		$qb->delete('directlink')
66		->where(
67		$qb->expr()->lt('expiration', $qb->createNamedParameter($expiration))
68		);
69
70		$qb->execute();
71		}
72		}
73

		@@ 83-92 (lines=10) @@
80		* @return Entity the deleted entity
81		* @since 14.0.0
82		*/
83		public function delete(Entity $entity): Entity {
84		$qb = $this->db->getQueryBuilder();
85
86		$qb->delete($this->tableName)
87		->where(
88		$qb->expr()->eq('id', $qb->createNamedParameter($entity->getId()))
89		);
90		$qb->execute();
91		return $entity;
92		}
93
94
95		/**

		@@ 49-56 (lines=8) @@
46		*
47		* @param string $token
48		*/
49		public function invalidate(string $token) {
50		/* @var $qb IQueryBuilder */
51		$qb = $this->db->getQueryBuilder();
52		$qb->delete('authtoken')
53		->where($qb->expr()->eq('token', $qb->createParameter('token')))
54		->setParameter('token', $token)
55		->execute();
56		}
57
58		/**
59		* @param int $olderThan

nextcloud / server

Code Duplication Length = 7-10 lines in 15 locations

apps/twofactor_backupcodes/lib/Db/BackupCodeMapper.php 1 location

apps/oauth2/lib/Db/AccessTokenMapper.php 1 location

lib/private/Accounts/AccountManager.php 1 location

apps/federatedfilesharing/lib/FederatedShareProvider.php 1 location

apps/dav/lib/CalDAV/CalDavBackend.php 1 location

lib/private/Files/Config/UserMountCache.php 2 locations

lib/private/SubAdmin.php 2 locations

apps/federatedfilesharing/lib/Controller/RequestHandlerController.php 1 location

apps/dav/lib/DAV/Sharing/Backend.php 2 locations

apps/dav/lib/Db/DirectMapper.php 1 location

lib/public/AppFramework/Db/QBMapper.php 1 location

lib/private/Authentication/Token/DefaultTokenMapper.php 1 location