nextcloud / server

	 * @param $password

	 * @return bool

	 */

	public function auth($username, $password) {

		if ($username !== 'system') {

			return false;

		}

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

		$query->select('url')->from($this->dbTable)

				->where($query->expr()->eq('shared_secret', $query->createNamedParameter($password)));

		$statement = $query->execute();

		$result = $statement->fetch();

		$statement->closeCursor();

		return !empty($result);

	}

}

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