doctrine / orm

        $query = $em->createQuery($dql);

        if (($firstResult = $input->getOption('first-result')) !== null) {

            if ( ! is_numeric($firstResult)) {

                throw new \LogicException("Option 'first-result' must contain an integer value");

            }

            $query->setFirstResult((int) $firstResult);

        }

        if (($maxResult = $input->getOption('max-result')) !== null) {

            if ( ! is_numeric($maxResult)) {

            $query->setFirstResult((int) $firstResult);

        }

        if (($maxResult = $input->getOption('max-result')) !== null) {

            if ( ! is_numeric($maxResult)) {

                throw new \LogicException("Option 'max-result' must contain an integer value");

            }

            $query->setMaxResults((int) $maxResult);

        }

        if ($input->getOption('show-sql')) {

            $ui->text($query->getSQL());