Need to use Symfony Console Command to accept input and access the data from database

Question

As per the documentation on the symfony, i have created the console file in /bin folder

!/usr/bin/env php
date_default_timezone_set('UTC');

set_time_limit(0);

(@include_once DIR . '/../vendor/autoload.php') || @include_once DIR . '/../../../autoload.php';

use AppBundle\Console\Command\FetchCompetitionCommand; use Symfony\Component\Console\Application;

$app = new Application(); $app->add(new FetchCompetitionCommand()); $app->run();

and then the Command file in the Bundle/Console/Command Folder

<?php 

namespace AppBundle\Console\Command;

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

class FetchCompetitionCommand extends ContainerAwareCommand {
     protected function configure()
     {
         $this
             ->setName('getCompetition')
             ->setDescription('Get the Competition Name (AFL,NRL)')
             ->addArgument(
                 'name',
                 InputArgument::OPTIONAL,
                 '(Which Competition Data are you looking to fetch?)'
             )
         ;
     }

     protected function execute(InputInterface $input, OutputInterface $output)
     {
         $name = $input->getArgument('name');

         $output->writeln($name );
     } 
} 
?>

What next i need to do for configuring the database and access the data from database

Thanks in Advance

M Khalid Junaid · Accepted Answer · 2015-04-27 11:56:44Z

2

In execute function you can get container and once you have container you can get your repositories through doctrine and do your database stuff

protected function execute(InputInterface $input, OutputInterface $output)
{
    $name = $input->getArgument('name');
    $container = $this->getContainer();
    $DM = $container->get('Doctrine')->getManager();
    $result = $DM->getRepository('NamspaceYourBundle:Entity')->findBy(array());
    /** do your stuff here */

    $output->writeln($name    );
}

answered Apr 27, 2015 at 11:56

M Khalid Junaid

64.6k10 gold badges93 silver badges120 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rooneyl · Accepted Answer · 2015-04-27 12:14:08Z

1

I tend to have a service class that does whatever the functionality required is, then the console command calls this. The advantage to this is that the same functionality can then be called from any place in your system.

protected function execute(InputInterface $input, OutputInterface $output)
{
    $name = $input->getArgument('name');
    $my_service = $this->getContainer()->get('my.service.class');
    $bar = $my_service->foo($name);
    $output->writeln($name    );
}

Example function from service class;

public function foo($name)
{
    $DM = $container->get('Doctrine')->getManager();
    $result = $DM->getRepository('NamspaceYourBundle:Entity')->findBy(array($name));
    return $result;
}

answered Apr 27, 2015 at 12:14

Rooneyl

7,9226 gold badges58 silver badges83 bronze badges

Collectives™ on Stack Overflow

Need to use Symfony Console Command to accept input and access the data from database

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related