Spatie\MigrateFresh\TableDroppers\Mysql::dropAllTables()

Complexity

Conditions	1
Paths	1

Size

Total Lines	30
Code Lines	17

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    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();
    }
}