owncloud / core

	 *

	 * @param int $id

	 */

	public function removeServer($id) {

		$query = $this->connection->getQueryBuilder();

		$query->delete($this->dbTable)

			->where($query->expr()->eq('id', $query->createParameter('id')))

			->setParameter('id', $id);

		$query->execute();

	}

	/**

	 * get trusted server with given ID

	 * @param IUser $user

	 * @param int $id

	 */

	public function deleteById(IUser $user, $id) {

		/* @var $qb IQueryBuilder */

		$qb = $this->db->getQueryBuilder();

		$qb->delete('authtoken')

			->where($qb->expr()->eq('id', $qb->createNamedParameter($id)))

			->andWhere($qb->expr()->eq('uid', $qb->createNamedParameter($user->getUID())));

		$qb->execute();

	}

}

	 *

	 * Removes all keys in appconfig belonging to the app.

	 */

	public function deleteApp($app) {

		$this->loadConfigValues();

		$sql = $this->conn->getQueryBuilder();

		$sql->delete('appconfig')

			->where($sql->expr()->eq('appid', $sql->createParameter('app')))

			->setParameter('app', $app);

		$sql->execute();

		unset($this->cache[$app]);

	}

	/**

	 * get multiple values, either the app or key can be used as wildcard by setting it to false

	 * @param int $mountId

	 * @param string $newMountPoint

	 */

	public function setMountPoint($mountId, $newMountPoint) {

		$builder = $this->connection->getQueryBuilder();

		$query = $builder->update('external_mounts')

			->set('mount_point', $builder->createNamedParameter($newMountPoint))

			->where($builder->expr()->eq('mount_id', $builder->createNamedParameter($mountId, IQueryBuilder::PARAM_INT)));

		$query->execute();

	}

	/**

	 * @param int $mountId

	 * @param int $mountId

	 * @param string $newAuthBackend

	 */

	public function setAuthBackend($mountId, $newAuthBackend) {

		$builder = $this->connection->getQueryBuilder();

		$query = $builder->update('external_mounts')

			->set('auth_backend', $builder->createNamedParameter($newAuthBackend))

			->where($builder->expr()->eq('mount_id', $builder->createNamedParameter($mountId, IQueryBuilder::PARAM_INT)));

		$query->execute();

	}

	/**

	 * @param int $mountId

	 * @param int $shareId

	 * @param string $token

	 */

	protected function updateSuccessfulReShare($shareId, $token) {

		$query = $this->dbConnection->getQueryBuilder();

		$query->update('share')

			->where($query->expr()->eq('id', $query->createNamedParameter($shareId)))

			->set('token', $query->createNamedParameter($token))

			->execute();

	}

	/**

	 * store remote ID in federated reShare table

	 *

	 * @param string $shareId

	 */

	private function removeShareFromTableById($shareId) {

		$qb = $this->dbConnection->getQueryBuilder();

		$qb->delete('share')

			->where($qb->expr()->eq('id', $qb->createNamedParameter($shareId)));

		$qb->execute();

		$qb->delete('federated_reshares')

			->where($qb->expr()->eq('share_id', $qb->createNamedParameter($shareId)));

		$qb->execute();

	}

	/**

	 * @inheritdoc

	 * @param string $uid

	 * @param int $shareType

	 */

	public function userDeleted($uid, $shareType) {

		//TODO: probabaly a good idea to send unshare info to remote servers

		$qb = $this->dbConnection->getQueryBuilder();

		$qb->delete('share')

			->where($qb->expr()->eq('share_type', $qb->createNamedParameter(\OCP\Share::SHARE_TYPE_REMOTE)))

			->andWhere($qb->expr()->eq('uid_owner', $qb->createNamedParameter($uid)))

			->execute();

	}

	/**

	 * This provider does not handle groups

	 *

	 * @param IJob $job

	 */

	public function unlockJob($job) {

		$query = $this->connection->getQueryBuilder();

		$query->update('jobs')

			->set('reserved_at', $query->expr()->literal(0, IQueryBuilder::PARAM_INT))

			->where($query->expr()->eq('id', $query->createNamedParameter($job->getId(), IQueryBuilder::PARAM_INT)));

		$query->execute();

	}

	/**

	 * get the id of the last ran job

		$query->execute();

	}

	public function setExecutionTime($job, $timeTaken) {

		$query = $this->connection->getQueryBuilder();

		$query->update('jobs')

			->set('execution_duration', $query->createNamedParameter($timeTaken, IQueryBuilder::PARAM_INT))

			->where($query->expr()->eq('id', $query->createNamedParameter($job->getId(), IQueryBuilder::PARAM_INT)));

		$query->execute();

	}

}

	 * @param IShare $share

	 * @param int $permissions

	 */

	protected function updatePermissionsInDatabase(IShare $share, $permissions) {

		$query = $this->connection->getQueryBuilder();

		$query->update('share')

			->where($query->expr()->eq('id', $query->createNamedParameter($share->getId())))

			->set('permissions', $query->createNamedParameter($permissions))

			->execute();

	}

}

	 *

	 * @param IUser $user

	 */

	public function removeUserMounts(IUser $user) {

		$builder = $this->connection->getQueryBuilder();

		$query = $builder->delete('mounts')

			->where($builder->expr()->eq('user_id', $builder->createNamedParameter($user->getUID())));

		$query->execute();

	}

	public function removeUserStorageMount($storageId, $userId) {

		$builder = $this->connection->getQueryBuilder();

		$query->execute();

	}

	public function remoteStorageMounts($storageId) {

		$builder = $this->connection->getQueryBuilder();

		$query = $builder->delete('mounts')

			->where($builder->expr()->eq('storage_id', $builder->createNamedParameter($storageId, IQueryBuilder::PARAM_INT)));

		$query->execute();

	}

}

	/**

	 * @param $resourceId

	 */

	public function deleteAllShares($resourceId) {

		$query = $this->db->getQueryBuilder();

		$query->delete('dav_shares')

			->where($query->expr()->eq('resourceid', $query->createNamedParameter($resourceId)))

			->andWhere($query->expr()->eq('type', $query->createNamedParameter($this->resourceType)))

			->execute();

	}

	public function deleteAllSharesByUser($principaluri) {

		$query = $this->db->getQueryBuilder();

			->execute();

	}

	public function deleteAllSharesByUser($principaluri) {

		$query = $this->db->getQueryBuilder();

		$query->delete('dav_shares')

			->where($query->expr()->eq('principaluri', $query->createNamedParameter($principaluri)))

			->andWhere($query->expr()->eq('type', $query->createNamedParameter($this->resourceType)))

			->execute();

	}

	/**

	 * @param IShareable $shareable