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

Code Duplication Length = 7-9 lines in 13 locations

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

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

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

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

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

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

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

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

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

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

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

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

		@@ 2095-2101 (lines=7) @@
2092		* @param int $calendarId
2093		* @param int $objectId
2094		*/
2095		protected function purgeProperties($calendarId, $objectId) {
2096		$query = $this->db->getQueryBuilder();
2097		$query->delete($this->dbObjectPropertiesTable)
2098		->where($query->expr()->eq('objectid', $query->createNamedParameter($objectId)))
2099		->andWhere($query->expr()->eq('calendarid', $query->createNamedParameter($calendarId)));
2100		$query->execute();
2101		}
2102
2103		/**
2104		* get ID from a given calendar object

nextcloud / server

Code Duplication Length = 7-9 lines in 13 locations

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

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

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

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

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

apps/federatedfilesharing/lib/FederatedShareProvider.php 1 location

lib/private/Accounts/AccountManager.php 1 location

lib/private/Settings/Mapper.php 1 location

lib/private/SubAdmin.php 2 locations

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