Spatie\MigrateFresh\TableDroppers\Mysql

Complexity

Total Complexity

1

Size/Duplication

Total Lines	33
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	1

Importance

Changes

0

1 Method

Rating	Name	Duplication	Size	Complexity
B	dropAllTables()	0	30	1

<?php

namespace Spatie\MigrateFresh\TableDroppers;

use DB;
use Schema;
use stdClass;

class Mysql implements TableDropper
{
    public function dropAllTables()
    {
        Schema::disableForeignKeyConstraints();

        collect(DB::select("SHOW FULL TABLES WHERE Table_Type = 'BASE TABLE'"))
            ->map(
                function (stdClass $tableProperties) {
                    return get_object_vars($tableProperties)[key($tableProperties)];
                }
            )
            ->each(
                function (string $tableName) {
                    Schema::drop($tableName);
                }
            );
            
        collect(DB::select("SHOW FULL TABLES WHERE Table_Type = 'VIEW'"))
            ->map(
                function (stdClass $tableProperties) {
                    return get_object_vars($tableProperties)[key($tableProperties)];
                }
            )
            ->each(
                function (string $viewName) {
                    DB::statement('DROP VIEW '.$viewName);
                }
            );

        Schema::enableForeignKeyConstraints();
    }
}