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

Code Duplication Length = 7-9 lines in 15 locations

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/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/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

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/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();
	}
}


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

lib/private/Settings/Mapper.php 1 location


	 * @param string $table one of the Mapper::TABLE_* constants
	 * @param string $className
	 */
	public function remove($table, $className) {
		$query = $this->dbc->getQueryBuilder();
		$query->delete($table)
			->where($query->expr()->eq('class', $query->createNamedParameter($className)));

		$query->execute();
	}

	/**
	 * @param string $table one of the Mapper::TABLE_* constants

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();
	}

	public function getUsedSpaceForUsers(array $users) {
		$builder = $this->connection->getQueryBuilder();

lib/private/Repair/NC13/RepairInvalidPaths.php 2 locations


		$query->execute();
	}

	private function reparent($from, $to) {
		$builder = $this->connection->getQueryBuilder();

		$query = $builder->update('filecache')
			->set('parent', $builder->createNamedParameter($to))
			->where($builder->expr()->eq('fileid', $builder->createNamedParameter($from)));
		$query->execute();
	}

	private function delete($fileid) {
		$builder = $this->connection->getQueryBuilder();

		$query->execute();
	}

	private function delete($fileid) {
		$builder = $this->connection->getQueryBuilder();

		$query = $builder->delete('filecache')
			->where($builder->expr()->eq('fileid', $builder->createNamedParameter($fileid)));
		$query->execute();
	}

	private function repair() {
		$entries = $this->getInvalidEntries();

		@@ 264-272 (lines=9) @@
261		* @param IUser $user
262		* @return boolean
263		*/
264		private function post_deleteUser($user) {
265		$qb = $this->dbConn->getQueryBuilder();
266
267		$qb->delete('group_admin')
268		->where($qb->expr()->eq('uid', $qb->createNamedParameter($user->getUID())))
269		->execute();
270
271		return true;
272		}
273
274		/**
275		* delete all SubAdmins by $group
		@@ 279-287 (lines=9) @@
276		* @param IGroup $group
277		* @return boolean
278		*/
279		private function post_deleteGroup($group) {
280		$qb = $this->dbConn->getQueryBuilder();
281
282		$qb->delete('group_admin')
283		->where($qb->expr()->eq('gid', $qb->createNamedParameter($group->getGID())))
284		->execute();
285
286		return true;
287		}
288		}
289

		@@ 105-111 (lines=7) @@
