owncloud / core

	 * @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();

	}

}

	 * @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 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();

	}

	/**

	 * @inheritdoc

	 *

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

	 */

	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 string $token

	 * @return bool

	 */

	public function deleteByFileIdAndToken(int $fileId, string $token) : bool {

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

		$rowCount = $query->delete($this->getTableName())

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

			->andWhere($query->expr()->eq('token_hash', $query->createNamedParameter(\md5($token))))

			->execute();

		return $rowCount === 1;

	}

	/**

	 * @param string $token

	 * @param int $shareId

	 * @param string $token

	 */

	protected function updateSuccessfulReShare($shareId, $token) {

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

		$query->update($this->shareTable)

			->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($this->shareTable)

			->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($this->shareTable)

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