Doctrine 2 - ORM

Native Query fail

Details

  • Type: Bug Bug
  • Status: Resolved Resolved
  • Priority: Blocker Blocker
  • Resolution: Invalid
  • Affects Version/s: 2.1.6
  • Fix Version/s: None
  • Component/s: DQL, ORM
  • Security Level: All
  • Labels:
    None
  • Environment:
    XAMPP on Windows 7
    Doctrine in Combination with Symfony

Description

I keep getting an error while I'm trying to perfom an native query.
If there is no result then everything is fine and I don't get any errors.

Notice: Undefined index: id in C:\xampp\htdocs\Symfony\vendor\doctrine\lib\Doctrine\ORM\UnitOfWork.php line 1949

 
$sql = "SELECT q.question FROM question q WHERE MATCH (q.question) AGAINST (?)";

$rsm = new \Doctrine\ORM\Query\ResultSetMapping;
$rsm->addEntityResult('WWMGameBundle:Question', 'q');
$rsm->addFieldResult('q', 'question', 'question');

$em = $this->getDoctrine()->getEntityManager();
$query = $em->createNativeQuery($sql, $rsm);
$query->setParameter(1, $request->request->get('q'));

$search = $query->getResult();

 
/**
* WWM\Entity\Question
*
* @ORM\Entity(repositoryClass="WWM\Entity\QuestionsRepository")
* @ORM\Table(name="question")
*/
class Question
{
    /**
     * @var integer $id
     *
     * @ORM\Column(name="id", type="integer", nullable=false)
     * @ORM\Id
     * @ORM\GeneratedValue(strategy="IDENTITY")
     */
    private $id;

    /**
     * @var integer $level
     *
     * @ORM\Column(name="level", type="integer", nullable=false)
     */
    private $level;

    /**
     * @var string $question
     *
     * @ORM\Column(name="question", type="string", length=255, nullable=false)
     */
    private $question;



    /**
     * Get id
     *
     * @return integer
     */
    public function getId()
    {
        return $this->id;
    }

    /**
     * Set level
     *
     * @param integer $level
     */
    public function setLevel($level)
    {
        $this->level = $level;
    }

    /**
     * Get level
     *
     * @return integer
     */
    public function getLevel()
    {
        return $this->level;
    }

    /**
     * Set question
     *
     * @param string $question
     */
    public function setQuestion($question)
    {
        $this->question = $question;
    }

    /**
     * Get question
     *
     * @return string
     */
    public function getQuestion()
    {
        return $this->question;
    }
}

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Benjamin Eberlei added a comment -

You have to add the id as field aswell using $rsm->addFieldResult()

Show
Benjamin Eberlei added a comment - You have to add the id as field aswell using $rsm->addFieldResult()
Hide
Permalink
Moritz added a comment -

It doesn't matter if I use the id as well. I keep getting the same error message:

$sql = "SELECT q.question FROM question q WHERE MATCH (q.question) AGAINST (?)";

$rsm = new \Doctrine\ORM\Query\ResultSetMapping;
$rsm->addEntityResult('WWMGameBundle:Question', 'q');
$rsm->addFieldResult('q', 'question', 'question');
$rsm->addFieldResult('q', 'id', 'id');

$em = $this->getDoctrine()->getEntityManager();
$query = $em->createNativeQuery($sql, $rsm);
$query->setParameter(1, $request->request->get('q'));

$search = $query->getResult();
Show
Moritz added a comment - It doesn't matter if I use the id as well. I keep getting the same error message: $sql = "SELECT q.question FROM question q WHERE MATCH (q.question) AGAINST (?)" ; $rsm = new \Doctrine\ORM\Query\ResultSetMapping; $rsm->addEntityResult('WWMGameBundle:Question', 'q'); $rsm->addFieldResult('q', 'question', 'question'); $rsm->addFieldResult('q', 'id', 'id'); $em = $ this ->getDoctrine()->getEntityManager(); $query = $em->createNativeQuery($sql, $rsm); $query->setParameter(1, $request->request->get('q')); $search = $query->getResult();
Hide
Permalink
Moritz added a comment -

It doesn't matter if I use the id as well. I keep getting the same error message.

Show
Moritz added a comment - It doesn't matter if I use the id as well. I keep getting the same error message.
Hide
Permalink
Benjamin Eberlei added a comment -

Do you want to fetch the whole Question Entity? Or just the question as string? Since you only do q.question i suppose using a scalar result instead of the entity works.

$sql = "SELECT q.question FROM question q WHERE MATCH (q.question) AGAINST (?)";

$rsm = new \Doctrine\ORM\Query\ResultSetMapping;
$rsm->addScalarResult('question', 'question');

$em = $this->getDoctrine()->getEntityManager();
$query = $em->createNativeQuery($sql, $rsm);
$query->setParameter(1, $request->request->get('q'));

$search = $query->getResult();

However if you want the whole entity, then you have to fetch the ID from sql as well:

$sql = "SELECT q.id, q.question FROM question q WHERE MATCH (q.question) AGAINST (?)";

$rsm = new \Doctrine\ORM\Query\ResultSetMapping;
$rsm->addEntityResult('WWMGameBundle:Question', 'q');
$rsm->addFieldResult('q', 'question', 'question');
$rsm->addFieldResult('q', 'id', 'id');

$em = $this->getDoctrine()->getEntityManager();
$query = $em->createNativeQuery($sql, $rsm);
$query->setParameter(1, $request->request->get('q'));

$search = $query->getResult();
Show
Benjamin Eberlei added a comment - Do you want to fetch the whole Question Entity? Or just the question as string? Since you only do q.question i suppose using a scalar result instead of the entity works. $sql = "SELECT q.question FROM question q WHERE MATCH (q.question) AGAINST (?)" ; $rsm = new \Doctrine\ORM\Query\ResultSetMapping; $rsm->addScalarResult('question', 'question'); $em = $ this ->getDoctrine()->getEntityManager(); $query = $em->createNativeQuery($sql, $rsm); $query->setParameter(1, $request->request->get('q')); $search = $query->getResult(); However if you want the whole entity, then you have to fetch the ID from sql as well: $sql = "SELECT q.id, q.question FROM question q WHERE MATCH (q.question) AGAINST (?)" ; $rsm = new \Doctrine\ORM\Query\ResultSetMapping; $rsm->addEntityResult('WWMGameBundle:Question', 'q'); $rsm->addFieldResult('q', 'question', 'question'); $rsm->addFieldResult('q', 'id', 'id'); $em = $ this ->getDoctrine()->getEntityManager(); $query = $em->createNativeQuery($sql, $rsm); $query->setParameter(1, $request->request->get('q')); $search = $query->getResult();
Hide
Permalink
Moritz added a comment -

Now it works perfectly fine. Thank you

Show
Moritz added a comment - Now it works perfectly fine. Thank you

People

  • Assignee:
    Benjamin Eberlei
    Reporter:
    Moritz
Vote (0)
Watch (1)

Dates

  • Created:
    Updated:
    Resolved: