class DbCommandBaseTest

class DbCommandBaseTest extends KernelTestBase {
    
    /**
     * Tests specifying a database key.
     */
    public function testSpecifyDatabaseKey() {
        $command = new DbCommandBaseTester();
        $command_tester = new CommandTester($command);
        Database::addConnectionInfo('magic_db', 'default', Database::getConnectionInfo('default')['default']);
        $command_tester->execute([
            '--database' => 'magic_db',
        ]);
        $this->assertEquals('magic_db', $command->getDatabaseConnection($command_tester->getInput())
            ->getKey(), 'Special db key is returned');
    }
    
    /**
     * Invalid database names will throw a useful exception.
     */
    public function testSpecifyDatabaseDoesNotExist() {
        $command = new DbCommandBaseTester();
        $command_tester = new CommandTester($command);
        $command_tester->execute([
            '--database' => 'dne',
        ]);
        $this->expectException(ConnectionNotDefinedException::class);
        $command->getDatabaseConnection($command_tester->getInput());
    }
    
    /**
     * Tests supplying database connection as a url.
     */
    public function testSpecifyDbUrl() {
        $command = new DbCommandBaseTester();
        $command_tester = new CommandTester($command);
        $command_tester->execute([
            '-db-url' => Database::getConnectionInfoAsUrl(),
        ]);
        $this->assertEquals('db-tools', $command->getDatabaseConnection($command_tester->getInput())
            ->getKey());
        Database::removeConnection('db-tools');
        $command_tester->execute([
            '--database-url' => Database::getConnectionInfoAsUrl(),
        ]);
        $this->assertEquals('db-tools', $command->getDatabaseConnection($command_tester->getInput())
            ->getKey());
    }
    
    /**
     * Tests specifying a prefix for different connections.
     */
    public function testPrefix() {
        if (Database::getConnection()->driver() == 'sqlite') {
            $this->markTestSkipped('SQLITE modifies the prefixes so we cannot effectively test it');
        }
        Database::addConnectionInfo('magic_db', 'default', Database::getConnectionInfo('default')['default']);
        $command = new DbCommandBaseTester();
        $command_tester = new CommandTester($command);
        $command_tester->execute([
            '--database' => 'magic_db',
            '--prefix' => 'extra',
        ]);
        $this->assertEquals('extra', $command->getDatabaseConnection($command_tester->getInput())
            ->tablePrefix());
        $command_tester->execute([
            '-db-url' => Database::getConnectionInfoAsUrl(),
            '--prefix' => 'extra2',
        ]);
        $this->assertEquals('extra2', $command->getDatabaseConnection($command_tester->getInput())
            ->tablePrefix());
        // This breaks simpletest cleanup.
        // @code
        //    $command_tester->execute([
        //      '--prefix' => 'notsimpletest',
        //    ]);
        //    $this->assertEquals('notsimpletest', $command->getDatabaseConnection($command_tester->getInput())->tablePrefix());
        // @endcode
    }

}