Code Duplication    Length = 8-15 lines in 5 locations

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

@@ 148-156 (lines=9) @@
145
		return $entities;
146
	}
147
148
	public function deleteById(string $uid, int $id) {
149
		/* @var $qb IQueryBuilder */
150
		$qb = $this->db->getQueryBuilder();
151
		$qb->delete('authtoken')
152
			->where($qb->expr()->eq('id', $qb->createNamedParameter($id)))
153
			->andWhere($qb->expr()->eq('uid', $qb->createNamedParameter($uid)))
154
			->andWhere($qb->expr()->eq('version', $qb->createNamedParameter(DefaultToken::VERSION, IQueryBuilder::PARAM_INT)));
155
		$qb->execute();
156
	}
157
158
	/**
159
	 * delete all auth token which belong to a specific client if the client was deleted

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

@@ 139-147 (lines=9) @@
136
		return $entities;
137
	}
138
139
	public function deleteById(string $uid, int $id) {
140
		/* @var $qb IQueryBuilder */
141
		$qb = $this->db->getQueryBuilder();
142
		$qb->delete('authtoken')
143
			->where($qb->expr()->eq('id', $qb->createNamedParameter($id)))
144
			->andWhere($qb->expr()->eq('uid', $qb->createNamedParameter($uid)))
145
			->andWhere($qb->expr()->eq('version', $qb->createNamedParameter(PublicKeyToken::VERSION, IQueryBuilder::PARAM_INT)));
146
		$qb->execute();
147
	}
148
149
	/**
150
	 * delete all auth token which belong to a specific client if the client was deleted

lib/private/Share20/DefaultShareProvider.php 1 location

@@ 354-368 (lines=15) @@
351
	 *
352
	 * @param \OCP\Share\IShare $share
353
	 */
354
	public function delete(\OCP\Share\IShare $share) {
355
		$qb = $this->dbConn->getQueryBuilder();
356
		$qb->delete('share')
357
			->where($qb->expr()->eq('id', $qb->createNamedParameter($share->getId())));
358
359
		/*
360
		 * If the share is a group share delete all possible
361
		 * user defined groups shares.
362
		 */
363
		if ($share->getShareType() === \OCP\Share::SHARE_TYPE_GROUP) {
364
			$qb->orWhere($qb->expr()->eq('parent', $qb->createNamedParameter($share->getId())));
365
		}
366
367
		$qb->execute();
368
	}
369
370
	/**
371
	 * Unshare a share from the recipient. If this is a group share

lib/private/DB/MigrationService.php 1 location

@@ 163-177 (lines=15) @@
160
	 * @return string[]
161
	 * @codeCoverageIgnore - no need to test this
162
	 */
163
	public function getMigratedVersions() {
164
		$this->createMigrationTable();
165
		$qb = $this->connection->getQueryBuilder();
166
167
		$qb->select('version')
168
			->from('migrations')
169
			->where($qb->expr()->eq('app', $qb->createNamedParameter($this->getApp())))
170
			->orderBy('version');
171
172
		$result = $qb->execute();
173
		$rows = $result->fetchAll(\PDO::FETCH_COLUMN);
174
		$result->closeCursor();
175
176
		return $rows;
177
	}
178
179
	/**
180
	 * Returns all versions which are available in the migration folder

lib/private/Files/Config/UserMountCache.php 1 location

@@ 201-208 (lines=8) @@
198
		$query->execute();
199
	}
200
201
	private function removeFromCache(ICachedMountInfo $mount) {
202
		$builder = $this->connection->getQueryBuilder();
203
204
		$query = $builder->delete('mounts')
205
			->where($builder->expr()->eq('user_id', $builder->createNamedParameter($mount->getUser()->getUID())))
206
			->andWhere($builder->expr()->eq('root_id', $builder->createNamedParameter($mount->getRootId(), IQueryBuilder::PARAM_INT)));
207
		$query->execute();
208
	}
209
210
	private function dbRowToMountInfo(array $row) {
211
		$user = $this->userManager->get($row['user_id']);