DatabaseBackuperTest::testRestorePostgresBackupNotEmptyBase() - Code Metrics - floor12/yii2-module-backup - Measure and Improve Code Quality continuously with Scrutinizer

testRestorePostgresBackupNotEmptyBase() A
last analyzed 2024-11-29 09:13 UTC

↳ Parent: DatabaseBackuperTest

Complexity

Conditions	1
Paths	1

Size

Total Lines	9
Code Lines	6

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
eloc	6
c	0
b	0
f	0
dl	0
loc	9
rs	10
cc	1
nc	1
nop	0

<?php
/**
 * Created by PhpStorm.
 * User: floor12
 * Date: 11.11.2019
 * Time: 07:45
 */

namespace floor12\backup\tests\unit;

/**
 * This is a tests for Backup class
 */

use floor12\backup\logic\DatabaseBackuper;
use floor12\backup\tests\TestCase;
use Yii;
use yii\base\Exception;
use yii\db\Connection;

class DatabaseBackuperTest extends TestCase
{

    public function testBackupFileExists()
    {
        $this->expectException(Exception::class);
        $backupFilePath = Yii::getAlias('@app/_output/sqlite.db'); // Just existing file
        $connection = Yii::$app->mysql;
        new DatabaseBackuper($backupFilePath, $connection);
        new DatabaseBackuper(/** @scrutinizer ignore-type */ $backupFilePath, $connection);
        $backuper = new DatabaseBackuper($backupFilePath, $connection);
        $backuper->backup();
    }

//    public function testCreateMysqlBackup()
//    {
//        $backupFilePath = Yii::getAlias('@app/data/mysql.tar');
//        $connection = Yii::$app->mysql;
//        $backuper = new DatabaseBackuper($backupFilePath, $connection);
//        $backuper->backup();
//        $this->assertFileExists($backupFilePath);
//    }

    public function testCreatePostgresBackup()
    {
        $backupFilePath = Yii::getAlias('@app/_output/postgres');
        $connection = Yii::$app->postgres;
        $backuper = new DatabaseBackuper($backupFilePath, $connection);
        $backuper = new DatabaseBackuper(/** @scrutinizer ignore-type */ $backupFilePath, $connection);
        $backuper->backup();
        $this->assertFileExists($backupFilePath);
        $this->assertFileExists(/** @scrutinizer ignore-type */ $backupFilePath);
        @unlink($backupFilePath);
        @unlink(/** @scrutinizer ignore-type */ $backupFilePath);
    }

    public function testRestorePostgresBackupEmptyBase()
    {
        $backupFilePath = Yii::getAlias('@app/data/postgres');
        /** @var $connection Connection */
        $connection = Yii::$app->postgres;
        $this->assertFalse($this->deleteTableSuccess('test_table', $connection));
        $backuper = new DatabaseBackuper($backupFilePath, $connection);
        $backuper = new DatabaseBackuper(/** @scrutinizer ignore-type */ $backupFilePath, $connection);
        $backuper->restore();
        $this->assertTrue($this->deleteTableSuccess('test_table', $connection));
    }

    public function testRestorePostgresBackupNotEmptyBase()
    {
        $backupFilePath = Yii::getAlias('@app/data/postgres');
        /** @var $connection Connection */
        $connection = Yii::$app->postgres;
        $connection->createCommand()->createTable('test_table', ['id' => 'int null'])->execute();
        $backuper = new DatabaseBackuper($backupFilePath, $connection);
        $backuper = new DatabaseBackuper(/** @scrutinizer ignore-type */ $backupFilePath, $connection);
        $backuper->restore();
        $this->assertTrue($this->deleteTableSuccess('test_table', $connection));
    }

    public function testCreateMysqlBackup()
    {
        $backupFilePath = Yii::getAlias('@app/_output/mysql.sql.tgz');
        $connection = Yii::$app->mysql;
        $backuper = new DatabaseBackuper($backupFilePath, $connection);
        $backuper = new DatabaseBackuper(/** @scrutinizer ignore-type */ $backupFilePath, $connection);
        $backuper->backup();
        $this->assertFileExists($backupFilePath);
        $this->assertFileExists(/** @scrutinizer ignore-type */ $backupFilePath);
        @unlink($backupFilePath);
        @unlink(/** @scrutinizer ignore-type */ $backupFilePath);
    }

    public function testRestoreMysqlBackupEmptyBase()
    {
        $backupFilePath = Yii::getAlias('@app/data/mysql.sql.tgz');
        /** @var $connection Connection */
        $connection = Yii::$app->mysql;
        $this->assertFalse($this->deleteTableSuccess('test_table', $connection));
        $backuper = new DatabaseBackuper($backupFilePath, $connection);
        $backuper = new DatabaseBackuper(/** @scrutinizer ignore-type */ $backupFilePath, $connection);
        $backuper->restore();
        $this->assertTrue($this->deleteTableSuccess('test_table', $connection));
    }

    public function testRestoreMysqlBackupNotEmptyBase()
    {
        $backupFilePath = Yii::getAlias('@app/data/mysql.sql.tgz');
        /** @var $connection Connection */
        $connection = Yii::$app->mysql;
        $connection->createCommand()->createTable('test_table', ['id' => 'int null'])->execute();
        $backuper = new DatabaseBackuper($backupFilePath, $connection);
        $backuper = new DatabaseBackuper(/** @scrutinizer ignore-type */ $backupFilePath, $connection);
        $backuper->restore();
        $this->assertTrue($this->deleteTableSuccess('test_table', $connection));
    }

    protected function deleteTableSuccess(string $tableName, $connection)
    {
        try {
            $connection->createCommand()->dropTable($tableName)->execute();
        } catch (\yii\db\Exception $e) {
            return false;
        }
        return true;
    }
}


floor12 / yii2-module-backup

testRestorePostgresBackupNotEmptyBase() A last analyzed 2024-11-29 09:13 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

testRestorePostgresBackupNotEmptyBase() A
last analyzed 2024-11-29 09:13 UTC