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