private function getSingleResult(Query $query)
{
try {
$result = $query->getSingleResult();
} catch (NonUniqueResultException $e) {
$result = null;
} catch (NoResultException $e) {
$result = null;
}
return $result;
}
/**
* Returns single result from query
*
* @access public
* @param bool $bAsArray
* @return mixed
* @throws Doctrine\ORM\NonUniqueResultException
* @since 1.0.0-alpha
* @version 1.0.0-alpha
*/
public function single($bAsArray = FALSE)
{
$this->limit(1);
try {
if ($bAsArray) {
self::$mResult = $this->oQuery->getSingleResult(2);
} else {
self::$mResult = $this->oQuery->getSingleResult();
}
} catch (Doctrine\Orm\NoResultException $e) {
self::$mResult = FALSE;
}
return self::$mResult;
}
/**
* @route: blog_tag
* Tag Controller
*/
public function tagAction($slug)
{
$em = $this->getEm();
$query = new Query($em);
$query->setDQL(
'SELECT t
FROM Bundle\BlogBundle\Entity\Tag t WHERE t.slug = ?1'
);
$query->setParameter(1, $slug);
$tag = $query->getSingleResult();
return $this->render('BlogBundle:Blog:tag.html.twig', array(
'tag' => $tag,
'posts' => $tag->getPosts()
));
}
public static function doQueryResult(\Doctrine\ORM\Query $query, $resultType)
{
switch ($resultType) {
case ResultType::ArrayType:
return $query->getArrayResult();
break;
case ResultType::ObjectType:
return $query->getResult();
break;
case ResultType::SingleObjectType:
return $query->getSingleResult();
break;
case ResultType::SingleArrayType:
return $query->getSingleResult(\Doctrine\ORM\Query::HYDRATE_ARRAY);
break;
default:
throw new \Exception("Not a valid ResultType.");
}
}
