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