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

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

↳ Parent: DeleteAllVersionedData

Complexity

Conditions	7
Paths	7

Size

Total Lines	24
Code Lines	17

Duplication

Lines	0
Ratio	0 %

Importance

Changes	5
Bugs	0	Features	0

Metric	Value
eloc	17
c	5
b	0
f	0
dl	0
loc	24
rs	8.8333
cc	7
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 DeleteAllVersionedData extends BuildTask
{
    protected $title = 'CAREFUL: delete all versioned data';

    protected $description = 'Delete versioned data!';

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

                    if (is_array($row)) {
                        foreach ($row as $db => $table) {
                            $this->truncateTable($table);
                        }
                    } else {
                        $table = $row['table'] ?? '';
                        if ($table) {
                            $this->truncateTable($table);
                        }
                    }
                }
            }
            FlushNowImplementor::do_flush('TRUNCATING ChangeSet');
            DB::query('TRUNCATE TABLE "ChangeSet";');
            FlushNowImplementor::do_flush('TRUNCATING ChangeSetItem');
            DB::query('TRUNCATE TABLE "ChangeSetItem";');
        } else {
            FlushNowImplementor::do_flush('You need to set the environment to TEST or DEV to run this task.');
        }
    }


    private function truncateTable(string $table)
    {
        if ('_Versions' === substr((string) $table, -1 * strlen('_Versions'))) {
            FlushNowImplementor::do_flush('TRUNCATING ' . $table);
            DB::query('TRUNCATE TABLE "' . $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 DeleteAllVersionedData extends BuildTask
12			{
13			protected $title = 'CAREFUL: delete all versioned data';
14
15			protected $description = 'Delete versioned data!';
16
17			public function run($request)
18			{
19			if (!Director::isLive()) {
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->truncateTable($table);
26			}
27			} else {
28			$table = $row['table'] ?? '';
29			if ($table) {
30			$this->truncateTable($table);
31			}
32			}
33			}
34			}
35			FlushNowImplementor::do_flush('TRUNCATING ChangeSet');
36			DB::query('TRUNCATE TABLE "ChangeSet";');
37			FlushNowImplementor::do_flush('TRUNCATING ChangeSetItem');
38			DB::query('TRUNCATE TABLE "ChangeSetItem";');
39			} else {
40			FlushNowImplementor::do_flush('You need to set the environment to TEST or DEV to run this task.');
41			}
42			}
43
44
45			private function truncateTable(string $table)
46			{
47			if ('_Versions' === substr((string) $table, -1 * strlen('_Versions'))) {
48			FlushNowImplementor::do_flush('TRUNCATING ' . $table);
49			DB::query('TRUNCATE TABLE "' . $table . '";');
50			}
51			}
52			}
53

sunnysideup / silverstripe-delete-all-tables

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

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

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