WordPress

<?php

namespace App\Command;

use App\Entity\FtpUser;
use App\Entity\User;
use App\Util\Mailer;
use App\Util\UserManipulator;
use FOS\UserBundle\Util\TokenGenerator;
use Symfony\Component\Console\Command\Command;
use Symfony\Component\Console\Input\InputArgument;
use Symfony\Component\Console\Input\InputInterface;
use Symfony\Component\Console\Input\InputOption;
use Symfony\Component\Console\Output\OutputInterface;
use Symfony\Component\Console\Style\SymfonyStyle;
use Psr\Container\ContainerInterface;
use Symfony\Component\DependencyInjection\ParameterBag\ParameterBagInterface;
use Symfony\Component\Filesystem\Filesystem;
use Symfony\Component\Finder\Finder;
use Symfony\Component\Routing\Generator\UrlGeneratorInterface;
use Symfony\Component\Routing\RouterInterface;

class CleanDbCommand extends Command
{
    protected static $defaultName = 'app:clean-db';
    private $userManipulator;

    private $container;
    private $params;
    private $mailer;
    private $router;


    public function __construct(ContainerInterface $container, ParameterBagInterface $parameterBag,Mailer $mailer,RouterInterface $router)
    {


        parent::__construct();
        $this->params = $parameterBag;
        $this->container = $container;
        $this->mailer = $mailer;
        $this->router = $router;

        $this->em = $this->container->get('doctrine')->getManager();
    }

    protected function configure()
    {
//        parent::__construct();
        $this
            ->setDescription('Clean Databse')
            ->addArgument('arg1', InputArgument::OPTIONAL, 'Argument description')
            ->addOption('option1', null, InputOption::VALUE_NONE, 'Option description')
        ;
    }



    protected function execute(InputInterface $input, OutputInterface $output): int
    {
        $context = $this->router->getContext();
        $context->setHost(getenv('HOST'));
//        $context->setScheme('https');
        $context->setBaseUrl('public');
        $io = new SymfonyStyle($input, $output);
        $em = $this->container->get('doctrine');
        $sql="
            delete from invoice_items;
    delete from cart_item;
    delete from cart;
    delete from reported_stock;
    delete from invoice;
    delete from payouts;
    delete from reported_stock;
    delete from stock_model;
    delete from stock_release;
    update home_featured_stock set contributor_id=2 where contributor_id >2;
    update stock_category set featured_stock_id=null where featured_stock_id is not null;
    delete from stocks_cats;
    delete from stock_recent_views;
    delete from model_release;
    delete from release_form;
    delete from payout_details;
    delete from role_user;
    delete from model;

    delete from stock;

    delete from ftpuser;
    delete from fos_user where id>2;
    update blog set writer_id=2;

        ";
        $conn = $em->getConnection();


        $stmt = $conn->prepare( $sql );
//        $stmt->setFetchMode( \PDO::FETCH_OBJ );
        $stmt->execute();

        $stmt->closeCursor();

        $io->success('Database Cleaned!.');

        return 0;
    }
}