protected function execute(InputInterface $input, OutputInterface $output)
{
$connection = new PDOConnection();
$adm = new Administration($connection);
$output->write('Starting vacuum… ');
$adm->vacuum($input->getArgument('table'), $input->getArgument('index'));
$output->writeln('done');
}
protected function execute(InputInterface $input, OutputInterface $output)
{
$connection = new PDOConnection();
$adm = new Administration($connection);
$users = $adm->userNames();
$output->writeln('Users:');
if (count($users) == 0) {
$output->writeln(' (none)');
} else {
foreach ($users as $user) {
$output->writeln(' - ' . $user);
}
}
}
protected function execute(InputInterface $input, OutputInterface $output)
{
$connection = new PDOConnection();
$adm = new Administration($connection);
if ($input->isInteractive()) {
/** @var DialogHelper $dialog */
$dialog = $this->getApplication()->getHelperSet()->get('dialog');
$should_do = $dialog->askConfirmation($output, 'Are you sure that you want to kill all transactions?', false);
} else {
$should_do = true;
}
if ($should_do) {
$output->write('Killing transactions… ');
$adm->killAll($input->getArgument('code'));
$output->writeln('done');
}
}
protected function execute(InputInterface $input, OutputInterface $output)
{
$connection = new PDOConnection();
$adm = new Administration($connection);
$login = $input->getArgument('user');
$role = $input->getArgument('role');
$possible_roles = $adm->roleNames();
if (!in_array($role, $possible_roles)) {
$output->writeln('Unknown role: ' . $role);
exit(1);
}
$assigned_roles = $adm->grantedRoles($login);
if (in_array($role, $assigned_roles)) {
// otherwise, it is already revoked
$adm->revokeRole($login, $role);
}
$output->writeln('OK');
}
protected function execute(InputInterface $input, OutputInterface $output)
{
$connection = new PDOConnection();
$adm = new Administration($connection);
if ($login = $input->getArgument('user')) {
$output->writeln('Roles granted to ' . $login . ':');
$roles = $adm->grantedRoles($login);
} else {
$output->writeln('Roles:');
$roles = $adm->roleNames();
}
if (count($roles) == 0) {
$output->writeln(' (none)');
} else {
foreach ($roles as $role) {
$output->writeln(' - ' . $role);
}
}
}
protected function execute(InputInterface $input, OutputInterface $output)
{
$connection = new PDOConnection();
$adm = new Administration($connection);
$output->writeln($adm->status());
}
