Code Duplication    Length = 7-9 lines in 10 locations

lib/private/SubAdmin.php 2 locations

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

lib/private/Settings/Manager.php 1 location

@@ 281-287 (lines=7) @@
278
	 * @param $table
279
	 * @param $className
280
	 */
281
	private function remove($table, $className) {
282
		$query = $this->dbc->getQueryBuilder();
283
		$query->delete($table)
284
			->where($query->expr()->eq('class', $query->createNamedParameter($className)));
285
286
		$query->execute();
287
	}
288
289
	private function setupAdminSettings($settingsClassName) {
290
		if(!class_exists($settingsClassName)) {

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

@@ 600-606 (lines=7) @@
597
	 * @param IShare $share
598
	 * @param int $permissions
599
	 */
600
	protected function updatePermissionsInDatabase(IShare $share, $permissions) {
601
		$query = $this->connection->getQueryBuilder();
602
		$query->update('share')
603
			->where($query->expr()->eq('id', $query->createNamedParameter($share->getId())))
604
			->set('permissions', $query->createNamedParameter($permissions))
605
			->execute();
606
	}
607
608
}
609

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

@@ 56-63 (lines=8) @@
53
		}, $rows);
54
	}
55
56
	public function deleteCodes(IUser $user) {
57
		/* @var IQueryBuilder $qb */
58
		$qb = $this->db->getQueryBuilder();
59
60
		$qb->delete('twofactor_backup_codes')
61
			->where($qb->expr()->eq('user_id', $qb->createNamedParameter($user->getUID())));
62
		$qb->execute();
63
	}
64
65
}
66

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

@@ 300-306 (lines=7) @@
297
	 *
298
	 * @param IUser $user
299
	 */
300
	public function removeUserMounts(IUser $user) {
301
		$builder = $this->connection->getQueryBuilder();
302
303
		$query = $builder->delete('mounts')
304
			->where($builder->expr()->eq('user_id', $builder->createNamedParameter($user->getUID())));
305
		$query->execute();
306
	}
307
308
	public function removeUserStorageMount($storageId, $userId) {
309
		$builder = $this->connection->getQueryBuilder();
@@ 317-323 (lines=7) @@
314
		$query->execute();
315
	}
316
317
	public function remoteStorageMounts($storageId) {
318
		$builder = $this->connection->getQueryBuilder();
319
320
		$query = $builder->delete('mounts')
321
			->where($builder->expr()->eq('storage_id', $builder->createNamedParameter($storageId, IQueryBuilder::PARAM_INT)));
322
		$query->execute();
323
	}
324
}
325

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

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

apps/federatedfilesharing/lib/FederatedShareProvider.php 1 location

@@ 398-404 (lines=7) @@
395
	 * @param int $shareId
396
	 * @param string $token
397
	 */
398
	protected function updateSuccessfulReShare($shareId, $token) {
399
		$query = $this->dbConnection->getQueryBuilder();
400
		$query->update('share')
401
			->where($query->expr()->eq('id', $query->createNamedParameter($shareId)))
402
			->set('token', $query->createNamedParameter($token))
403
			->execute();
404
	}
405
406
	/**
407
	 * store remote ID in federated reShare table