CodexShaper\Dumper\Test\MySqlTest

Complexity

Total Complexity

8

Size/Duplication

Total Lines	101
Duplicated Lines	0 %

Importance

Changes	3
Bugs	0	Features	0

<?php
class MySqlTest extends TestCase
{
    /** @test */
    public function it_provides_a_factory_method()
    {
        $this->assertInstanceOf(MysqlDumper::class, MysqlDumper::create());
    }

    /** @test */
    public function it_can_generate_a_dump_command()
    {
        $dumper = MysqlDumper::create()
            ->setDbName('dbname')
            ->setUserName('username')
            ->setPassword('password')
            ->dump('dump.sql');
        $tempFile = $dumper->getTempFile();
        $command  = $dumper->getCommand();
        $this->assertSame('mysqldump --defaults-extra-file=' . $tempFile . ' dbname --skip-comments > dump.sql', $command);
    }

    /** @test */
    public function it_can_generate_a_dump_command_with_compression_enabled()
    {
        $dumper = MysqlDumper::create()
            ->setDbName('dbname')
            ->setUserName('username')
            ->setPassword('password')
            ->useCompress()
            ->dump('dump.sql');
        $command  = $dumper->getCommand();
        $tempFile = $dumper->getTempFile();
        $this->assertSame('mysqldump --defaults-extra-file=' . $tempFile . ' dbname --skip-comments | gzip > dump.sql.gz', $command);
    }

    /** @test */
    public function it_can_generate_a_dump_command_with_absolute_path()
    {
        $dumper = MysqlDumper::create()
            ->setDbName('dbname')
            ->setUserName('username')
            ->setPassword('password')
            ->dump('/path/to/directory/dump.sql');
        $command  = $dumper->getCommand();
        $tempFile = $dumper->getTempFile();
        $this->assertSame('mysqldump --defaults-extra-file=' . $tempFile . ' dbname --skip-comments > /path/to/directory/dump.sql', $command);
    }

    /** @test */
    public function it_can_generate_a_dump_command_without_using_comments()
    {
        $dumper = MysqlDumper::create()
            ->setDbName('dbname')
            ->setUserName('username')
            ->setPassword('password')
            ->doNotUseSkipComments()
            ->dump('dump.sql');
        $tempFile = $dumper->getTempFile();
        $command  = $dumper->getCommand();
        $this->assertSame('mysqldump --defaults-extra-file=' . $tempFile . ' dbname > dump.sql', $command);
    }

    /** @test */
    public function it_can_generate_a_restore_command()
    {
        $dumper = MysqlDumper::create()
            ->setDbName('dbname')
            ->setUserName('username')
            ->setPassword('password')
            ->restore('dump.sql');
        $tempFile = $dumper->getTempFile();
        $command  = $dumper->getCommand();

        $this->assertSame('mysql --defaults-extra-file=' . $tempFile . ' dbname < dump.sql', $command);
    }

    /** @test */
    public function it_can_generate_a_restore_command_with_compression_enabled()
    {
        $dumper = MysqlDumper::create()
            ->setDbName('dbname')
            ->setUserName('username')
            ->setPassword('password')
            ->useCompress()
            ->restore('dump.sql.gz');
        $command  = $dumper->getCommand();
        $tempFile = $dumper->getTempFile();
        $this->assertSame('gzip < dump.sql.gz | mysql --defaults-extra-file=' . $tempFile . ' dbname', $command);
    }

    /** @test */
    public function it_can_generate_a_restore_command_with_absolute_path()
    {
        $dumper = MysqlDumper::create()
            ->setDbName('dbname')
            ->setUserName('username')
            ->setPassword('password')
            ->restore('/path/to/directory/dump.sql');
        $command  = $dumper->getCommand();
        $tempFile = $dumper->getTempFile();
        $this->assertSame('mysql --defaults-extra-file=' . $tempFile . ' dbname < /path/to/directory/dump.sql', $command);
    }