Sunnysideup\MigrateData\Tasks\CleanUpSS4Files::run()

Complexity

Conditions	4
Paths	6

Size

Total Lines	32
Code Lines	19

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function run($request)
    {
        $sql = '
        SELECT Filename
        FROM `File`
            LEFT JOIN File_Live ON File.ID = File_Live.ID
        WHERE File_Live.ID IS NULL AND File.ClassName = \'SilverStripe\\\Assets\\\File\' ORDER BY File.Filename
        ';
        $rows = DB::query($sql);
        echo '<h2>Files that are not published</h2>';
        foreach ($rows as $row) {
            DB::alteration_message($row['Filename'], 'deleted');
        }

        $sql = '
            SELECT "Filename", "ID"
            FROM "File"
            WHERE
                "ClassName" = \'' . addslashes(File::class) . '\'
            ORDER BY Filename ASC';
        $rows = DB::query($sql);
        $baseDir = Director::baseFolder() . '/public/';
        foreach ($rows as $row) {
            $fullName = $baseDir . $row['Filename'];
            if (file_exists($fullName)) {
                echo '.';
            } else {
                DB::alteration_message('DELETING: ' . $fullName, 'deleted');
                $sql = 'DELETE FROM File WHERE ID = ' . $row['ID'] . ';';
                DB::query($sql);
                $sql = 'DELETE FROM File_Live WHERE ID = ' . $row['ID'] . ';';
                DB::query($sql);
            }