Code Duplication    Length = 7-11 lines in 7 locations

apps/federation/lib/dbhandler.php 1 location

@@ 100-106 (lines=7) @@
97
	 *
98
	 * @param int $id
99
	 */
100
	public function removeServer($id) {
101
		$query = $this->connection->getQueryBuilder();
102
		$query->delete($this->dbTable)
103
			->where($query->expr()->eq('id', $query->createParameter('id')))
104
			->setParameter('id', $id);
105
		$query->execute();
106
	}
107
108
	/**
109
	 * get trusted server with given ID

apps/files_external/service/dbconfigservice.php 2 locations

@@ 229-237 (lines=9) @@
226
	 * @param int $mountId
227
	 * @param string $newMountPoint
228
	 */
229
	public function setMountPoint($mountId, $newMountPoint) {
230
		$builder = $this->connection->getQueryBuilder();
231
232
		$query = $builder->update('external_mounts')
233
			->set('mount_point', $builder->createNamedParameter($newMountPoint))
234
			->where($builder->expr()->eq('mount_id', $builder->createNamedParameter($mountId, IQueryBuilder::PARAM_INT)));
235
236
		$query->execute();
237
	}
238
239
	/**
240
	 * @param int $mountId
@@ 243-251 (lines=9) @@
240
	 * @param int $mountId
241
	 * @param string $newAuthBackend
242
	 */
243
	public function setAuthBackend($mountId, $newAuthBackend) {
244
		$builder = $this->connection->getQueryBuilder();
245
246
		$query = $builder->update('external_mounts')
247
			->set('auth_backend', $builder->createNamedParameter($newAuthBackend))
248
			->where($builder->expr()->eq('mount_id', $builder->createNamedParameter($mountId, IQueryBuilder::PARAM_INT)));
249
250
		$query->execute();
251
	}
252
253
	/**
254
	 * @param int $mountId

lib/private/appconfig.php 1 location

@@ 226-236 (lines=11) @@
223
	 *
224
	 * Removes all keys in appconfig belonging to the app.
225
	 */
226
	public function deleteApp($app) {
227
		$this->loadConfigValues();
228
229
		$sql = $this->conn->getQueryBuilder();
230
		$sql->delete('appconfig')
231
			->where($sql->expr()->eq('appid', $sql->createParameter('app')))
232
			->setParameter('app', $app);
233
		$sql->execute();
234
235
		unset($this->cache[$app]);
236
	}
237
238
	/**
239
	 * get multiple values, either the app or key can be used as wildcard by setting it to false

lib/private/files/config/usermountcache.php 2 locations

@@ 273-279 (lines=7) @@
270
	 *
271
	 * @param IUser $user
272
	 */
273
	public function removeUserMounts(IUser $user) {
274
		$builder = $this->connection->getQueryBuilder();
275
276
		$query = $builder->delete('mounts')
277
			->where($builder->expr()->eq('user_id', $builder->createNamedParameter($user->getUID())));
278
		$query->execute();
279
	}
280
281
	public function removeUserStorageMount($storageId, $userId) {
282
		$builder = $this->connection->getQueryBuilder();
@@ 290-296 (lines=7) @@
287
		$query->execute();
288
	}
289
290
	public function remoteStorageMounts($storageId) {
291
		$builder = $this->connection->getQueryBuilder();
292
293
		$query = $builder->delete('mounts')
294
			->where($builder->expr()->eq('storage_id', $builder->createNamedParameter($storageId, IQueryBuilder::PARAM_INT)));
295
		$query->execute();
296
	}
297
}
298

apps/federatedfilesharing/lib/federatedshareprovider.php 1 location

@@ 573-582 (lines=10) @@
570
	 * @param string $uid
571
	 * @param int $shareType
572
	 */
573
	public function userDeleted($uid, $shareType) {
574
		//TODO: probabaly a good idea to send unshare info to remote servers
575
576
		$qb = $this->dbConnection->getQueryBuilder();
577
578
		$qb->delete('share')
579
			->where($qb->expr()->eq('share_type', $qb->createNamedParameter(\OCP\Share::SHARE_TYPE_REMOTE)))
580
			->andWhere($qb->expr()->eq('uid_owner', $qb->createNamedParameter($uid)))
581
			->execute();
582
	}
583
}
584