How do I query the mySql DB? For some reason I am not getting the response I expect below.
I have a message table with a messageBody column that I would like to get.
I am also trying to return it as an array of JSON formatted objects.
/**
* @Route("/api/messages")
* @Template()
*/
public function messagesGetAction()
{
$repository = $this->getDoctrine()->getRepository('AppBundle:Message');
$messagesArr = $repository->findBy(array('messageBody'=>'messageBody'));
$messages = json_encode($messagesArr);
return new Response($messages);
}
This is what is returned
[{},{},{}]
My question is how do I build a proper get controller to return an api json response?
Message entity
<?php
namespace AppBundle\Entity;
use Doctrine\ORM\Mapping as ORM;
/**
* @ORM\Entity
* @ORM\Table(name="message")
*/
class Message
{
/**
* @var integer
*/
private $id;
/**
* @var string
*/
private $fromUser;
/**
* @var string
*/
private $toUser;
/**
* @var string
*/
private $messageTitle;
/**
* @var string
*/
private $messageBody;
/**
* Get id
*
* @return integer
*/
public function getId()
{
return $this->id;
}
/**
* Set fromUser
*
* @param string $fromUser
* @return Message
*/
public function setFromUser($fromUser)
{
$this->fromUser = $fromUser;
return $this;
}
/**
* Get fromUser
*
* @return string
*/
public function getFromUser()
{
return $this->fromUser;
}
/**
* Set toUser
*
* @param string $toUser
* @return Message
*/
public function setToUser($toUser)
{
$this->toUser = $toUser;
return $this;
}
/**
* Get toUser
*
* @return string
*/
public function getToUser()
{
return $this->toUser;
}
/**
* Set messageTitle
*
* @param string $messageTitle
* @return Message
*/
public function setMessageTitle($messageTitle)
{
$this->messageTitle = $messageTitle;
return $this;
}
/**
* Get messageTitle
*
* @return string
*/
public function getMessageTitle()
{
return $this->messageTitle;
}
/**
* Set messageBody
*
* @param string $messageBody
* @return Message
*/
public function setMessageBody($messageBody)
{
$this->messageBody = $messageBody;
return $this;
}
/**
* Get messageBody
*
* @return string
*/
public function getMessageBody()
{
return $this->messageBody;
}
}
Routing
## api routes
app_getmessages:
pattern: /api/messages
defaults: { _controller: AppBundle:Default:messages}
Database
NEW CODE:
/**
* @Route("/api/messages")
* @Template()
*/
public function messagesGetAction()
{
$repository = $this->getDoctrine()->getRepository('XYGamingBundle:Message');
$messagesArr = $repository->findAll();
$json = new JsonResponse($messagesArr);
if (!$json) {
throw $this->createNotFoundException(
'No messages found'
);
}
return new Response($json);
}
Solution
// add to controller
use Symfony\Component\Serializer\Serializer;
use Symfony\Component\Serializer\Encoder\XmlEncoder;
use Symfony\Component\Serializer\Encoder\JsonEncoder;
use Symfony\Component\Serializer\Normalizer\GetSetMethodNormalizer;
/**
* @Route("/api/messages")
* @Template()
*/
public function messagesGetAction()
{
//$serializer = $container->get('jms_serializer');
// $serializer->serialize($data, $format);
// $data = $serializer->deserialize($inputStr, $typeName, $format);
$encoders = array(new XmlEncoder(), new JsonEncoder());
$normalizers = array(new GetSetMethodNormalizer());
$serializer = new Serializer($normalizers, $encoders);
$repository = $this->getDoctrine()->getRepository('XYGamingBundle:Message');
$data = $repository->findAll();
//$json = $serializer->serialize($data, 'json');
$json = $serializer->serialize($data, 'json');
//$json = new JsonResponse($messagesArr);
if (!$json) {
throw $this->createNotFoundException(
'No messages found'
);
}
return new Response($json);
}
Thanks guys
