NV\RequestLimitBundle\Command\MySQLProviderSetupCommand

Complexity

Total Complexity

2

Size/Duplication

Total Lines	20
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	execute()	0	9	1
A	configure()	0	6	1

<?php

namespace NV\RequestLimitBundle\Command;

use Doctrine\DBAL\Connection;

The type Doctrine\DBAL\Connection was not found. Maybe you did not declare it correctly or list all dependencies?

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

The type Symfony\Component\Console\Input\InputInterface was not found. Maybe you did not declare it correctly or list all dependencies?

use Symfony\Component\Console\Output\OutputInterface;

The type Symfony\Component\Console\Output\OutputInterface was not found. Maybe you did not declare it correctly or list all dependencies?

class MySQLProviderSetupCommand extends ContainerAwareCommand
{
    protected function configure()
    {
        $this
            ->setName('nv:request-limit:mysql-init')
            ->setDescription('Creates a table in your project database to store keys')
            ->setHelp('This command initialize MySQL provider workflow')
        ;
    }

    protected function execute(InputInterface $input, OutputInterface $output)
    {
        /** @var Connection $connection */
        $connection = $this->getContainer()->get('doctrine.orm.default_entity_manager')->getConnection();
        $connection->exec('CREATE TABLE nv_request_limit_items (
            item_key VARCHAR(30) PRIMARY KEY,
            expires_at TIMESTAMP
            );');
        $connection->close();
    }
}