sunnysideup / silverstripe-delete-all-tables

src/DeleteAllVersionedData.php

<?php

namespace Sunnysideup\DeleteAllTables;

use SilverStripe\Control\Director;
use SilverStripe\Dev\BuildTask;
use SilverStripe\ORM\DB;
use Sunnysideup\Flush\FlushNow;
use Sunnysideup\Flush\FlushNowImplementor;

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

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.

                    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 . '";');
        }
    }
}