Code Duplication    Length = 7-11 lines in 9 locations

apps/files_sharing/lib/Migration/OwncloudGuestShareType.php 1 location

@@ 64-74 (lines=11) @@
61
	/**
62
	 * @param IOutput $output
63
	 */
64
	public function run(IOutput $output) {
65
		if (!$this->shouldRun()) {
66
			return;
67
		}
68
69
		$query = $this->connection->getQueryBuilder();
70
		$query->update('share')
71
			->set('share_type',  $query->createNamedParameter(Share::SHARE_TYPE_GUEST))
72
			->where($query->expr()->eq('share_type', $query->createNamedParameter(Share::SHARE_TYPE_EMAIL)));
73
		$query->execute();
74
	}
75
76
	protected function shouldRun() {
77
		$appVersion = $this->config->getAppValue('files_sharing', 'installed_version', '0.0.0');

apps/dav/lib/Migration/FixBirthdayCalendarComponent.php 1 location

@@ 54-62 (lines=9) @@
51
	/**
52
	 * @inheritdoc
53
	 */
54
	public function run(IOutput $output) {
55
		$query = $this->connection->getQueryBuilder();
56
		$updated = $query->update('calendars')
57
			->set('components', $query->createNamedParameter('VEVENT'))
58
			->where($query->expr()->eq('uri', $query->createNamedParameter(BirthdayService::BIRTHDAY_CALENDAR_URI)))
59
			->execute();
60
61
		$output->info("$updated birthday calendars updated.");
62
	}
63
}
64

lib/private/BackgroundJob/JobList.php 1 location

@@ 292-298 (lines=7) @@
289
	 * @param IJob $job
290
	 * @suppress SqlInjectionChecker
291
	 */
292
	public function unlockJob(IJob $job) {
293
		$query = $this->connection->getQueryBuilder();
294
		$query->update('jobs')
295
			->set('reserved_at', $query->expr()->literal(0, IQueryBuilder::PARAM_INT))
296
			->where($query->expr()->eq('id', $query->createNamedParameter($job->getId(), IQueryBuilder::PARAM_INT)));
297
		$query->execute();
298
	}
299
300
	/**
301
	 * get the id of the last ran job

apps/federatedfilesharing/lib/FederatedShareProvider.php 1 location

@@ 918-927 (lines=10) @@
915
	 * @param string $uid
916
	 * @param int $shareType
917
	 */
918
	public function userDeleted($uid, $shareType) {
919
		//TODO: probabaly a good idea to send unshare info to remote servers
920
921
		$qb = $this->dbConnection->getQueryBuilder();
922
923
		$qb->delete('share')
924
			->where($qb->expr()->eq('share_type', $qb->createNamedParameter(\OCP\Share::SHARE_TYPE_REMOTE)))
925
			->andWhere($qb->expr()->eq('uid_owner', $qb->createNamedParameter($uid)))
926
			->execute();
927
	}
928
929
	/**
930
	 * This provider does not handle groups

apps/sharebymail/lib/ShareByMailProvider.php 1 location

@@ 968-975 (lines=8) @@
965
	 * @param string $uid
966
	 * @param int $shareType
967
	 */
968
	public function userDeleted($uid, $shareType) {
969
		$qb = $this->dbConnection->getQueryBuilder();
970
971
		$qb->delete('share')
972
			->where($qb->expr()->eq('share_type', $qb->createNamedParameter(\OCP\Share::SHARE_TYPE_EMAIL)))
973
			->andWhere($qb->expr()->eq('uid_owner', $qb->createNamedParameter($uid)))
974
			->execute();
975
	}
976
977
	/**
978
	 * This provider does not support group shares

lib/private/Authentication/Token/DefaultTokenMapper.php 2 locations

@@ 48-55 (lines=8) @@
45
	 *
46
	 * @param string $token
47
	 */
48
	public function invalidate(string $token) {
49
		/* @var $qb IQueryBuilder */
50
		$qb = $this->db->getQueryBuilder();
51
		$qb->delete('authtoken')
52
			->where($qb->expr()->eq('token', $qb->createNamedParameter($token, IQueryBuilder::PARAM_STR)))
53
			->andWhere($qb->expr()->eq('version', $qb->createNamedParameter(DefaultToken::VERSION, IQueryBuilder::PARAM_INT)))
54
			->execute();
55
	}
56
57
	/**
58
	 * @param int $olderThan
@@ 163-169 (lines=7) @@
160
	 *
161
	 * @param string $name
162
	 */
163
	public function deleteByName(string $name) {
164
		$qb = $this->db->getQueryBuilder();
165
		$qb->delete('authtoken')
166
			->where($qb->expr()->eq('name', $qb->createNamedParameter($name), IQueryBuilder::PARAM_STR))
167
			->andWhere($qb->expr()->eq('version', $qb->createNamedParameter(DefaultToken::VERSION, IQueryBuilder::PARAM_INT)));
168
		$qb->execute();
169
	}
170
171
}
172

lib/private/Authentication/Token/PublicKeyTokenMapper.php 2 locations

@@ 43-50 (lines=8) @@
40
	 *
41
	 * @param string $token
42
	 */
43
	public function invalidate(string $token) {
44
		/* @var $qb IQueryBuilder */
45
		$qb = $this->db->getQueryBuilder();
46
		$qb->delete('authtoken')
47
			->where($qb->expr()->eq('token', $qb->createNamedParameter($token)))
48
			->andWhere($qb->expr()->eq('version', $qb->createNamedParameter(PublicKeyToken::VERSION, IQueryBuilder::PARAM_INT)))
49
			->execute();
50
	}
51
52
	/**
53
	 * @param int $olderThan
@@ 154-160 (lines=7) @@
151
	 *
152
	 * @param string $name
153
	 */
154
	public function deleteByName(string $name) {
155
		$qb = $this->db->getQueryBuilder();
156
		$qb->delete('authtoken')
157
			->where($qb->expr()->eq('name', $qb->createNamedParameter($name), IQueryBuilder::PARAM_STR))
158
			->andWhere($qb->expr()->eq('version', $qb->createNamedParameter(PublicKeyToken::VERSION, IQueryBuilder::PARAM_INT)));
159
		$qb->execute();
160
	}
161
162
	public function deleteTempToken(PublicKeyToken $except) {
163
		$qb = $this->db->getQueryBuilder();