102		/**
103		* @param $resourceId
104		*/
105		public function deleteAllShares($resourceId) {
106		$query = $this->db->getQueryBuilder();
107		$query->delete('dav_shares')
108		->where($query->expr()->eq('resourceid', $query->createNamedParameter($resourceId)))
109		->andWhere($query->expr()->eq('type', $query->createNamedParameter($this->resourceType)))
110		->execute();
111		}
112
113		public function deleteAllSharesByUser($principaluri) {
114		$query = $this->db->getQueryBuilder();
		@@ 113-119 (lines=7) @@
110		->execute();
111		}
112
113		public function deleteAllSharesByUser($principaluri) {
114		$query = $this->db->getQueryBuilder();
115		$query->delete('dav_shares')
116		->where($query->expr()->eq('principaluri', $query->createNamedParameter($principaluri)))
117		->andWhere($query->expr()->eq('type', $query->createNamedParameter($this->resourceType)))
118		->execute();
119		}
120
121		/**
122		* @param IShareable $shareable

		@@ 610-616 (lines=7) @@
607		* @param IShare $share
608		* @param int $permissions
609		*/
610		protected function updatePermissionsInDatabase(IShare $share, $permissions) {
611		$query = $this->connection->getQueryBuilder();
612		$query->update('share')
613		->where($query->expr()->eq('id', $query->createNamedParameter($share->getId())))
614		->set('permissions', $query->createNamedParameter($permissions))
615		->execute();
616		}
617
618		/**
619		* @NoCSRFRequired

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

		@@ 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

		@@ 415-421 (lines=7) @@
412		* @param int $shareId
413		* @param string $token
414		*/
415		protected function updateSuccessfulReShare($shareId, $token) {
416		$query = $this->dbConnection->getQueryBuilder();
417		$query->update('share')
418		->where($query->expr()->eq('id', $query->createNamedParameter($shareId)))
419		->set('token', $query->createNamedParameter($token))
420		->execute();
421		}
422
423		/**
424		* store remote ID in federated reShare table

		@@ 188-194 (lines=7) @@
185		* @param string $table one of the Mapper::TABLE_* constants
186		* @param string $className
187		*/
188		public function remove($table, $className) {
189		$query = $this->dbc->getQueryBuilder();
190		$query->delete($table)
191		->where($query->expr()->eq('class', $query->createNamedParameter($className)));
192
193		$query->execute();
194		}
195
196		/**
197		* @param string $table one of the Mapper::TABLE_* constants

		@@ 2065-2071 (lines=7) @@
2062		* @param int $calendarId
2063		* @param int $objectId
2064		*/
2065		protected function purgeProperties($calendarId, $objectId) {
2066		$query = $this->db->getQueryBuilder();
2067		$query->delete($this->dbObjectPropertiesTable)
2068		->where($query->expr()->eq('objectid', $query->createNamedParameter($objectId)))
2069		->andWhere($query->expr()->eq('calendarid', $query->createNamedParameter($calendarId)));
2070		$query->execute();
2071		}
2072
2073		/**
2074		* get ID from a given calendar object

		@@ 312-318 (lines=7) @@
309		*
310		* @param IUser $user
311		*/
312		public function removeUserMounts(IUser $user) {
313		$builder = $this->connection->getQueryBuilder();
314
315		$query = $builder->delete('mounts')
316		->where($builder->expr()->eq('user_id', $builder->createNamedParameter($user->getUID())));
317		$query->execute();
318		}
319
320		public function removeUserStorageMount($storageId, $userId) {
321		$builder = $this->connection->getQueryBuilder();
		@@ 329-335 (lines=7) @@
326		$query->execute();
327		}
328
329		public function remoteStorageMounts($storageId) {
330		$builder = $this->connection->getQueryBuilder();
331
332		$query = $builder->delete('mounts')
333		->where($builder->expr()->eq('storage_id', $builder->createNamedParameter($storageId, IQueryBuilder::PARAM_INT)));
334		$query->execute();
335		}
336
337		public function getUsedSpaceForUsers(array $users) {
338		$builder = $this->connection->getQueryBuilder();

		@@ 88-95 (lines=8) @@
85		$query->execute();
86		}
87
88		private function reparent($from, $to) {
89		$builder = $this->connection->getQueryBuilder();
90
91		$query = $builder->update('filecache')
92		->set('parent', $builder->createNamedParameter($to))
93		->where($builder->expr()->eq('fileid', $builder->createNamedParameter($from)));
94		$query->execute();
95		}
96
97		private function delete($fileid) {
98		$builder = $this->connection->getQueryBuilder();
		@@ 97-103 (lines=7) @@
94		$query->execute();
95		}
96
97		private function delete($fileid) {
98		$builder = $this->connection->getQueryBuilder();
99
100		$query = $builder->delete('filecache')
101		->where($builder->expr()->eq('fileid', $builder->createNamedParameter($fileid)));
102		$query->execute();
103		}
104
105		private function repair() {
106		$entries = $this->getInvalidEntries();

nextcloud / server

Code Duplication Length = 7-9 lines in 15 locations

lib/private/SubAdmin.php 2 locations

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

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

lib/private/Accounts/AccountManager.php 1 location

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

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

apps/federatedfilesharing/lib/FederatedShareProvider.php 1 location

lib/private/Settings/Mapper.php 1 location

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

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

lib/private/Repair/NC13/RepairInvalidPaths.php 2 locations