App\Tests\Command\ImportDataFromCsvCommandTest

Complexity

Total Complexity

9

Size/Duplication

Total Lines	171
Duplicated Lines	0 %

Importance

Changes	10
Bugs	0	Features	0

<?php
class ImportDataFromCsvCommandTest extends KernelTestCase
{
    use DatabaseHelperTrait;

    /**
     * Bootstrap kernel and prepare database.
     */
    protected function setUp(): void
    {
        // Bootstrap the Symfony kernel
        self::bootKernel();

        // Get the parameter bag from the container
        $container = self::$kernel->getContainer();
        /** @var ParameterBagInterface $parameterBag */
        $parameterBag = $container->getParameterBag();

        // Get the database connection parameters
        $databaseParams = $parameterBag->get('doctrine.connections');

        var_dump($databaseParams);

        // Get the database connection name (game in this case)
        $connectionName = 'game';

        // Get the entity manager and connection from the container
        $entityManager = $this->getEntityManager($connectionName);
        /** @var Connection $connection */
        $connection = $entityManager->getConnection();

        // Query the schema manager to get the table names
        $schemaManager = $connection->createSchemaManager();
        $tables = $schemaManager->listTables();

        // Output the table names to the console
        echo "\nTables in the '{$connectionName}' database:\n\n";
        foreach ($tables as $table) {
            echo $table->getName() . " columns:\n";
            foreach ($table->getColumns() as $column) {
                echo ' - ' . $column->getName() . "\n";
            }
            echo "\n";
        }

        // Execute the query to get SQLite version
        $versionQuery = $connection->query('SELECT sqlite_version() as version');
        while (($row = $versionQuery->fetchAssociative()) !== false) {
            var_dump($row);
        }
        
        // if (getenv('APP_ENV') !== 'test') {
        //     $this->markTestSkipped(
        //         'This test can only be run on the test environment.'
        //     );
        // }

        /** @var EntityManagerInterface */
        $entityManager = $this->getEntityManager('game');

        // Truncate the location table before each test
        $this->truncateTable($entityManager, 'location');
    }

    /**
     * Test case for execute method with valid input.
     */
    public function testExecute(): void
    {
        // Get the entity manager for the 'game' connection
        /** @var EntityManagerInterface */
        $entityManager = $this->getEntityManager('game');

        // Check the contents of the 'location' table before executing the command
        $this->assertEmptyTable($entityManager, 'location');

        $application = new Application(self::$kernel);

        $command = $application->find('app:import-csv');

        $commandTester = new CommandTester($command);
        $commandTester->execute([
            'filename' => 'location.csv',
            '--manager' => 'game',
        ]);

        $commandTester->assertCommandIsSuccessful();

        // Check the output of the command in the console
        $output = $commandTester->getDisplay();
        $this->assertStringContainsString("Importing CSV\n=============\nFilename: location.csv", $output);

        // Check the contents of the 'location' table after executing the command
        $this->assertNonEmptyTable($entityManager, 'location');
    }

    /**
     * Test case for execute method with invalid file.
     */
    public function testExecuteWithNonExistentCsvFile(): void
    {
        $application = new Application(self::$kernel);

        $command = $application->find('app:import-csv');

        $commandTester = new CommandTester($command);
        $commandTester->execute([
            'filename' => 'nonexistent.csv',
            '--manager' => 'game',
        ]);

        $this->assertSame(Command::FAILURE, $commandTester->getStatusCode());

        // Expected path to the file
        $csvPath = self::$kernel->getProjectDir() . '/public/csv/nonexistent.csv';

        // Check the output of the command in the console
        $output = $commandTester->getDisplay();
        $this->assertStringContainsString('The CSV file "' . $csvPath . '" does not exist.', $output);
    }

    /**
     * Test case for execute method with invalid entity manager.
     */
    public function testExecuteWithNonExistentEntityManager(): void
    {
        $application = new Application(self::$kernel);

        $command = $application->find('app:import-csv');

        $commandTester = new CommandTester($command);
        $commandTester->execute([
            'filename' => 'location.csv',
            '--manager' => 'nonexistent',
        ]);

        $this->assertSame(Command::FAILURE, $commandTester->getStatusCode());

        // Check the output of the command in the console
        $output = $commandTester->getDisplay();
        $this->assertStringContainsString('The Entity Manager "nonexistent" does not exist.', $output);
    }

    /**
     * Test case for execute method with missing entity class.
     */
    public function testExecuteWithNoEntityClassFound(): void
    {
        $application = new Application(self::$kernel);

        $command = $application->find('app:import-csv');

        $commandTester = new CommandTester($command);
        $commandTester->execute([
            'filename' => 'dummy.csv',
            '--manager' => 'game',
        ]);

        $this->assertSame(Command::FAILURE, $commandTester->getStatusCode());

        // Check the output of the command in the console
        $output = $commandTester->getDisplay();
        $this->assertStringContainsString('No entity class found for the CSV file "dummy.csv".', $output);
    }

    /**
     * @return object The entity manager.
     */
    private function getEntityManager(string $name = 'default')
    {
        $container = self::$kernel->getContainer();

        /** @var ManagerRegistry $doctrine */