ByJG\DbMigration\Commands\SqliteCommand

Complexity

Total Complexity

8

Size/Duplication

Total Lines	46
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	2

Importance

Changes	1
Bugs	0	Features	1

6 Methods

Rating	Name	Duplication	Size	Complexity
A	prepareEnvironment()	0	3	1
A	createDatabase()	0	3	1
A	dropDatabase()	0	14	2
A	createVersion()	0	5	1
A	executeSql()	0	8	2
A	executeSqlInternal()	0	4	1

<?php

namespace ByJG\DbMigration\Commands;

use ByJG\AnyDataset\ConnectionManagement;

class SqliteCommand extends AbstractCommand
{

    public static function prepareEnvironment(ConnectionManagement $connection)
    {
    }

    public function createDatabase()
    {
    }

    public function dropDatabase()
    {
        $iterator = $this->getDbDataset()->getIterator("
            select 
                'drop table ' || name || ';' as command 
            from sqlite_master 
            where type = 'table' 
              and name <> 'sqlite_sequence';
        ");

        foreach ($iterator as $row) {

The expression $iterator of type object<ByJG\AnyDataset\Repository\IteratorInterface> is not traversable.

            $this->getDbDataset()->execSQL($row->getField('command'));
        }
    }

    public function createVersion()
    {
        $this->getDbDataset()->execSQL('CREATE TABLE IF NOT EXISTS migration_version (version int)');
        $this->checkExistsVersion();
    }

    public function executeSql($sql)
    {
        $statements = explode(";", $sql);

        foreach ($statements as $sql) {
            $this->executeSqlInternal($sql);
        }
    }

    protected function executeSqlInternal($sql)
    {
        $this->getDbDataset()->execSQL($sql);
    }
}