SqliteCommand::dropDatabase() - Code Metrics - Inspection of "Added the SqliteCommand and examples for migrate u..." - byjg/migration - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( f5a493...f6c233 )

by Joao

created 2016-06-10 04:32 UTC

SqliteCommand::dropDatabase() A

↳ Parent: SqliteCommand

Complexity

Conditions	2
Paths	2

Size

Total Lines	14
Code Lines	4

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	1

Metric	Value
c	1
b	0
f	1
dl	0
loc	14
rs	9.4285
cc	2
eloc	4
nc	2
nop	0

<?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) {

            $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);
    }
}


1			<?php
2
3			namespace ByJG\DbMigration\Commands;
4
5			use ByJG\AnyDataset\ConnectionManagement;
6
7			class SqliteCommand extends AbstractCommand
8			{
9
10			public static function prepareEnvironment(ConnectionManagement $connection)
11			{
12			}
13
14			public function createDatabase()
15			{
16			}
17
18			public function dropDatabase()
19			{
20			$iterator = $this->getDbDataset()->getIterator("
21			select
22			'drop table ' \|\| name \|\| ';' as command
23			from sqlite_master
24			where type = 'table'
25			and name <> 'sqlite_sequence';
26			");
27
28			foreach ($iterator as $row) {
			0 ignored issues – show Bug introduced 2016-06-10 04:35 UTC by Report Bug Copy Issue Report The expression `$iterator` of type `object<ByJG\AnyDataset\R...tory\IteratorInterface>` is not traversable. Loading history...
29			$this->getDbDataset()->execSQL($row->getField('command'));
30			}
31			}
32
33			public function createVersion()
34			{
35			$this->getDbDataset()->execSQL('CREATE TABLE IF NOT EXISTS migration_version (version int)');
36			$this->checkExistsVersion();
37			}
38
39			public function executeSql($sql)
40			{
41			$statements = explode(";", $sql);
42
43			foreach ($statements as $sql) {
44			$this->executeSqlInternal($sql);
45			}
46			}
47
48			protected function executeSqlInternal($sql)
49			{
50			$this->getDbDataset()->execSQL($sql);
51			}
52			}
53

byjg / migration

Push — master ( f5a493...f6c233 )

SqliteCommand::dropDatabase() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like