StatsDBundle/Command/EndpointMysqlCommand.php

<?php

namespace StatsDBundle\Command;

use Symfony\Bundle\FrameworkBundle\Command\ContainerAwareCommand;
use Symfony\Component\Console\Input\InputArgument;
use Symfony\Component\Console\Input\InputInterface;
use Symfony\Component\Console\Output\OutputInterface;

class EndpointMysqlCommand extends ContainerAwareCommand
{

    protected function configure()
    {
        $this
                ->setName('endpoint:mysql')
                ->setDescription('Test jsonendpoint mysql - Obtiene los últimos 10 registros de la métrica que se pasa')
                ->addArgument('metric', InputArgument::REQUIRED, 'Metric name')
        ;
    }

    /**
     * @param InputInterface $input
     * @param OutputInterface $output
     */
    protected function execute(InputInterface $input, OutputInterface $output)
    {
        //$json = '{"range":{"from":"2017-12-01T14:09:25.307Z","to":"2017-12-07T23:09:25.308Z"},"intervalMs":0,"targets":[{"target":"d_1_s_1_cmd_fiberhome_olt_scan"}],"format":"json","maxDataPoints":10}';
        $endpoint = $this->getContainer()->get('endpoint.mysql');
        $metric = $input->getArgument('metric');
        $data = array('targets' => array(0 => array("target" => $metric)), 'maxDataPoints' => 10);
        $json = json_encode($data);
        $result = $endpoint->get($json,'last');
        print_r($result);

        
        print_r(PHP_EOL);
        print_r(date("Y-m-d H:i:s"));
        print_r(PHP_EOL);
    }

}