Esempio n. 1
0
<?php

include "../patches.php";
$patch = new Patch(20);
if (!$patch->exists()) {
    $emptySql = "SELECT count(id) FROM s3_files WHERE add_date='0000-00-00 00:00:00'";
    $originalCount = db()->getValue($emptySql);
    $patch->log("Starting with {$originalCount} files with invalid dates.");
    // Fix known images
    $sql = "UPDATE s3_files, webcam_images\n\t\t\tSET s3_files.add_date=webcam_images.timestamp\n\t\t\tWHERE s3_files.id = webcam_images.image_id\n\t\t\tAND s3_files.add_date='0000-00-00 00:00:00'";
    $currentCount = fix_timestamp($sql, "Known image timestamps", $originalCount);
    // Fix gcode files uploaded directly
    $sql = "UPDATE s3_files, jobs\n\t\t\tSET s3_files.add_date=jobs.created_time\n\t\t\tWHERE jobs.source_file_id=s3_files.id\n\t\t\tAND s3_files.add_date='0000-00-00 00:00:00'";
    $currentCount = fix_timestamp($sql, "Known gcode files", $currentCount);
    // Fix gcode files made by a slicer
    $sql = "UPDATE s3_files, jobs, slice_jobs\n\t\t\tSET s3_files.add_date=slice_jobs.finish_date\n\t\t\tWHERE jobs.id=slice_jobs.job_id\n\t\t\tAND slice_jobs.input_id=jobs.source_file_id\n\t\t\tAND slice_jobs.output_id=jobs.file_id\n            AND s3_files.id=jobs.file_id\n\t\t\tAND slice_jobs.finish_date!='0000-00-00 00:00:00'\n\t\t\tAND s3_files.add_date='0000-00-00 00:00:00'";
    $currentCount = fix_timestamp($sql, "Sliced gcode files", $currentCount);
    // Fix files if a child has a timestamp, but the parent doesn't.
    $sql = "UPDATE s3_files a, s3_files b\n\t\t\tSET a.add_date=b.add_date\n\t\t\tWHERE a.id=b.parent_id\n\t\t\tAND b.parent_id!=0\n\t\t\tAND b.add_date!='0000-00-00 00:00:00'\n\t\t\tAND a.add_date='0000-00-00 00:00:00'";
    $currentCount = fix_timestamp($sql, "Fixing parent files", $currentCount);
    // Fix files if a parent has a timestamp, but the child doesn't.
    $sql = "UPDATE s3_files a, s3_files b\n\t\t\tSET a.add_date=b.add_date\n\t\t\tWHERE a.parent_id=b.id\n\t\t\tAND a.parent_id!=0\n\t\t\tAND b.add_date!='0000-00-00 00:00:00'\n\t\t\tAND a.add_date='0000-00-00 00:00:00'";
    $currentCount = fix_timestamp($sql, "Fixing child files", $currentCount);
    $patch->log("Total: " . ($originalCount - $currentCount) . " fixed, {$currentCount} remaining");
    $patch->finish("Fixing bad timestamps for s3_files");
}
function fix_timestamp($sql, $method, $lastCount)
{
    global $patch, $emptySql;
    db()->execute($sql);
    $currentCount = db()->getValue($emptySql);
Esempio n. 2
0
                        $user_id = $job->getUser()->id;
                        $rowSql = "('" . date("Y-m-d H:i:s", $timestamp) . "', ";
                        $rowSql .= "{$image_id}, {$user_id}, {$job->id}, ";
                        $bot = $job->getBot();
                        if ($bot->isHydrated()) {
                            $rowSql .= "{$bot->id}";
                        } else {
                            $rowSql .= "NULL";
                        }
                        $rowSql .= ")";
                        $rowData[] = $rowSql;
                    } else {
                        $failCount++;
                    }
                } else {
                    // Remove it from the array to save memory
                    unset($existingImages[$image_id]);
                }
            }
            if (count($rowData) > 0) {
                db()->execute("INSERT IGNORE INTO webcam_images(`timestamp`, `image_id`, `user_id`, `job_id`, `bot_id`) VALUES " . implode(",", $rowData));
            }
            $count++;
            $patch->progress($count * 100 / $total);
        }
    }
    if ($failCount > 0) {
        $patch->log($failCount . " images no longer exist in the database");
    }
    $patch->finish("Added webcam images table");
}
Esempio n. 3
0
<?php

include "../patches.php";
$patch = new Patch(22);
if (!$patch->exists()) {
    $sql = "UPDATE jobs set user_sort=0 WHERE status IN (\n\t\t\t'complete',\n\t\t\t'failure',\n\t\t\t'canceled'\n\t\t)";
    $jobsAffected = db()->execute($sql);
    $patch->log("{$jobsAffected} jobs cleaned");
    $patch->finish("Cleaning up user_sort for jobs");
}