DeleteAllTablesTask::run() - Code Metrics - sunnysideup/silverstripe-delete-all-tables - Measure and Improve Code Quality continuously with Scrutinizer

DeleteAllTablesTask::run() B
last analyzed 2025-04-26 00:41 UTC

↳ Parent: DeleteAllTablesTask

Complexity

Conditions	8
Paths	7

Size

Total Lines	14
Code Lines	11

Duplication

Lines	0
Ratio	0 %

Importance

Changes	3
Bugs	1	Features	0

Metric	Value
eloc	11
c	3
b	1
f	0
dl	0
loc	14
rs	8.4444
cc	8
nc	7
nop	1

<?php

namespace Sunnysideup\DeleteAllTables;

use SilverStripe\Control\Director;
use SilverStripe\Dev\BuildTask;
use SilverStripe\ORM\DB;
use Sunnysideup\Flush\FlushNow;
filter:
    dependency_paths: ["lib/*"]
use Sunnysideup\Flush\FlushNowImplementor;
filter:
    dependency_paths: ["lib/*"]

class DeleteAllTablesTask extends BuildTask
{
    protected $title = 'CAREFUL: delete all tables';

    protected $description = 'Delete all tables in the database - no backup - so please be super careful!';

    public function run($request)
    {
        if (Director::isDev() || Director::is_cli()) {
            $rows = DB::query('SHOW TABLES;');
            foreach ($rows as $row) {
                if ($row) {

                    if (is_array($row)) {
                        foreach ($row as $db => $table) {
                            $this->deleteTable($table);
                        }
                    } else {
                        $table = $row['table'] ?? '';
                        if ($table) {
                            $this->deleteTable($table);
                        }
                    }
                }
            }
        }
    }

    private function deleteTable(string $table)
    {
        FlushNowImplementor::do_flush('DELETING ' . $table);
        DB::query('DROP TABLE IF EXISTS "' . $table . '";');
    }
}


1			<?php
2
3			namespace Sunnysideup\DeleteAllTables;
4
5			use SilverStripe\Control\Director;
6			use SilverStripe\Dev\BuildTask;
7			use SilverStripe\ORM\DB;
8			use Sunnysideup\Flush\FlushNow;
			0 ignored issues – show Bug introduced 2025-04-26 00:38 UTC by Report Bug Copy Issue Report The type `Sunnysideup\Flush\FlushNow` was not found. Maybe you did not declare it correctly or list all dependencies? The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g. `excluded_paths: ["lib/"]`, you can move it to the dependency path list as follows: filter: dependency_paths: ["lib/"] For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths Loading history...
9			use Sunnysideup\Flush\FlushNowImplementor;
			0 ignored issues – show Bug introduced 2025-04-26 00:38 UTC by Report Bug Copy Issue Report The type `Sunnysideup\Flush\FlushNowImplementor` was not found. Maybe you did not declare it correctly or list all dependencies? The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g. `excluded_paths: ["lib/"]`, you can move it to the dependency path list as follows: filter: dependency_paths: ["lib/"] For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths Loading history...
10
11			class DeleteAllTablesTask extends BuildTask
12			{
13			protected $title = 'CAREFUL: delete all tables';
14
15			protected $description = 'Delete all tables in the database - no backup - so please be super careful!';
16
17			public function run($request)
18			{
19			if (Director::isDev() \|\| Director::is_cli()) {
20			$rows = DB::query('SHOW TABLES;');
21			foreach ($rows as $row) {
22			if ($row) {
			0 ignored issues – show Bug Best Practice introduced 2025-04-26 00:38 UTC by Report Bug Copy Issue Report The expression `$row` of type `array` is implicitly converted to a boolean; are you sure this is intended? If so, consider using `! empty($expr)` instead to make it clear that you intend to check for an array without elements. This check marks implicit conversions of arrays to boolean values in a comparison. While in PHP an empty array is considered to be equal (but not identical) to false, this is not always apparent. Consider making the comparison explicit by using `empty(..)` or `! empty(...)` instead. Loading history...
23			if (is_array($row)) {
24			foreach ($row as $db => $table) {
25			$this->deleteTable($table);
26			}
27			} else {
28			$table = $row['table'] ?? '';
29			if ($table) {
30			$this->deleteTable($table);
31			}
32			}
33			}
34			}
35			}
36			}
37
38			private function deleteTable(string $table)
39			{
40			FlushNowImplementor::do_flush('DELETING ' . $table);
41			DB::query('DROP TABLE IF EXISTS "' . $table . '";');
42			}
43			}
44

sunnysideup / silverstripe-delete-all-tables

DeleteAllTablesTask::run() B last analyzed 2025-04-26 00:41 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

DeleteAllTablesTask::run() B
last analyzed 2025-04-26 00:41 UTC