SetBased\Audit\Command\AlterAuditTableCommand

Complexity

Total Complexity

3

Size/Duplication

Total Lines	66
Duplicated Lines	0 %

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	configure()	0	8	1
A	execute()	0	21	2

<?php

namespace SetBased\Audit\Command;

use SetBased\Audit\Audit\AlterAuditTable;
use SetBased\Stratum\Style\StratumStyle;
use Symfony\Component\Console\Input\InputArgument;
use Symfony\Component\Console\Input\InputInterface;
use Symfony\Component\Console\Output\OutputInterface;

/**
 * Command for comparing data tables with audit tables.
 */
class AlterAuditTableCommand extends AuditCommand
{
  //--------------------------------------------------------------------------------------------------------------------
  /**
   * Check full full and return array without new or obsolete columns if full not set.
   *
   * @param array[] $columns The metadata of the columns of a table.
   *
   * @var StratumStyle
   */
  protected $io;

  //--------------------------------------------------------------------------------------------------------------------
  /**
   * @inheritdoc
   */
  protected function configure()
  {
    $this->setName('alter-audit-table')
         ->setDescription('Creates alter SQL statements for audit tables')
         ->addArgument('config file', InputArgument::REQUIRED, 'The audit configuration file')
         ->addArgument('sql file', InputArgument::OPTIONAL, 'The destination file for the SQL statements');

    $this->setHelp(<<<EOL
Generates alter table SQL statements for aligning the audit tables with the 
audit configuration file and data tables.

Manual inspection of the generated SQL statements is required. For example: 
changing an audit column from varchar(20) character set utf8 to varchar(10)
character set ascii might cause problems when the audit column has values
longer than 10 characters or values outside the ASCII character set (even 
though the current data table hold only values with length 10 or less and 
only in the ASCII character set).

No SQL statements will be generated for missing or obsolete columns in the 
audit tables. Use the command 'audit' for creating missing columns in audit
tables.
EOL
    );
  }

  //--------------------------------------------------------------------------------------------------------------------
  /**
   * @inheritdoc
   */
  protected function execute(InputInterface $input, OutputInterface $output)
  {
    $this->io = new StratumStyle($input, $output);

    $sqlFilename = $input->getArgument('sql file');

    $this->configFileName = $input->getArgument('config file');
    $this->readConfigFile();

    $this->connect($this->config);

    $alter = new AlterAuditTable($this->config);
    $sql   = $alter->main();

    if ($sqlFilename!==null)
    {
      $this->writeTwoPhases($sqlFilename, $sql);
    }
    else
    {
      $this->io->write($sql);
    }
  }

  //--------------------------------------------------------------------------------------------------------------------

}

//----------------------------------------------------------------------------------------------------------------------