nextcloud / server

	 * @param int $id

	 * @return IJob|null

	 */

	public function getById($id) {

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

		$query->select('*')

			->from('jobs')

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

		$result = $query->execute();

		$row = $result->fetch();

		$result->closeCursor();

		if ($row) {

			return $this->buildJob($row);

		} else {

			return null;

		}

	}

	/**

	 * get the job object from a row in the db

	 * @return array

	 * @throws ShareNotFound

	 */

	private function getRawShare($id) {

		// Now fetch the inserted share and create a complete share object

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

		$qb->select('*')

			->from('share')

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

		$cursor = $qb->execute();

		$data = $cursor->fetch();

		$cursor->closeCursor();

		if ($data === false) {

			throw new ShareNotFound;

		}

		return $data;

	}

	/**

	 * Create a share object from an database row