pomm-project / Cli

sources/lib/Command/InspectDatabase.php

<?php
/*
 * This file is part of Pomm's Cli package.
 *
 * (c) 2014 - 2015 Grégoire HUBERT <hubert.greg@gmail.com>
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */
namespace PommProject\Cli\Command;

use PommProject\Foundation\ResultIterator;
use Symfony\Component\Console\Helper\Table;
use Symfony\Component\Console\Input\InputInterface;
use Symfony\Component\Console\Output\OutputInterface;

/**
 * InspectDatabase
 *
 * Return the list of schemas in the current database.
 *
 * @package   Cli
 * @copyright 2014 - 2015 Grégoire HUBERT
 * @author    Grégoire HUBERT
 * @license   X11 {@link http://opensource.org/licenses/mit-license.php}
 * @see       PommAwareCommand
 */
class InspectDatabase extends SessionAwareCommand
{
    /**
     * configure
     *
     * @see Command
     */
    public function configure()
    {
        $this
            ->setName('pomm:inspect:database')
            ->setDescription('Show schemas in the current database.')
            ;

        parent::configure();
    }

    /**
     * execute
     *
     * @see Command
     */
    protected function execute(InputInterface $input, OutputInterface $output)
    {
        parent::execute($input, $output);
        $info = $this->getSession()->getInspector('schema')->getUserSchemas();
        $version = $this->getSession()->getInspector('database')->getVersion();
        $size = $this->getSession()->getInspector('database')->getSizePretty();
        $name = $this->getSession()->getInspector('database')->getName();
        $this->formatOutput($output, $info, $version, $size, $name);

        return 0;
    }

    /**
     * formatOutput
     *
     * Format command output from the inspector's result.
     *
     * @access protected
     * @param  OutputInterface  $output
     * @param  ResultIterator   $iterator
     * @return null
     */
    protected function formatOutput(OutputInterface $output, ResultIterator $iterator, $version, $size, $name)
    {
        $output->writeln(
            sprintf(
                "PostgreSQL v.%s",
                $version
            )
        );
        $output->writeln(
            sprintf(
                "Found <info>%d</info> schemas in database \"%s\" (%s).",
                $iterator->count(),
                $name,
                $size
            )
        );
        $table = (new Table($output))
            ->setHeaders(['name', 'oid ', 'relations', 'owner', 'comment'])
            ;

        foreach ($iterator as $schema_info) {

This code seems to be duplicated across your project.

            $table->addRow([
                sprintf("<fg=yellow>%s</fg=yellow>", $schema_info['name']),
                $schema_info['oid'],
                $schema_info['relations'],
                $schema_info['owner'],
                wordwrap($schema_info['comment'])
            ]);
        }

        $table->render();
    }
}