dillard
e58b86fc48
Off, once a day or every N hours from a time, each in its own time zone. Existing locations keep the time that held for all of them. A backup that has to wait shows as queued, and its restore point has the time it really began.
50 lines
1.7 KiB
PHP
50 lines
1.7 KiB
PHP
<?php
|
|
|
|
declare(strict_types=1);
|
|
|
|
// SPDX-FileCopyrightText: 2026 Dillard Blom
|
|
// SPDX-License-Identifier: AGPL-3.0-or-later
|
|
|
|
namespace OCA\NgBackup\Migration;
|
|
|
|
use Closure;
|
|
use OCA\NgBackup\Service\LocationSchedule;
|
|
use OCA\NgBackup\Service\Schedule;
|
|
use OCP\DB\ISchemaWrapper;
|
|
use OCP\DB\Types;
|
|
use OCP\IDBConnection;
|
|
use OCP\Migration\IOutput;
|
|
use OCP\Migration\SimpleMigrationStep;
|
|
|
|
/** A schedule per location. Each existing location gets the daily time that held for all of them. */
|
|
final class Version000008Date20261107010000 extends SimpleMigrationStep {
|
|
public function __construct(
|
|
private IDBConnection $db,
|
|
private Schedule $schedule,
|
|
) {
|
|
}
|
|
|
|
public function changeSchema(IOutput $output, Closure $schemaClosure, array $options): ?ISchemaWrapper {
|
|
/** @var ISchemaWrapper $schema */
|
|
$schema = $schemaClosure();
|
|
$t = $schema->getTable('ngb_targets');
|
|
if ($t->hasColumn('schedule')) {
|
|
return null;
|
|
}
|
|
$t->addColumn('schedule', Types::STRING, ['notnull' => false, 'length' => 16]);
|
|
$t->addColumn('schedule_zone', Types::STRING, ['notnull' => false, 'length' => 64]);
|
|
$t->addColumn('schedule_since', Types::BIGINT, ['notnull' => false, 'unsigned' => true]);
|
|
return $schema;
|
|
}
|
|
|
|
public function postSchemaChange(IOutput $output, Closure $schemaClosure, array $options): void {
|
|
['time' => $time, 'timezone' => $zone] = $this->schedule->get();
|
|
$qb = $this->db->getQueryBuilder();
|
|
$qb->update('ngb_targets')
|
|
->set('schedule', $qb->createNamedParameter(Schedule::validTime($time) ? LocationSchedule::normalize($time) : ''))
|
|
->set('schedule_zone', $qb->createNamedParameter($zone))
|
|
->where($qb->expr()->isNull('schedule'));
|
|
$qb->executeStatement();
|
|
}
|
|
}
|