/
githubmirror
/
ydb-php-examples
Обзор
Документация
Войти
/
githubmirror
/
ydb-php-examples
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
app/Commands/SelectCommand.php
68 строк
2 KB
Alexei Shabalin
initial commit
16 апр 2021, 10:37
16 апр 2021, 10:37
01ac227
Код
Авторство
О чём код?
<?php namespace App\Commands; use App\AppService; use Symfony\Component\Console\Helper\Table; use Symfony\Component\Console\Command\Command; use Symfony\Component\Console\Input\InputArgument; use Symfony\Component\Console\Input\InputInterface; use Symfony\Component\Console\Output\OutputInterface; class SelectCommand extends Command { /** * @var string */ protected static $defaultName = 'select'; /** * @var AppService */ protected $appService; public function __construct() { $this->appService = new AppService; parent::__construct(); } protected function configure() { $this->setDescription('Select rows form a table.'); $this->addArgument('table', InputArgument::REQUIRED, 'The table name.'); } /** * @param InputInterface $input * @param OutputInterface $output * @return int * @throws \YandexCloud\Ydb\Exception */ protected function execute(InputInterface $input, OutputInterface $output) { $table_name = $input->getArgument('table') ?: ''; $ydb = $this->appService->initYdb(); $table = $ydb->table(); $result = $table->session()->query('select * from `' . $table_name . '` limit 10;'); $output->writeln('Column count: ' . $result->columnCount()); $output->writeln('Row count: ' . $result->rowCount()); $t = new Table($output); $t ->setHeaders(array_map(function($column) { return $column['name']; }, $result->columns())) ->setRows($result->rows()) ; $t->render(); return Command::SUCCESS; } }